Forum Moderators: buckworks
More specificly:
We would like a product / customer / shoping cart database for store and web sales. Real time (live for web and inhouse searches). Our entire product inventory: in stock, on order, on order showing 'committed' for a mail order (available and not available). Web orders and store sales at the registers would use the same (one) inventory data base. (updating after a sale or checked in product)
Provideing search answers to: Is it in stock? What is the status of my order?
Customers should be able to check their order status on the site. What is the status of my order?
And they should be able to search our inventory database from our web site.
Searching our entire product line.
Accounting included is not neccesary but is very desireable.
If an item is ordered that we are out of, the system should look for 'on order' purchase orders and tie to the PO with a mail order Number. If the item is not on order the system should start a suggested purchase order for the appropriate product and vender and mark the item with the mail order number needing the item.
So, Front end and back end (shipping) mail order, ecommerce cart, along with retail store POS software and a general ledger accounting.
And two desireble quiry reports are: 1. Stock split lists between the two stores regarding same items shared inventory. 2. When freight is checked in or a mail order return is checked back into stock, the system should search mail orders to see if any need the said product.
It would be fantastic if the web cart could populate its own colors, sizes, gender, ... options from the inventory data. And, if individual items (not a general cart setting) could be flagged as a discontinued item. So, when the last size medium is sold, the size choice would be eliminated for the next cart shopper.