To get a list of item numbers from TurboLister.

a) TurboLister

1. Open the ended list in TurboLister.
2. Sort by the first column to find all flagged items for repair,
   or sort by item number in reverse order (newest first, largest item number first).
3. Then highlight all the items to relist (items must not be more than 90 days ended).
4. From the TL menu, choose "File > Export Selected" to open a new screen.
   
   • Select FileExchange CSV format.
   • At the bottom of the dialog, click "Show Options" and select the elements to export.
     The default is "all", but we only need enough fields to filter out the duplicates, so uncheckmark "all" and select a few that you think you may need, in addition to the required ItemId, like:
     Category, StartPrice, ItemID, and StartTime and EndTime near the bottom of the list.
5. Export the list.

b) Excel

1. Open the CSV file in Excel.
2. Locate the column labeled ItemID.
   • Highlight the entire vertical column, right-click-FormatCells, and select "number" and set the decimal places to zero.
   • You should see the numbers revert from exponential to normal numbers.
3. Now it's time to remove obvious duplicates:
   • Highlight the entire database list, and from the menu, select Data > Sort to open a dialog.
     
     • Mark the "Header row" option so that header names are available in the drop lists.
     • The first sort parameter will be "Title" (ascending) and the second will be "ItemId" (descending) so that all the titles will be grouped together with the most recent items leading the duplicates. You won't need more than the first two options.
   • After sorting, scan down the rows and, assuming the first of duplicates is the newest, remove any subsequent items that are obvious repeats:
   • To remove, highlight the row, right-click-delete or right-click-hide.
4. Copy the ItemId column from the reduced list and save it for the scan process.

c) Copy the list

Copy and Paste the list of ended items into the box at the top of this page. Each number must be separated by a space or punctuation or must be on a separate line. The tool will look for numbers in the list that have at least 12 digits and will assume each one is an item number. It will ignore anything that is not a 12-digit number.

d) Scan the List

Choose the eBay site where your items are listed and click the SCAN button to start processing the item numbers. The tool will build a color coded list of items and provide a link to create enlarged photos. Each line item will also include a button allowing you to open your ended listing to revise the photos and relist. You must manually replace the new photos within eBay's listing form.

You must be logged into your eBay account prior to using the "relist" button on the tool.

To get a list of item numbers from eBay's Pages.

Use the site search to return a 2-week list of items, or log into your My eBay page and use the ended item list to return up to 60 days of items.

a) Search Ended Listings on Site

Search for your ended listings on the eBay site to bring up a 2-week list and display the items in list view.
SELLER NAME GO

If the item number does not display next to each listing, then customize the settings to display the item number.

b) or Search Unsold Listings on My eBay

While you are logged into the site, go to your unsold items list within My eBay and change your settings to display the item number. Set the retrieval period to any number of days up to 60 days maximum.

c) Copy the displayed page contents

When the item numbers appear in the page, drag your cursor down the list to highlight all of your ended items on the page. Copy and paste the highlighted text into the box at the top of this tool. In most cases, the tool should be able to extract your item numbers from the block of page text.

d) Scan the List

Choose the eBay site where your items are listed and click the SCAN button to start processing the item numbers. The tool will build a color coded list of items and provide a link to create enlarged photos. Each line item will also include a button allowing you to open your ended listing to revise the photos and relist. You must manually replace the new photos within eBay's listing form.

You must be logged into your eBay account prior to using the "relist" button on the tool.