Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Export order data to .csv


Dan_

Recommended Posts

Posted

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.

Posted

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 ======>>>>>.

Posted

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.

Posted

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

Archived

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

×
×
  • Create New...