Developer forum

Forum » Integration » Integration - language - variant issue

Integration - language - variant issue

E-mail notifications
Davy Capiau
Reply
Posted on 04/12/2023 16:53:55

Hi,

Since we're on 9.16.3 (with the swift 1.24) we're having an issue with the product creation when products are combined in the backend.

Method:

Data integration via csv

Import flow :

  1. I1 - Creation of products with destination settings: "insert only new records" in the main language EN
    1. Remark: no variant information is included
  2. I2 - Creation of products in additional language (e.g. FR)
      1. Remark: no variant information is included
  3. Re-import of I1 to update the DB

Result = Success

4. Manual combination of products (of I1) in the backend: e.g. TPJ08, TPJ09
5. Re-import of I1 to update the DB

Result = Error =>
"Error: Cannot insert duplicate key row in object 'dbo.EcomProductsTempTableForBulkImport1' with unique index 'DW_PK_EcomProducts'. The duplicate key value is (TPJ08, LANG1, VO41)."
"Error: Cannot insert duplicate key row in object 'dbo.EcomProductsTempTableForBulkImport1' with unique index 'DW_PK_EcomProducts'. The duplicate key value is (TPJ09, LANG1, VO42)."

Note: The combined product returns the duplicate error. Also variant information is added in the duplicate-error, while it's not part of the import I1. There the key is: ID, Languagecode.

6. Manual unlinking of products in the backend

7. Re-import of I1 to update the DB

Result = Success

 

Conclusion:

when a product is combined AND a language layer the issue arises.

Extra:

Screenshot from Ecomproducts Table
 

 


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 04/12/2023 17:17:35
Reply
Hi Davy, What is your destination provider? BR, Dmitrij
 
Davy Capiau
Posted on 05/12/2023 08:17:27
Reply

Hi Dmitriy,

The ecom provider

 

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 05/12/2023 11:13:31
Reply

Hi Davy,
can you check the "Discard duplicate key rows" and see if it will solve your issue?
BR, Dmitrij

 
Davy Capiau
Posted on 05/12/2023 11:35:49
Reply

Hi Dmitrij

 

Tried it, but same error arose.

 

 


Error: Cannot insert duplicate key row in object 'dbo.EcomProductsTempTableForBulkImport1' with unique index 'DW_PK_EcomProducts'. The duplicate key value is (TPJ08, LANG1, VO41).

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 05/12/2023 12:00:31
Reply

Can you remove the VariantId column mapping from the Table Mapping (not just de-activate) and see if it helps?
If that doesn't help can you attach your sample CSV file (with just one product row)?

 
Davy Capiau
Posted on 05/12/2023 12:56:31
Reply

Hi Dmitrij

There is no variant mapping. There is also no variant-info in the file, nor am I trying to create variants. These are created manually in the backend.

Attached you find the requested file.

Kind regards

Davy

 
Morten Snedker Dynamicweb Employee
Morten Snedker
Posted on 05/12/2023 16:04:33
Reply

Hi Davy,

If you pass me a URL I can take a look at the solution. If you wish you may create a ticket with a link to this posting.

BR
Snedker

 
Davy Capiau
Posted on 05/12/2023 17:14:36
Reply

Hi Morten,

Ticket created with the url: https://care.dynamicweb.com/support/tickets/10729

 

Kr 

Davy

 
Davy Capiau
Posted on 07/12/2023 15:38:15
Reply
This post has been marked as an answer

The issue is fixed by adding the ProductVariantId column (with a constant [blank]), required by the 'Use strict primary key matching'.

Votes for this answer: 1

 

You must be logged in to post in the forum