Import items from a file
On our website, you can import items from an Excel spreadsheet file. To import items, go to the Manage lots page and click on the Import items button:
In the window that has opened, click Upload File and load the spreadsheet with the list of lots. In the same window, you can download Import File Template showing a filled table with lots, an empty template for filling it with your lots as well as a list of categories:
The import file can be in .xlsx, .xls, .csv or .ods format.
You will see file import status after importing has started. You can close the page - importing lots will continue in the background :
When you re-enter the lot management page after the import process is completed, you will see a window with a report on the number of imported items and table row numbers from which lots were not imported.
Lots from a file are not imported in cases when all the required fields have not been filled in or an error has been made in category names :
The import file is a table in which each row displays a separate lot. The corresponding lot information is entered in each row cell :
Lot number. The number of the lot. Numbers, letters, and other symbols can be entered.
Title. The title of the lot; up to 80 characters. If more characters have been entered, only the first 80 are imported.
Starting Price. The starting price of the lot. The currency is not specified!
Low estimate. The lowest estimated lot price. Optional to fill.
High estimate. The highest estimated lot price. Optional to fill.
Category. The category in which the lot will be placed.
Subcategory 1. Subcategory of level 1 in which the lot will be placed.
Subcategory 2. Subcategory of level 2 in which the lot will be placed.
Description. Lot description.
Condition. Lot condition. Optional to fill.
Main Image. Main image/photo of the lot. The link pointing to the image file on the Internet should be inserted here.
For example: http://mysite.com/lot/image1.jpg
Additional images. Additional images/photos of the lot (no more than 80 images). The links pointing to image files should be inserted here. They should be separated with the ";" sign. Optional to fill.
Filling categories in the import file.The category in which the lots will be placed is indicated in the Category, Subcategory 1, Subcategory 2 columns, forming a hierarchical path to the lot Category > Subcategory 1 > Subcategory 2 :
The names of categories/subcategories should be taken from the sample file. You should copy the names correctly, as the names in the import file must fully match the existing categories on the website. The structure is quite simple; in the screenshots, we have used conditional color markup for your easier navigation.
Category (green tabs) – the names of the main categories. Each tab has Subcategory 1 and Subcategory 2 tables.
Subcategory 1 (red row) – subcategories of level 1.
Subcategory 2 (yellow columns) – subcategories of level 2. Subcategory 2 should be selected strictly from the column of the previously selected Subcategory 1 (that is, any of the values are located below the selected Subcategory 1).
For example, you want to sell a coin of the Russian Empire during the reign of Peter I. Then you select:
Category —> Coins
Subcategory 1 —> Russia
Subcategory 2 —> Peter I (1699-1725):
And you copy these cells into the corresponding cells of the import file:
As a result, the lots will get into the appropriate catalog section on the website: