SKU management

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 428,369 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,511 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Database Design advertiser: Programming Forums

Thread Tools Display Modes

Views: 717 | Replies: 1

•

Join Date: May 2008

Posts: 7

Reputation: daniyalnawaz is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

daniyalnawaz daniyalnawaz is offline

Offline

Newbie Poster

SKU management

Jun 5th, 2008

Hi,

I'm creating a database for e-commerce website and its inventory system. There products and every product is divided into further unique SKUs on the basis of size,color and other options. So i've created a table for products and another for its units. I'm thinking about creating a third table which contains options with option name and values as columns.

PRODUCT -|--------|< PRODUCT_UNIT -|-------|< OPTIONS

But i'm thinking that this might be difficult to handle when the products will be displayed on a webpage with options. Is there any other way to handle it?

Thank You!
Daniyal Nawaz

•

Join Date: Oct 2008

Posts: 1

Reputation: malford385 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

malford385 malford385 is offline

Offline

Newbie Poster

Re: SKU management

4 Days Ago

Hi, we are about to do the same and wonder if we could collaborate? I don't know the answer to your question but wonder if we can share your code and ours to create a killer SKU DB?