dynamic product options and sku numbers

Hello,

We're working on building our product options table so we can add dynamic filtering to our store. We have a question about the SKU numbers... We're selling water filters that have several variables - height, micron rating, and diameter. For example, you can have a 10" x 2.5" filter with a 10 or a 20 micron rating. There are two different SKU numbers for each of these items. We may be setting up our product table incorrectly. I'm going to attach the three tables we're working with... Can you please advice if they're correct? (You'll notice we have the same SKU number in each row, which we know is incorrect but aren't sure how it should be structured.)

Thanks!

I really don't know enough about your products to design your database, and that is a bit beyond what I can effectively do through this forum.

My guess is that you will probably either need a separate row in the products table for each SKU, or you may need a fourth table specifically for SKUs that match up a product with the available options.

This is something I could help with in a premier support ticket.

Hello,

I'm sorry I started another ticket... my topic changed from the previous ticket we were working with so I thought I needed a new thread.

Basically, here's our problem... I'll replace our water filters with t-shirts... Imagine you have a t-shirt with two variables, color - red and blue - and size - S, M, L - and the SKU number varies based on how those are paired. When we're adding the rows to the table, we're adding first the colors as options and then the size. So there will be small shirt, medium shirt, large shirt, red shirt, and blue shirt with the idea that customers could first filter by size and then by color, or whatever.... But we need a small red shirt to have a different SKU from a medium red shirt or a blue small shirt.

Based on your previous post, it sounds like we need another table to assign the SKU to the various variable combinations? Or am I misinterpreting the information in the tutorial and creating our tables incorrectly?

Thanks so much for your help!

Yes, probably another table makes sense. It could have columns for ProductID, ColorID, SizeID, and SKU... that way you could store and look up the correct SKU based on the three determining IDs.

Thank you so much!

I'll give it a try and will let you know if I have any questions.

Have a good evening!