Guidance on setting up database

Personally - I'd do them all separately as there would be just too many variables. But, with the new import plugin, I'd get all the data in an Excel template and manage any bulk changes with that.

Hi,

If each product will have different sizes, and different prices per quantity, then you'd be best to separate them into different sections. This will make your system more flexible.

Here is one way you could organize it. You can have one section for a product, a section for quantities, and a section for sizes. You will then have a section you can call something like "Product Pricing". Here you create a record where you select 1 product, 1 size, and 1 quantity and then enter a price. Then when you're outputting your content, you can select all the "Product Pricing" record for a given product.

Hope this helps. Let us know if you have any questions.

Hi,

Glad to hear that is working out for you.

You could have title be a list if you like. I don't see any immediate issue with doing that. Can you give an example of how that would be helpful and I can let you know if that would be the best approach?

I have attached what I have done so far. At the moment i am manually typing in the title but if i could use the size list then i wouldn't need to.
Joseph

Hi,

Okay, I see what you mean. In this case, since your title is just your size, you don't actually need a title field. You can just remove it.

Hope this helps.