ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Getting Started
  New Posts New Posts RSS Feed - Inventory Management
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Inventory Management

 Post Reply Post Reply
Author
Message
ecoist View Drop Down
Newbie
Newbie


Joined: 08-July-2008
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote ecoist Quote  Post ReplyReply Direct Link To This Post 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 ?

Back to Top
ProductCart View Drop Down
Admin Group
Admin Group

ProductCart Team

Joined: 01-October-2003
Status: Offline
Points: 135
Post Options Post Options   Thanks (0) Thanks(0)   Quote ProductCart Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
intour View Drop Down
Senior Member
Senior Member


Joined: 30-June-2006
Location: United Kingdom
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote intour Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.070 seconds.