VPP Store Purchase History Nightmare is Now Manageable!

Your rating: None (3 votes)

I have been struggling with the VPP store (education), specifically, the purchase history section for a while now. It was always a nightmare when I needed to go back into my purchase history and find a specific App and re-dwonload the CSV(Drunk for that app.

It can be a huge pain because the site will only show the 20 most recent purchases until you click “show more”. Then you get another 20… and so on… and so on… and you get the pain. It would take me 5 min. just to get all my history to show. Then I would need to use a find command to find all the instances of a particular apps purchase. Again, a pain…  

I decided that I MUST find a better way!  I went to the Purchase History page, clicked show more until all my history was showing. Selected all the info, copied and pasted it into a Numbers spreadsheet. To my delight all the info coped over perfectly: Order date; Order; Name (with links to app page); Type; Order total; Licenses; Codes (WITH DOWNLOAD LINK).

Now I have a spreadsheet that I can do all the fun things you can with a spreadsheet. Most importantly is has all the live links!  As long as I am logged into the correct account on the apps store all the App and download links work perfectly. 

From here I will simply add to this spreadsheet as I make purchases and never need to use the stupid purchase history on the Apple site again!  Not sure why I didn’t think of this sooner!!!  Dense I guess! 

Loving life a little more now…

Share your ideas

carriesn's picture

carriesn

Joined: Mar 20, 2013

wow

Your rating: None

very cool! thanks for sharing! I was feeling annoyed myself just yesterday and now this post. Thanks again-

--carrie

Top
bjthaman's picture

bjthaman

Joined: Mar 20, 2013

Tip - Skip the Show More

Your rating: None

Thanks for this info. when loading your Purchase History, you can save a lot of time (and clicking) by putting a large number after the batch= portion of the URL.

Top
Mitch Boston's picture

Mitch Boston

Joined: Jun 8, 2012
WWW

Great tip!

Your rating: None

Great tip!

Top
mscheid13's picture

mscheid13

Joined: Jan 23, 2013
WWW

Nice!

Your rating: None

I like the Batch Tip!! I think I will still use the spreadsheet so I can sort and use all the functions I get in the Spreadsheet. Smile

Top
carriesn's picture

carriesn

Joined: Mar 20, 2013

Numbers

Your rating: None

Hi- maybe this is a dumb question but when I copy and paste the info, it shows up in the Numbers spreadsheet as one column. ? Something I'm missing? Thanks!

--carrie

Top
mscheid13's picture

mscheid13

Joined: Jan 23, 2013
WWW

Not Sure

Your rating: None

I used safari on a mac for the copy from the VPP store... I didn't do anything special, just click and drag to highlight what I wanted. In Numbers I only had the top right cell selected then command V to paste the info. It put the data into columns and all was happy. Hope there is something there that is different from what you tried and you can get it to work!

Top
carriesn's picture

carriesn

Joined: Mar 20, 2013

Ha! That's it!

Your rating: None

I was working on this earlier this morning and was still struggling. Then I went back and reread your comment- I realized you said you used Safari. Im using Chrome so I went into Safari and opened up the VPP history-- copied and pasted it into Excel... same problem. Then decided to open Numbers. And presto! You're right... it copies over just fine!

So... SAFARI and NUMBERS are a requirement in order to get this to work. Really, Apple? Just offer an option to download all the info into one spreadsheet! Smile But thanks mscheid!

--carrie

Top

Recent Activity