Is there anyway to do an inventory list?

[musicyouneed]

Well, I just have another CD that I have listed and can't find.   So it is time to do an inventory list.  I have over 1500 listed, is there any way of doing an alphabetical list that doesn't take 40 pages?

[momcqueen]

Bulk editor, export as cvs I think will do what you seek. 

[thestuffofchris]

Do you mean something specifically on eBay, or just a general way to create a list?

I've always used Excel for making lists. I currently have a large spreadsheet listing and organizing all my physical media (though only for personal reasons, not for selling purposes), and I find it's quite manageable with a similar number of items.

Obviously with 1500 items it's going to take up a lot of "space" no matter what, but if you're comfortable with using spreadsheets, Excel is very versatile. You can add a lot of data and sort it virtually any way you want.

[momcqueen]

1. Export to File

2. Chose csv or pdf

Export to File in Bulk EditorChoose between PDF or CSV

[momcqueen]

So far as I can tell Export to File is only good for inventory, it gives you the title and some minor details like condition and price but saves no images or item descriptions or shipping settings or anything else that might be otherwise useful. 

Once you've 'exported' your file, you can view it as either a PDF or cvs, the latter of which is manipulatable in Numbers (Mac-based) or, I assume, Excel (Windows-based). 

[reallynicestamps]

You can put your active listings (or your unsolds) into alphabetical order  by clicking on Title on the appropriate page.

And you can have up to  200 items per page.

Do you want to print it out?

[musicyouneed]

I've put them in alphabetical order and printed out the first 100, it was 5 pages.  I have 1,515 listed, I am going to do it in phases.  

I tried to export to a CSV file and I couldn't figure it out past what MJ had shown.   It never downloaded.   I also list on .com and .ca so it got really confusing.

[imbuzzy · Accepted solution]

Try subscribing to File Exchange - it's free.

With that you can download all your active listings as one csv spreadsheet file - with no limit on number of listings.  A lot of information is provided including site id - useful when posting on multiple sites.

Minimum knowledge of spreadsheet programs is needed.

If you get over the file exchange learning curve hump,  you would also be able to list up to 5000 items per day by uploading just one csv file.  That's a  powerful feature especially when listing nearly identical items with minimal changes (eg: you with cd's and me with postcards). Trust me on that, working with one spreadsheet file for new listings is much easier and efficient than entering hundreds, if not thousands of SYI forms.

But then I digress...

[momcqueen]

I hate to beat a dead horse but a CSV file is immediately available with Bulk Editor using the steps I have described, I've done it a handful of time. It's exactly an inventory list, nothing more. 

[imbuzzy]

Seller has 1500 listings, some on ebay.com and some on ebay.ca, and wants a list generated:

BULK EDITOR

Maximum of 500 items per csv file resulting in a minimum of at least 3 csv files needed to be generated.

Each site requires its own csv file(s) download request.

All downloaded csv files need to be parsed together to make 1 functional csv file.

FILE EXCHANGE

1 csv file for all 1500 items requested for download.

Both ways work - I was offering a second option...

[momcqueen]

You are correct, and that is a very good point. Using File Exchange would no doubt be a more efficient and straightforward way of accessing all 1500 listings; I'd forgotten about the 500-item limit to Bulk Editor. 

[musicyouneed]

That worked perfectly and exactly what I wanted.  Thanks so much for providing that info.

[musicyouneed]

It's that time to do another inventory list.  I did it using file exchange but forget how to get to it.  Anyone point me in the right direction?

[musicyouneed]

Never mind, I found it.  Was hiding.

[lotzofuniquegoodies]

Is the possibility to create a csv file in Sellers Hub still an option? I am not seeing it.

-CM

[musicyouneed · Accepted solution]

File exchange is here: