Welcome to WebmasterWorld Guest from 126.96.36.199
Forum Moderators: buckworks
Should I list all sizes and if user orders something unavailable, then just refund the money and apologize? Or should I update quantities in the description field?
As a side question. Are there any shopping carts that support this sort of complex inventory. Sizes + colors + quantities? I can't even think of a way this could be implemented...
Items with multile variations. Once the variations are selected, the result is a unique entity which should have an inventory count.
So, start with Widgets which are available in Red, Blue and Green and then have L,XL,XXL sizes.
No matter what your process for selecting them, at the end of the day, your database should tell you how many Red Widgets in XL size are in your inventory and you can then let the customer buy or not buy.
Do not take money and apologize. This can turn into a mess, as you'll loose money on the credit card processing fees.
I think OScommerce has a module which allows you to do this (the one I've seen is paid for.. there might be free ones).
If it's clothing you need to have a master colors table and you'll also need a item attributes table to manage colors by item
skuxyz comes in red and green:
Same thing for sizes:
[edited by: minnapple at 2:41 pm (utc) on April 17, 2006]
[edit reason] TOS #13 [/edit]
Footwear is where you'll have loads of work setting up your creating and editing facilities. I had to build a grid of checkboxes by size and width.
Does this make sense?
5 ¦ 5.5 ¦ 6 ¦ 6.5
widthB x x
widthD x x x
Then dump those values into the sizes table for that item.