FAH/Vudu Tracking and Comparison

These very useful tools from Will G and Brent S will track what you own at FAH/Vudu and compare your library to show what you are missing, what has been upgraded, what is new, etc. 

You first need to install the Fandango At Home Catalog tool in Chrome/Edge (Android option: https://www.makeuseof.com/chrome-extensions-android-mobile/ )

For this comparison you will need to turn purchase dates off on the Vudu Catalog Extension. Go to chrome://extensions/?id=bnlpiockcfehbfbdcegahemgmjfkdopc  and unclick include purchase dates

Next go to hhttps://athome.fandango.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. Make sure you save with the date. You will run this monthly or whenever you want and save them separately. When you have two or more reports to compare you can move onto the next step.

Next click on this link  https://docs.google.com/spreadsheets/d/1VuptAtur_QGCgi3M5_SS0LJwMMvPV2N4RoauF7W0D9Q/copy it will open up a copy of the compare file. This is yours to edit

Go to the first sheet in this file titled New-Import in Cell 1

Click on 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 (this will have the most recent date on it)

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)

Go to the rest of the tabs on the sheet and you can see your new movies, missing movies, downgrades, upgrades, etc.

Make a new sheet and repeat for TV