Open tpperlman opened 2 years ago
Thank you @WillStrohl. We ended up just doing all the choices at the product level instead of shared choices. We didn't realize that you couldn't remove an option on a product-level without deleting it from the shared choice. We were assuming that when you created variants that only the ones created would appear in the dropdown list on the detail page.
@tpperlman Can you please e-mail a copy of the XLS you're using to solutions@upendoventures.com? We're having issues fully duplicating the issue you reported.
Describe the bug
We're attempting to import our product database and everything seems to work except for the Choices tab where it either creates duplicate shared choices or throws an error if the shared choice already exists. We do however notice that if we export any products using shared choices it will import without error, but once we add even one new shared choice to a product an exception error is returned.
Software Versions
To Reproduce
Steps to reproduce the behavior:
Row 3 thrown exception: An error occurred while updating the entries. See the inner exception for details.
System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_hcc_ProductOptions'. Cannot insert duplicate key in object 'dbo.hcc_ProductOptions'.
Expected behavior
Choices should not create duplicates or return a duplicate error if one exists.
Screenshots
Here is an example of the Choices tab:
Additional context
Add any other context about the problem here.