Visibility of products is showing empty

Hi Support team,
I have installed Ubertheme 3.1.8 for migration from M1 to M2. All the products in M2 is migrated with visibility “Not visible indivually” whereas in M1, all product visibility is “catalog,search”. Please provide solution ASAP.

5 answers

Profile photo of Mall Staff 124600.00 $tone December 2, 2019
Public

Hi there,

All the products in M2 is migrated with visibility “Not visible indivually” whereas in M1, all product visibility is “catalog,search”. Please provide solution ASAP.

Please run the following SQL in your M1 database and provide me the screenshots of the result:

SELECT * FROM `eav_attribute_option` WHERE `attribute_id` IN (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'visibility');

I will get back to you then.

Regards,
Mall.

#1
Profile photo of Mall Staff 124600.00 $tone December 3, 2019
Public

Hi there,

https://prnt.sc/q5edni 

That is the root of the issue you mentioned. The data record found in that screenshot isn’t needed and it caused that issue.

Please do steps as follows:
+ Run the SQL query below in your M1 database to delete that unnecessary data record:

DELETE FROM `eav_attribute_option` WHERE `attribute_id` IN (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'visibility');

+ Then run the following SQL queries in your M2 database:

DELETE FROM ub_migrate_map_step_3_attribute WHERE entity_name = 'eav_attribute' AND m2_id NOT IN (SELECT attribute_id FROM eav_attribute);
DELETE FROM ub_migrate_map_step_3_attribute_option WHERE entity_name = 'eav_attribute_option' AND m2_id NOT IN (SELECT option_id FROM eav_attribute_option);

+ Next, clean the cache of our module by running the command in your SSH terminal:
rm -rf pub/ub-tool/protected/runtime/cache/
+ And then, run the delta migration in step #3 with the ‘update’ mode:
php -f bin/ubdatamigration run --step=3 --mode=update
+ Once done, run the delta migration in step #5 with the ‘update’ mode:
php -f bin/ubdatamigration run --step=5 --mode=update
+ Finally, reindex the migrated data and clean your M2 cache.

Regards,
Mall.
 

#3

Please login or Register to Submit Answer

Written By

Comments