Jump to content

Export Catalog to CSV?


Recommended Posts

Hello:

 

I've searched to forums for information regarding the Export feature.  However, every post that seems to allude to an answer on how to export my catalog is in French.  Matthieu, I have my French-English dictionary right next to me but it's not helping.  Can anyone help point me to a tutorial on how to export my catalog?

 

I am trying to export my current catalog from one server, install Prestashop on another server, and then re-import the catalog into the new server.  Sounds simple enough but the solution alludes me for the moment.

 

 

Thank you!

Link to comment
Share on other sites

I found the following information.  However, it doesn't give any information pertaining to a particular "Catalog Exporting tool."  I will post the information for those who may need it and perhaps someone can give me an idea on just exporting the entire catalog WITHOUT having to transfer the entire PS directory with it.  I know it makes sense to transfer the entire directory with the SQL file.  However, I am performing a fresh new install on a different server and I don't know if it matters that Prestashop was installed on one server (for testing purposes) which may have created tokens/session/etc... particular to that server.  Does anyone know if this is the case?  If not, is the recommendation to just transfer the entire directory as outlined in the following steps?

 

 

For the PS Directory:

http://www.prestashop.com/doc/doku.php/shop_owner_guide?s=export

 

Migrate PrestaShop

 

To migrate your entire PrestaShop shop to another Web server:

 

  1.

      First, we advise you to go in your back office in Preferences rubric, and write your new PS directory in the appropriate field. Or you can also open the file config/settings.inc.php and write your new PrestaShop directory's path: define(_PS_BASE_URI_, 'myNewDirectory');.

  2.

      Then, you have to move your current PS directory to its new location.

 

For the database:

http://www.prestashop.com/doc/doku.php/back_up_your_database

 

Lots of info with images so check it out for yourself.

Link to comment
Share on other sites

I used Google's translation service in case anyone needed a pretty good English version of Julien's info.  Rock on Julien!

 

 

http://translate.google.com/translate?u=http%3A%2F%2Fwww.julienbreux.com%2F2008%2F06%2F04%2Fmodule-prestashop-backup%2F&sl=fr&tl=en&hl=en&ie=UTF-8

 

 

If the link doesn't work just head over to translate.google.com and enter Julien's link in the post above.

Link to comment
Share on other sites

@Julien

 

I just installed the module and it rocks.  Quick question, was this meant to backup the entire database or just the pertinent information (e.g. catalog, customers)?  I know silly questions but it's late here and I am having difficulty reading all the SQL syntax.  I will into it again in the morning.

 

Also, what is your opinion on this: If I do a fresh install on a new server, then take a db backup file (thanks to you) and import it into phpMyAdmin on the new MySQL db server, would there be any problems with any of the Prestashop settings?

 

Thank you!

Link to comment
Share on other sites

  • 4 weeks later...

Hi! I installed your module sucessfuly. Made one backup of the fresh installation of prestashop rc3. After adding products and made another backup.
Tried to restore the first one and it says that it worked well. went to my shop and it says there's an error. tried to enter backoffice and tell's me that :
There is 1 error
employee does not exist, or bad password .

What happend?

Link to comment
Share on other sites

By the contrary my friend! Im very pleased with this module since it doesn't existe nothing like this and in fact is so easy to operate. Listen, i went to phpmyadmin, clicked in prestashop and import one backup from the your module folder. It gave me this error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 49

Can you tell me what does it means and how to resolve it?

Thanks again!!

Link to comment
Share on other sites

Yes, i had exactly same problem, when i used this module to backup database its deleted all database files in my phpadmin, thats why you cant login, no data, no users etc
In the generated file is a bug, at the and of part to meet the table was always missing parenthesis-this symbol ")"
So if you put it there and make backup in php admin it works fine.
But if would work right, its very needed module, thanks for it :)

Link to comment
Share on other sites

×
×
  • Create New...