Compatibility:

WebSite X5 Evo and Pro


After creating an e-commerce shopping cart, it may be useful to export the product catalog to use in another Project, or with other software, such as your accounting program. It is also just as important to be able to import a product catalog so that you don't have to recreate it from the beginning.

In WebSite X5 you can import/export product catalogs using the options Import Products e Export Products available in the  toolbar in the Shopping Cart > Product List window. When you export a product catalog, a file in .TXT or .CSV format is generated, that can easily be opened and edited with any text editor (for example Windows Notepad) or Microsoft Excel.

Follow the instructions below if you manually edit the exported Product Catalog file, or you create a new one to import:

  • The first row must contain the field headings with these labels:
ID;Category;Name/Code;Description;SKU;Price;Weight;Options;Enable Discounts;Discounts;Availability Type;Available;Pending;Images
  • If you delete a field from the header, you will delete that data for all Products. Mandatory fields (Category, Name/Code, Description and Price) cannot be deleted.
  • Each row after the heading corresponds to one product.
  • All the parameters must be separated by the ";" character.
  • The following must be given for each product: Category name, Product name, Product description, Product price. All the other fields are optional and may be omitted (you won't need to write anything between the ";" characters for the field in question).
  • The product ID is generated by the Program, not manually: if you enter a new Product, leave the ID field empty.
  • Any unnecessary spaces in the file will be removed when it is imported.


The parameters in a .TXT or .CSV file are:


Parameter: ID
Mandatory
No
Description
The product's unique identification.
Value
It is generated and associated with a product automatically by the Program.

If you update the .TXT or .CSV file of a previous export, do not edit the existing IDs, and leave this field empty for new products. When new .TXT or .CSV file is created to import a product catalog, you wont need to manually create the Product IDs. When importing the file, the Program checks against duplicate IDs and generates the necessary new ones.
Parameter: Category
Mandatory
Yes
Description
The Category of the Product.
Value
Use the ">" character to indicate the path of categories and subcategories.

For example, a T-shirt in the subcategory "Casual" of the category "Men's clothing" is indicated in the ,TXT or .CSV file :

... ; Men's clothing > Casual ; ...

You can add all the necessary subcategories in this way.
Parameter: Name/Code
Mandatory
Yes
Description
The Name or Code of the product.
Value
When the catalog is exported to a .TXT or .CSV file, this parameter is taken from the Name/Code field in the Product Settings > General window.
Parameter: Description
Mandatory
YesDescription
The description of the Product.
Value
When the catalog is exported to a .TXT or .CSV file, this parameter is taken from the Description field in the Product Settings > General window.
Parameter: SKU Code
Mandatory
NoDescription
The SKU Code of the Product.
Value
When the catalog is exported to a .TXT or .CSV file, this parameter is taken from the SKU Code field in the Product Settings > General window.
Parameter: Price
Mandatory
Yes
Description
The price of the Product.
Value
When the catalog is exported to a .TXT or .CSV file, this parameter is taken from the Price field in the Product Settings > General window.


Parameter: Weight
Mandatory
NoDescription
The weight of a Product.
Value
When the catalog is exported to a .TXT or .CSV file, this parameter is taken from the Weight field in the Product Settings > General window.
Parameter: Options
Mandatory
NoDescription
A list of possible Product options.
Value
When the catalog is exported to a .TXT or .CSV file, this parameter is taken from the Main Option List field in the Product Settings > Options window.

If you are creating a .TXT or .CSV file to import, the Product options in the list can be separated by the "|" character, as follows:

... ; Option1 |Option2 | Option3 ; ....

All the necessary options can be added in this way.
Parameter: Enable Discounts
Mandatory
NoDescription
Indicator for bulk discount for the Product.
Value
When the catalog is exported to a .TXT or .CSV file, this parameter is taken from the Enable Quantity Discount option in the Product Settings > Discount window.

This parameter can have a value of 1 or 0, according to whether the Enable Quantity Discount option has been selected or not.
Parameter: Discounts
Mandatory
NoDescription
The list of possible bulk discounts for the Product.
Value
When the catalog is exported to a .TXT or .CSV file, this parameter is taken from the Enable Quantity Discount option in the Product Settings > Discount window.

If you are creating a .TXT or .CSV file to import, the list of bulk discounts must be written as follows:

... ; quantity : discount | quantity : discount ; ...

So, if a bulk discount of 10% is applied to orders for more than 20 articles, and a discount of 15% is applied to orders for more than 50 articles, you would write:

... ; 20 : 10 | 50 : 15 ; ...

Use the "|" character to add all the necessary bulk discounts.
Parameter: Availability Type
MandatoryNoDescriptionThe kind of information reported about the stock availability of a product.
Value When a catalog is exported to a .TXT or .CSV file, this parameter is taken from the Product Settings> Availability window.

If you are creating a .TXT or.CSV file, please consider the parameter may take on the following values:
  • ..;Unset;.. - if the option No information on product availability is set;
  • ..;Fixed;.. - if the option Approximate quantity is set;
  • ..;Dynamic;.. - if the option Available quantity is set.
Parameter: Available
MandatoryNoDescriptionThe approximate or actual availability of a product.
ValueWhen a catalog is exported to a .TXT or .CSV file, this parameter is taken from the Product Settings> Availability window.

If you are creating a .TXT or.CSV file, please consider the parameter may take on the following values:
  • ..;Available;.. - for the option Approximate quantity | In Stock;
  • ..;Lack;.. - for the option Approximate quantity | Limited availability;
  • ..;Not Available;.. - for the option Approximate quantity |     Out of Stock

If the Available quantity is set, the quantity is taken from the option Quantity currently in stock.
Parameter: Pending
MandatoryNoDescriptionIn case an Available quantity  is set, this reports how many products must be added or removed from the stock.
ValueWhen a catalog is exported to a .TXT or .CSV file, this parameter is taken from the Product Settings> Availability window, and takes on the value reported for the Quantity to add/remove.

If you are creating a .TXT or.CSV file, the parameter should only display the set value
Parameter: Images
Mandatory
NoDescriptionThe list of the images added for a product
ValueWhen the catalog is exported to a .TXT or .CSV file, this parameter is taken from the Product Settings > Image window. The original absolute path name is given for each picture.

If you create a .TXT or .CSV file to import, on the other hand, a Product picture list can start with the “|” character, followed by the relative or absolute path name, as follows:

... ; PathImage1 | PathImage2 | PathImage3 ; ....


When you import a .TXT or .CSV file from a previous export operation or that you have written yourself, it will probably be updated by the Program, by adding missing IDs, for example. If you want an updated copy of the .TXT or .CSV file, you will have to re-export the product catalog.