CSV file field name

What this field describes

Value type

sku*

Unique identifier of the product.

String,
Max. length: 32

name*

Product name. This field is required if creating new products and is optional if updating existing products.

String,
Multilingual

price

Default product price.

Float (e.g., 1.00)

memberships

Membership types, which members can see the product. Do not set it if you want to make the product visible to all customers. Otherwise, it will be visible to the users assigned to specified membership only.

String,
Multiple

description

Full description of the product.

String,
Multilingual,
HTML allowed

briefDescription

Brief description of the product that is shown on the catalog pages.

String,
Multilingual,
HTML allowed

enabled

Whether the product is enabled.

Yes/No

weight

Product weight.

Float (e.g., 8.00)

shippable

Whether the product can be shipped physically

Yes/No

images

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

Note that if you require to store images for import inside the "images" folder of your X-Cart store installation, they must be placed inside the folder "images/product" or a subfolder of "images/product"; X-Cart will not be able to import images stored in the folder "images" outside the subfolder "images/product." It will be able, however, to import images stored in other locations within your <XCART-DIRECTORY> folder, outside of the folder "images."

Correct:

Incorrect:

Also, note that the images import takes considerably less time if the images to be imported are stored locally on the server. It does not matter if the image path is specified as a URL or as a file path — 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 stored elsewhere, you can speed up the process quite a bit simply by saving those images locally on the server inside the folder <XCART-DIRECTORY>/images/product.

It is possible to specify more than one image for import by separating the image paths with the && symbols;

for example, images/product/image1.png&&images/product/images2.png.

String,
Multiple

imagesAlt

Text for alt property of images. This text will be shown when an image is not loaded for some reason.

If many images are assigned to the product, you can import many alt texts as well. These alt texts must be separated by && construction.

Examples:

String,
Multiple,
Max. length: 255

arrivalDate

Date when the product will be available for sale.

Date (e.g., 1 Jan 2022)

date

Date when of the product creation in the X-Cart Admin area.

Date (e.g., 1 Jan 2022)

updateDate

The date of the last product update.

Date (e.g., 1 Jan 2022)

inventoryTrackingEnabled

Whether inventory (stock) tracking is enabled.

Yes/No

stockLevel

Current stock level.

Integer

lowLimitLevel

When the stock of the product reaches this amount, the admin will get a notification about the low limit of these goods.

Integer (e.g. 10)

lowLimitEnabled

Whether low stock notification is enabled

Yes/No

minimumPurchaseQuantity

The minimum allowed quantity for purchase.

If the store administrator adds the field, it must be imported along with the vendor field. The vendor field value should be either empty if the product owner is the store admin or a vendor email if the product owner is a vendor.

If the minimumPurchaseQuantity field is imported by a vendor, no additional fields are required.

Integer

categories

The categories to which the product belongs.

Separate the category names by the >>> construction for nested categories.

Multiple categories can be specified, separated by the && construction.

Examples:

String,
Multiple

inCategoriesPosition

Determines the position of the product within a category relative to the other products in the same category.

If the product belongs to multiple categories, specify the product position in each of them using the xx&&yy&&zz format.

Integer (xx/yy/zz)

cleanURL

SEO-friendly URL of the product page.

Example: apple.html

Clean URLs are imported according to the following rules:

String

useSeparateBox

Whether a separate box needs to be used for this item when you ship it

Yes/No

boxWidth

If useSeparateBox is Yes, this field defines the width of the custom box for this product

Float (e.g., 1.00)

boxLength

If useSeparateBox is Yes, this field defines the length of the custom box for this product

Float (e.g., 1.00)

boxHeight

If useSeparateBox is Yes, this field defines the height of the custom box for this product

Float (e.g., 1.00)

itemsPerBox

If useSeparateBox is Yes, this field defines what quantity of the product can be shipped in this box.

Integer (e.g., 3)

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:

String,
Max. length: 1

metaTitle

Defines the content of <meta name="title" content="%value%"> meta tag

String,
Multilingual,
Max. length: 255

productClass

Defines attribute class for a product.

See also:

String

[attribute_name](field:product)

Defines a product-specific attribute for the product, where [attribute_name] stands for the name of the product-specific attribute

e.g. Color(field:product)

String,
Multilingual,
Max. length: 255

taxClass

Defines the tax class for the product

String

CSV file field name

What this field describes

Value type

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

CSV file field name

What this field describes

Value type

attachments

Defines what files are attached to this product.

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

If using the latter option (local filepath), the attachment files for import need to be placed in one of the following locations:

Multiple files can be attached, and they must be separated by the && construction.

Examples:

Note that import of attachments takes considerably less time if the files to be imported are stored locally on the store server rather than elsewhere. Therefore, if you need to import a considerable number of attachment files stored away from the store server, it may be possible to speed up the process simply by saving those files locally on the server and changing the location of those files in the import CSV file accordingly.

String,
Multiple

attachmentsTitle

Defines the titles of attachment files.

This field supports titles for many attachments, and they must be separated by && construction.

Examples:

String,
Multiple,
Multilingual,
Max. length: 128

attachmentsDescription

Defines the description of the attachments file.

This field supports descriptions for many attachments, and they must be separated by && construction.

Examples:

String,
Multiple,
Multilingual

CSV file field name

What this field describes

Value type

attachmentsPrivate

Defines what attachments should be private and available after an order has been paid for (e-goods) and what attachments should be available right from the product page (the Product Attachments and E-Goods add-ons must be enabled).

In the case of multiple attachments, it is possible to mark some of them as private and some as publicly available. Multiple values must be separated by the && construction.

Example:

CSV file field name

What this field describes

Value type

marketPrice

Defines the product's market price so your customers can estimate how much less than the average price of the product on the market they will need to pay if they buy the product from you.

Float (e.g., 5.00)

CSV file field name

What this field describes

Value type

sale

Defines your discount for this product.

It can have two types of values (absolute discount and percent one):

String

saleDiscounts

Defines a global discount assigned to a product. See how to configure global discounts here.

Multiple discount offers can be specified, separated by the && construction.
e.g., Sale_1&&Sale_2

String

CSV file field name

What this field describes

Value type

vendor*

Product vendor login name

String

CSV file field name

What this field describes

Value type

(X-Cart 5.3.3+) variantID

Autogenerated product variant identifier

String,
Autogenerated,
Multirow

variantSKU

Product variant SKU (if empty, takes SKU from parent product)

String,
Max. length: 32,
Multirow

variantPrice

Product variant price (if empty, takes price from parent product)

Float,
Multirow

variantQuantity

Product variant quantity (if empty, takes quantity from parent product)

Integer,
Multirow

variantWeight

Product variant weight (if empty, takes weight from parent product)

Float,
Multirow

variantImage

Product variant image location

String,
Multirow

variantImageAlt

Product variant image alt text

String,
Max. length: 32,
Multirow

CSV file field name

What this field describes

Value type

variantsAsTable

Display product variants in the Table mode.

Yes/No

CSV file field name

What this field describes

Value type

wholesalePrices

Defines wholesale prices for the product.

Examples:

String,
Multiple

variantWholesalePrices

Defines wholesale prices for the product variant.

The add-on Product Variants must be enabled.

String,
Multiple,
Multirow

CSV file field name

What this field describes

Value type

upcIsbn

Barcode (GTIN, UPC, EAN, JAN, ISBN, etc.)

String,
Max. length: 32

mnfVendor

Manufacturer Part Number (MPN)

String,
Max. length: 64

variantupcIsbn

Barcode of a product variant
​

* requires Product Variants add-on

String,
Max. length: 32,
Multirow

variantmnfVendor

MPN of a product variant

* requires Product Variants add-on

String,
Max. length: 64,
Multirow

CSV file field name

What this field describes

Value type

relatedProducts

SKUs of related products. You can specify several products, separating them with && symbols.

Examples:

String,
Multiple

CSV file field name

What this field describes

Value type

fitmentType

The fitment type of the product.

Possible values are:

String

CSV file field name

What this field describes

Value type

tags

Product tags values

Multiple values must be separated by && construction.

String,
Multiple

CSV file field name

What this field describes

Value type

shipForFree

Enables/disables the "Free shipping" option for a product

Yes/No

freeShipping

Enables/disables the "Exclude from shipping cost calculation" option for a product

Yes/No

freightFixedFee

Defines a fixed shipping fee for a product

Float (e.g., 1.00)

CSV file field name

What this field describes

Value type

nextagId

Adds a NexTag feed category to a product

NexTag Category ID

shopzillaId

Adds a Shopzilla feed category to a product

Shopzilla Category ID

pricegrabberId

Adds a Pricegrabber feed category to a product

Pricegrabber Category ID

ebayCommerceId

Adds an eBay Commerce Network (shopping.com) feed category to a product

eBay Category ID

googleShoppingId

Adds a Google Shopping feed category to a product

Google Shopping Category ID

CSV file field name

What this field describes

Value type

callForPrice

Enables the "Call for price" option for a product

Yes/No

variantCallForPrice

Enables the "Call for price" option for a product variant

Yes/No

CSV file field name

What this field describes

Value type

availableForBackorder

Enables the "Available for backorder" option for the product

Yes/No

backorderQtyLabel

Defines a backorder promo text that is displayed to customers when a product is out of stock

It's possible to insert the number of units available for backordering by using the %number% placeholder.

EXAMPLE: You can back-order up to %number% items.

String

Multilingual

HTML allowed

isBackorderLimited

Enables the "Limit the backorder quantity" option for the product.

Yes/No

backorderLimit

Defines the maximum backorder quantity.

Integer