Community Forums 

Main Content

Re:Live Inventory: How to implement?

    Mar 21 2012 18:44:32



    Join date : 2008-09-18      Posts : 488

    I've done it and GT has it right. There are three pieces:

    1) MySQL product database with product codes and stock. In your case, since you want to display or not display products based on stock level, I recommend putting all your product info in the database (description, price, etc.). You'll find there are lots of other advantages to having all product info in a database.
    2) Remote call script (php) to update stock levels after sale is complete.
    3) php function called from your web pages to display a product if there is any quantity in stock.