Not worked with 'clothing' in a cart before and as a result hadn't realised the joys and endless permutations created from it lol <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>


I have the cart working fine but wondered if anyone had any general pointers, links or guides as to how best to control the stock generated for clothing? This is what I have at the moment:


Product Table
---------------------
contains all the product information with a 'stock level' and 'stock alert' (used to notify admin to re-order) - this is fine for most products!


This is all fine having stock that does not have multiple versions like size and colour but I want to keep tight control on each size/colour permutation and what we have in stock so have added the following.......................


If the product now has entries in either the 'productSizes' or 'productColour' tables I use the total of them as a 'stock level' now rather than the 'stock level' in the products table!


Does this sound ok to folk? If not do you have a better way to achieve this? Oh yeah only working with Access a the moment <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>


Additional Tables for clothing
------------------------------------------


Size Table
-----------------
sizeID
sizeDesc
sizeStock
sizeStockAlert


productSizes
--------------------
productID
sizeID


Colour Table
------------------
colourID
colourDesc
colourStock
colourStockAlert


productColours
----------------------
productID
colourID


Regards,

Jaysun

[ Web Chimp ]

------------------------
www.ultra-dumb.co.uk
&lt;ook!&gt;Brain food for web chimps&lt;/ook!&gt;

------------------------

Unless you can set up a unique Product code for each particular product attribute, like 12345-S-RED, 12345-M-RED, 12345-M-BLU etc. I can't think of any way to do it without setting up Many-to-Many relationships and retreiving everything with Queries.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

That's what I thought Owen <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

It's one of those problems that get 'harder' the more you think about it and add more options to lol <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> I reckon this would work.......what do you think?

Product Table [ as is ]
-----------------------

Size Table
-----------------
sizeID
sizeDesc
sizeP2A*

*this is a 'price to add' option which allows you to add to the products price depending on the size.

eg.
Product Price = £10
Medium = £10 'it's sizeP2A = 0
Large = £12 'it's sizeP2A = 2

Colour Table
------------------
colourID
colourDesc
colourP2A 'same rules as size

productAttributes
----------------------
productID
sizeID
colourID
colourStock
colourStockAlert

This would allow me to link the product with it's size, colour and ultimately stock level and alert....erm.........I think lol <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

What do you reckon?



Regards,

Jaysun

[ Web Chimp ]

------------------------
www.ultra-dumb.co.uk
&lt;ook!&gt;Brain food for web chimps&lt;/ook!&gt;

------------------------

Looks OK to me, I mean how hard can it be? (Famous last words).

One thing though, is this for an Internet or an Intranet site? How many Products? Access might struggle a bit if it's very big and gets lots of hits.

Is the use of Access a client restriction or a personal one? You can get SQL server hosting pretty cheap and get a 120 day trial copy of SQL server Developer Edition from Miscrosoft, nothing to dowload or about $15 for them to send you a copy on CD-ROM. Here's a link:
www.microsoft.com/sql/evaluation/trial/2000/default.asp

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

After some thought I have decided to go for pretty much what I have below Owen with one change <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

productAttributes
----------------------
productID
sizeID
colourID
productAStock
productAStockAlert
productAImage*

*This allows me to add different images to each product if needed/wanted but also leaves the 'default' image for viewing if not found.

As with all my work it'll start off on Access, then if traffic dictates a move I'll upsize to M$ SQL Server <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Thanks for bouncing my 'thoughts' off you owen - cheers <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>




Regards,

Jaysun

[ Web Chimp ]

------------------------
www.ultra-dumb.co.uk
&lt;ook!&gt;Brain food for web chimps&lt;/ook!&gt;

------------------------