I've recently installed Move my Inventory.  I created two listings.  The listing number for the first is 1 and 4 for the second.  I'm trying to figure this out?  Is there anyway to access the data directly from the db and delete whatever listings 2 and 3 are?  Also...Is there anyway to renumber the existing listings.  For example..make listing number 2...number 1 and make list number 1....number 2.

 Hi Steve,

The listing numbers are actually the Xmod recorIds from the Xmod database tables.

They are designed that way so you can easily cross reference the listing with the associated image folder that has the same listing ID.

This is useful in the case where you delete a listing, you can then go to the DNN File Manager >> Portal Root >> xmod >> packages/ MoveMyInventory >> images folders and easily delete all image files associated with that listing.

All SQL database tables have what is called a primary key. This is typically an automated numbering system that the database uses to ensure that all records are unique.

The same holds true for the Xmod RecordId.

With listings always being added or deleted, it is very difficault to ensure that all your listing numbers will always be in sequence.

If SQL has used a number as the primary key it will not be reused again.

If you are missing two listings in sequence, is it possible that you had tested and deleted these listings?