Looking for a personalized inventory tracking, reporting and forecasting system.
We sell discontinued china and tableware. Since it's discontinued, we do not have a "normal" supply chain. Instead we buy from private individuals as it is offered to us. So we need to have a very solid grasp as to what has sold in the past to help inform our purchasing decisions.
Looking to setup a data base to:
-track current inventory both in quantity and dollar value (on a sku level as well as a category level, (e.g. sku would be how many "Lenox Liberty dinner plates" sold, while category would be how many "Lenox Liberty" items overall sold including dinner plates, cups, bowls etc.)
--best selling products by qty
--best selling products by dollar amt
--worst selling products by qty
--worst selling products by dollar amt
--best selling categories by qty
--best selling categories by dollar amt
--worst selling categories by qty
--worst selling categories by dollar amt
-ease of use
--easy upload of inventory (thru excel)
--easy upload of transactions from multiple channels (website, ebay, amz, channels manager
--show averages over x periods of time (e.g. sold x amount over the past three months or years)
--trend charts (if possible)
--factor in product bundles
--excellent search features needed
--speed a must
--average time in inventory
--factor in seasonal fluctuations
--factor in unavailability of product
Looking for top quality work and very willing to pay for it.