topic Re: report on variations sold in Selling

report on variations sold

ninx-now — Sun, 03 Aug 2014 10:55:23 GMT

Hi, I am trying to find a way where I can get a report or a list of which of the variations on listings have sold out (what sizes). I have hundreds of listings with variations and it is very time consuming to go into each variation to see what sizes have sold out, Does anyone know what report I can run to get this information daily?

Similar to "sold" listings but these only have the listings that are finished, does not show variations are finished.

Please help!!

Re: report on variations sold

bigbrickshop — Sun, 03 Aug 2014 11:16:11 GMT

Have you tried an Advanced Search of your Active Listings in SMP? You can search by Quantity, it should find variations with a zero quantity.

Re: report on variations sold

ninx-now — Sun, 03 Aug 2014 14:24:27 GMT

Hi, I have tried searching quantity is equal to 0 and I also tried quantity is less than 1 but I get no results. Any idea what criteria to search for?

Re: report on variations sold

bigbrickshop — Sun, 03 Aug 2014 23:05:28 GMT

Sorry, we don't have any variant listings at the moment. I'll have a look through the other options.

Re: report on variations sold

digital*ghost — Sun, 03 Aug 2014 23:58:01 GMT

Selling Manager has an inventory feature, which I don't use so can't advise how it works, but the quickest and easiest way to find listings with 0 quantity variations is to load them into the bulk editing tool, as that highlights variations with 0 with an orange flag - eg:

You won't be able to edit the quantity there, but you'll at least have an immediate list of items with 0 quantity - you should be able to tick the ones with a flag (select all of them by ticking the box next to the warning at the top) and export to a file so that you don't have to write them all down or what have you.

Re: report on variations sold

bigbrickshop — Mon, 04 Aug 2014 00:31:20 GMT

Have you tried a download of Active Listings through the File Management Centre?

Re: report on variations sold

ninx-now — Mon, 04 Aug 2014 09:19:38 GMT

Hi, Thanks this gives me a listing of all items with a 0 quantity, but unfurtunately it doesn't tell me which variatios have a quantity of Zero, so I would still need to go in item by item to work it out.

So it is a good listing but not very useful.

I am now waiting for File management centre report to see what that shows.

Even Turbo lister can't provide this unless I go into each item one at a time to check. With over 500 listings this is very time consuming.

Re: report on variations sold

ninx-now — Mon, 04 Aug 2014 09:23:55 GMT

Active listing from File Management Centre doesn't give any information on variations at all.

Any oher ideas?

Re: report on variations sold

digital*ghost — Mon, 04 Aug 2014 09:26:57 GMT

Sorry, I meant to come back to this thread earlier. I created a download for all of my active listings, but in order for that to have worked the way you need it to, it would have to provide fields for individual variation quantity so that you could find all with 0, or sort each item (rather than each listing) by quantity, but eBay (at best) only provides a global quantity for summary purposes.. (That's near as I can tell, anyway, I don't know if it's me or the system, but when I load my reports into the spreadsheet, I can't make head nor tail of the information, it's all over the place with lots of fields with errors).

Sounds like the best option would be the inventory tool, but I had a look at that too and I couldn't see a way to use it with current listings, only to create new ones. Hopefull someone who uses it can provide more info on that.

Re: report on variations sold

bigbrickshop — Mon, 04 Aug 2014 10:08:27 GMT

I've just googled to see if I could find anything. There's a question and answer on the US boards that may help.

http://community.ebay.com/t5/Archive-File-Exchange/Downloading-Variations-for-Listings/td-p/3026829

The 'Revise Price and Quantity' option looks like it is only available when you go to File Exchange on ebay.com

Re: report on variations sold

bigbrickshop — Mon, 04 Aug 2014 10:09:24 GMT

http://k2b-bulk.ebay.com/ws/eBayISAPI.dll?SMDownloadRequest&ssPageName=STRK:ME:LNLK

Re: report on variations sold

ninx-now — Mon, 04 Aug 2014 11:34:05 GMT

It says "You are currently not subscribed to Selling Manager, Selling Manager Pro or File Exchange." on ebay.com and some of the criteria is not available on ebay.com.au .

Back to square one!!!

Re: report on variations sold

bigbrickshop — Mon, 04 Aug 2014 11:36:44 GMT

You can subscribe to File Exchange on ebay.com. Login to ebay.com and under the account tab click on Subscriptions. There's no fee involved.

Re: report on variations sold

digital*ghost — Mon, 04 Aug 2014 11:49:51 GMT

This is eBay's advanced file exchange instruction booklet (PDF) - it has nearly 120 pages, none of which I have read, but it might help you find a solution. Maybe.

http://pages.ebay.com.au/file_exchange/SMP_FMC_User_Guide.pdf

Re: report on variations sold

ninx-now — Mon, 04 Aug 2014 13:11:42 GMT

Thank you so much, that worked but only in the ebay.com website. This is very helpful.

Re: report on variations sold

bigbrickshop — Mon, 04 Aug 2014 13:32:25 GMT

It worked? Great! Hopefully the extra download options are added on the AU site soon.