Mochi09 Posted January 2, 2015 Share Posted January 2, 2015 Hello, can someone help me transferring the products for live website to local server website? do I need to make the local server website same as live website before making an import? thanks in advance Link to comment Share on other sites More sharing options...
vekia Posted January 5, 2015 Share Posted January 5, 2015 you mean that you just want to run test environment of your shop? Link to comment Share on other sites More sharing options...
Mochi09 Posted January 5, 2015 Author Share Posted January 5, 2015 you mean that you just want to run test environment of your shop? I want to transfer all the products from the live site to my local server prestashop installed in PC, is it possible? even Im using different theme on the local PS? Link to comment Share on other sites More sharing options...
Richard S Posted January 6, 2015 Share Posted January 6, 2015 The theme does not have anything to do with the data itself. If you are advanced user, you could just copy database tables which are connected to products and migrate them to your local enviroment. If you do not have programming practice and not so good in SQL, then you can just export the products to CSV using default Export capabilities and then import it to your local enviroment. Link to comment Share on other sites More sharing options...
vekia Posted January 6, 2015 Share Posted January 6, 2015 1) export database from your remote environment 2) import it to your local environment if you want also pictures of products, categories etc. copy whole /img/ directory Link to comment Share on other sites More sharing options...
Mochi09 Posted January 6, 2015 Author Share Posted January 6, 2015 The theme does not have anything to do with the data itself. If you are advanced user, you could just copy database tables which are connected to products and migrate them to your local enviroment. If you do not have programming practice and not so good in SQL, then you can just export the products to CSV using default Export capabilities and then import it to your local enviroment. 1) export database from your remote environment 2) import it to your local environment if you want also pictures of products, categories etc. copy whole /img/ directory Thank you guys, gonna try that Link to comment Share on other sites More sharing options...
Mochi09 Posted January 6, 2015 Author Share Posted January 6, 2015 I have successfully transffered the products, but not their prices, I don't see the "Base Price" or "Final Price" option before importing Link to comment Share on other sites More sharing options...
Richard S Posted January 7, 2015 Share Posted January 7, 2015 Which method you have used? Link to comment Share on other sites More sharing options...
Mochi09 Posted January 7, 2015 Author Share Posted January 7, 2015 the one vekia said Which method you have used? Link to comment Share on other sites More sharing options...
Mochi09 Posted January 8, 2015 Author Share Posted January 8, 2015 btw, If im going to reinstall the PS does it also removes the database? Link to comment Share on other sites More sharing options...
Richard S Posted January 8, 2015 Share Posted January 8, 2015 If you clear all tables in database, yes. Link to comment Share on other sites More sharing options...
Mochi09 Posted January 8, 2015 Author Share Posted January 8, 2015 oh ok, so I can reinstall without losing all the products,customers etc. If you clear all tables in database, yes. Link to comment Share on other sites More sharing options...
Richard S Posted January 8, 2015 Share Posted January 8, 2015 It will not probably allow you to install anything in the same database and you will be asked to change prefix or use another database.Why you want to reinstall? Delete files except config folder and upload them back if you want to have fresh files. Reinstallation will not help you with data as it is all the same and nothing will be changed. Link to comment Share on other sites More sharing options...
Mochi09 Posted January 8, 2015 Author Share Posted January 8, 2015 because the website is buggy, and the theme they using is for 1.5 and they are suing PS 1.6, also some of the functions at BO are not working It will not probably allow you to install anything in the same database and you will be asked to change prefix or use another database.Why you want to reinstall? Delete files except config folder and upload them back if you want to have fresh files. Reinstallation will not help you with data as it is all the same and nothing will be changed. Link to comment Share on other sites More sharing options...
Richard S Posted January 9, 2015 Share Posted January 9, 2015 BO functions should all work just fine and they are usually independent of theme.Just remove the theme or install new one. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now