Prestashop database import of products.

Avatar
heartlandpet
  • Answered
Scott, Arnel....et all,

Here is where you really have a chance to help me big time!

My 1.6 Prestashop became corrupted with all kinds of problems. Problems created by multiple uploads of new themes I was trying. Yesterday I did a back-up. Then the techs from In-Motion helped me to create a brand new fresh install of 1.6.13.
So now I have a new theme but do now want to re-create all the products combinations, attributes etc.
I need you to walk me through what I need to do to bring my products and combinations over to the new shop.

I have never used myphp or mysql and know nothing about it. So help me out here. My logins will be included below. The In-Motion tech moved everything from the old Prestashop by creating an old public html, public_html_old. Also the files are in a folder called OLDSITE.

Help me get this done.

r,

Bruce

Replies 1
Avatar
0
Arn
Hi Bruce! Thanks for question about moving your old database to the new PrestaShop 1.6 installation. The main issue here will be taking your NEW installation and pointing it to the OLD database. You will need to make a copy of the settings.inc.php in the CONFIG folder. That way you can you point BACK to the new database, if necessary. After you have it backed up, open the settings.inc.php from your old installation (it's in the same location but in the other PUBLIC_HTML folder). Copy the DATABASE SETTINGS - you'll need replace these settings from old to new: define('_DB_SERVER_', 'localhost'); define('_DB_NAME_', 'username_dbname'); define('_DB_USER_', 'username_dbname'); define('_DB_PASSWD_', 'db-password'); define('_DB_PREFIX_', 'ps_'); Make sure you're replacing the NEW file with your old settings in order to connect to the old database! The next thing is to rename the MODULES and IMG folders in the new installation to something else. Then copy those same folders from the OLD site to the NEW site. That should bring the images over. Turn off the SEO Friendly URLs, then turn them back on. At that point you should be 95% of the way. The rest will mean going back and figuring out where you made changes to the templates as you did before. Scott tested all of this on his test server today, and we saw it working. So, hopefully, it will be the same for you! Regards, Arnel C.