I have 506 tier prices inmagento 1. The logging of step 8 shows:
2017/10/07 11:55:44 [info] [ub_data_migration] [Processing] Step #8 migration completed with 100 CatalogProductEntityTierPrice items;
2017/10/07 11:55:44 [info] [ub_data_migration] [Processing] Step #8 migration completed with 100 CatalogProductEntityTierPrice items;
2017/10/07 11:55:44 [info] [ub_data_migration] [Processing] Step #8 migration completed with 100 CatalogProductEntityTierPrice items;
2017/10/07 11:55:44 [info] [ub_data_migration] [Processing] Step #8 migration completed with 100 CatalogProductEntityTierPrice items;
2017/10/07 11:55:44 [info] [ub_data_migration] [Processing] Step #8 migration completed with 100 CatalogProductEntityTierPrice items;
2017/10/07 11:55:45 [info] [ub_data_migration] [Processing] Step #8 migration completed with 6 CatalogProductEntityTierPrice items;
That is exactly right. But after migration the table catalog_product_index_tier_price is empty and no tier prices are shown in the catolog.
13 answers
Hi there,
That is exactly right. But after migration the table catalog_product_index_tier_price is empty and no tier prices are shown in the catolog.
The data in the table named catalog_product_index_tier_price will be auto fill by Magento’s indexer after you have done with reindex command.
Regards,
Mall.
Yes, but hen it is still empty as is the table catalog_product_tier_price!
Hi there,
Yes, but hen it is still empty as is the table catalog_product_tier_price!
Let’s provide me the admin credentials, ssh credentials and web root path of your Magento 2 instance.
And provide me more the phpMyadmin credentials of your Magento1’s and Magento2’s databases.
I will check further and reply you more later.
Regards,
Mall.
Hi there,
Kindly try reset data migration in the step #8 and restart data migration in this step. And tell me know how it goes.
Regards,
Mall.
Hi jukebox-revival,
I have checked further from my end and found the root issue as you mentioned. That because all your tier prices was applied to customer goup id = 0 or website_id = 0. And some latest changed of our tool was not handled for that cases.
To solve that issue, you could do steps as followings:
-- Step 1: Open the php file at path: pub/ub-tool/protected/controllers/Step8Controller.php
and find to the code line:
if ($productId2 AND $customerGroupId2 AND $websiteId2) {
and replace it by code line:
if ($productId2 AND !is_null($customerGroupId2) AND !is_null($websiteId2)) {
Step 2: Reset data migration in the step #8 and restart data migration in this step.
Once done, reindex your data and clean the Magento cache.
And tell me know how it goes.
Thanks for your comment!
Regards,
Mall.
Yes,
Works ok now!
Hi there,
Yeah, let’s contact me if you need further assistance.
Regards,
Mall.
Hi there,
I have this same problem, went to try your fix above but noted that it has already been applied in my version like:
if ($productId2 AND !is_null($customerGroupId2) AND !is_null($websiteId2)) {
But still when I look at redoing step 8 I can see:
Tier Prices (0)
So it still does not recognise the records in the table:
catalog_product_entity_tier_price
And does not import any tier prices.
Any help is very welcome
Thanks
Matt
Hi floorsave,
But still when I look at redoing step 8 I can see:
Tier Prices (0)
Kindly provide me the information as followings:
+ Admin credentials of your Magento2
+ SSH credentials and web root path of your Magento2 instance.
+ phpMyadmin credentials of your Magento1 and Magento2 databases.
I will check further in your working and help you out.
Regards,
Mall.
Hi there,
I managed to get the table imported by changing the customer_group_id in the source database then changing it back once imported.
However, I have some rows where the website_id is set but these rows do not show for the product as they did in the source M1 database.
I have tried changing the scope on product pages but this makes no difference.
Any ideas?
Thanks
Matt
Hello again,
Sorry but just to add that in ‘Advanced Pricing’ the only option in the dropdown for Tier Prices is: ‘All Websites [GBP]’ none of the other sites even appear regardless of scope selected.
Thanks Again
Matt
Hi there,
‘All Websites [GBP]’ none of the other sites even appear regardless of scope selected.
Yes, i have checked in your instance and see that issue. But seem that is not relate to our tool. Kindly re-check further and contact me if you need further assistance. (Please, requests’s responding from your server to my end very slow now)
Regards,
Mall.