How do I import categories in my online store?

How do I import categories in my online store?

You can import categories using CSV files in X-Cart format.

X-Cart import format allows you to import root categories and subcategories and make them enabled/disabled. Unfortunately, it is not possible to import categories with images yet, so you will need to upload them manually when the categories structure is created. 

For example, you want to create the following categories structure in your store:

  1. Tools
    1. Kitchen
      1. Spoons
      2. Forks
      3. Knives
    2. Garden
  2. Spices
    1. Indian
    2. Chinese
    3. Asian
  3. Fruits
  4. Vegetables
  5. Gifts

In this case, your CSV file for import will have this format:
[CATEGORIES]
!CATEGORY;!AVAIL
Tools;1
Tools/Kitchen;1
Tools/Kitchen/Spoons;1
Tools/Kitchen/Forks;1
Tools/Kitchen/Knives;1
Tools/Garden;1
Spices and Herbs;1
Spices and Herbs/Indian;1
Spices and Herbs/Chinese;1
Spices and Herbs/Asian;1
Fruits;1
Vegetables;1
Gifts;1


where
Tools;1

line adds the root category and number "1" after it shows that category is active (use 0 to create disabled category)
Tools/Kitchen;1

line adds the subcategory of root "Tools" category and "1" after it shows that the category is active, etc.

Thus, the first column contains the name of the category and/or its path and the second one – category availability. Use "1" to make the category visible and "0" to make it hidden.

Once the file is created, do the following:

Select Catalog. Select the Import Products button and choose the "XCart" tab from the pop-up window.
 



Upload your file with your list of categories in the "File" section. Choose "Semicolon" as a Delimeter. Select Import.
Optional: Select the "Delete all products and categories before import" checkbox if you want to remove all previous products and categories. 




When the import is complete, you will see the following message: 



Select the "See details" link to make sure everything was imported properly.

    • Related Articles

    • How do I organize products into categories in my online store?

      A category is a group of products that you wish to show on the same page in your store. Here are a few examples of categories you may want to create: Clothes, Accessories, Shoes Sale Items Seasonal Products Digital Products Select the E-Commerce ...

    • How do I change the order of categories in my online store?

      To change the order of your categories, select the E-Commerce tile. Select the Catalog tab. If you wish to show some categories first, you can easily change the order of categories and subcategories. Drag and drop categories in the category tree.

    • How do I manage categories in my online store?

      You can group your products by a certain common attribute by using categories. Here are a few examples of categories you may want to create: Clothes, Accessories, Shoes Sale items or Special Offers Seasonal Products The products that are grouped into ...

    • How do I create categories and subcategories in my online store?

      Categories are groups of products that you wish to show on the same page in your store (for example, Women's Fashion, Men's Clothing, etc.). They help customers navigate through the store and find the products they need. The same product can belong ...

    • Can I enable "Selling on Facebook" for my online store?

      Selling on Facebook allows you can automatically upload and sync your store product catalog to the mobile-friendly Shop section on your Facebook business page. The Facebook Shop can be viewed on a desktop, mobile as well as the Facebook app. All ...