Forum Moderators: open

Message Too Old, No Replies

Off-the-shelf Stock Control

Anybody know of one?

         

Balloon

5:00 pm on Jun 6, 2005 (gmt 0)

10+ Year Member



Hi,

I'm in the middle of building a bespoke e-commerce site for one of our clients. They've now announced that they want to add stock control and inventory valuation systems into the back-end.

Does anyone know of an 'off-the-shelf' stock control system that I could integrate with my system?

Thanks,
- Chris

TheNige

9:37 pm on Jun 6, 2005 (gmt 0)

10+ Year Member



I use QuickBooks for my invoicing and inventory systems and then export the inventory to my website database.

Balloon

12:49 pm on Jun 7, 2005 (gmt 0)

10+ Year Member



Sounds interesting!

Could you also go the other way - take updated stock readings from the web site (which is where the stuff is being sold) and import it back into QuickBooks?

Thanks,
- Chris

TheNige

9:34 pm on Jun 7, 2005 (gmt 0)

10+ Year Member



There are ways I believe to import transactions into QuickBooks.

The way I use it though is that each time I get an order on the website I enter the invoice or receipt into QB and treat QB as the master of the stock levels and then just do a quick export of the data back to website. This is good for me, as I could also take transactions off-line with phone orders, etc and always have the correct stock levels on the website.

I was using SQL Server so I created a DTS package to do the updates and would run it with a command line batch file to make it easy.