How to import data
page last edited on 30 January 2017
Why you may need import
If you run a big store with hundreds of products and decide to update your product descriptions or add many new products, you will realize that it is annoying to update/add each new product via the Admin interface. Instead, you can work in your favourite spreadsheet editor (MS Excel _or _LibreOffice Calc), add/change all the needed info there, which is faster, and then upload this document into the store so that your X-Cart 5 will create/update the products for you. The process is as follows:
- Prepare a CSV file.
- Upload your CSV file into X-Cart 5 via the Catalog > Import section of the store’s Admin area; the platform will do the rest for you.
Preparing a CSV file
There are two ways to create a CSV file for import:
- Export all the products via the Catalog > Export section in the Admin area. In this case, the CSV file will contain information about all the products in your store. This method is useful when you want to update the details of your existing products.
- Create a CSV file from scratch. This method can be useful, for example, if you need to add new products to your store.
Creating a CSV file from scratch
- Create a new table in your favourite spreadsheet editor (MS Excel, LibreOffice Calc, etc).
- Define what parameters you want to import. To do so, specify these parameters in the cells of the first line in your spreadsheet file. Links to articles with detailed information on the supported parameters can be found in the section CSV format by X-Cart data type of this manual.
- Specify the actual details in the cells of the second and all the subsequent lines. Ultimately, your file will look similar to this:
- Export the file to CSV format.