Feed Import Products ( Commerce ) and Products Category ( Node Page )

Question

I need to create a CSV feed importer to import both Commerce products and products category node using single table and I am using Commerce Feed Module... when I create it using two different tables I can easily achieve it using Feeds Tamper Module (using explode plug in)

But when I implement single table structure as mentioned in the image... since the title is not unique it creates multiple nodes for each product... Is there any other table structure to implement this..

But what I actually need is:

Display1- A, SKU1|SKU2|SKU3

Display2- B, SKU4|SKU5|SKU6

Display3- C, SKU7|SKU8|SKU9

Is there no one familiar with this or done this before.. ?? or else I have to refine the question.. ??

Answer 1

The following CSV template and Feed Import settings will import 1 Product Node with multiple Product Entities being referenced.

Step 1 - Creating The CSV

The following example provides the title and product_variation headers...

title: Mapped to the Node Title field in Feed Import

product_variation: Mapped to the Commerce Product Referenced field. Field limit should be greater then 1, so multiple entities can be imported.

title,product_variation

Product Example,"product_sku-1|product_sku-2"

Step 2 -Import Node

The "|" is used to create a unique entry using the Feeds Import Explode plugin.

The Feed Tamper product_variation field should have a single Plugin called Explode with the String separator set to "|".

Essentially, the Feeds Tamper Module will prepare the column values into an array, so Drupal can handle the request all awesome like :)

Answer 2

Using Feed to import product into Drupal Commerce is not the best approach. Instead you should use Commerce Migrate which add Commerce Product support for Migrate. Many helpers are available to support for example taxonomy terms, files ...

Many tutorials explain how to use Migrate which is a wonderfull module, but a quite huge.

But here is a sample workflow :

1. Import Category into Taxonomy
2. Import Product Ref
3. Import Product Display and link them to previous imported elements (category and product ref)

To do the last thing, you have to specify the previous source used. Like that, Migrate will be able to "convert" SKU and categories codes to the drupal corresponding elements.

Modules to use :

• Migrate
• Commerce Migrate
• Migrate Extras