Here are my site's login credentials.

Hello Bruce,

I apologize for the inconvenience.

I am currently reviewing your issue. Once I have more information, I will share an update with you.

Thank you for your patience and understanding.

Best regards,

The issue you are facing is due to duplicate values. I can see that these values are already added in EasyStore → Settings → Variation Library → Width.

Because of this, when you try to add the same value again under Product Variation → Width, the system shows an error.

Please select the existing value from the list instead of typing the same value again, and then click save. This applies to all existing variations.

Thanks,

Hi - Thanks for your help.

Just to clarify the situation:

I was adding a new value, not already assigned to the product. There shouldn't have been a duplicate.

Now I have tried adding another new value 'K - Extra Wide' to my test product "Haflinger - Hawk - sheep skin - Chestnut" (ID = 3) and then tried saving.

The following error message appeared:

Save failed with the following error: Cannot add or update a child row: a foreign key constraint fails (devcomfo_db.comf_easystore_variation_combinations, CONSTRAINT comf_easystore_variation_combinations_ibfk_2 FOREIGN KEY (product_attribute_value_id) REFERENCES comf_easystore_product_attribute_values (id) ON DELETE CASCADE ON UPDATE CASCADE)

That does not look like a message expected for a normal end user experience.

I wonder if there might be data corruption somewhere.

What do you think?

Here is another observation.

After seeing the message explained above, I did the following:

1. closed the Product record.
2. Re-opened the product and found that the new Width variation 'K - extra-wide' has been added successfully.
3. Saved the Product record - this time without error.

A second colour variation has also saved.

The error message only appeared when saving the Product record AFTER using the "Add another variation" button.

Also to clarify further...

I want one variation named "Width" And different values possible 'Narrow', 'Standard Wide', 'Extra Wide', 'Extra-extra Wide' etc.

Just like with "Sizes", I want one Attribute with multiple values.

This is difficult to explain.

I will check the user instructions again, but I don't think I'm doing anything wrong.

I have created some screenshots to illustrate the problem

They show:

1. Editing Sizes (adding)
2. Editing Widths (adding)
3. Product variations (after adding)
4. The error message on save
5. The product record re-opened and the new widths visible.

The error message does not seem to affect adding the new Variations.

I have also tested this adding Size 46. Same error message and the new size is created.

I hope this helps.

Also, thank you for alerting me to the variations library. I have reviewed them and I understand the re-use of existing values.

However, my earlier confusion was because those existing values were not shown in the Product Variation options editor.

But now, when I add variations those existing values are now appearing.

I am uncertain why they are working now.

Thanks for your help.

My initial misunderstanding was trying to add new variations through the Product entry page.

I now understand how to use the Variations library editor. It took me a while to realise that you must click on the 'Save' button after adding new values and editing existing ones. I have become used to other user interfaces which save automatically.

Also, for clarification, I have a good understanding now of the data structure (tables and key relationships) behind the Variations Library and how it all relates to products. It all makes sense.

I think I have things under control now.

Thanks again.

Hi Bruce,

Thank you for your update, and we’re glad to hear everything is now making sense and under control.

It’s also great to hear that you now have a clear understanding of how the Variations Library structure and its relationship with products works.

If you run into anything else or need further clarification in the future, feel free to reach out anytime.

Thanks again for your feedback and support.

Best regards,