Prices Staying at $0 for Some Products in Front End

[preserver]

Prices are not updating on the front office, when I change them in the back office.  Images, and info can change, but prices don't.  The back office lists the price I enter, but it doesn't show up in the front end.  This is only happening to some products though.

 

I read in the forums that this kind of thing might have to do with a product.tpl file from certain templates. I am just using the default 1.5.4 theme modified with Nemo's product grid code. 

 

I did delete some of the products' subcategory and put them into that subcategory's parent category.  I used prestashop's automatic function for this.  I don't know if that would have anything to do with the issue, I just thought I would mention it . 

 

Not sure if either of those things have anything to do with the $0 price issue, but I am mentioning it just in case it does.

 

Thanks!

[eengledow]

I am having the same problem....have you gotten any help?

 

Eddie

[preserver]

I didn't.  I ended up just reentering some products manually.  Not fun, but doable since it wasn't that many.  If this had happened on a huge section it would have been a big problem!  

 

Maybe one of us should post it in the bug tracker.

[eengledow]

Well, I have found that the problem for me is in the Theme that I purchased from Prestashop.

If I revert back to the default Theme the problem goes away!

 

Eddie

[El Patron]

tip: there been been some reports related to block layered module causing this issue.

[eengledow]

Where can I get more info on how to fix it?

[ctcamp]

Hi there

Same problem here. some of the prices are updating and others are not. Can anybody shed some light on this?

i noticed this problem before i updated to version 1.6.0.9 from 1.6.0.8. i was hoping the update will rectify the problem, but it did not, could someone please help with this, i have hundreds of prices changing and need to update them as soon as possible.

[sidhujag]

Problem still there with 1.0.6.13... I update the database ps_product_shop 'price' field, the backend updates as per the product catalog but the frontend doesn't... sometimes If i clear my backend cache through performance it ends up changing.. is this a cache issue? Last time it took 10 mins and then changed...

 

I also noticed that if you click on the product and go into any kind of other view other than the homepage the new price shows up... just not on the homepage where it seems cached...

 

using default bootstrap theme... logging in and trying still shows the old prices on the homepage.

 

When I cleared the cache on the backend it updated prices immediately...

 

The issue seems to be with Smarty cache, see next post for test case. It is only evident also if you update the database of prices manually.

Edited March 5, 2015 by sidhujag (see edit history)

[sidhujag]

Ok so my test case is as follows:

 

1) Make price change in backend and notice how price changes on front-end

2) enable Smarty cache and clear any previous cache

3) Make same price change in backend and see that the front end updates, this works.

 

Now I have my module that updates the backend SQL database with a new price via updating the ps_product_shop.price field manually on a cronjob... 

 

1) Run cronjob

2) Notice how price changes on backend product page

3) Notice that the front end price doesn't change

4) Disable smarty cache and repeat 1), this time it works!

 

Smarty cache only works if you update the backend via the backend ajax controls... how do you trigger smarty cache to reinvalidate if you are updating the DB manually?

Edited March 5, 2015 by sidhujag (see edit history)