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
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.
Hi Mall,
Thanks for the response. This is result screenshot while running the query in M1 Database.
https://prnt.sc/q5edni
Hi there,
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.
Thanks for quick response. I will follow the above steps and Let you know if any help needed.
Hi there,
Yes, please get back to us here in case you need further help.
Regards,
Ubertheme team