Jump to content

v 1.4 Reductions = wrong product price displayed


Recommended Posts

My store default is euros and i also accept £
My products have a set retail price in euros and then I apply a discount for everyone in euros.

e.g Retail Price 43.99euros Reduction 5.00euros=38.99euros

The problem I have is if I use £ in the FO on the product page it displays the price with a £5.00 reduction not 5.00euros but when the product is added to the cart it displays the correct price with a 5.00euro reduction (see pic).

Please help, i've tried to fix it for about 5 hours and searched the forums with no luck

edit: This problem is just on the product page it displays the correct price on the home page and in categories.

41806_o92B6O3XRm46t3OiEn7h_t

41807_XTvmBe3oK4nzp2zJTf2r_t

Link to comment
Share on other sites

  • 4 weeks later...

I had this problem and I think it is a problem in the product import. It seems to only happen on products that don’t have any options. The import It is setting the cache_default_attribute field in the pss_product table when it should not be (this field would only be set when products have a default option). Running this SQL solved the problem:

1. Clear the cache_default field for all products
UPDATE `pss_product` SET `cache_default_attribute` = 0

2. Reset the values:
UPDATE `pss_product` AS p, `pss_product_attribute` AS pa
SET p.`cache_default_attribute` = pa.`id_product_attribute`
WHERE p.`id_product` = pa.`id_product` AND pa.`default_on` = 1

This also solved the problem of products appeariing on the category page as out of stock, when they were actually in stock. When displaying the category pages, PS appears to us the cache_default_attribute field to find the price of the default option. Because this field appears to be being set for products without options, PS is goiong to find the pss_product_attribute record, not finding it, displaying a randon value for the price, and also thinking the product is out of stock.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...