0 Replies Latest reply: Nov 30, 2013 7:03 PM by Mohsin Zubair RSS

    Retail Data model

    Mohsin Zubair

      Does any body help me how to create Item table structure for POS system

       

      and how to update SKU suppose i have these three record for sale-able items

       

      item_no    | Item Desc                               |  Price | UOM | item_per_pk  | Ref_no

       

      001            Match box Pack Jumbo            |   100  | PK    | 10                 | null

      002            Match Box Pack Big                |    70   | PK    | 20                 | 001

      003            Match Box Unit                        |   10   | Unit   | 1                   | 002

       

      What i want.

      how to manage inventory these type of items and how to update as i can sale loose item from jumbo and same for big pack

       

       

      Regards