1ShoppingCart.com

New and returning users may sign in

Sign in
prestine
(thinking…)
Password icon
Sign in with: Facebook Google 1ShoppingCart.com
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
  • Sign in
  • Sign up
← Big Ideas

1ShoppingCart would rule the eCommerce world if you just...

Feedback

15 15 votes

Big Ideas: Products & Inventory

Categories

  • CATEGORIES
  • All ideas
  • My feedback
  • API 40 ideas
  • Ad Trackers 10 ideas
  • Affiliate Module 95 ideas
  • Analytics 9 ideas
  • Autoresponders 85 ideas
  • Broadcasting 62 ideas
  • Bundle Offers 21 ideas
  • Contacts 73 ideas
  • Control Panel & Dashboard 25 ideas
  • Coupons & Discounts 54 ideas
  • Customer Portal 13 ideas
  • Customer Support 28 ideas
  • Digital Products 30 ideas
  • Email Notifications 38 ideas
  • Email Reporting 14 ideas
  • Email Templates 8 ideas
  • Mobile 20 ideas
  • Orders 101 ideas
  • Other 44 ideas
  • Payment Gateways 51 ideas
  • Products & Inventory 85 ideas
  • Recurring Billing 48 ideas
  • Sales Reporting 33 ideas
  • Settings & Options 9 ideas
  • Shipping & Taxes 73 ideas
  • Shopping Cart 116 ideas
  • Store Builder 16 ideas
  • Tags 3 ideas
  • Third Party Integrations 61 ideas
  • Upsell Express 20 ideas
  • User Management 7 ideas
  • Web Forms 28 ideas

JUMP TO ANOTHER FORUM

(thinking…)
  • Searching…

    No results.

    Clear search results
    • Big Ideas 1,375 ideas
  • 1ShoppingCart.com

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.

15 votes
Vote
Sign in
prestine
(thinking…)
Password icon
Sign in with: Facebook Google 1ShoppingCart.com
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
NicStick Inc. shared this idea  ·  June 20, 2011  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →
Tweet

18 comments

  • Remove
Attach a File
Sign in
prestine
(thinking…)
Password icon
Sign in with: Facebook Google 1ShoppingCart.com
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·  March 17, 2014 01:28  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    Maybe ask them to request a color

    Submitting...
  • DJR commented  ·  January 14, 2014 16:50  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    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?

    Submitting...
  • Gary Whitt commented  ·  October 09, 2013 07:31  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

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

    Submitting...
  • DoradoVista Inc. commented  ·  October 08, 2013 18:02  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    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.

    Submitting...
  • AdminJustin Bell (Director of Product Strategy, 1ShoppingCart.com) commented  ·  August 30, 2013 06:45  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    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.

    Submitting...
  • storres Uniforms commented  ·  August 29, 2013 18:00  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    Hello,
    is this already in place SKUs and Stock inventory by product combination ?

    Submitting...
  • SpongeCandy.com commented  ·  September 06, 2012 18:26  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    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-

    Submitting...
  • Surthrival LLC commented  ·  September 06, 2012 08:17  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    PLEASE get this idea rolling!! It is really needed and would be extremely appreciated~ :-)

    Submitting...
  • NicStick Inc. commented  ·  July 29, 2011 12:21  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    Is there any headway on this item?

    Submitting...
  • dainismichel commented  ·  April 04, 2011 14:28  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

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

    Submitting...
  • dainismichel commented  ·  April 04, 2011 12:07  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    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

    Submitting...
  • Thomas Laine commented  ·  November 10, 2010 14:27  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    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.

    Submitting...
  • Surefire Fitness Bootcamp commented  ·  October 11, 2010 11:30  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    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.

    Submitting...
  • Jeff Howard commented  ·  May 21, 2010 11:50  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    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.

    Submitting...
  • jp francia commented  ·  February 12, 2010 13:07  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    Please please please add inventory tracking by size!!!! I sell clothing for kids and cant live without this feature.

    Submitting...
  • Active Sports Ltd commented  ·  January 26, 2010 19:10  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    Oh and out of stock feature is extremely important. We are often overselling items.

    Submitting...
  • Active Sports Ltd commented  ·  January 26, 2010 19:09  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    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.

    Submitting...
  • Ringold Nutritional Systems LLC commented  ·  October 11, 2009 08:48  ·  Flag as inappropriate  ·  Edit…  ·  Delete…

    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.

    Submitting...
1ShoppingCart.com
1ShoppingCart.com Terms of Service Powered By UserVoice

Your password has been reset

We have made changes to increase our security and have reset your password.

We've just sent you an email to . Click the link to create a password, then come back here and sign in.