This guide covers how to Import your Timed Lots and Listings via our formatted Spreadsheet.
CSV Import Prerequisites
Before proceeding, please ensure you have:
Saved your Spreadsheet in the CSV UTF-8 (Comma Delimited) format
Created a new Timed Auction and it is in either Preview or Live status
Importing your Item Catalogue CSV Spreadsheet
Once you’ve created a new Timed Auction and finished filling in our formatted spreadsheet, you can import your Items to your Auction via the Create New Items menu.
Step 1 – Log into the Webtron Dashboard and open the Auctions & Items > Create New Items menu
After you’ve logged into the Webtron Dashboard, click on the Auctions & Items dropdown, then click on Create New Items (the last option in the dropdown):
Step 2 – Select an Auction and click Choose File
You’ll now see another dropdown labelled Select an Auction, click on the Select an Auction dropdown, you’ll see a list of Auction Titles, click on the Auction Title for the Auction you’d like to upload these Items to:
After selecting an Auction two options will appear; Create New Items and Upload Items, click on the Choose File button next to the Upload Items button, and select your CSV Spreadsheet via your File Explorer/Finder:
Step 3 – Click Upload Items and review your Imported Items
Once you’ve selected your CSV Spreadsheet, the Upload Items button will turn green, click on it to begin importing your Items:
You’ll be moved into the Create Ghost Items menu and the Dashboard will display a list of your Imported Items inside the Ghost Items table.
If any of the fields for each Item have been filled in incorrectly or required fields are blank, they will be marked with a friendly red ⚠️ Warning badge, float you cursor over the badge for more information on what you need to fill in or fix for that field:
Step 4 – Convert your Items from Ghost status to Preview status
Once all of your Items have been reviewed and any flagged fields have been fixed, you can select your Items using the Select All checkbox at the top-left of the Ghost Items table:
Now that all of your Items are selected, click on the green Convert button above the top-left of the Ghost Items table, a confirmation window will appear at the centre of your screen, click on the blue Convert Items button to proceed:
The Create Ghost Items menu will now empty out and your Items will be transferred over the Item List for this Auction. Click on Items shortcut at the top-right of the Create Ghost Items menu to open the Item List and access your converted Items:
What next?
Now that your Items have been imported and converted, you can start uploading photos to them, either via the Bulk Upload Images menu, Bulk Edit’s Attachments Uploader or VendorPlus.
For a quick guide on using Bulk Upload Images, click on the guide linked below:
Uploading Photos via the Bulk Upload Images menu
Prerequisites for using Bulk Upload Images Before we begin, you must ensure the following: Your Auction is in at least Preview status Your Items have been converted from Ghost Status to Preview Status Your image files have been renamed based on the Bulk Match structure (e.g. image files for Lot 1 must be 1.jpg, 1-1.jpg, 1-2.jpg, etc.) Accessing and Using the Bulk Upload Images menu Once you've fulfilled the requirements for using Bulk Upload Images,
FAQ – Importing Timed Lots and Listings via Spreadsheet
Q: When I click Upload Items it’s giving me a “Number of columns” error, what do I do? A: The Dashboard will give you the “Number of columns” error if your spreadsheet is: 1. The wrong format – It must be a .csv (CSV UTF-8 Comma Delimited), or 2. The Spreadsheet Template’s columns have been edited or are missing – the Dashboard will search through your spreadsheet and match your Item data to each respective column, do not alter the template and make sure you have used the template to catalogue your Items.
Q: Can I convert my Lots and fix any errors or missing info later? A: No, all required fields must be filled in or fields fixed before the Convert button will enable for that Lot. Set placeholders and use Bulk Edit later if necessary.
Q: I left out a Lot from my upload spreadsheet, can I just enter it in manually to the Dashboard? A: Yes, in the Create Ghost Items menu, click on the faint blue line (the bottom row of the table) to create a new Item, like this:
Q: I made a mistake or left out something in the spreadsheet, can I apply a change to multiple Items rather than doing it one-by-one? A: Possibly, if you need to apply a change to multiple Items and it’s from the Category column onwards, you can use the Group Edit panel. Simply select your Items using the checkboxes at the left-hand edge of the Ghost Items table, then click the grey Group Edit button at the top-right of the Create Ghost Items menu:
Importing Timed Lots and Listings via Spreadsheet
This guide covers how to Import your Timed Lots and Listings via our formatted Spreadsheet.
CSV Import Prerequisites
Before proceeding, please ensure you have:
Importing your Item Catalogue CSV Spreadsheet
Once you’ve created a new Timed Auction and finished filling in our formatted spreadsheet, you can import your Items to your Auction via the Create New Items menu.
Step 1 – Log into the Webtron Dashboard and open the Auctions & Items > Create New Items menu
After you’ve logged into the Webtron Dashboard, click on the Auctions & Items dropdown, then click on Create New Items (the last option in the dropdown):
Step 2 – Select an Auction and click Choose File
You’ll now see another dropdown labelled Select an Auction, click on the Select an Auction dropdown, you’ll see a list of Auction Titles, click on the Auction Title for the Auction you’d like to upload these Items to:
After selecting an Auction two options will appear; Create New Items and Upload Items, click on the Choose File button next to the Upload Items button, and select your CSV Spreadsheet via your File Explorer/Finder:
Step 3 – Click Upload Items and review your Imported Items
Once you’ve selected your CSV Spreadsheet, the Upload Items button will turn green, click on it to begin importing your Items:
You’ll be moved into the Create Ghost Items menu and the Dashboard will display a list of your Imported Items inside the Ghost Items table.
If any of the fields for each Item have been filled in incorrectly or required fields are blank, they will be marked with a friendly red ⚠️ Warning badge, float you cursor over the badge for more information on what you need to fill in or fix for that field:
Step 4 – Convert your Items from Ghost status to Preview status
Once all of your Items have been reviewed and any flagged fields have been fixed, you can select your Items using the Select All checkbox at the top-left of the Ghost Items table:
Now that all of your Items are selected, click on the green Convert button above the top-left of the Ghost Items table, a confirmation window will appear at the centre of your screen, click on the blue Convert Items button to proceed:
The Create Ghost Items menu will now empty out and your Items will be transferred over the Item List for this Auction. Click on Items shortcut at the top-right of the Create Ghost Items menu to open the Item List and access your converted Items:
What next?
Now that your Items have been imported and converted, you can start uploading photos to them, either via the Bulk Upload Images menu, Bulk Edit’s Attachments Uploader or VendorPlus.
For a quick guide on using Bulk Upload Images, click on the guide linked below:
FAQ – Importing Timed Lots and Listings via Spreadsheet
Q: When I click Upload Items it’s giving me a “Number of columns” error, what do I do?
A: The Dashboard will give you the “Number of columns” error if your spreadsheet is:
1. The wrong format – It must be a .csv (CSV UTF-8 Comma Delimited), or
2. The Spreadsheet Template’s columns have been edited or are missing – the Dashboard will search through your spreadsheet and match your Item data to each respective column, do not alter the template and make sure you have used the template to catalogue your Items.
Q: Can I convert my Lots and fix any errors or missing info later?
A: No, all required fields must be filled in or fields fixed before the Convert button will enable for that Lot. Set placeholders and use Bulk Edit later if necessary.
Q: I left out a Lot from my upload spreadsheet, can I just enter it in manually to the Dashboard?
A: Yes, in the Create Ghost Items menu, click on the faint blue line (the bottom row of the table) to create a new Item, like this:
Q: I made a mistake or left out something in the spreadsheet, can I apply a change to multiple Items rather than doing it one-by-one?
A: Possibly, if you need to apply a change to multiple Items and it’s from the Category column onwards, you can use the Group Edit panel. Simply select your Items using the checkboxes at the left-hand edge of the Ghost Items table, then click the grey Group Edit button at the top-right of the Create Ghost Items menu: