Home » Forums » Ubercart » Bug Reports
6 replies [Last post]
Mon, 12/17/2007 - 22:14
JonW
JonW's picture
Offline
Joined: 12/05/2007
Juice: 94
Was this information Helpful?

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

Top
Mon, 12/17/2007 - 22:41
#1 View page
aswalla
aswalla's picture
Offline
Getting busy with the Ubercode.Spreading the word - Ubercart for president.
Joined: 08/17/2007
Juice: 105
Re: Product with sku and title changes still show old data on in

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

Top
Mon, 12/17/2007 - 23:31
#2 View page
JonW
JonW's picture
Offline
Joined: 12/05/2007
Juice: 94
Thanks - but those are all good.

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.

Top
Mon, 12/17/2007 - 23:59
#3 View page
Alaska
Alaska's picture
Offline
Joined: 10/16/2007
Juice: 1433
Title Changes

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

Top
Tue, 12/18/2007 - 00:25
#4 View page
aswalla
aswalla's picture
Offline
Getting busy with the Ubercode.Spreading the word - Ubercart for president.
Joined: 08/17/2007
Juice: 105
Re: Title Changes

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.

Top
Tue, 12/18/2007 - 11:43
#5 View page
Ryan
Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15438
Re: Product with sku and title changes still show old data on in

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.)

Top
Wed, 12/19/2007 - 12:42
#6 View page
JonW
JonW's picture
Offline
Joined: 12/05/2007
Juice: 94
Problem resolved...not sure why though

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.

Top