I'm running an e-commerce website, selling academic solutions. My team has to upload questions and solutions on the website. The solutions are uploaded through FTP but questions are uploaded as new product(one question as one new product). The process of uploading questions take lot of time because of the internet speed and shared server.
My question is that if it is possible to upload all the questions in local computer(local copy of zencart installed) and then just upload the database file to the live server.

Will that work fine if not then please give me any suitable solution so that we can upload large number of questions daily.

Thanks