How to Import Data

A general overview of data importing in X-Cart.

Olga Tereshina avatar
Written by Olga Tereshina
Updated over a week ago

Import is a fast and convenient way to populate an online store with the inventory it needs to contain. Using the data import tools, a store admin can add new and adjust the store's existing data.

To import data into an X-Cart store, follow the steps below:

  1. First, prepare a CSV file of a particular format matching the imported data type. You can do this in any spreadsheet editor (MS Excel, LibreOffice Calc, etc.).

  2. Click the Choose file button on the Catalog > Import page of the store's Admin area. By default, you can use CSV or ZIP file formats.

    The selected file(s) will display next to the button.

  3. Now, define the required import settings.

    • Do not verify images to run the process faster: If disabled, the option allows checking if images included in the import file exist on the server. Images verification slows down the import process.

    • Import mode: Select how imported data should affect the store.
      Your options are:

      • Create new items and update existing items* - This mode enables you, as the name suggests, to create new items and update the existing ones. For example, if your import file contains items that do not yet exist in the store's database, these items will be created due to the import.
        You can create new items based on the following master IDs:

        • categories: path

        • products: sku

        • attributes: product, name, class, group

        • product-attributes: productSKU, type, name, class, group, owner, value

        • reviews: product, additionDate, reviewerName, email

        • customers: login

      • Update existing items, but skip new items* - This mode enables you to update the existing items without creating new ones.

        * In both import modes, your online store will create missing items dependent on the existing items. For example, if you update a product that doesn't have a category assigned to it and specify a category value, the related category will be created.

      • Create new items, but skip existing items (Orders) - This mode is added by the Orders Import add-on and applies to orders only. It allows importing new orders, not affecting existing ones.

    • Charset: Set the character encoding used in your CSV file. If you did not change
      it, keep the default setting "UTF-8".

    • CSV delimiter: Set the type of delimiter used in your CSV file: comma or semicolon. Keep the default setting if you did not change it (Comma).

  4. Click Start import.

Related pages:

Did this answer your question?