Developer forum

Hi Morten,

I was looking the querie... In my case the result was completly different.
I'm trying insert just a main products after this the variants... then the result is totaly different.

Now I'm putting together (like union between Products and variants), then is work perfectly, but should be possible to includ just variants, no? (I mean update the product with new variables).

Hi George,

Yes, it should be possible to have a main product, and then followingly add just variants.

I don't know if this clarifies anything, but:

With reference to my screendump in previous answer: EcomProducts has a composite key composed by

• ProductID
• ProductLanguageID
• ProductVariantID

Still with reference to my screendump: let's say you import via CSV and you have these two lines (ProductID,LanguageID;VariantID;Price):

PROD4;LANG1;VO1;10
PROD4;LANG1;VO5;20

then the result would be that

• PROD4/VO1 would have its price UPDATED to 10.
• PROD4/VO5 would be CREATED and have its price set to 20 (since there is no row with this ProductVariantID).

Bottom-line: a product is matched on ProductID+ProductLanguageID+ProductVariantID. If this composite key is NOT matched, a new row will be added.

Does this answer your question? Or is just that you don't understand why your query (combining products/variants in your source) works, but running them separately does not work...and you think that's weird?   :-)

Regards /Snedker

Hi Morten,

Yep I was doing like your setup. Was including in products like variants, but was not incrementing the ProductVariantCounter (always is 0) and ProductVariantProdCounter (is incrementing 0,1,2,3).

George