Import Catalog via Spreadsheet

In order to import your catalog into Wavebid, it must be saved either as a Comma Separated Value (CSV) file or as a Tab Separated Value (TSV) file. Our platform can work with either one as long as the proper options are configured. We recommend sticking with the most common .CSV method. 

You may notice that your spreadsheet columns have different names in the header than what we use in Wavebid (using "Lot" vs. "Lot #").

This is okay! However, it should be noted that if you use the same title as you find in the list of available Wavebid Headers, that you won't have to go through the hassle of manually mapping each corresponding field. 

Step 1 - Format your CSV (Spreadsheet)

Take special note of the way the spreadsheet below was built and yours should closely resemble what you see here. 

1spreadsheet.PNG

Step 2 - Upload File

From the Dashboard, go to your auction workspace, then to Catalogs > Import Catalog. You will arrive at the Lot Import page.

2CatalogImportPage.PNG

You will have a few options available to you:

  • Has header row?: This lets Wavebid know whether the first row of the file is the one naming the columns. The default is checked.
  • Delimiter: Most files will use COMMA, but if the software created the file using TAB or PIPE you can set it here. The default is comma

Click Browse to open a file browser window. Navigate to the folder in your computer containing the CSV file and open it. The file location box will update, allowing you to click Upload.

3catalogImportPage.PNG

Step 3 - Map The Columns

Each of these mappings alter what information will be pulled into Wavebid and are useful when pulling catalog data from those specific services. In the event your data does not match any of these Wavebid can still import your data by setting up a custom mapping; if the spreadsheets are always using the same columns you can save your mapping to save you the work of either renaming your column headers or manually mapping it repeatedly. 

Click Save your mapping, then enter a Mapping Name to start the process if you opted to have your own custom mapping. 

4ImportPageTop.PNG

If you didn't name your headers the exact same way Wavebid named theirs, then you'll have to map the columns accordingly. Example: Your column is named Lot Number, but in Wavebid it is called Lot #. The header in Wavebid called "Lot #" will have to be drag-and-dropped next to the field for your "Lot Number" column header.

5MappingColumns.PNG

6mappingColumns.PNG

Step 4 - Import the information

Once you’re done mapping your columns scroll down to the bottom of the page and click on Import. There are a few things to keep in mind

The imported data will overwrite the contents of whatever existed in the database at that point unless you check the "Do Not Overwrite Existing Lots" checkbox. If you’re not one hundred percent sure you want this to happen you can use your Training Sale workspace to import your catalog and determine if the results are what you expect.

Once you click the Import button nothing can stop the import process.

Once the import is finished Wavebid will let you know if there were any issues. If there was a problem the data will not be written to the database.

7SubmitImport.PNG

8ImportSubmitted.PNG

9NoErrors.PNG

Congratulations! You've successfully imported your spreadsheet. 

 

 

 

Setting up a Mapping

On the left column you can see a list of Your Headers; this are the column headers contained in your CSV file, with every column being displayed here. Each column is Mapped to a column within the Wavebid database. In the event a header is not automatically mapped, you can select a header from the list of Wavebid Headers from the tray to the right.

There are two additional options to keep in mind:

Append to previous:

Include header: This will include the header as part of the data imported into the database.

Each of these mappings alter what information will be pulled into Wavebid and are useful when pulling catalog data from those specific services. In the event your data does not match any of these Wavebid can still import your data by setting up a custom mapping; if the spreadsheets are always using the same columns you can save your mapping to save you the work of setting it up time after time.

Click Save your mapping, then enter a Mapping Name to start the process.

Resources

To view a sample CSV file, you can use the Wavebid Sample Data Set, available in Help > Resources. The CSV file contains the following data:

  • 5 columns: Category, Description, Lot, Reserve, Seller.
  • The first row contains the column headers. All the other rows contain lot data
  • Four Sellers: Jerry, Sue, Ricky, Betty
  • 15 Lots: Each lot will have the values entered within each column.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.