locked
how to integrate inventory to bakery template RRS feed

  • Question

  • User-1557173817 posted

    hello working on the bakery template but wondering how integrate inventory management of stock. Any help?

    Friday, December 4, 2015 4:59 PM

Answers

  • User379720387 posted

    During the checkout process, or at the time when the shipment is made:

    UPDATE Orders SET Quantity = Quantity - 1 WHERE ...

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, December 10, 2015 10:00 PM

All replies

  • User379720387 posted

    Create a table:

    Inventory

    itemId PK

    itemDescription

    itemQty

    Everytime a user checks out an item you reduce itemQty by 1

    Monday, December 7, 2015 10:36 AM
  • User-1557173817 posted

    Thank you, but how can I reduce the stock quantity by 1 each a user checkout. i need code samples.

    Tuesday, December 8, 2015 3:26 PM
  • User379720387 posted

    During the checkout process, or at the time when the shipment is made:

    UPDATE Orders SET Quantity = Quantity - 1 WHERE ...

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, December 10, 2015 10:00 PM