Import Lots File

Modified on Thu, 5 Jan, 2023 at 12:57 PM

In scenarios where you might manage and create your own list of lots, with inner items information, to be used in event or viewing purposes, we provide a quick and easy import tool. The tool is supporting CSV files only to be uploaded to the platform. Once uploaded, the tool will transform each line in the CSV into a new inventory item with the corresponding attributes, and then combine the items into lots using the information you provided in the file. All attributes might be modified after the import process.

Please Note

The system distinguishes between importing inventory files and importing lots files. In case your intention is to import a file containing only inventory items for the purpose of inventory management - please check the Import Inventory File article.

Supported CSV columns:

Each line should represent a single inner item with related attributes. For a full list of all available attributes, please check the Inventory Attributes article.

Additionally, for the purpose of creating lots from the items, each line in the CSV should contain the following columns:

  • lot_number / lot_id (required)
  • lot_description
  • lot_reserve_price
  • lot_start_price
  • lot_code

The import tool is using the lot_number column in order to combine the items into the correct lots, meaning that all the items that have the same lot number will be combined as inner items of the same lot. The order of the inner items will be the same order as provided in the CSV file.

The other optional columns can be repeated for each line or stated only once per lot. The tool will use the first non-empty value for the value of the lot rows, as the corresponding value of the lot.

In case of missing lot descriptions, the system will generate descriptions based on the inner items' descriptions.

 Additional notes:

  • All columns named are case-insensitive, meaning that upper-case letters will be treated as lower-case letters.
  • All columns in the CSV that contains underscore (_) character, can be replaced with space or hyphen / Dash (-) character accordingly. e.g. the column "weight_unit" is also supported as "weight unit" or "weight-unit".

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article