Mochi09 Posted January 2, 2015 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 Share this post Link to post Share on other sites More sharing options...
vekia Posted January 5, 2015 Posted January 5, 2015 you mean that you just want to run test environment of your shop? Share this post Link to post Share on other sites More sharing options...
Mochi09 Posted January 5, 2015 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? Share this post Link to post Share on other sites More sharing options...
Richard S Posted January 6, 2015 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. Share this post Link to post Share on other sites More sharing options...
vekia Posted January 6, 2015 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 Share this post Link to post Share on other sites More sharing options...
Mochi09 Posted January 6, 2015 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 Share this post Link to post Share on other sites More sharing options...
Mochi09 Posted January 6, 2015 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 Share this post Link to post Share on other sites More sharing options...
Richard S Posted January 7, 2015 Posted January 7, 2015 Which method you have used? Share this post Link to post Share on other sites More sharing options...
Mochi09 Posted January 7, 2015 Posted January 7, 2015 the one vekia said Which method you have used? Share this post Link to post Share on other sites More sharing options...
Mochi09 Posted January 8, 2015 Posted January 8, 2015 btw, If im going to reinstall the PS does it also removes the database? Share this post Link to post Share on other sites More sharing options...
Richard S Posted January 8, 2015 Posted January 8, 2015 If you clear all tables in database, yes. Share this post Link to post Share on other sites More sharing options...
Mochi09 Posted January 8, 2015 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. Share this post Link to post Share on other sites More sharing options...
Richard S Posted January 8, 2015 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. Share this post Link to post Share on other sites More sharing options...
Mochi09 Posted January 8, 2015 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. Share this post Link to post Share on other sites More sharing options...
Richard S Posted January 9, 2015 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. Share this post Link to post 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