Import

In this section you can import your own data or images to the shop. There are different options and you can download the Excel templates, sample files and instructions for each type of import.

Accessories import

This import is used when you want to connect accessories to products.

Supported format: Excel file (XLSX).

Template structure:

Template explanation:

Title	Meaning
Main part number	Product article number.
Main manufacturer name	Product manufacturer name.
Accessories part number	Product article part number of the accessory.
Delete	If the accessory should be deleted from the product.
Recommended	If the accessory is recommended.

Address import

This import is used to update customer addresses.

Supported format: Excel file (XLSX).

Template structure:

Title	Meaning
Action	Delete column: column is used to delete an existing entry by filling in "D". It should be left blank otherwise.
Address type	The Address Type column should contain 0 for Invoice address or 1 for Delivery address. Any other value, or an empty row, will cause the row to be skipped.
Name
Company
Gln
Address 1
Address 2
Zip
City
Country
Code	The Code column is for identifying specific addresses on the customer, if a customer has multiple addresses each of them need a unique Code to be separated from the other addresses connected on the customer. If no address is found via the code then a new address will be created on the customer(s).
Read only	The "Read Only" column should contain either the value "true" or "false". If set to true, this address will be set as read only and can not be modified in the shop. It can still be changed or deleted through a new import.
Customers	The Customers column should contain comma separated customer numbers to be updated with the address.

Product Imports

If you wish to extend the solution range of complementary products, there are procedures in place. Select the type of product imports. After that you can, via the option "Download template for Excel-import", download a zip file containing an Excel template that is based on a given product structure. The Zip file also contains an example and a description of the columns in the template.

Fill in the Excel template with the products you wish to replenish. The next step is to upload the Excel file.

Next, use “Browse” to search for and select your file. Once you find the file to be imported, click on the button "Execute the import."

Please note: You cannot make any structural changes in the Excel template, for example. You cannot delete or add columns, however on some occasions you may not have to fill in all columns with data on the template. Binding columns marked with an asterisk (*).

Fixed-price imports

This type of import is to be used in the event that you wish to administer fixed rates via Excel. This is useful in the event that you wish to work with a larger number of fixed prices. Imports constitute real price logics within the shop. If necessary you can edit imported fixed price logics using the same sheet.

BID Imports

This import is used in the event that you wish to complete the shop with BID pricing. This can be useful if for some reason you cannot obtain your “price file” with associated purchase prices automatically.

Customer Import

Here, you can import customers with associated information such as shipping and billing addresses. You can also add the price file and other additional connections that the customer needs to be associated with.

If you do not want an email to go out to newly registered customers once they have been uploaded please ensure that the “Registration Mail to new customers” is unchecked.

In this part you can also create your own dynamic template. At "Dynamic field template", click on Edit / Create and then select the fields you want to be in the template.

When you are done, click Ok and then select the template you created. Note that the columns in your excel file must have the same order as you created in your template.

Image Import

To import images in a coherent way you must make sure that the image is named the same as the manufacturer's part number, plus the file extension. (Jpg or Gif) Once you have collected the images you want to import into a folder, create a zip file of images in the folder. Zip the file to the upload by selecting the type; "Photo Import" during the import, and then use the “Browse” button to locate the file to be imported. Click on "import". The pictures will be treated to images sized to best fit into the store.

Warehouse Stock Imports

Import of own stock is done by imports. You can also choose which layer for the import if you have several warehouse locations.

Agreement assortment product import

Import products to an agreement assortment list. This can be very useful if you have a long list of products to add.

Function	What it does
Save import	This option lets you configure a recurring import via FTP. When the file is updated on the FTP, it will be scheduled for import in the shop.
Type	Choose the format of your import file. These are the options available to use.
File	Pick a file to upload.
Focus assortments	Choose the focus assortment to import to.
Full file import	If checked, the current focus assortment will be emptied and replaced with the products in the import. Otherwise, the current products in the focus assortment will be merged with the products in the new import.