Exporting Auctions can be used to download the catalog file and photos so they can be manually uploaded to a service for which Wavebid does not provide API integration. It is also useful for downloading a catalog and photos without having to export them to a bidding platform (Universal export). This article describes the settings that must be in place to export in this manner, the various export options available, the resulting export file types, and common export issues. For information on monitoring large exports, see Export Monitor.
Auctions must be set to "Universal" prior to exporting in this manner:
- Navigate to the appropriate auction from the Dashboard, then select Auction > Edit Settings.
- In the Auction Attributes tab, select Universal from the Auction Software drop-down menu.
- Click the Disk icon in the top right corner of the page to save.
Creating Export Files
- Navigate to the appropriate auction from the Dashboard, then select Auction > Export Auction.
- Use the menu on the left side of the page to configure the export files:
- Lot Options:
- All Lots: This will export all of the lots currently in the auction. (This is the default.)
- Categories: Only the selected categories will be exported. To select multiple categories, hold down the Control (Ctrl) key on the keyboard while clicking on the categories.
- Lot Ranks: Only the specified ranks will be exported. (To enable this function, navigate to the auction on the Dashboard and select Auction > Edit Settings. Click on the Adv. Attribute Settings and check the Show Lot Rank? box. Click the Disk icon in the top right corner to save.) To select multiple ranks, hold down the Control (Ctrl) key on the keyboard while clicking on the ranks.
- Lot Range: Specify which lots to export. For example:
1, 2, 3would export lots 1, 2, and 3.
1-10would export lots 1 through 10.
- Catalog Options:
- Generate Catalog: Whether to create a comma-separated values (.CSV) file containing the lot attributes and descriptions. (This is the default.) If this option is disabled, Wavebid will save the file in text (.txt) file format.
- Data Mapping: Select what column order to use when exporting the CSV file. (Proxibid is the default.) This field is irrelevant when performing a Universal Export.
- Save as .CSV: Select which file extension to use. If this option is disabled, Wavebid will save the file in text (.txt) file format. If the option is enabled, Wavebid will save the file in a comma-separated values file format (this is the default).
- Remove HTML: Wavebid will always include any HTML code entered in the lot Description or Additional Description fields. Enabling this option will strip out all of that code, leaving only plain text with HTML entities being rendered as their characters. (The default is for this option to be disabled.)
- Photo Options:
- Zip Photos: Will create a ZIP file containing all of the photos from the auction, except for photos labeled as barcodes. (This is the default.)
- Add Watermark: Will enable watermark text for the photos. (The default is for this option to be disabled.) For more information on watermarks, see Watermarking Photos.
- New Photos Only: Will only include photos that have been uploaded or manipulated since the last export. If no exports have been created for the auction, Wavebid will include all of the photos. (The default is for this option to be disabled.)
- Thumbnails: Will create thumbnail versions of the photos using the pixel dimensions selected in the drop-down menu. (The default is for this option is None.)
- Marketing Options: Since a universal export will not be sent to marketing partners, these options can be disregarded.
- Lot Options:
- Once configuration is complete, review the current summary and click the Export Auction button.
- A confirmation window will appear. Click the Ok button. Wavebid servers will begin the export process.
For large catalogs, visit the Export Monitor to view the export's progress.
When the export is complete, download the files.
Newly created files will appear on the right side of the Export Auction page:
- Previous Catalogs: Results in a CSV (comma-separated values) file in plain text that can opened with spreadsheet software. Download the file by clicking on the timestamp link.
- Previous Photos: Results in a ZIP file containing all of the photos for the auction's lots except for photos labeled as barcodes. Download the photo ZIP file by clicking on the timestamp link.
Files are named according to the date and time the export server was finished creating the file. There is no limit to the number of export files that can be created.
To delete an export, click the Trashcan icon to the right of the timestamp link.
For Wavebid company accounts that are linked to a bidding platform, Wavebid will always store the resulting export files even though the lots themselves were transferred via API. This provides users with a backup and an alternate means of obtaining a catalog and photos.
Photos can be missing from exports for a variety of reasons. After you export your auction; you can find a .zip file that contains all of your photos on the export page. This file will allow you to upload missing photos.
- From My Dashboard, navigate to your auction > Auction > Export Auction.
- Go to the section that says previous photos and download the top file:
- From there you can extract the .zip files and upload the ones that are missing.
What are these strange symbols after exporting my catalog?
The Lot's commas, double quotation marks or other symbols have not been read correctly from one system to another and now showing odd results.
The catalog process can introduce some interesting and unexpected results such as strange symbols showing up in your bidding platforms or other systems. This is caused by differences in the ways technology communicates regarding special characters. Special characters are not always written the same and change "behind the scenes" by technology providers. This will cause us to see odd symbols.
Special characters are any symbols that is not a number or letter. Common special characters that can cause us to see unexpected or strange symbols are the comma and double quotation marks.
After we exported to CSV or reviewed exports to bidding platforms, we may see these strange symbols instead of our expected double quotation mark, comma or others.
Once the characters are in our catalog, we have two ways to fix them.
- Export your catalog into a csv and use the find and replace function in Excel to correct.
- Using Lot Preview; delete the impacted area and re-type.
We can avoid these in the future by reviewing our settings on our computers to not use smart punctuation functions. Please refer to your device manuals to see if you have this function.