Moving to new host - How to change file paths???

-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.2.24
-- Browser(s) name and version -- : ie 11

I am moving to a new host and I sell download PDF files... The files are very large and I have them stored outside of a web folder such as a path like this currently:

/home/content/51/70951/downloads/(FILE NAME WOULD GO HERE.pdf)

My new host has the path to that folder now as:

/home/MYUSERNAME/downloads/(FILE NAME WOULD GO HERE.pdf)

I have over 1000 download products and would LOVE to be able to do a mass action on them to change this path to reflect the new sevrer path.

PLEASE HELP!!!!

Thank you in advance!!!

Nevermind. I made a direct edit to the database using find and replace in dreamweaver then re upload the hikashop_file table. thanks anyway