TeamWox HelpProductsImport

Import of Products

In order to start importing products you should press the "Import" button, located at the upper part of the "Products" tab.

Import of products

The process of importing consist of several stages:

1 Data Source

The following is specified at this stage:

  • Data source — in this field you should specify the format of a file that you're going to import. Only the *.CSV files are supported at the moment.

2. Data Source Parameters

The following parameters are specified here:

  • File — in this field you should choose a file to be imported by pressing the "Browse" button.
  • Encoding — the selection of encoding of the imported file.
  • Skip rows — the number of rows that should be skipped in the beginning of file.
  • Separator — separator that divides different data by products in the file (comma, dot or tabulation character). If the "Auto" variant is chosen, the identification is performed automatically.

The imported file should not contain unclosed quotes and brackets. Otherwise, the imported data may be incomplete.

3. Additional Settings

There are no additional parameters when importing products.

4. Match Fields

At this stage you should match the fields of the file with the fields in the system:

Viewing and associating columns

The preview window shows first 10 lines to be imported.  Columns that are matched to a field in the system are green colored, and the ones that are not are blue. To switch between matched and unmatched fields, use the corresponding commands in the upper part of the box.

To match a column with a field, press the Select field button in the upper part of the table. Obligatory fields are marked with the Obligatory field in the list.

It is obligatory to specify the "Name" field when importing products. At a repeated import the comparison with the existing products is performed by the "Name" field, this allows not to duplicate the products but to update the information by them.

The statistics on the imported file is show below — number of listed rows and the total number of rows in the file. The number of rows that cannot be imported due to some reason is shown here as well. The reason of it can the absence of an obligatory field.

Once you've finished checking and matching columns you should press the "Import" button.

← Export Reports →