Report to tell how many times something has relisted?

[quarno]

Is there a report or way to tell how many times at item has relisted? We list all of our items as GTC and we are wondering if there is a way for us to tell how many times we have relisted something so we know when it is time to either decrease the price or end the listing. We are listing many items every day and want to make sure we aren't paying to keep relisting something that we've had for a while.

Any and all help would be appreciated.

Thanks!

Billy

[berserkerplanet]

Not that I'm aware of.

You could maybe kludge something up using the itemids.txt reports you can get from clicking on the used listings count in the Seller Hub Promotions panel.

General idea is that you'd go there once a month, click on the use listings number which takes you to a page showing the listings used out of the allotment (on a 50 free, store allotment, promo, etc), generate a report, use a batch file or script to append the month/year or date to each entry in the report, import that into an Excel file (along with precious reports, and then you's have a sortable report with dates and items numbers for each time a particular item number was relisted.

Here's a quick batch routine that can be used to do the date appending. Save the following code as IIRdate.bat (or whatever name), then drag and drop downloaded report files on the batch file or a shortcut to the file, enter a datestamp string when prompted, and it will create anew CSV file with the datestamp appended to each item number line to then be imported into Excel for sorting and viewing.

@echo off

if exist %1 goto doit

echo.
echo.
echo Drag and drop an eBay itemids.txt listing insertion report on this batch, enter a
echo datestamp string which will be appended to the filename and appended to each line
echo in a new CSV file for subsequent import into Excel or other spreadsheet program.
echo.
pause
exit

:doit
set ds=
set /P ds="Enter a datestamp (like 063019 to be appended or hit enter to exit : "
if .%ds%==. exit

for /F "delims= tokens=1" %%a in (%1) do echo %%a,%ds%>>%~d1%~p1%~n1_%ds%.csv

[lacemaker3]

@quarno, 

You can sort your items by date listed, and then the oldest ones will be at the end of the list. That should tell you what you need to know. 

When I do this on your listings, with the limited view that I get as a potential buyer, I can see that your newest items were listed yesterday, and the oldest items that are still active were listed on Apr 10 of this year. 

If you suspect that you may have listings that are more than a year old, then watch the months as you scroll down the page. They stay in sequence by the data listed, so if the months are out of sequence it's because they were listed earlier.

FYI, starting July 1, 2019, the GTC items are going to change so that they relist once a month instead of every 30 days. That way, you won't have to worry about being charged extra because some of them might relist twice in one month. So you can just go by the total number of active listings, and know that any listings that don't sell will relist and use up your free-insertion-fee listings.

I don't have seller hub, but if you go to the page that shows the date listed, then you can try clicking on the column heading to sort by that column. If that changes the sort, then you can keep clicking it to change between newest first and oldest first. This a standard GUI and that's how it worked on the Sell Your Item page, so there's a good chance that this will work in Seller  Hub too.

[quarno]

I was hoping to have a way to just print a list of what has been listed for how long or over a certain amount of time. We plan on listing as much of our inventory as possible, but want to cull items that have been listed for a long time. 

[shipscript · Accepted solution]

@quarno 

Here is a screenshot of Seller Hub where I've turned on the StartDate and EndDate columns using "Customize" at the top. Clicking the StartDate column sorts the order. There is then a "Print" option, but you'll want to adjust column widths or turn off unused columns for a better fit across one page. Whenever I see a "print" option on a page, that usually means I could alternatively use my browser's "Print Preview" to see the same thing and make print size adjustments instead of blindly sending it to the printer.