Tier prices are not migrated

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

Profile photo of Mall Staff 184060.00 $tone October 7, 2017
Public

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.

#1
Profile photo of Mall Staff 184060.00 $tone October 7, 2017
Public

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.

#3
Profile photo of Mall Staff 184060.00 $tone October 8, 2017
Public

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.

#5
Profile photo of Mall Staff 184060.00 $tone October 9, 2017
Public

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.
 

#6
Profile photo of floorsave 150.00 $tone October 27, 2017
Public

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

#9
Profile photo of Mall Staff 184060.00 $tone October 28, 2017
Public

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.
 

#10
Profile photo of floorsave 150.00 $tone October 30, 2017
Public

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

#11
Profile photo of floorsave 150.00 $tone October 30, 2017
Public

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

#12
Profile photo of Mall Staff 184060.00 $tone October 30, 2017
Public

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.

#13

Please login or Register to Submit Answer

Written By

Comments