page last edited on 30 January 2017
Data import is a perfect solution if you don’t have time or desire to populate your store with products and customers, adding them manually one by one. It enables you to add new and update existing information about products, categories, users and other stuff by submitting a specially formatted data file. If necessary, it is even possible to import orders.
If you want to add multiple changes to products that already exist in the database, you may find it easier to use bulk editing instead.
For data import/export, X-Cart uses CSV files. Such files can be edited using any popular spreadsheet editor like MS Excel or LibreOffice Calc.
Importing products is useful if you are switching to X-Cart from another platform, or if you want to make multiple changes to your products or inventory that are not possible with bulk editing.
Similarly, if you have a customer list from another platform that you want to transfer to your X-Cart store, you can enter it into a CSV file and import this file via your X-Cart Admin area. You can also use a CSV template to build a new customer list.
Data export is a convenient way to get structured information out of your X-Cart store. Typically, the auxiliary function of the data export is to facilitate the detection of the correct format required for data import. For example, to reveal the correct field format and values to import a specific type of data you can add a couple of items of that type via the X-Cart store Admin area manually (or use the existing demo data) and then export it to CSV. This way, you will have a pattern to follow when formatting the rest of the data to be imported into the store via CSV.
In this section:
- How to Import data
- How to Export Data
- CSV Format by X-Cart Data Type
- Updating Product Properties (Price, Stock Quantity, etc.) via import
- Integration with Doba (Drop Shipping Services)
Help make this document better
This guide, as well as the rest of our docs, are open-source and available on GitHub.