General Questions

Drupal Commerce-related questions2

What does the error “Drupal Commerce CSV file got corrupted” mean?

To successfully upload your Drupal Commerce files into wizard, check them in terms of the following issues:

  • The first line of the file shouldn’t be empty.
  • The number of columns in the header and in the lines of files should match.
  • The contents of the columns should correspond to the title (e.g. the category column shouldn’t include the product weight).

Besides, make sure to rename column names to English equivalents, so that the names could be recognized and the data could be migrated correctly.

Here’s how a valid CSV-template should look like:

Drupal Commerce CSV file Drupal Commerce CSV file
More info
How to export files from Drupal Commerce?

To export products and categories from Drupal Commerce, you will have to activate the costless Views data export plugin, beforehand. Also, it is necessary to install the free Views and Ctools modules preliminary, to make sure that Views data export is working correctly.

Alternatively, you may watch this video guide or follow up the instructions listed below.

So, when all three modules are downloaded, installed and activated - perform the following steps separately to export products and, then, to export categories:

1. Log in to your admin panel, go to Structure-> Views and click Add new view.

How to export files from Drupal Commerce?

How to export files from Drupal Commerce?

2. Fill the View name field in accordance with these samples - “export_product” - for products, “export_category” - for categories.

3. Select Commerce Products (for products) or Taxonomy Terms (for categories) from the “Show” drop down menu, and choose All, in “of type” one.

4. Press Continue and Edit.

How to export files from Drupal Commerce?

5. Click Add in the Fields section, and put ticks near:

How to export files from Drupal Commerce?

- for products - “Commerce Product: Product ID”, “Commerce Product: SKU”, “Commerce Product: Status” and “Commerce Product: Title”.

How to export files from Drupal Commerce?

- for categories - “Taxonomy term: Name”, “Taxonomy term: Term description” and “Taxonomy term: Term ID”

How to export files from Drupal Commerce?

6. Keep clicking Apply (All Displays) until you configure all the needed fields.

How to export files from Drupal Commerce?

7. Press Save.

How to export files from Drupal Commerce?

8. Click Add under Displays heading and, then, Data Export.

How to export files from Drupal Commerce?

9. In the Format field choose CSV file, and in its settings - click on Provide as a file. Apply the changes.

How to export files from Drupal Commerce?

10. Go to Data Export Settings, type export-product (for products) or export-categories (for categories) in the Path field, choose Page in the Attach to field and press Apply.

How to export files from Drupal Commerce?

11. Open the Display a specified number of entities menu, choose Display all items and click Apply.

How to export files from Drupal Commerce?

12. Finally, save the changes and click view Data export.

How to export files from Drupal Commerce?

After all the uplisted actions are done, upload the CSV files to the appropriate fields on Migration Wizard.

(more…)
More info

Just set up the migration and choose the entities to move – the service will do the rest.

Try It Free

Delegate the job to the highly-skilled migration experts and get the job done.

Choose Package
Stop war in Ukraine