This guide will help you properly complete the .csv file used to import products. The file's columns should be separated by a ; (semicolon) and the text delimited by a ". The columns shown below should maintain their position and order.
SKU (Stock Keeping Unit): Unique product code. If the code is already present in your e-commerce, the product will be overwritten with the new data.
NAME: Product title
DESCRIPTION: Product description
PRICE: Product list price
FINALPRICE: Product final price
STOCKCOUNT: Product stock or quantity
UNLIMITED: If 1, the system will not manage the quantity of the product and it can be sold unlimited times. If enter 0, product quantity/availability will depend on the StockCount field.
USEVARIANTS: Set the field to 1 if there are product variants.
VARIANTS: Variants available for that product [e.g. color::red|blue|yellow#size::42|44 means that the product will have three colors (red, blue, yellow) and two sizes (42,44)].
Enter all variant combinations, following the example below:
red - size 42
red - size 44
blue - size 42
blue - size 44
yellow - size 42
yellow - size 44
VARIANTSVALUE: Defines the quantity and the additional price for the combined variants. Each variant combination must be defined: COMBINATION | QUANTITY | ADDITIONAL CHARGE | SKU | EAN | URL_IMAGE # ...
The # (hash) character separates one combination from the next. No spaces are allowed.
The | (pipe) character separates the properties of the combination and must be included even when a piece of data is not present.
Combination: the superkey of the options in the current combination. For example: if we are in the color red, size S, the superkey will be: red_s . If I have only one variant, the superkey is the same as the key to the option: red
Quantity: the available quantity of the combination [leave as 0 (zero) if the product has unlimited quantities]
Additional charge: additional charge for the combination (will be added to the product price, optional, it can be 0)
SKU: unique code for the combination (optional)
EAN: EAN of the combination (optional)
Image URL: URL of the image of the combination (optional). The URL must be reachable from the network. No URLs from local computers.
CATEGORYTREE: Category tree to which the product is assigned. If the categories do not already exist, they will be created automatically by the system.
SOCIALCATEGORYID: Insert the marketplace ID category. Here is the updated list of social categories .
BRAND: Product brand. If it is not already in the system, it will be automatically created.
WEIGHT: Weight of the product in kg.
W: Length in cm of the packaging (used to calculate shipping)
H: Height in cm of the packaging (used to calculate shipping)
Z: Depth in cm of the packaging (used to calculate shipping)
PARAMETERS: Filters set from the control panel (e.g. color|1#discounted|0 will apply the "color" and "discounted" filters)
IMAGES: Image URL reachable via HTTP to assign the product's main image and any related images. Images must be separated by "|" (e.g. link_principal|link_related1|link_related2).
TAGS: Insert tags for your product separated by a "," (comma).
FACEBOOKENABLE: If 1, the product will be visible on the Facebook showcase; if 0, it will not be visible.
SEOTITLE: Product SEO title
SEODESCRIPTION: Product SEO description
SEOKEYWORDS: Product meta keywords
FREE_SHIPPING: If 1, the product will have free shipping. If 0, the product will be included in the shipping cost calculation.
EAN13: Insert the EAN13 code or EAN8 code of the product. This code will be used, if required, during synchronization with third-party marketplaces (e.g. Amazon, eBay etc.).
MPN: Manufacturer Part Number. Used to sync with third-party marketplaces.
VISIBLE: Set to 1 to make the product visible on your storefront. Set to 0 to hide the product from your storefront. Here is a file to use as an example: Click here to download
Comments