Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
November 29, 2018
Question

Inventory with the same name, but different stock codes

  • November 29, 2018
  • 13 replies
  • 50 views

Good morning,

 

We have a service center where we service and repair vehicles. 

 

Being new to Quickbooks, is it possible to load e.g Oil filter (as product name) and in the SKU, the stock code (Z156, Z25A etc). At this stage, I get an error when I load it like this.

 

Your assistance is appreciated.

 

Kind Regards, 

 

Ane Venter

13 replies

November 29, 2018

Thanks for choosing QuickBooks, @AneVenter.

 

I have some information that should help you in setting up inventory items in Products and Services.

 

At this time, you should be tracking inventory items in different names since QuickBooks would recognize item that already exists. You may add the stock code as a name extension, so each item differs.

 

While the feature you need isn't available, I encourage you to send feedback straight to our product developer to let them know you'd like this added. QuickBooks Online is a constantly evolving platform and the voice of users, like yourself, helps steer the changes that occur.

 

Here's how:

  1. Go to the Gear icon.
  2. Choose Feedback.
  3. Enter your request/product suggestion, then click Next.
  4. Select Feedback as the Category.
  5. Click Send message.

Additionally, I want you to know that your voice matters and I'm going to submit feedback based on this interaction. Feedback is sent to the Development Team for determining what features and systems to implement for users.

 

With you being new to QuickBooks, I'd like to leave some helpful articles and tutorial about Inventory in QuickBooks Online:

That should help you add new inventory items. Let me know how things go once you've tried the steps. If you should need anything, I'm just a reply away. Have a most lovely day.

October 9, 2019

This feature is much needed. Take a T-Shirt for example. I will have a SKU for EVERY style, color, size combination. Now I am expected to create a new product for every single combination?

 

The concept of Products and SKUs is extremely common across every ERP system. I know that Quickbooks is not an ERP system, but to keep customers like me on board, I need basic business concepts such as Products and SKUs to be supported in the correct systematic manner. Multiple SKUs within a single Product Name should and must be supported.

 

A simple solution: Enforce the unique constraint ONLY if the Product Name AND SKU are identical. This is a very minor change that your development team can development in an hour, test in 1 day, and implement in the next release.

October 9, 2019

 

It's great to have you here, @rtate,

 

We recognize the urgency to create identical item names with different codes in QuickBooks Online. While this preference is currently unsupported, I recommend following the suggestions provided by my colleagues in this thread.

 

We don't have the timeline on when our engineers will release new features. Rest assured, this feedback is forwarded to the Development team for consideration in future updates. They strive to meet the needs of our customers by reviewing the requests sent to them.To stay updated on all QuickBooks news and product updates, you can view the details through here: QuickBooks Blog.

 

If you need additional help with QuickBooks, just click the Reply button below. I’ll be more than happy to provide further assistance. Have a lovely day!

Rustler
Level 15
November 29, 2018

@AneVenter wrote:

Good morning,

 

We have a service center where we service and repair vehicles. 

 

Being new to Quickbooks, is it possible to load e.g Oil filter (as product name) and in the SKU, the stock code (Z156, Z25A etc). At this stage, I get an error when I load it like this.

 

Your assistance is appreciated.

 

Kind Regards, 

 

Ane Venter


QB names have to be different

make a category for oil filters, then use the stock code for the name, thos items would be under the category oil filter

November 26, 2020

I have the same situation like you, but If I found any solution then I'll let you know FaceTime PC

February 10, 2021

We're all barking on the wrong tree. It is apparent that QuickBooks Online is so deficient in its Inventory module that it can't do most of what we deem basic functions. The poor company moderator here can just keep on referring us to the blog that take new function requests, which will never be implemented because QBO concentrates mainly with contractor service accounting, not detail inventory mgmt accounting. After unbelievable amount of hours researching, tweaking, and experimenting, I have come to the conclusion that it is best to just keep "Product/Service" exactly the same as "SKU", and do the usual "product name" in the "Description" field. This way, one can easily export inventory list, modify contents, and import inventory list back in to replace existing inventory records in QBO. I learned it the hard way that "Product/Service" if not unique, system will just keep on churning a new record on every import. My inventory is jam packed with outdated inventory items that I can no longer delete (only inactivate is available). Frankly if I have another choice of doing inventory mgmt and accounting better, I will switch in a heartbeat. The last comment is for QuickBooks mgmt to see.