Importing Lots

Modified on Thu, 27 Feb at 9:39 AM

Importing Lots Admin

Snoofa comes with the ability to Import both Client data & Lot data en masse from CSV files. This article explains the steps required to Import Lots into Snoofa. To learn how-to Import Clients, see that article.

There are 2 types of Lot Import, Standard & Simple. The Simple Import tries to remove all the more specialised data, keeping things down to what is truly needed at its most stripped down, & in doing so has the potential to Import other formats that you may have exported from any sites you list on.

How-to Import Lots

1. Hover over the plus icon in the top right corner & click Import

2. Select the Lots import type (standard or simple), select an unlocked auction, select a CSV file (details below), & click Upload

3. Check that number of rows matches expectations & hit Start import

4. The import can run for many minutes (depending on the number of rows). Once the import status changes from IN PROGRESS to FINISHED (refresh the page to check the status) the import is done.

5. Now you can check the errors log (if there are any) & optionally you can Erase Data created by the import.

CSV Template

The CSV templates (downloads at end of this article) contain all the header columns needed to parse into Snoofa. You can use them as a template when preparing your import.

Below is an explanation of what each header represents.

Explanation of Columns

Header Column	Example value	Notes
vendor_id	`ABC1234`	A unique identifier for the Client. In case a Client Import has happened & made use of the ID Column, then this ID will be used to reference the Client. All other vendor details can be empty.
vendor_email	`[email protected]`	This must be unique for each Client. If a duplicate is detected the import shows the error: `Client with email [email protected] already exists.` If not filled in a unique email for the Client is generated. See the What if a Client doesn't have an email address? article for more details.
vendor_title	`Mr`
vendor_firstname	`Archie`	This is a required field.
vendor_lastname	`Harrison`
vendor_phone	`+44 7911 123456`	Include the Country Code.
vendor_vat_number	`GB 123 4567 89`
vendor_company_name	`Company Limited`
vendor_preferred_language	`en`	Supported options: en, de, ja, es, zh, sv, it, fr, ko Default: en
vendor_registration_date	`1601023031`	Default: date & time of the import in the form of the UNIX Timestamp
vendor_address_first_line	`123 Elm House`
vendor_address_second_line	`Llancayo Court`
vendor_address_third_line	`Apartment 3`
vendor_address_city	`Usk`
vendor_address_unit	`Monmouthshire`	Regions (units), when filled in must be one of the available options: see the full list.
vendor_address_zip_code	`NP15 1HY`
vendor_address_country	`United Kingdom`	When filled in it must be one of available options: see the full list.
ca_number	`AB1000`	Must be filled in for all rows
ca_line	`12`	All cells must be empty (in that case line numbers are assigned automatically) or all must be filled in.
item_title	`A violin`
item_subtitle	`19th centrury`
item_description	`Made by…`
item_category_id	`4`	This is a required field. The Categories must be first created in `System Settings` > `Item Categories`.
item_low_estimate	`10000`
item_high_estimate	`50000`
item_starting_bid	`6000`
item_reserve_price	`8000`
item_is_antique	`1`	`1` = item is antique, `0` = item is not antique
item_vat_schema	`MS`	Mandatory. MS for Margin Schema or SS for Standard Schema.
lot_number	`123`
lot_hammer_price	`25000`
lot_buyer_commission_id	`3`	Item Charges must be first created in `System Settings` > `Item Charges`.
lot_vendor_commission_id	`5`	Item Charges must be first created in `System Settings` > `Item Charges`.
lot_vendor_commission_value	`2500`
buyer_id	`ABC1234`	All of these columns behave the same way as the `vendor_...` columns.
buyer_email	`[email protected]`
buyer_title	`Mr`
buyer_firstname	`Archie`
buyer_lastname	`Harrison`
buyer_phone	`+44 7911 123456`
buyer_vat_number	`GB 123 4567 89`
buyer_company_name	`Company Limited`
buyer_preferred_language	`en`
buyer_registration_date	`1601023031`
buyer_address_first_line	`123 Elm House`
buyer_address_second_line	`Llancayo Court`
buyer_address_third_line	`Appartment 3`
buyer_address_city	`Usk`
buyer_address_unit	`Monmouthshire`
buyer_address_zip_code	`NP15 1HY`
buyer_address_country	`United Kingdom`
registration_paddle_number	`ONL12345`
registration_type	`1`	`1` = Room, `2` = Absentee, `3` = Phone, `4` = Online

Keeping It Simple

As mentioned at the start of this article, there are the Standard & Simple Lot Import CSVs. The above table explained the various header columns contained within the Standard CSV. The Simple CSV strips out most of the headers, keeping it as simple as possible.

It contains just the item_title, item_description, item_reserve_price & item_starting_bid headers. There is also the option of having the item_mpc_labels header, this header adds labels. E,g., Guitars; Modern & Contemporary.

Downloads Below

Attachments (3)

csv

Standard Lot....csv
991 Bytes

csv

Simple Lot I....csv
110 Bytes

csv

Simple Lot L....csv
158 Bytes