FAH/Vudu 4K UHD Compare
This useful tool from Brent S and Will G will help you compare what 4K UHD you own on FAH/Vudu to the entire FAH/Vudu 4K UHD Catalog that is for purchase/rent.
Note that this will not include hidden titles that are no longer for sale.
You first need to install the Vudu Catalog tool in Chrome/Edge
For this comparison you will need to turn purchase dates off on the Vudu Catalog Extension. Go to chrome://extensions/?options=bnlpiockcfehbfbdcegahemgmjfkdopc and unclick include purchase dates
Next go to https://www.vudu.com/content/movies/mymovies while signed in and run the extension (click it). If you have a large library and this is your first time running it, it may take awhile.
Save the CSV file somewhere you can find it on your computer
Next click on this link https://docs.google.com/spreadsheets/d/1jo90ZEg-HBRgkm-FKVfoVHN_pKDFOqJhQfnJddjcBZ4/copy it will open up a copy of the compare file. This is yours to edit
Go to the second sheet in this file titled Vudu Catalog Movies - Import in Cell C1
Make sure your cursor is in cell C1
Go to File
Click on Import
Upload
Find your most recent file from the vudu catalog of your movies
Change the import location to "Replace data at selected cell"
Unclick "Convert text to numbers, dates and formulas"
Click Import Data
Wait for it to load (this may take a few minutes, it may take longer depending on your library size)
There are two tabs on the sheet 4K UHD Movies - Unowned which will show the movies you do not own in 4K and 4K UHD Movies which will show all.
Wishlist Option (Optional, you don't have to do this to make it work unless you want to)
If you'd like to see what is MA on your wishlist, run the Vudu Catalog on https://www.vudu.com/content/movies/mywishlist Then go to the Wishlist tab on the sheet, go to Cell A1 and import using the same settings as before. If you have the movie on your wishlist, it will appear under Owned. You can filter and sort that way. Note when you replace your wishlist you probably want to go to that tab, hit Ctrl+A (For a PC), delete and then reimport.
FAQ on Personalized Sheets
Do I have to run a new report every day?
No, it will automatically update. You only have to set it up once and then just open when you want to look at it.
When is it updated?
Daily
Does it automatically update with the movies I buy?
No, if you want it to take away the movies you have bought you will need to run a report and import the updated CSV as before. After you run it the first time, the rest run much faster. Or you can just manually add the FAH/Vudu ID and quality of the movie you bought into the FAH/Vudu movies, etc tab. Or you can just leave it as is and skip over the ones you know you purchased.
It’s not showing I own a movie even though it’s in the movies owned tab
You probably don’t have it in there as text. Make sure you are pasting as a value and not formula if you are copying and pasting.
I messed it all up, help me!
Just start over and make a new one, it takes about 5 min and is probably easier than figuring out what you did.
It shows I need to upgrade even though I own the highest quality in MA
If FAH/Vudu has a movie in a lower quality and another provider has it in a higher quality that movie will continue to show up because the data is from your FAH/Vudu collection. You can manually change the quality on your owned tab if it bugs you.
I want it to sort in a different order
Sorry, it pulls from another sheet so you can’t. You can copy and paste into a totally different sheet if you really want to do something else with it but it won’t update in that one.
Can I utilize it on a mobile device?
Yes, once it’s created you can open it on any device. To set it up the first time and run a csv on an android device follow the directions here: https://www.makeuseof.com/chrome-extensions-android-mobile/ and then send me a chat to help set up your sheet.