Why you need to be offline ? if you are offline , you can not update products . May be you can install xamp to your pc and install same website with online and update it on your pc then you can upload your sql file and other folders to your online side. But Even with this , you need to be online at the end.