Re: FLASH: Database Structure

[Cheri Harder]

Oh!  I think I was thinking bass-ackwards on this one.  I was trying to have

the "item" have all the links to the "attributes" where what I really want

is the "attributes table" have the link to the "item"...


I think I can do this...except you are most likely right, each store is

gonna have it's own unique way of numbering their product....and it will

likely play havoc with whatever I decide for my catalog database structure.

Hmmm.


I'm just doing this on my own, you understand, on the "hopes" I get some

business.  So I'm not in a hurry and if you can look at your prior stores I

would sure appreciate it.  If it turns out that I just need a line of data

for each product SKU (including size, tho?  Sheesh that could be a ton!)

then that's what I'll do.  Then the options can just be part of the

description column data.


~~~~Cheri Harder~~~~~

charderawsolution [dot] com

Advantage Web Solution

www.awsolution.com


> I'd have to look into a few online stores I've dealt

> with in the past, but off the top of my head, I

> believe there was an attibutes table that was linked

> by product ID.  So, within that attibutes table you

> would have as many attributes as you wanted associated

> with that item. (size, color, material, etc)  And yes,

> as in real retail, I belive each unique size/color,

> etc of an item as it's own Product ID or SKU number I

> think it is.

>




flasher is generously supported by...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

     flashforward2000 and The Flash Film Festival

  "The World�s Premier Flash Solutions Conference and Expo"

 March 27-29, Nob Hill Masonic Center, San Francisco, California


-Register before Feb 25 and save $200!!-- www.flashforward2000.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

To unsubscribe or change your list settings go to

http://www.chinwag.com/flasher or email

helpchinwag [dot] com