Kriter.io Posted December 3, 2013 Share Posted December 3, 2013 Hello Guys, I have no experience about queries, but I need to export the following data from my store using MYSQL Manager in Prestashop 1.5.5. The fields I need are: ID ORDER - PAYMENT METHOD - DATE OF ORDER - CUSTOMER NAME - CUSTOMER LAST NAME - CUSTOMER EMAIL - SHIPPING ADRESS - INVOICE FULL NAME - INVOICE ADDRESS - PHONE NUMBER - PRODUCT(S)ID - PRODUCT(S) NAME - PRODUCT PRICE TAX EXCLUDED - PRODUCT PRICE TAX INCLUDED - VAT VALUE - PRODUCT REFERENCE - SUPPLIER PRODUCT REFERENCE I would really appreciate your help. P.S. If any of you can also suggest me how to set a kind of cron or automatic export of the results, i would be very happy and thanksful about it. Thanks Link to comment Share on other sites More sharing options...
guest* Posted December 3, 2013 Share Posted December 3, 2013 With phpMyAdmin you can also export tables to an csv. For what do you need the data to be exported ? Link to comment Share on other sites More sharing options...
Kriter.io Posted December 3, 2013 Author Share Posted December 3, 2013 I need it to directly import the data in my tax and fiscal administration software manager since we have a company that sell online, off line, wholesale, and direct sales. So i have to import the relative data from online sales. Link to comment Share on other sites More sharing options...
guest* Posted December 3, 2013 Share Posted December 3, 2013 Any possibility to have this automated, for ex. through an api or module ? Which format does your software allow ? Link to comment Share on other sites More sharing options...
guest* Posted December 3, 2013 Share Posted December 3, 2013 BTW, in Prestashop 1.5. you have the possibility to USE SQL-Manager for to export your tables: http://nemops.com/prestashop-export-products/ Link to comment Share on other sites More sharing options...
Kriter.io Posted December 3, 2013 Author Share Posted December 3, 2013 Mu software allow csv files. I'd like to automate it. I saw the link you pasted, but i have to deal with all the fileds of the orders, importing also name and last name of customers, and so on. That's why i was asking if there is somebody who can help me the set properly my MYSQL MAnager in PS. .....or to tell me how to the the same via phpmyadmin or somehow with a cron set. Link to comment Share on other sites More sharing options...
guest* Posted December 3, 2013 Share Posted December 3, 2013 The link I posted show you how easy it is to Manage SQL-Exports. With phpMyAdmin you have to use queries (select from, join....), if you want to export only some tables, or columns of tables. Perhaps this link is better explained for how to use Prestashop SQL-Manager ? http://www.inmotionhosting.com/support/edu/prestashop-15/sql-manager Link to comment Share on other sites More sharing options...
Kriter.io Posted December 3, 2013 Author Share Posted December 3, 2013 thanks. I'll try to do it. Meanwhile i'll also wait if someboyd can set it for me or suggest me of to automatically set it. Link to comment Share on other sites More sharing options...
guest* Posted December 3, 2013 Share Posted December 3, 2013 For to use automatic write and feed, you must write a script, which exports your data from prestashop and your software must also have another script or cron to automatically import the csv. So both must communicate. Otherwise you have to export or/and import manually. The other software is ? Name it here please, perhaps there are solutions already available for that what you want. Link to comment Share on other sites More sharing options...
Kriter.io Posted December 3, 2013 Author Share Posted December 3, 2013 it is called DNA ERP and it is an old ERP by Oracle. Is is very old and i have to use it since the company that i work for does not want to change it. So i think i'll have to configure either the MYSQL MANAGER or via phpmyadmin the DB Link to comment Share on other sites More sharing options...
guest* Posted December 3, 2013 Share Posted December 3, 2013 Oh Jesus... OLD ? Very old. So nothing ready-for-use available. Perhaps this easy tuturial will help you to build-up your SQL-Query, if you can't do it with SQL-Manager from Pestashop (much more easier to build-up as via own SQL-queries). http://www.tizag.com/sqlTutorial/sqlqueries.php Link to comment Share on other sites More sharing options...
RogueWaveLimited Posted December 3, 2013 Share Posted December 3, 2013 I can help you do this. Contact me at the email below if you are interested. Link to comment Share on other sites More sharing options...
Recommended Posts