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.
This import is used when you want to connect accessories to products.
Supported format: Excel file (XLSX).
Template structure:
Template explanation:
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.
This import is used to update customer addresses.
Supported format: Excel file (XLSX).
Template structure:
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.
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 (*).
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.
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.
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.
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.
Import of own stock is done by imports. You can also choose which layer for the import if you have several warehouse locations.
Import products to an agreement assortment list. This can be very useful if you have a long list of products to add.
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.
