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 |
| 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 | This must be unique for each Client. If a duplicate is detected the import shows the error:
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 |
| |
vendor_firstname |
| This is a required field. |
vendor_lastname |
| |
vendor_phone |
| Include the Country Code. |
vendor_vat_number |
| |
vendor_company_name |
| |
vendor_preferred_language |
| Supported options: en, de, ja, es, zh, sv, it, fr, ko |
vendor_registration_date |
| Default: date & time of the import in the form of the UNIX Timestamp |
vendor_address_first_line |
| |
vendor_address_second_line |
| |
vendor_address_third_line |
| |
vendor_address_city |
| |
vendor_address_unit |
| Regions (units), when filled in must be one of the available options: see the full list. |
vendor_address_zip_code |
| |
vendor_address_country |
| When filled in it must be one of available options: see the full list. |
ca_number |
| Must be filled in for all rows |
ca_line |
| All cells must be empty (in that case line numbers are assigned automatically) or all must be filled in. |
item_title |
| |
item_subtitle | 19th centrury | |
item_description |
| |
item_category_id |
| This is a required field. The Categories must be first created in |
item_low_estimate |
| |
item_high_estimate |
| |
item_starting_bid |
| |
item_reserve_price |
| |
item_is_antique |
|
|
item_vat_schema |
| Mandatory. MS for Margin Schema or SS for Standard Schema. |
lot_number |
| |
lot_hammer_price |
| |
lot_buyer_commission_id |
| Item Charges must be first created in |
lot_vendor_commission_id |
| Item Charges must be first created in |
lot_vendor_commission_value |
| |
buyer_id |
| All of these columns behave the same way as the |
buyer_email | ||
buyer_title |
| |
buyer_firstname |
| |
buyer_lastname |
| |
buyer_phone |
| |
buyer_vat_number |
| |
buyer_company_name |
| |
buyer_preferred_language |
| |
buyer_registration_date |
| |
buyer_address_first_line |
| |
buyer_address_second_line |
| |
buyer_address_third_line |
| |
buyer_address_city |
| |
buyer_address_unit |
| |
buyer_address_zip_code |
| |
buyer_address_country |
| |
registration_paddle_number |
| |
registration_type |
|
|
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
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article