Top

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.

Quick Tips

  • The Auction Preview defaults to displaying lots in Lot Number order. The Sequence Number column must be enabled in order to view the actual lot sequence.
  • Sequencing changes made via the Sequence Lots page (Auction > Catalogs > Sequence Lots) must be saved to avoid sequencing issues.
  • The 'Manual Sequence' column on the Sequence Lots page should not be used to re-sequence lots. Doing so can cause a variety of issues.
  • To re-sequence lots via .CSV, be sure there are only two columns on the spreadsheet.
  • All of the lots must be listed on the spreadsheet (even if their sequence isn't changing) when re-sequencing via .CSV.

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 Auction Preview defaults to displaying the catalog in Lot Number order. Click on the Columns button in the top right corner of the page and then click on the Sequence Number column header to add the lot sequence to the current view. The Auction Preview can then be sorted by sequence by clicking on the header of the Sequence Number column. 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. Failure to save can resort in sequencing issues.

Resequence_by_Lot.gif

 

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. Failure to save can resort in sequencing issues.

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.

2018-03-20_10-30-26_reorder_panel.gif

 

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. Failure to save can resort in sequencing issues.

2018-03-20_10-36-50_sequence_column.gif

 

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. Failure to save can resort in sequencing issues.

2018-03-20_10-45-30_drag_and_drop.gif

 

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:

Resequence1.jpg

All lots must 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.

 

Troubleshooting


Attempts to Re-Sequence Do Not Work

If attempts to re-sequence lots do not work, but error messages do not appear, confirm that there are no values in the Manual Sequence column/fields on the Sequence Lots page. If there are any values in the Manual Sequence column/fields, they must be manually removed from each lot before lots can be successfully re-sequenced.

Sequence is Correct in Wavebid but Incorrect in Marketplace

If the lot sequence in Wavebid appears to be correct, but is incorrect on one of the integrated Online Bidding Platforms, first use the Auction Preview page to confirm the sequence in Wavebid is actually correct and then re-export the catalog.

  1. Navigate to the applicable auction from the Dashboard, then select Auction > Preview Auction.
  2. Click on the Columns button in the top right corner of the page.
  3. Click on the Sequence Number option to add the 'Sequence Number' column to the Auction Preview.
  4. Scroll through the Auction Preview to confirm the sequence is correct.
    • If the sequence is not correct, follow the steps above to re-sequence the lots.
  5. Once a sequence has been edited, the entire catalog needs to be re-exported in order for the new sequence to correctly appear on the Online Bidding Platform
    • If only part of the catalog has been exported since the lots were re-sequenced, it is likely that the lots will still appear out of order on the marketplace.

 

 

 

Related Articles:

Have more questions? Submit a Request

0 Comments

Article is closed for comments.