Inventory Management

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi guys, 

I have an inventory management issue which has 2 possible solutions. Let me know if they make sense or what you would recommend. 

1) Integrate an inventory management software like fishbowl to Quickbooks and then Synchronize with Product Cart ?  The problem I have is that our wholesale business also uses the same quickbooks account and we want to separate the inventories. Due to the complexities of managing our wholesale inventory, I want to treat our online business (and online inventory) almost like a separate entity.  Also, we have less than 300 SKUS which I feel does not justify the investment in an inventory management software. 

2) Using the export product info, i could determine what needs to be reordered, when, and how much. To do that,  I would have to add fields to product cart, some which are input fields and some would have to calculate a value (using a formula). They would include the following per SKU

Lead time

Monthly Average Sales (units)

Safety Stock

Lead Time Sales

Min Stock

on PO

Stock 

Min inventory

INV value (costs)

INV value (retail) 

Reorder Level 

Etc. 

Does version 3.5 provide more reporting and inventory management capabilities ? 

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ecoist Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 08-July-2008 Status: Offline Points: 0	Post Options Post Reply Quote ecoist Report Post Thanks(0) Quote Reply Topic: Inventory Management Posted: 13-May-2009 at 3:20am
	Hi guys, I have an inventory management issue which has 2 possible solutions. Let me know if they make sense or what you would recommend. 1) Integrate an inventory management software like fishbowl to Quickbooks and then Synchronize with Product Cart ? The problem I have is that our wholesale business also uses the same quickbooks account and we want to separate the inventories. Due to the complexities of managing our wholesale inventory, I want to treat our online business (and online inventory) almost like a separate entity. Also, we have less than 300 SKUS which I feel does not justify the investment in an inventory management software. 2) Using the export product info, i could determine what needs to be reordered, when, and how much. To do that, I would have to add fields to product cart, some which are input fields and some would have to calculate a value (using a formula). They would include the following per SKU Lead time Monthly Average Sales (units) Safety Stock Lead Time Sales Min Stock on PO Stock Min inventory INV value (costs) INV value (retail) Reorder Level Etc. Does version 3.5 provide more reporting and inventory management capabilities ?

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply Posted: 19-May-2009 at 9:02pm
	Aren't "Min Stock", "Min Inventory", "Reorder Level"... the same thing? ProductCart contains a "Reorder Level" field, and you could add some of the other fields as "Custom Search Fields" (product properties), which become unlimited in ProductCart v3.5. See the documentation about Custom Search Fields: http://wiki.earlyimpact.com/productcart/managing_search_fields ... and some more technical information (and an inventory-related application of custom search fields): http://wiki.earlyimpact.com/developers/custom_search_fields_db We hope this helps!
	The ProductCart Team Home of ProductCart shopping cart software

intour Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 30-June-2006 Location: United Kingdom Status: Offline Points: 0	Post Options Post Reply Quote intour Report Post Thanks(0) Quote Reply Posted: 22-May-2009 at 2:35pm
	Usually Re-order level kicks in before the Min stock is reached. If you re-order when you reach Min stock its too late. I think Min inventory refers to the Minimum Order level (the minumum amount you would order from a particular supplier). Thats what we call it in the UK anyhow. So all 3 are different. Many companies have quite complicated mathematical equations for calculating these things. And then of course you have the Economic Order Quantity ! A common one is the square root of 2 x (annual usage in units)x(annual cost) divided by the annual carrying cost per unit. Sorry couldnt show that as an equation properly here. Nigel
	Innerview Productcart Platinum Reseller Web Design/Hosting/Virtual Tours