Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using Quickbooks to handle invoicing, purchasing, sales, etc. and so, to facilitate all these processes, I have an 'Items' list; I know, pretty standard stuff, right? Well, here's my problem, what I've been told I can do about it, and my woes trying to figure it out.

The Problem: Many of my items, while still serving the same needs of my customers, have changed item numbers, manufacturers, price, etc. In other cases, my default item is the latest and greatest, but some customers still need the old items. The best way to describe my situation is through an example...

The following is a pretty typical order around here: 2 x 2D Barcode Scanners, 6 x 10' Scanner Cable - Serial, 4 x 16' Scanner Cable - USB, 2 x 40' USB Extension Cable.

Now, for the above order, depending on which customer it is (and in turn, what kind and how new of an installation they have) the 2D Barcode Scanners will be 1 of 3 types. As a result, there are 3 different items in my QB that start with 2D Barcode Scanner and then some ending tag that distinguishes each from the others. My Scanner Cables come in one of two types, depending on the Scanner-side connector, so there are two entries for both the -Serial and -USB cables. Finally, on the 40' Extension Cable, it could have one of several part numbers and manufacturers depending on which batch it came in (I order these through a discount service, so the specifics change based on which price is lowest at the time of my order).

The result of all this mess is that my 'Items' list in QB is stupidly long and fairly repetitive, both of which make it less than simple to navigate. A friend of mine (an accountant, so probably not the most experienced when it comes to using QB for inventory-related tasks) suggested that there was a way to have some sort of master item that then held the different specifics within it so that, instead of having 3 different items for my 2D Scanners, I could have one entry that would then let me specify which type to use in each instance. The same idea applies to my other woes, and I'd like to get it to where my 'Items' list only displays a sort of 'what is it' list that I then use to specify which one.

In the system I'm trying to effect, the above order would be entered by: Clicking on 2D Barcode Scanner (the only one in my streamlined 'Items' list), then selecting which type, etc.

My ultimate question is: Is there a way to accomplish this? If so, how? If not, what can you suggest that would get me close?

Thanks in advance.

share|improve this question

Late answer, for what it's worth... I'd download the current item list into csv or xsl file and change what you want there. Then format it to QB's requirements and upload the new items list. I gather you'd have to delete the old one. Scary! I'd do it just before I upload a new one.

share|improve this answer
Feedback on one more. This one is also a pretty vague description of an approach that isn't very actionable. It's more of a hint to a direction to investigate, so it would be more appropriate as a comment. A much better answer would be to show an example in enough detail for someone to follow. You seem to have some experience with QB. Pick some questions where you can post high quality answers based on the information provided in the question. That will attract upvotes, which will build your rep so that you can help on questions where comments are needed. – fixer1234 Jun 29 at 4:09
It says everything another QB user would need to understand my suggestion. Similarly, my other post did as well grammar and spelling notwithstanding. I didn't realize answers had to be in the form of technical writing or instruction manuals. Perhaps the tour would help. And I will refrain from posting when sleepy in the future. I just happened upon this site and answered questions I saw without reading the about the apparently very narrow parameters for engagement. I'll stick to the more casual LinkedIn Q&A help groups. – VSJohnson Jun 30 at 8:36

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .