macandcheese Posted February 16, 2009 Share Posted February 16, 2009 Posted this awhile ago, couldn't really get it resolved. I have a working shop that is great (on Prestashop), www.spoonysglasspipes.com. I have a wholesale site as well that I am working on, and I want to copy the entire catalog into the new wholesale site (then just change the prices in the admin area). I tried copying the sql tables through mysql and the product categories copied over, but not the products at all. Any help? Link to comment Share on other sites More sharing options...
prestabase Posted February 16, 2009 Share Posted February 16, 2009 macandcheese,Is your wholesale site already setup? If not, you could download a backup of your PrestaShop database, then import that backup into your new account. Once imported, simply run an installation of PrestaShop and use the populated database connection details during install. Link to comment Share on other sites More sharing options...
macandcheese Posted February 16, 2009 Author Share Posted February 16, 2009 It is installed, but I wouldn't be against reinstalling it if I could save all the trouble. When you say into a new account do you mean just duplicate my database through mysql or through prestashop itself, or just use a different database (the backup) when installing and choosing database path. Sorry if that made no sense. Link to comment Share on other sites More sharing options...
prestabase Posted February 16, 2009 Share Posted February 16, 2009 Hey,I'll try to clarify. Create a new database for prestashop to use on your wholesale site. Make a database backup of your current prestashop(spoonysglasspipes.com). Next, import that database backup into your new wholesale site database you created. Once imported, upload a new PrestaShop installation into your hosting account, and then install using your newly created database connection settings.Hopefully that makes sense? I may be able to do this for you, if you'd like. Link to comment Share on other sites More sharing options...
macandcheese Posted February 16, 2009 Author Share Posted February 16, 2009 Thanks, I'll try that with the reinstall if I can't get it to work without doing that. On that note, could I just drop all tables from the wholesale site's current database and load the ones from the retail site into that, or do I still need to do a reinstall for it to be read and installed correctly? Link to comment Share on other sites More sharing options...
prestabase Posted February 16, 2009 Share Posted February 16, 2009 You should be able to do that. Give it a try, it will save ya some time if it works. Link to comment Share on other sites More sharing options...
macandcheese Posted February 16, 2009 Author Share Posted February 16, 2009 It worked great, but now I can't log into the admin area. All I did was copy the retail site's SQL into the wholesale site's SQL, and all the products and everything else (cms, settings, etc.) copied over. But I can't log in... I get:"There is 1 error 1. employee does not exist, or bad password"But its the same password and login as the retail admin, which works fine.. any help? Link to comment Share on other sites More sharing options...
prestabase Posted February 17, 2009 Share Posted February 17, 2009 Glad to hear that. To restore the password, search "employee does not exist" on the forum. You'll need to place your MD5 has into phpmyadmin, etc. Link to comment Share on other sites More sharing options...
macandcheese Posted February 17, 2009 Author Share Posted February 17, 2009 I searched and found this thread: http://www.prestashop.com/forums/viewthread/12753/installation_configuration___upgrade/install_problemBut when I follow it, nothing changes. I checked out the employee sql fromthe retail original site and there are no passwords shown, as they say there are in the thread. I got the cookie key from the settings file in the new wholesale site, but do I put it for both employees? I tried just me for now and it didn't work, with or without the password as part of the cookie string. Link to comment Share on other sites More sharing options...
Dave Egerton Posted February 17, 2009 Share Posted February 17, 2009 could try information on this linkhttp://www.prestashop.com/forums/viewthread/12959/general_discussion/please_help Link to comment Share on other sites More sharing options...
Sulo Posted March 24, 2009 Share Posted March 24, 2009 I am using prestashop v. 1.1.0.5, I would like to migrate to another hosting. I was backup my database and imported in my new created database on new hosting. after that I run fresh installation and use database which I imported. I can´t go through step 3. When I press verify "Database is connected." but when I press next "A Prestashop database already exists, please delete it or change the prefix." could anybody help?. I previously try to copy all files through ftp from one to another hosting and update setting.inc.php file. Everything is ok except two things, in FO there is not pictures and when I run regenerate thumbnails it write error "zero sized reply". PS In BO pictures are visible. How I can run my webshop on new hosting? Thank you Link to comment Share on other sites More sharing options...
Recommended Posts