Unable to add a product variation via the "Add Product variation" screen

[Joseph Wayodi]

Hi people,

I am trying to add a product variation without using the "Variation Manager". Via the Variation Manager works okay.

I am using, from the main admin page: Configurable > Product variations > Add. Alternatively, I am also trying to use: at the bottom of a Change Configurable Product page, under Variations, click Add Variation.

After selecting the Product (the plain Product), Parent (the Configurable Product), and the Options, and clicking save, I get the error:

IntegrityError at /admin/configurable/productvariation/add/
insert or update on table "configurable_productvariation_options" violates foreign key constraint "productvariation_id_refs_product_id_55e6e722"
DETAIL:  Key (productvariation_id)=(1738) is not present in table "configurable_productvariation".

Could someone please let me know what the problem is?

Regards,

Joseph.

[Josh]

I'm not sure if this exactly answers your question but check out this
tutorial, it talks about adding product variations, etc...:
http://www.satchmoproject.com/docs/dev/tutorial1.html

-Josh

[Joseph Wayodi]

On Fri, Nov 12, 2010 at 12:33 AM, Josh <jos...@gmail.com> wrote:

I'm not sure if this exactly answers your question but check out this
tutorial, it talks about adding product variations, etc...:
http://www.satchmoproject.com/docs/dev/tutorial1.html

Hi Josh,

Sorry if I wasn't more clear.

Adding product variations as per the tutorial (checking the Create Variations checkbox on the Change Configurable Product page) works okay.

A customer of ours stumbled upon the "idea" of sharing option groups among different products. For example, she has an option group named "Color", with about 30 options (i.e Red, Green, Blue, etc.). And then she has a number of different products that have variations based on this group, but each of which uses only around 4 out of the 30 options (i.e. red shirt, green shirt; red jacket, blue jacket, etc.).

So, she has been creating (all) variations for each configurable product (by checking the Create Variations checkbox on the Change Configurable Product page), and then going back and deleting the variations that she does not want (by clicking on Delete ProductVariation, in the Variations section, at the bottom of the Change Configurable Product page).

So, she was wondering why she can't simply create just the variations she wants, by clicking on Add Variation, in the Variations section, at the bottom of the Change Configurable Product page. This gives the error I referred to in my original post.

I have advised her to instead use the Variation Manager to do the kind of thing she wants. Or even better, to restrict Option Groups to a single product (because of things like being able to have price variations).

I am also wondering what the Add Variation link, in the Variations section, at the bottom of the Change Configurable Product page, is used for. Maybe it should be removed to avoid any possible confusion?

Thanks a lot for helping me see it more clearly.

Joseph.

[Josh]

Hmm, I'm not totally sure about that, I wasn't sure to begin with but
thought that maybe you hadn't seen the tutorial. Sorry that I can't
be of more assistance. It sounds like your advice to your client is
spot on though. Maybe Bruce or Chris could weigh in on the confusion?

-Josh

On Nov 14, 2:28 am, Joseph Wayodi <jway...@gmail.com> wrote: