Edit Lot Sequencing

This article describes where an auction's current lot sequencing can be viewed, as well as the various methods for editing the lot sequence. For information on re-numbering lots, see Bulk Lot Number Change. To move lots to another auction, see Move/Copy Lots to Another Auction.

This article contains the following sections:


About Lot Sequencing

Sequencing refers to the order in which lots will appear on a bidding platform. Wavebid allows for edits to be made to the sequencing of lots by overriding the numerical order specified by the actual lot numbers. For example, rather than seeing lots 1-5 in numerical order, they can be re-sequenced to appear in a new order: Lot 1, Lot 2, Lot 5, Lot 3, Lot 4.

Prior to re-sequencing lots, it is recommended that an auction house create a Universal export of the auction as a backup of the catalog’s current state. Sequencing changes cannot be undone. To put lots back in their original sequence, the lots would have to be sequenced again.


View Lot Sequence

An auction's current lot sequencing information can be viewed in multiple locations:

  • Auction Preview: The lots will be displayed according to the current sequence. Enable the Sequence Number column to view the current sequence order. For more information, see Auction Preview.
  • Lot Builder: After saving a lot, click the Left Arrow or the Right Arrow in the top right corner of the screen to see the previous or next lot in the sequence. For more information, see Lot Builder.
  • Clerking: When clerking with the Cataloged option selected in Auto Advance, the first un-clerked lot in the sequence will load. Once the entire catalog has been clerked, Wavebid will stop loading lots. 
  • Exporting:
    • When exporting to a bidding platform, the lots will follow the specified lot order as long as the platform supports this feature.
    • The .CSV file stored in the Export page will also contain the lots ordered according to the sequence, overriding the numerical order.

Confirm that lot sequencing is correct prior to exporting an auction to any bidding platform.


Re-sequence Lots

To re-sequence lots, navigate to the applicable auction on the Dashboard and  select Auction > Catalogs > Sequence Lots. There are four options for re-sequencing lots:

  1. Sequencing by Lot Number
  2. Reorder Panel
  3. Sequence Column
  4. Drag and Drop


Sequencing by Lot Number

To set the lot sequence to match the lot number:

  1. Click on the Re-sequence by Lot Number button in the top right corner of the page.
  2. A pop-up window will open. Click the Ok button to confirm.
  3. All lots will be arranged according to their lot number.
    • If any lots are lettered (1A, 1B, 2, 3A), they will be sequenced by the digit first, letter second. The sequence positions will always be numerical values.
  4. Click the Disk icon in the top right corner to save.



Reorder Panel

The Reorder Panel appears on the left side of the page.

  1. Enter the sequence position followed by the lot number.
  2. Repeat until all the desired lots are sequenced.
    • Do not leave gaps in the sequencing or lots may be automatically re-sequenced to fill those gaps.
  3. Click the Reorder button for the changes to take effect.
  4. Click the Disk icon in the top right corner to save. 

Lots that are not moved via the Reorder Panel will remain in their previous sequence. For example, if an auction has 100 lots and the Reorder Panel is just used to re-sequence lots 1-5, lots 6-100 will remain in their previous sequence.



Sequence Column

The Sequence column will reflect the current lot sequencing.

  1. Delete the current sequence number and replace with a new one to re-sequence.
  2. Click the Reorder button in the top right corner of the page for the changes to take effect.
  3. Click the Disk icon in the top right corner to save.



Drag and Drop

Lots can be dragged and dropped into new positions.

  1. Click on the desired lot and then drag it to the new position.
  2. Click the Disk icon in the top right corner to save.



Bulk Lot Re-Sequencing

Preparing a Spreadsheet

Before the lot numbers can be changed, prepare a spreadsheet containing only two columns. The columns should be titled Sequence Number and Lot #. There should be as many rows in the spreadsheet as there are lots currently in the catalog. In the example below, lots 15 through 20 are being re-sequenced to become the first 5 lots in the catalog:


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

The file must be saved as a .CSV (comma-separated values) file type. Once the file is saved, it can be imported into Wavebid.


Importing the .CSV

  1. Navigate to the appropriate auction on the Dashboard and select Catalogs > Import Catalog.
  2. Click the Choose File button and select the .CSV file.
  3. Click the Upload button.
  4. Ensure that the Sequence Number and Lot # headers appear under the Mapped To column.
    • If they do not, drag the Sequence Number and Lot # headers from the Wavebid Headers section on the right side of the page and place them in the Mapped To column. Resequence2.jpg
  5. Click the Import button at the bottom of the page. A success message will appear once the import is complete. Lots will now appear in their new sequence.


Related Articles:

Have more questions? Submit a request


Article is closed for comments.