Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Export order data to .csv


Recommended Posts

Hi All,


I'm trying to write an SQL query which will allow me to open a url (ie.www.store.com/report) which will generate a downloadable csv file of all the orders that were shipped on that day to be imported into another system.


I'm having some issues putting the script together and keep getting connection errors, if you could please offer any assistance on how this could be achieved it would be appreciated.

Link to comment
Share on other sites



Have you looked at the add ons for something that already does this?


Export order





Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile


Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.


For links mentioned in old answers that are no longer here follow this link Useful Threads.


If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Hi Geoff,


Thanks for the response, I have had a look but as this is such a heavily modified store I have not been able to implement a plug in, I thought coding a simple page may be the easiest?


Edit: after searching though some of the plugin's i may be able to adapt the code accordingly, I'll give it a try and advise.

Link to comment
Share on other sites

Hmm having a look at the code for export orders to CSV I seem to have found an incompatibility.


The instructions suggest looking for the following,


find :

   $contents[] = array('text'  => '<a href="' . tep_href_link(FILENAME_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_CUSTOMERS . '</a><br>' .
                                  '<a href="' . tep_href_link(FILENAME_ORDERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_ORDERS . '</a>');


Yet this site is structured differently


$contents[] = array('text'  => tep_admin_files_boxes(FILENAME_ORDERS, BOX_CUSTOMERS_ORDERS, 'SSL') .
                                  tep_admin_files_boxes(FILENAME_CREATE_ORDER, BOX_MANUAL_ORDER_CREATE_ORDER, 'SSL') .
                                  tep_admin_files_boxes(FILENAME_CREATE_ORDERS_ADMIN, BOX_CREATE_ORDERS_ADMIN, 'SSL') .
                                  tep_admin_files_boxes(FILENAME_PAYPAL, BOX_CUSTOMERS_PAYPAL, 'SSL') .


Looks like I'll have to keep researching.


btw Geoff - is that your balloon? looks similar to an Rmax one

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...