Hi Ton

Do you have a URL where I can see that happening? Unless you're talking about the Admin screen?

Hi Stepen,
Go to:
https://www.watermanshop....erpulver-opak-ml1100
Then choose another color.
You are not able to pick another color wit 5 or 15 gram.
The other languages working fine.
Also the same in.
https://www.watermanshop....r-transparent-ml1005

Regards, Ton

I think it has to do with the Advanced URL provider needs to make sure each possible URL combination is unique.

In German language, can you check your SEO URL keywords are unique for the variant where you have 5 or 15 gram with the other colors? Try giving them different URL keywords. Those keywords are used to formulate the URL (if you look at the URL path).

Hi Stephen,

I have updated all the url and seo names.
They are all different now.

I updated:
- product
- productvariant
- productvariantgroup
- productvariantoption

productvariantgroupoption give 2 errors while updating (see below)
It is strange because I am "u" updating and not "i" inserting
I removed these from updating and then all went fine.

The transacton has been rolled back because an error occured near row 52. Cannot insert duplicate key row in object 'dbo.Revindex_Storefront_ProductVariantGroupOption' with unique index 'IX_Revindex_Storefront_ProductVariantGroupOption_1'. The duplicate key value is (101006). The statement has been terminated.

The transacton has been rolled back because an error occured near row 92. Cannot insert duplicate key row in object 'dbo.Revindex_Storefront_ProductVariantGroupOption' with unique index 'IX_Revindex_Storefront_ProductVariantGroupOption_1'. The duplicate key value is (101221). The statement has been terminated.

This is strange because only the German language is not working ok.

The problem with selecting more then 2 options is on all products in the German language.
With English and Dutch all selectors of all product working fine.

I do not know what I can do to resolve this.
If you need I bought a support ticket.

Regards, Ton

-----------------------------

AbsoluteURL:/Default.aspx
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:a3a13025-5809-4b7e-8cc4-c3000fd4f6dd
AssemblyVersion:9.10.1
PortalId:0
UserId:1
TabId:717
RawUrl:/de-de/Buro/Shop-Buro?rvdsfpt=Catalog-CatalogImportControl&rvdsfentity=Product&returnurl=%2fde-de%2fBuro%2fShop-Buro%3frvdsfpt%3dCatalog-ProductControl%26rvdsfpvi%3d0%26rvdsfpvs%3d10%26rvdsfpsortdrt%3d0%26rvdsfpsortexp%3dName%26rvdsfsinventory%3d0%26rv
Referrer:https://www.watermanshop....6rvdsfpsortexp%3dNam
UserAgent:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36
ExceptionHash:TQATlAb/Ub4ks3FMQg6YPZAkbbA=
Message:The transacton has been rolled back because an error occured near row 52. Cannot insert duplicate key row in object 'dbo.Revindex_Storefront_ProductVariantGroupOption' with unique index 'IX_Revindex_Storefront_ProductVariantGroupOption_1'. The duplicate key value is (101006). The statement has been terminated.
StackTrace:
InnerMessage:The transacton has been rolled back because an error occured near row 52. Cannot insert duplicate key row in object 'dbo.Revindex_Storefront_ProductVariantGroupOption' with unique index 'IX_Revindex_Storefront_ProductVariantGroupOption_1'. The duplicate key value is (101006). The statement has been terminated.
InnerStackTrace:
   at Revindex.Dnn.RevindexStorefront.Controllers.ImportController.ImportProductVariantGroupOption(DataTable dt, ImportMap map, String cultureCode)
   at Revindex.Dnn.RevindexStorefront.CatalogImportControl.ImportLinkButton_Click(Object sender, EventArgs e)
Source:
FileName:
FileLineNumber:0
FileColumnNumber:0
Method:
Server Name: WIN-UH6L84HG4JI