Knowledge base
Guides
Academy
Video tutorials
Try searching for:
Recently viewed articles:

Table of contents

Adding product categories through CSV (legacy)

Using Ecwid CSV files you can:

  • Create empty new categories/subcategories
  • Create both new products and new categories/subcategories for them
  • Add existing products to new categories/subcategories (they will be created after import)
  • Add new or existing products to existing categories/subcategories
This article is about a legacy CSV format in Ecwid. If you’ve signed up after 24.05.2023, you have a new catalog import format in your store. To switch to the new format, go to Settings → What's New or contact support.

Example 1. Adding only categories 

Let’s say you want to add a list of new categories and subcategories to your Ecwid store. This is how your file should look like in a spreadsheet (before you save it as CSV file for a further import):

Can_I_import_categories__4_.png

After you save your file as CSV, open Ecwid import dialog and tick Category 1 (as you have one column):

Can_I_import_categories__2_.png

Then press Import. After the import is complete, you will have all the new categories and subcategories from the file created in your Ecwid store.

All the necessary categories/subcategories from the category “path” are created as well. For example, if you haven’t had a category named Women’s Apparel/Tanks in your store, then, after you import a file with a path Women’s Apparel/Tanks, you will have both the Women’s Apparel category and its Tanks subcategory created.

Example 2. Adding categories with products

Let’s say you want to add a new product named Black Dress with SKU 0000 and simultaneously create two new subcategories for it: Women's Apparel/Dresses and Women's Apparel/Dresses/Evening Dresses. This is how your file should look like in a spreadsheet (before you save it as CSV file for a further import):

Can_I_import_categories__3_.png

After you save this file as CSV, open Ecwid import dialog and tick Name, SKU, Category 1 and Category 2 boxes:

Can_I_import_categories__1_.png

Make sure there is a tick in the Skip First Line box. Otherwise you will have categories named Category1 and Category2 (and Category3 if you used three categories/subcategories in your import) created as well, along with an extra Name SKU product.

After you press Import, you will have a new product named Black Dress with SKU 0000 created in your store. You will also have two new subcategories: Women's Apparel/Dresses and Women's Apparel/Dresses/Evening Dresses – that will both contain this product.

You can also import product categories using X-Сart format. See more details in the article on X-Cart import format in Ecwid. Or you can import categories using LiteCommerce import format.

Was this article helpful?

Awesome! Thanks for your feedback!

Thanks for your feedback!

Sorry about that! What went wrong?
0 out of 1 found this helpful
10
We use cookies and similar technologies to remember your preferences, measure effectiveness of our campaigns, and analyze depersonalized data to improve performance of our site. By choosing «Accept», you consent to the use of cookies.
Accept cookies Decline