I have the column in my orders table for status. So all I need is the session and no status table? If I put "pending" for the session to post in order table is that ok?
I will redo my order_items table and do an order itemid and make orderid the sessionid. I want to add the inventoryid to this table, this is the table that the sizes are stored. Will I have a problem posting the inventoryid to the order_items table? Do I need to add an inventory recordset and if so do I need to inner join it with products?