Informations not updating in the order BO (total price), cache on BO ?

[William K.]

Hello, 

 

I have a recurent but on my 1.6.1.15 shop.

 

 

It happens on the BO order page, when I add a product to the order, modify a product or apply a reduction to the order.

 

After saving the change, the total isn't recalculated and if we do another change the prices of the order break completly and don't make any sens anymore. (forcing us to do the changes via phpmyadmin ...)

 

We realised that if we wait long enough after a change it finaly  spread. 

 

The issue is that in my understanding there isn't any cache on the BO of prestashop but this isn't due to a browser cache because we can see the issue on another computer or while being in private navigation.

 

The information is right in the php even when it isn't in the BO, so where is the wrong price on the order page coming from ? Any idea on how to resolve this issue ?

 

Thanks in advance, sorry for the broken english

[Nikolai]

Hi

 

Did you try to find order in database ?

How to do it

1) backup db to sql (1st file)before order added

2) create order

3) backup db to sql  (2nd file)

4) compare via Araxis or any other comparision software sql 1 & sql 2 files. find changes (and your order )

[William K.]

Like I tried to explain, when we update the order the database is changed, but the BO keep showing the previous information for the order total.

 

That's where I am lost because I don't get where the BO find the previous total when there shouldn't be any BO cache and the old information isn't in the database anymore..

[bellini13]

Are you using opcache or memcache or some other data caching engine for PHP?  If so, it effects the entire store, not just the front office

[William K.]

I am using the caching system "File System", is this where it is coming from ? should I disable caching to avoid dealing with my issue ? is it even an option or is it going to be to make my site load slower for users ? 

[bellini13]

Using a file system cache may or may not effect your performance, that really depends on your file system and ultimately the read/write speeds of the disk.  In-memory cache will almost always be faster than disk cache.

 

Regardless, the usage of a cache will effect the front and back office.  And if you change data outside of prestashop (as you are changing data directly in the database), then your file/memory cache will never be made aware of that change unless the cache expires or is purged.