Special prices after migration

Hi there,

Could you please investigate this for me please.

I need a closer look to detect the root of issue you mentioned. Let’s provide me information about your instance:
+ Admin credentials and URL to back-end
+ SSH credentials and path to Magento folder
Regards,
Mall.

Hi there,
Please provide me more the product’s SKU which has issue as you mentioned.
Regards,
Mall.

Hi there,
I have checked further in your M1 database and I see this in the M1 database: http://i.prntscr.com/6ff2kVIjQaG36ioOybpc4A.png
As you see, there is not value greater 0 of the product special_price attribute in your M1 database.
You could use below SQL to re-check in M1 database at your end:

SELECT count(*) FROM `catalog_product_entity_decimal` WHERE value > 0 AND `attribute_id` IN (SELECT `attribute_id` FROM eav_attribute WHERE attribute_code = 'special_price');

And that is root of the issue you mentioned.
Regards,
Mall.

Hi there,

Can you explain further and let me know of a solution.

Did you do data migration with our Lite version of our migration tool in the current instance in the first migration?
And before using our Pro version, did you reset, then did data migration again?
Regards,
Mall.

Hi there,
As explained in my reply #5: I have checked further in your M1 database and I see this in the M1 database: http://i.prntscr.com/6ff2kVIjQaG36ioOybpc4A.png
As you see, there is not value greater 0 of the product special_price attribute in your M1 database.
This means in your M1 db, there’s no value > 0 of the product special_price attribute.
Under this circumstance, this caused the issue, even when you used our Lite version.
You can verify the value of the product special_price attribute in your M1 database by using this SQL:

SELECT count(*) FROM `catalog_product_entity_decimal` WHERE value > 0 AND `attribute_id` IN (SELECT `attribute_id` FROM eav_attribute WHERE attribute_code = 'special_price');

Regards,
Mall.
 

Hi there,

If there is no value above 0, it means that no special price are enabled in my M1 DB so why would there be any special price in my M2 installation?

Could you tell me know what is the product SKU of that products? I have rechecked in back-end of your M2 and I didn’t see any migrated products which has special price greater zero: http://i.prntscr.com/KQnO73kRRdu5B2l2zEi-Eg.png
Regards,
Mall.

Hi there,

http://www.longstone.club/catalog/product/view/id/6914/s/185hr13-michelin-xas-ff/category/11455/

That is not a product with special price as you think. That is a grouped product with children products. And the prices which you saw in front-end are original price and price including tax of the children products: http://i.prntscr.com/nrarLdSpRWCaQtr3Abba0Q.png
Please have a look again.
Regards,
Mall.

Hi there,

You can see the “old” price which is the right price in orange, I can see also in the code (is it not special price?):

Yes, that is not special prices which you see in the back-end grid view of products or product pricing form on editing page. 
As my first reply #12 that are prices with tax calculation.
Regards,
Mall.

Hi there,

I don’t understand. There is 3 prices per product, 

As indicated in my first reply. The product you mentioned is Grouped product type and it has three children products with such price in back-end configuration: https://prnt.sc/kfjxrh
And the prices blocks you mentioned:

<span class="special-price">....</span>

That is strange blocks. Seem it related to third party extensions or theme you are used in your M2 instance. Please re-check at your end.
Could you disable all third-party extensions and switch to use the default theme (Luma or blank theme) to testing migrated data first?
Regards,
Mall.
 
 

Hi there,
I checked further in your instance and I saw you have some of product Tax classes and Tax rules and the prices value you mentioned, it related to the rules in the product tax classes which you have assigned to your product. Please re-check this at your end.
Below are there URLs of three children products (simple product) of the Grouped product you mentioned:
http://www.longstone.club/offset-valve-michelin-tube-13f-v13.html
http://www.longstone.club/rim-tape-for-wire-wheel-13-17.html
http://www.longstone.club/pack-of-5-classic-valve-caps.html
And these products has tax class setting: https://prnt.sc/kfkgpp
You could change Tax class setting and then see price changes in front-end view at your end.
Regards,
Mall.
 

Hi there,

Same problem on my other stores:
http://longstone.xyz/135sr15-michelin-zx.html

As explained in my first reply. That related to Magento functions on your current configuration of the grouped product you mentioned.
You could try update the tax class in back-end of the associated products you will see the prices changes.
Regards,
Mall.

Hi there,

This appears to be site wide and any products.
http://www.longstone.club/offset-valve-michelin-tube-15cb-13.html (simple product)

Yes, that because your product has tax setting (Taxable Goods): http://i.prntscr.com/k-puMgUbS6KumBdN6WIb4A.png
And that are prices after calculation of your tax setting. Let’s re-check tax settings on your products.
Regards,
Mall.

Hi there,

The price of this product in GBP is 9,50. I have entered a currency exchange for EUR of 1.12 which should be the price shown on this page. But for some weird reason without having settings it inserts a “special price” which is the right price and shows the GBP price.
http://www.longstone.club/offset-valve-michelin-tube-15cb-13.html

That is strangle. I helped to check further in your M2 database and I saw all price values of that product (entity_id = 6301) are corrected (9.5000). You could see more at below screenshots and re-check at your end:
http://i.prntscr.com/qW-ZEXXCQMC021n9LCtbig.png
http://i.prntscr.com/oQYqdZL7SdutQH0HQh3p6Q.png
Seem the issue in front-end view page of that product relates to some third-party extensions or third-party theme in your M2 instance.
And then, I helped to debug further in your instance and I saw the root issue related the function of the third-party extension named ‘Bss_CheckoutWithDisplayCurrency’
It was overwrite function of the Magento core and returns a wrong regular price value (10.64)
You could see this: http://i.prntscr.com/RsPB5tCPR927ElvHEK_RfQ.png
Let’s disable the third-party extension named Bss_CheckoutWithDisplayCurrency and the issue will be solve.
Therefore, you could see that issue was not related to our migration tool. Let’s have a look again.
Regards,
Mall.

Hi there,
Yeah, let’s contact me if you need further assistance.
Regards,
Mall.