Compatibility:
WebSite X5 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 | Yes | Description | 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 | No | Description | 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 | No | Description | 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 | No | Description | 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 | No | Description | 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 | No | Description | 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 | |||
| Mandatory | No | Description | The 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:
| ||
| Parameter: Available | |||
| Mandatory | No | Description | The approximate or actual 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:
If the Available quantity is set, the quantity is taken from the option Quantity currently in stock. | ||
| Parameter: Pending | |||
| Mandatory | No | Description | In case an Available quantity is set, this reports how many products must be added or removed from the stock. |
| Value | When 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 | No | Description | The list of the images added for a product |
| Value | When 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.