fabio10 Posted April 21, 2011 Share Posted April 21, 2011 Hi there,i’ve a fresh new prestashop 1.4 installed and i’ve got this problem just today ! It’s incredible, with no reasons some products have WRONG price in the product_list template and in homeFeatured module …I've tried adding and delete attribute for product with this bug, and this trick has worked well, but i can’t do for 40 products affected by this strange problem …Anyone knows if this is a bug and if it has been tracked ? Thank’s ! Link to comment Share on other sites More sharing options...
shokinro Posted April 22, 2011 Share Posted April 22, 2011 this will be big and fatal issue if it really is as what you said.maybe it is just that it displayed in different way between front office and back office?for example, if you set display price with tax included or tax excluded.the price will be displayed differently for different customer based on your store setting. Link to comment Share on other sites More sharing options...
Luca S. Posted April 22, 2011 Share Posted April 22, 2011 hello, this error is in 1.4.1? Link to comment Share on other sites More sharing options...
fabio10 Posted April 22, 2011 Author Share Posted April 22, 2011 No, i've Prestashop 1.4.0.17Tomorrow I'll try the new Prestashop version. the price will be displayed differently for different customer based on your store setting. I've got this strange problem with two object with same parameters (price, quantity, attribute etc.) in BO, but in FO they have different price with same browser ( one is 10€ while the other is 11€ ( 10+20%VAT) ) Link to comment Share on other sites More sharing options...
phunter121 Posted April 30, 2011 Share Posted April 30, 2011 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 productsUPDATE `pss_product` SET `cache_default_attribute` = 02. 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` = 1This 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 More sharing options...
shokinro Posted April 30, 2011 Share Posted April 30, 2011 Thanks phunter121 for sharing the information and provide the solutions.I think it is very precious information that may help other people too. Link to comment Share on other sites More sharing options...
fabio10 Posted May 21, 2011 Author Share Posted May 21, 2011 Thank you very very much ! ! The solution provided works perfectly ! Link to comment Share on other sites More sharing options...
weasel69 Posted March 20, 2014 Share Posted March 20, 2014 If that doesn't work for you, you can have a look at this solution here, which worked for me Link to comment Share on other sites More sharing options...
hakeryk2 Posted September 3, 2016 Share Posted September 3, 2016 For 1.6.1.4 this solution worked just fine UPDATE ps_product SET cache_default_attribute = 0;UPDATE ps_product_shop SET cache_default_attribute = 0; Link to comment Share on other sites More sharing options...
Recommended Posts