Home » Issue Tracker » Ubercart

Unable to change a sub-products SKU more than once

Submitted by AntoineSolutions on Mon, 05/05/2008 - 20:23.
Project: 
Ubercart
Category: 
bug report
Version: 
Ubercart 1.0 RC
Priority: 
normal
Assigned: 
Unassigned
Status: 
fixed

I created a product and gave it a default SKU. I then added attributes and attributes options and then went to the adjustments tab to modify the SKU's. I accidentally gave a sub-product the wrong SKU and when I went to change it, the message "Product adjustments have been saved" appears but the SKU has in fact not been changed.

Cheers,

Jon Antoine
www.antoinesolutions.com
#1Submitted by Lyle on Tue, 05/06/2008 - 09:47.

Re: Unable to change a sub-products SKU more than once

You can change it if you change it to something that isn't the default. If the value of the adjustment is the same as the product node's SKU, then the form doesn't save it to the database. That keeps us from having a bunch of duplicate data floating around. The problem is that if you try to change it back, it doesn't delete the old record. That's now fixed in the latest version.

#2Submitted by AntoineSolutions on Tue, 05/06/2008 - 13:52.

Lyle, I just downloaded the

Lyle,

I just downloaded the latest from the bazaar repository. When I replace a SKU with the products default SKU and click submit, the records don't appear to be deleting from the database because the SKU I was replacing appears again.

Cheers,

Jon Antoine
www.antoinesolutions.com

#3Submitted by AntoineSolutions on Tue, 05/06/2008 - 14:09.

Lyle, To elaborate further

Lyle,

To elaborate further on the issue, I found a SKU that I typed incorrectly and when I went to re-enter it correctly, this change was not committed to the database either. Both the originating SKU and the destination SKU were unique to the table.

Cheers,

Jon Antoine
www.antoinesolutions.com

#4Submitted by Lyle on Tue, 05/06/2008 - 15:06.

Re: Lyle, To elaborate further

When I was testing this morning to track down this bug, I only had problems with SKUs that were the same as the product's. All the others saved just fine.

#5Submitted by AntoineSolutions on Tue, 05/06/2008 - 15:40.

Re: Re: Lyle, To elaborate further

Here are the particulars to what I am seeing.

1. Create product with SKU 30911
2. Add attributes with options
3. Set product-attribute-combo options to 30008-A, 30008-B, 30008-C, 30008-D, 30008-E, 30008-F, 30008-G, 3008-H (Should be 30008-H).
4. Trying to set SKU to 30008-H fails.

Let me know if you need more info, I'd be happy to zip up my database for your inspection if that would help.

Cheers,

Jon Antoine
www.antoinesolutions.com