Option SKUs not displayed in saved order and not used in stock tracking

Actually, you should be reporting bugs here not on ubercart.org.

Can you please describe the problem in more detail including steps needed to reproduce the error?

Once the order is complete and I view the order I see only the parent sku's for all items in the cart regardless of the size that was selected.

I cannot confirm this bug. I set up a product with a size attribute, added three options (S, M, L), then assigned a different SKU to each option. I purchased this product, then went to view the completed order. (I looked at both admin/store/orders/% and user/%/order/%). The proper SKU is always shown to me in the order view. I suspect your node_import didn't do the right thing, so your product isn't configured correctly. Look at node/%/edit/adjustments to make sure the proper SKUs are associated with your product attributes, and check node/%/edit/stock to make sure you're tracking stock for all the child SKUs and not for the parent SKU.

I think the problem may be that you're using the same SKU for the parent and for one of the options. The parent SKU is set at node/%/edit, while the option SKUs are set at node/%/edit/adjustment, and default to the parent SKU. At node/%/edit/stock, *if* the parent SKU were unique you would see four rows instead of three: one row for the parent and one row for each of the individual options. In that case, you could uncheck "active" for the parent SKU and track the individual option SKUs separately. I think what might be happening in your situation is that the stock for the parent SKU gets decremented every time you sell that product with *any* option, but since the SKU shares a number with the smallest size it appears that the smallest size is getting decremented every time, no matter what size you buy.

As a fix, why don't you try modifying the parent SKU so it's unique (append a P or something) then turn off stock tracking on the parent at node/%/edit/stock.

Re: You second paragraph ... I doubt it's related, but regardless it's properly addressed in your other issue #686418: Size Attributes are our of order in drop down rather than here.

The value you want to change is stored in the model column of the uc_products table. I personally would write a script to change these values, but if there are some you don't want to change, or if you want to do more than add a suffix, it might just be quicker to use phpMyAdmin and change the model column by hand.

Sounds like this is fixed, so I'm changing the status.

I couldn't say whether that's normal or not - I've never tried it.

Hello there,

I am running into a similar problem, like yours, Razerback. I recently mass uploaded 15000 or so products using node import, and now when I create a test order only the parent sku is showing when I review the order, when I need the adjusted sku to show. The way I have it set up is numerical, for instance I have a clothing item that has a sku of 736438 and has 3 variations in sizes. The adjusted sku then becomes (parentsku+childsku), or:

Small: 736438-55651
Medium: 736438-55652
Large: 736438-55653

So in the order, if someone bought a large, 736438 is showing up on their order.

I need 736438-55653 to show up.

I looked into the coding to see if I could manually display the products' full sku but it could get very messy as that data appears to be in a different table called uc_products_adjustments and I'm not really sure on how to manually get that to display.

Also, one note, is that I imported all the products with stock disabled, as inventory is not needed on the site. However, as a test, I enabled stock on both the child and parent skus on the test product and placed an order, and it still didn't show up correctly on the order form, so I'm guessing that that's not the issue. I also disabled the parent sku in a different order as done with Razorback above and that still didn't work. Though Razorbacks issue was that the parent and child skus were the same? Mine should always be different because the child sku is unique.

I am also live as Razorback is so I'm a little nervous right now about making big changes like re-importing and such. Anything that you can do to help me out would be hugely appreciated!

Phoenixxx

Drupal 6.15 | Ubercart 6.x-2.x-dev | Node import 6.x-1.x-dev

Hi all,

I am using Ubercart 3 with drupal 7. I am still having this problem. When i make an order, the stock not even reducing for the adjustment sku and showing the parent sku in the order. I followed the instructions properly and i have three unique adjustment skus(Prod-g1, prod-g2, prod-g3) and unique default sku(prod-g). I also unchecked the default sku from stock. Am i doing anything wrong? If any help would be highly appreciated. Thanks.

I really doubt any of the information in this four year old closed issue has any relevance.

If you're really using 7.x-3.0-alpha1, then you need to upgrade. We're not going to support extremely old alpha releases. If you can reproduce your issue with the current version of Ubercart, then please provide some detailed information about how you've configured your site and post steps to reproduce the issue along with a description of what you expect to see. But open up a new thread for that purpose, don't post it here.

Hi TR, Thanks for you information. I updated the Ubercart and now it seems to be working. Thanks again!