Home » Forums » Ubercart » Bug Reports

Product with sku and title changes still show old data on invoices.

Submitted by JonW on Mon, 12/17/2007 - 22:14
JonW
Posts: 40
 Joined: 12/05/2007

If you save an existing product with a new sku and/or update its name, the product edit form shows the new current data, but for some products, when the product is ordered, the orders in the admin/store/orders section show the products with the old names and sku's. This does not seem to be a consistent problem, about half of the sku's I changed did not take...it might have to do with whether the title was also changed??

I could spend all day trying to recreate this, and I will. But maybe someone familiar with the system could recognize the problem right away...

My store just went live tonight, so I have too much to do right now. I will work on recreating it later. In the mean time, where is the table that stores SKU and title, so I can check that out and edit it directly??

Thanks
permalink #1 Mon, 12/17/2007 - 22:41
aswalla

Posts: 50
 Joined: 08/17/2007
Getting busy with the Ubercode.Spreading the word - Ubercart for president.

Hi JonW - for the title, look in node and node_revisions. For the sku/model, look in uc_products.

permalink #2 Mon, 12/17/2007 - 23:31
JonW
Posts: 40
 Joined: 12/05/2007

I checked those tables, and all the data is correct. Very strange. I looked in node_revisions, thinking that this is perhaps where previous versions of the node would reside, but that table has only the current content in them.

I am going to sleep on this and just hope it disappears in the morning Smiling - maybe the bad orders had started their sessions prior to the data being changed? -

Thanks for the quick reply.

permalink #3 Mon, 12/17/2007 - 23:59
Alaska
Posts: 375
 Joined: 10/16/2007

Not sure if this is anywhere close to an answer but found an issue with inventory not reflecting changes. Seems clearing the browser cache did the trick, but most likely you have all ready been there and done that.

Jim

permalink #4 Tue, 12/18/2007 - 00:25
aswalla

Posts: 50
 Joined: 08/17/2007
Getting busy with the Ubercode.Spreading the word - Ubercart for president.

not sure if it would help as well but I recall having a problem where a cck field wasn't updating similar to your issue . It worked to empty (DON'T DROP!) all the cache tables in the sql file (cache_views cache_page cache_filter etc). Give that a try.

permalink #5 Tue, 12/18/2007 - 11:43
Ryan

Posts: 5367
 Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

When a product is ordered, the order saves a snapshot of the product's information so that the invoice does not change with time. So, any order already placed will not receive product title, SKU, price, or anything updates when the nodes themselves are updated.

(Based on the thread title, that would seem to answer the question, though your first post seemed to confuse the issue a little.)

permalink #6 Wed, 12/19/2007 - 12:42
JonW
Posts: 40
 Joined: 12/05/2007

Thanks to all for your ideas.
I was sidetracked with other issues, and it had to sit for a day...and now all is working as it should. So I do not know if it was a cache issue...could have been and it could have cleared itself up after 24hrs, or an issue with someone starting and saving an order from before I set the new SKU.

Either way, it is resolve now without me having to actively do anything.

Again, thanks for the quick and useful feedback.