 Help managing item lists in Quickbooks
Does anyone have a good system for organizing their blank apparel items in Quickbooks?
We're a screen printing company that is allowing for clients to print on a variety of different items. We're just starting to learn Quickbooks and I can soo see our item list getting really out of control.
For instance, if we tell customers that we will print on Hanes style # 5170 then that's over 150 items in Quickbooks (28 colors, and 5-7 sizes in each color) I'm assuming that there is no way around having to create a gazillion items in our item list, but does anyone know of a "good" way to do this?
Currently our item list is set up with sub-items as follows:
T-Shirts:Hanes:5170 (Ash Grey) S
This gets us individual item names but it doesn't lend itself to data integrity and in general it just doesn't seem right.
On the other hand, if we separated things into more sub-items we'd have a bunch of sub-items listed as "S":
T-Shirts:Hanes:5170:Ash:S
T-Shirts:Hanes:5170:Black:S
That doesn't seem right either.
Soooo what's a good way to do this? Does anyone use their own model numbers? We toyed with creating descriptive sub-items like gender and fit to make it easier for us in a bunch of different ways. We are planning on using a Yahoo Store, does anyone how much does this will affect the "back end" of our store?
Any help would be greatly appreciated! |