The SKU's section has a fundamental flaw, more than one option needs to be a unique sku
SKU's are traditionally used to track the number of products in stock. For the most part this works well on the website except when you have a product with two or more options. For Example, product Tshirt is a great product, but we have three sizes, (S,M,L). We also have 3 colors (Red, Green, Blue). The current method allows me to specify an SKU for a Small Tshirt, but there is no way to specify the SKU for a Small Blue Tshirt. This is unfortunate, since many companies have products with far greater options. Perhaps you could append the original SKU if an option is picked, so a the SKU for a small blue Tshirt could be: shirt-S-BL. In any case, this would make your shopping cart better.

18 comments
-
Anonymous commented
Maybe ask them to request a color
-
DJR commented
So has this fix happened? Is there a way to show one item then have the inventory table affected properly when a customer selects a Medium, for example. I have different inventory levels relative to size and I don't want to show 5 shirts for each one. Help?
-
Gary Whitt commented
It's a shame, really, when the backend user interface 'suggests' a functionality that was only engineered 1 millimeter deep with no actual thought to the SKU being indexed in the database so they can be related. Then there's the (probably) refund issue that won't allow partial refunds. Money and inventory are evidently (stupidly) coupled in the database somehow and do not reflect real world retail. Not everybody is some multi-level marketer, you know.
But it's an ancient legacy database design error that is well past ignoring. That being said, I got tired of waiting and just reported out all my sales to Google Analytics and funny, I can now (a year later) report out sales figures back one year to my heart's content. Still can do a partial refund out of the cart, though....
-
DoradoVista Inc. commented
Really need this to make 1SC product tracking match 1:1 through the whole pipeline. Having reports, videos & DVD's for each product line breaks the ability to allow customer a simple SKU checkbox and be able to unwind all the sales data later. Ugh! Please fix soon.
-
This change has not been made in the system as there are some complications with the existing implementation of SKU's for products. The SKU field was initially implemented simply for you to add a SKU that would appear in order notices, invoices, etc. to help with fulfillment. As a result the filed was implemented as an optional field, which in turn limited the functional possibilities.
In addition there are complications with how SKU's are generated for products with multiple product options, which in turn limit how granular inventory can be tracked.
These challenges require a significant effort to solve and must be solved together in order to satisfy the requirements we've collected from our users. We hope to have the opportunity to prioritize this work on our roadmap in the coming months and appreciate everyone's continued support and feedback of this idea. The more we hear from users that this is important, the easier it will be for us to prioritize it against other initiatives that users are asking for.
Thanks everyone for the discussion and your votes! Looking forward to hearing more on how we can make SKU's work for you.
-
storres Uniforms commented
Hello,
is this already in place SKUs and Stock inventory by product combination ? -
SpongeCandy.com commented
It doesn't matter if you assign SKU's to the first option anyway, as you can't report out SALES BY SKU. If you look at the inventory reports or the sales by item reports, they are actually reporting by the internally generated Product ID, which is the product without any options. Same for the "inventory control". SKU's have no relevance anywhere. That assigning SKU's business is just some so-called software engineer's incomplete, incompetent effort.
SO, a year ago when I reorganized my product line in the shopping cart from 20 products down to a more comprehensible 6 products with options and assigned SKU's to the product option values, little did I realize a year later I wouldn't be able to pull my sales data out of the database to forecast the coming Christmas season.
I suggested some sort of fix back in March: "Sales Reports or Analytics Reports needs SALES BY SKU" So far NADA....
http://ideas.1shoppingcart.com/forums/20399-big-ideas/suggestions/2674544-sales-reports-or-analytics-reports-needs-sales-by- -
Surthrival LLC commented
PLEASE get this idea rolling!! It is really needed and would be extremely appreciated~ :-)
-
NicStick Inc. commented
Is there any headway on this item?
-
dainismichel commented
well, i just signed up for premium support, or whatever it's called, called 1SC and they pointed out the checkbox. i went through the KB, the dox, and searched online. i find it annoying when it looks like poor documentation "drives" customers to purchase more robust support packages. i searched for "inventory" i searched for "quantity," etc. as a "former" documentation professional, here's my take: "excellent documentation increases internal efficiency, enhances user satisfaction...and drives sales."
-
dainismichel commented
is it possible that i can't control inventory with 1sc? i'm selling workshops with 20 seats. i've been searching around for a few hours and can't figure out how to limit the number of a product available. totally a deal-breaker for 1sc. gotta look for another alternative for myself and my clients if 1sc can't do this...i can't find "optional values - inventory" right now...i'll keep looking
-
Thomas Laine commented
I'm adding duplicate items to my site to support different sizes and colors. Generally, my biggest complaint about 1SC is the stock management. I would also like to point out that the product export contains stock info, but the API does not; this would not be a big leap in coding but would make reinforce 1SC can manage stock.
-
Surefire Fitness Bootcamp commented
This really needs to happen soon. I'll be forced to look for another shopping cart if I can't track inventory on each option. I run fitness boot camps and need to cap each class at a certain number of people. If I oversell, it's bad news.
-
Jeff Howard commented
Why would I want to appear to be unprofessional to my customers by selling them something I am out of stock on? An inventory option is a MUST, please.
-
jp francia commented
Please please please add inventory tracking by size!!!! I sell clothing for kids and cant live without this feature.
-
Active Sports Ltd commented
Oh and out of stock feature is extremely important. We are often overselling items.
-
Active Sports Ltd commented
I agree with this but can you even still do this basic level of inventory tracking? I couldn't see it under Product Optional Values.
-
Ringold Nutritional Systems LLC commented
In addition, you should be able to assign each product a quantity that it represents in inventory. For example, I setup up different products for 1 bottle of vitamins, 2 bottles of vitamins, and 3 bottles of vitamins. If a customer purchases my 3 bottle product, I need it to take 3 bottles out of inventory.