Below is a list of supported fields and their respective value types for category import.

Field in CSV file What this field describes Value type
Fields supported by X-Cart core
path* Path to category. Serves as identifier.
Example: Toys >>> Science Toys 

String,
Max. length: 32

enabled Is the category enabled? Yes/No
showTitle Option to show category title Yes/No
position Internal value of the category order. May not be negative. A smaller number means a higher position in the order. Integer
memberships Membership types, which members can see the category. Do not set it if you want to make the category visible to all customers. Otherwise, it will be visible to the users assigned to specified membership only. String,
Multiple 
image

For any image that needs to be imported, you need to specify the image location. This can be one of the following:

  • Image URL (can be local to the X-Cart server)
  • Path to the image on the server relative to the <XCART-DIRECTORY> folder; for example, images/category/image1.png

Note that import of images takes considerably less time if the images to be imported are stored locally on the server. It doesn't matter if image path is specified as URL or filepath — X-Cart will try to detect if the URL is local to the server. So, if you need to import a considerable number of images from URLs, you can speed up the process quite a bit simply by saving those images locally on the server inside <XCART-DIRECTORY>/images folder.

String
cleanURL

SEO friendly URL of the category page.

Example: toys

String
*name Category name. String,
Multilingual 
description Full description of the category.

String,
Multilingual,
HTML allowed 

metaTags Defines the content of <meta name="keywords" content="%value%"> meta tag String,
Multilingual,
Max. length: 255 
metaDesc Defines the content of <meta name="description" content="%value%"> meta tag String,
Multilingual 
metaDescType

Defines meta description content type. Can be either A or C, where:

  • A stands for automatic mode when meta description will be generated from category description;
  • C stands for custom mode when meta desciption will be taken from metaDesc_* field in appropriate translation*;
    *this means that if the store is in English language, meta description will be taken from metaDesc_en field.
String,
Max. length: 1 
metaTitle Defines the content of <meta name="title" content="%value%"> meta tag String,
Multilingual,
Max. length: 255 
Fields added by GoSocial module
useCustomOpenGraphMeta Defines whether use custom Open Graph meta tags for this product or use default ones Yes/No
openGraphMeta If useCustomOpenGraphMeta is Yes, then defines custom Open Graph meta tags

String,
HTML allowed,
Scripting allowed 

Fields added by Product Filter module
productClasses    
useClasses    

* Required field.

** See CSV field attributes for more info.

Tips:

  • If you are going to import data into X-Cart and do not wish to update certain X-Cart fields during the import process, you should not include these fields into your CSV file for import. Simply remove the respective column(s) from the file.

  • If necessary, import can be used to clear previously set field values from non-numeric fields. To clear a field value via import, in your CSV file to be imported specify the value of the field as “NULL”. After the import process is completed, the fields in which the value “NULL” has been imported will be cleared. 

    This feature is supported by the following fields pertaining to categories:

    • memberships;
    • image;
    • banner;
    • productClasses (processed by the module Product Filter).