Getting Started - Inventory Management

Print Page | Close Window

Inventory Management

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Getting Started
Forum Description: Installing, activating, and getting started with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=2733
Printed Date: 05-October-2024 at 9:54pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Inventory Management

Posted By: ecoist
Subject: Inventory Management
Date 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 ?

Replies:

Posted By: ProductCart
Date 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 - 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 - http://wiki.earlyimpact.com/developers/custom_search_fields_db

We hope this helps!

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: intour
Date 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

-------------
http://www.innerview.co.uk - Innerview
Productcart Platinum Reseller
Web Design/Hosting/Virtual Tours