I would have to agree with Jeff, Steve, and Alvin. Trying to design an inventory management system may be difficult and can cost you your time and your effort. If you could, I would recommend using programs that already exist to help you with your small business. One suggestion I would give is try using Mailware. It helps manage orders and has that inventory management [/url]aspect that you are looking for.