Computer Repair Shop - Inventory - Help
by LPCS-Myke - 6/16/10 10:01 AM
Hello CNet. I'm a small business owner in the West Michigan area. We are a full service [residential/commercial] computer repair shop inside of our 3rd month of operation.
Things are going amazingly well for us, all things considered. It's almost become a problem from the internal processes angle... which is why I'm here seeking advice today.
Currently the process we have for inputting and tracking inventory is tiresome and prone to error.
First we use Avery DesignPro 5 to create Labels and UPCs for each item. The UPC code is created by us and is formulated on a first-come-first-serve basis. So.. 160GB HDD could be 1004, while a 500GB HDD could be 1056.
After that.. we scan the UPCs into Quickbooks PoS and add the UPC code as an Alternate look-up. We also have to input the Active price [Price we retail it for], and the intake price [costs to purchase the item]. The kicker is that both of these numbers change.. so the UPC code [Alternate look-up] is literally never accurate.
This causes round-about a million and a half problems.. and it only gets worse each time we re-up inventory.
I'm looking for help/advice/ideas that come at minimal cost. Obviously free solutions would be ideal.
Thanks in advance.