Top

Bulk Lot Number Change

This article describes the process for completely changing the numbering of lots within an auction by creating and uploading a CSV (Comma-separated values) file. For smaller re-sequencing needs, see Edit Lot Sequencing. For information on moving lots to another auction, see Move Lots to Another Auction. For information on changing lot details in bulk, see Lot Bulk Actions.

Preparing a CSV File

Change Lot Numbers

Common Errors

Example CSV File

 

Preparing a CSV File                                                                                 

Before the lot numbers can be changed, use spreadsheet software (ex. Excel) to prepare a comma-separated value (CSV) file. The file should only contain two columns, titled originalLotNumber and newLotNumber. There should be as many rows in the spreadsheet as there are lots currently in the catalog. In the example below, lots 1 through 5 are being re-numbered to become lots 101 through 105:

mceclip0.png

 

It is important that all lots be entered into the CSV file, otherwise the re-numbering might lead to unexpected results. Before proceeding, create a Universal export of the auction as a backup of the catalog’s current state.

Once the file is prepared, it must be saved as a CSV (comma-separated values) file type. Download a sample file here.

 

Change Lot Numbers                                                                               

  1. Navigate to the appropriate auction on the Dashboard and select Catalogs > Sequence Lots.
  2. Click on the Bulk Lot Number Change button in the top right corner of the page.
  3. A pop-up window will open. Click the Choose File button to upload the CSV file.
  4. Type CONFIRM in all uppercase letters to have Wavebid proceed with the change. 
    • Confirm that no one else is working within the auction to prevent any issues, as Wavebid will lock the auction down while the change is taking place.
  5. Click Yes, I’m Sure.                                                                                                                                                             BulkLotSequenceConfirmWindow.JPG

The contents of the file will then be written into the Wavebid database. The page will refresh and should reflect the new sequencing.

 

Common Errors                                                                                      

Error: Can not find lot number [###] referred to on line 1 of import file.
  • Cause: A lot number is specified in the originalLotNumber column that does not currently exist within the catalog. As the lot doesn’t exist, Wavebid is unable to re-number it.
  • Solution: Only specify lot numbers that exist in the catalog. Either remove the row from the CSV file, or create them in Lot Builder.
Destination lot number ### referred to on line ### already exists please correct your import file and try again.
  • Cause: The target lot number in the newLotNumber column already exists elsewhere in the catalog.
  • Solution: Remove the row from the CSV or manually re-number the lot using the Lot Builder.
 
 

Example CSV File                                                                                     

Download a sample file here.

 

Related Articles:

Have more questions? Submit a request

0 Comments

Article is closed for comments.