Level 54
i'm confused too... i always thought available is a boolean flag that based on quantity... perhaps someone can explain better why and when need to have both availability and quantity...
Nov 1, 2020
2
Level 1
shopping cart database design for "products" table
should the "products" table for an ecommerce website have two columns: "availability" and "quantity", so that when user clicks on checkout, availability will reduce, and when the order is completed, quantity will reduce? or should it just be "quantity" ?
I am a bit confused about the overall process of adding products to cart/ checkout/ complete order , and how it relates to product quantity/availability.
Level 5
For me 'availability' is the date it becomes available, 'quantity' is stock keeping. For instance when stock/quantity = 0, restock but that takes time so availability = 3 weeks.
Of course a good shopkeeper will restock in advance ;)
Please or to participate in this conversation.