Member Avatar for daniyalnawaz

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

  • 2 Contributors
  • 1 Reply
  • 84 Views
  • 4 Months Discussion Span
  • Latest Post Latest Post by malford385
Member Avatar for malford385

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.