Top

Bulk Lot Number Change

This article describes the process for renumbering the lots within a catalog by creating and uploading a .CSV (Comma-separated values) file. For information on re-sequencing lots, 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

Troubleshooting

 

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: Original Lot Number and New Lot Number. 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.

Important: Wavebid will generate an error if the same lot number is on the spreadsheet twice. If any of the New Lot Numbers are the same as any of the Original Lot Numbers, then all of the lot numbers should be changed to a third series of unused lot numbers first, before changing them to the actual New Lot Numbers. See the Troubleshooting section below for more information.

 

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.

After the lot number is changed, the lot will have an Inventory Number field visible in Lot builder. This field will contain the last lot number assigned to the lot, unless inventory numbers were imported with a catalog. If inventory numbers were imported with a catalog, those inventory numbers will remain in the Inventory Number field regardless of whether the lot is moved. InventoryNumberField.JPG

If the current lot number and inventory number are the same, the Inventory Number field will not be visible.

 

Troubleshooting                                                                                       

Error: Can not find lot number [###] referred to on line 1 of import file.
  • Cause: A lot number is specified in the Original Lot Number 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 New Lot Number column already exists elsewhere in the catalog.
  • Solution: If any of the New Lot Numbers are the same as any of the Original Lot Numbers, then all of the lot numbers should be changed to a third series of unused lot numbers first, before changing them to the actual New Lot Numbers.                                                                                                                                                                                                                                                                  This means that, to correct this issue, two Bulk Lot Number Changes will need to be completed- one changing the lots to a series of unused lot numbers, and a second changing the lots to the desired new lot numbers.                                                                                                                                                                                                                                                                                                  For example, lots 1-50 need to be renumbered, but lots 51-100 need to stay the same. Since the lot numbers cannot be the same in both the Original Lot Number and New Lot Number columns, lots 51-100 cannot appear as 51-100 in both columns. To resolve this issue, the spreadsheet will need to have lots 1-100 in the Original Lot Number column with unused lot numbers such as 5001-5100 in the New Lot Number column. Once those lot numbers have been changed, a second spreadsheet can be created with lots 5001-5100 in the Original Lot Number column and the correct lot numbers in the New Lot Number column.

BulkLotNumberChange1.jpg

 

Related Articles:

Have more questions? Submit a request

0 Comments

Article is closed for comments.