eStore – selling 25 products with 5 "sizes" with different prices

[huotg01]

Hello

I know that I can setup a product (like a t-shirt) with many sizes, one price for each size.

I need to display 25 products, each having the same 5 options (similar to a “size”), with a price for each of them.

Is there a way to do it without re-doing it for each of the 25 products ?

Thanks

[admin]

You can copy the product to make the new ones to make the job a little easier. Check the copy product feature in eStore’s product management and add/edit interface.

[huotg01]

Thanks.

You are right, but if something changes in the “size”, I have to deal with each of the 25 product.

Is there another way of doing it?

Thanks.

[wzp]

No. That’s because each product database entry is independent from each other; thus there is no concept of “linked variations.” This is not something that can easily be implemented in eStore; because MySQL is a flat, as opposed to a hierarchical, database.

[huotg01]

MySQL is not flat; it is a relational database, like Oracle, sql server, and all big league players.

[wzp]

By “flat,” I meant the records within the tables. It’s “relational,” only because the tables are linked to each other; using a free-form user-defined schema. A hierarchical database, does not use linked tables (it’s a homogeneous structure); segments are implicitly joined; whereas in a relational database, you must explicitly join multiple (flat) tables. You can tell I’m partial to hierarchical databases, LOL.

If you can suggest a relational schema that would implement the feature you are looking for, we will consider it.

[Author]

Posts