Importing Lots Admin
You can import both Client data and Lot data from CSV files. This article explains the steps required to Import Lots into Snoofa. You can read the Import Clients article if you'd like import the client data.
There are two ways how to import Lots. There is a Standard and Simple lot import. The Simple Import tries to remove all the more specialised data, keeping things down to what is truly needed at its most stripped down. If you're just starting out use this import format. To import more fields or to do a data migration involving information about the vendors and buyers of lots, you can use the Standard Import.
TABLE OF CONTENTS
Simple Lot Import
This video guides you through preparing your CSV file (using Google Sheets as an example), understanding the required columns, uploading the file, and troubleshooting common errors.
Here is the Google Sheet Snoofa Simple Lot Import Template referenced in the video. And you might also find the List of Marketplace Labels useful.
Standard Lot Import
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.
Columns of the Standard Lot Import
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.
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 |
|
|
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