Hi,
I see lots of technical issues about the Accumulative product reference mapper, For instance: https://drupal.org/node/1188994, https://drupal.org/node/1420346 and https://drupal.org/node/1351162

But no where a How to to find. How can I add multiple product entities/variations to one node/product display on such a way that I can use Update to update those nodes/product displays?

Do I first of all need to use the product_reference_importer? Likewise "normal 1-1 product node/ variation.
But then where can I add onther product entities/variations to a product display?

Do I need to add them sequentially likewise:https://drupal.org/node/1420346#comment-5536970

S1,Range 1,R1,100,,,,,,,,
S2,Range 1,R1,100,,,,,,,,
S3,Range 1,R1,100,,,,,,,,
S4,Range 1,R1,100,,,,,,,,
S5,Range 1,R1,100,,,,,,,,

Thanks a lot in advance for your reply!

Greetings, Martijn

Comments

flebas’s picture

flebas commented

You need two importers : one for product variations, and one for product displays.
1) Import product variations (SKU->product SKU, unique target)
2) Import product display nodes, with Range ID set as GUID and unique target

Regards,
Frederic

summit’s picture

summit commented

Hi,

To get it straight. My database has the following information:
Productdisplay ID, Productdisplay Title, Productdisplay Body, SKU, Productvariation Title, Price currency, Price amount, Image url.

As I understand it correctly I have then to:
1) Import my productvariations through the productvariation importer into my database with settings:


http-equiv="content-type">


style="text-align: left; width: 100%; font-family: Courier New,Courier,monospace;"
border="1" cellpadding="2" cellspacing="2">
Source
Target
Unique
SKU
SKU
Yes
Productvariation Title
Product Title
No
Price Currency
Product Price Currency
No
Price Amount
Product Price Amount
No
Image URL Product Image url 
No




2) After that import has run, than run the product reference importer to build Productdisplays:


http-equiv="content-type">


style="text-align: left; width: 820px; font-family: Courier New,Courier,monospace; height: 160px;"
border="1" cellpadding="2" cellspacing="2">
Source
Target
Unique
SKU
Products: SKU
No
Productdisplay ID
GUID
Yes
Productdisplay Title
Title
No
Productdisplay Body
Body No






Is this correct please?
Thanks a lot for your reply in advance!
Greetings, Martijn

vbard’s picture

vbard commented

#2 Yes, as it seems to me, you're right.
First time you use "Commerce Product processor", second - "Node processor".
Feel free to email me if any questions, or ask here!

limbovski’s picture

limbovski commented
Issue summary: View changes

My commerce feeds importer duplicates the Product Display Nodes on import.

I have setup 2 importers; one for product variations and another for product displays to group these variations.

The variations importer works perfectly and seamlessly imports multiple products. When I run this importer again with the same input CSV it updates the existing variations. Perfect!

My 'product display' importer works perfectly first time around only. It creates the required product display nodes and groups the product variations that were imported in the previous step together.

If I run the product display importer a second time it creates a whole new set of nodes - these are now duplicates. It doesn't update the original nodes.

I've been following Randys guide and videos here precisely and I'm not sure where the issue is or where to even look at this stage...

I have a SKU with a target of GUID and it is the Unique Target.
Any ideas what I should be looking for or where I should focus my efforts? I'm pulling my hair out at this stage.

vbard’s picture

vbard commented

Hi limbovski!
Do you still have this issue?
What field do you have as unique on your 'product display' importer?