Dan_ Posted July 11, 2010 Posted July 11, 2010 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.
♥geoffreywalton Posted July 11, 2010 Posted July 11, 2010 Dan Have you looked at the add ons for something that already does this? Export order Cheers G 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 ======>>>>>.
Dan_ Posted July 14, 2010 Author Posted July 14, 2010 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.
Dan_ Posted July 14, 2010 Author Posted July 14, 2010 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.