Variants, variations and main products can be difficult to keep track of – especially when they are in a flat file such as csv. Therefore, when importing variations into OpenDIMS, it must be done in a certain way.

---

The start of the integration setup MUST look like this!

The first merge MUST be SKU merge (e.g. ItemNumber) for the variants, with “Update on match” active.
The next MUST be the main product SKU generation and merge to recipient field type “Variation”, due to the first merge this will be saved in the same field as in the first merge.

Then the variant fields MUST be merged (when creating a field in the integration’s setup, they are NOT correct, but must be corrected to the “One value” type).
Variant fields do not have to be the same columns as the main product sku, but can be color or different fields.

Since the main products have no values in this run, you can set up a new integration that updates the main products and matches the same SKU generation.

First merge lines MUST be SKU and match lines like this:

Billede-VSN7W2.png