Quick import

• Quick import
  • What is the quick import?
  • Why?
  • How to use it?
    • Load your data
    • Choose the fields in which to import your data
      • For list and categories
      • For numbers
      • For media
    • Import mode
    • Save your configuration
  • Scope
  • Multi-categories
  • Multi-levels
  • FAQ
    • For lists or categories how to map my values with the values expected by the retailer?
    • What happens if the options or categories does not exist?
    • Why my values have not been imported?
    • Why can I not find my field?
    • How do I enable the import without an identifier ?

What is the quick import?

It allows to quickly import data from an Excel file.

Why?

You might need:

• To mass import data from an Excel file
• To update just one column but for several items
• If you are a retailer or a marketplace you need a tool for your suppliers/vendors to quickly import their data

How to use it?

Load your data

Copy your data from your Excel or Google sheet with Ctrl + C.

You can copy all your products data at once, whether they are in the same category or not, whether they are on the same level or not, with the common and specific attributes all together. More details in sections Multi-Categories and Multi-Levels.

Then go to Actions > Import data and paste your data with Ctrl + V:

Tip

To be able to paste information there, you must first authorize Google Chrome to access to the clipboard.

If you have copied headers, you must check that the first line is the header. That will enable the Quick Import to suggest you a target field for your data.

Then click the Next button.

Choose the fields in which to import your data

Here you have to map columns with existing fields by simply clicking on a column header and typing the name of the field that you want to import into.

It is required to select an identifier to continue. That enables the Quick Import to create new items and find existing items to update.

In case your table does not expose an identifier, you must provide the fields required to uniquely identify an item. Check with the table owner which they are. If the provided data is not enough to uniquely identify an item, it will neither be created or updated.

With the Quick Import, you can, for each column, search for any accessible field in the table, with the option of filtering results on relevant fields only (i.e.: identifiers, classifications, common or specific fields for a classification and category). By default, you can select any field type.

With the Quick Import, if you're using a multi-level table, you can also filter fields by level. By default, you can select any field at any level.

Depending on the type of data contained in the column, you need to take the following into account:

For list and categories

Lists and categories have a key and a title for each value, for example for a field named Country of origin, for each option you can see the title and the key:

With the quick import you can use either the key or the title.

For numbers

You can import numbers in different formats, for example:

• 2 300,90 €
• $ 2,300.90
• 2300.9

For the prefix and the suffix, usually used for unit and currency, you must indicates it for each column:

For the decimal and thousands separator, enter the right value in the next step:

For media

You can use the quick import to mass import images or files. Each file must be available on a public url starting with https:// or http://.

Import mode

You can choose between:

Mode	Description
Create and update items	If the line does not exist it is created, if the line exists it is updated.
Only create new items	If the line does not exist it is created, if the line exists it is not updated.
Only update existing items	If the line does not exist it is not created, if the line exists it is updated.

Save your configuration

A great way to save you time, is to save the configuration that you have used for each columns. This way next time you will be able to just paste your data without the hassle of mapping each columns.

Scope

• A maximum of 100 000 cells can be imported at once
• At least one Identifier column must be selected for each level of data to be imported.

Multi-categories

When you sell multiple kind of products, each category of product can have common properties, and specific properties. A Laptop, a Fridge and a Washing machine does not have the same properties.

With the Quick Import you can import any kind of products at the same time avoiding to split your import category by category. To do so, you need to have a column for each specific attribute. And in case multiple categories sharing the same attribute, you can have a single column.

The specific field data will only be imported on the specific fields of the item category.

Multi-levels

When you manage product declinations with multiple levels, to create and update your products with the Quick Import : you must provide an identifier for the product to import plus an identifier for its parent declination.

To import the below products:

Your data must look like this:

Reference	Typology	Title	Gender	Reference color	Color	Main Image	Material	SKU	EAN	Size	Stock
0001	T-Shirt	T-Shirt for sprint	Woman	0001-RED	Red	000-red_front.jpg	100% cotton	0001-RED-S	1234567890123	S	123
0001	T-Shirt	T-Shirt for sprint	Woman	0001-RED	Red	000-red_front.jpg	100% cotton	0001-RED-L	1234567890124	L	34
0001	T-Shirt	T-Shirt for sprint	Woman	0001-GREEN	Green	000-green_front.jpg	100% cotton	0001-GREEN-S	1234567890125	S	45
0001	T-Shirt	T-Shirt for sprint	Woman	0001-GREEN	Green	000-green_front.jpg	100% cotton	0001-GREEN-L	1234567890126	S	12

Here you have defined for each article the full declination. Without the parent Model color and Model, you cannot create or update the Article as the Model color and Model to which it belongs are unknown.

Optionally, you can define a line for each Model and Model color. In that case, be careful to the data consistency, there could be differences between each line.

Reference	Typology	Title	Gender	Reference color	Color	Main Image	Material	SKU	EAN	Size	Stock
0001	T-Shirt	T-Shirt for sprint	Woman
0001	T-Shirt	T-Shirt for sprint	Woman	0001-RED	Red	000-red_front.jpg	100% cotton
0001	T-Shirt	T-Shirt for sprint	Woman	0001-RED	Red	000-red_front.jpg	100% cotton	0001-RED-S	1234567890123	S	123
0001	T-Shirt	T-Shirt for sprint	Woman	0001-RED	Red	000-red_front.jpg	100% cotton	0001-RED-L	1234567890124	L	34
0001	T-Shirt	T-Shirt for sprint	Woman
0001	T-Shirt	T-Shirt for sprint	Woman	0001-GREEN	Green	000-green_front.jpg	100% cotton
0001	T-Shirt	T-Shirt for sprint	Woman	0001-GREEN	Green	000-green_front.jpg	100% cotton	0001-GREEN-S	1234567890125	S	45
0001	T-Shirt	T-Shirt for sprint	Woman	0001-GREEN	Green	000-green_front.jpg	100% cotton	0001-GREEN-L	1234567890126	S	12

FAQ

For lists or categories how to map my values with the values expected by the retailer?

The quick import feature is only limited to import data in format of the table you are working with. If you need to do more complex mappings between your data and the data expected by your retailer, then you need to use the feature Rules engine. To learn more contact your customer success.

What happens if the options or categories does not exist?

They are ignored and not imported.

Why my values have not been imported?

For options and categories, only valid values in the list can be imported. For example in a field named Country of origin like this:

Only values that are defined in the list can be imported. Therefore if you try to import a value which is not in the list, the value will be ignored. To import the value you can use either the key or the title.

Why can I not find my field?

In the Quick Import, you can only find identifiers that you can see in one of your screens. If you can not see it in a screen, you can not import it.

How do I enable the import without an identifier ?

As the table owner, you can enable the import without an identifier by editing the table properties from the table menu in App.