Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Daily order download in delimited format


Guest

Recommended Posts

Posted

I know this is a dumb question but I'm still new to PHP. I need to be able to download all orders by date (once a day) into a delimited format (tab, or pipe preferably) but I haven't been able to write the query correctly. I need it to pull all the info that's in a normal order, ex. something like:

ORDER#1|DATE|NAME|ADDRESS|PHONE|D.O.B|EMAIL|Total|CC#|Exp|COMMENTS|ProdOrdered1|

ProdOrdered2|ProdOrdered3|ProdOrdered4.... ORDER#2|DATE|NAME|ADDRESS|PHONE|D.O.B|EMAIL|Total|CC#|Exp|COMMENTS|ProdOrdered1|

ProdOrdered2|ProdOrdered3|ProdOrdered4....

If anyone can help me out that would be great, if not, well, I'll keep trying.... :wink:

Posted

Still stuggling with this, just getting it to print out on a page that they could copy and paste would even work, has anyone done something close to this?

Posted

I have made a small script to do this, and am making some additions to that it will email them out as a CSV text file attachment every night. I you would like the code (not ready to be released), please feel free to email me.

 

Thanks,

Zac

  • 2 years later...
Posted

Could you please email it to me also?

 

Thanks,

Chris Behnke

[email protected]

 

 

I have made a small script to do this, and am making some additions to that it will email them out as a CSV text file attachment every night. I you would like the code (not ready to be released), please feel free to email me.

Thanks,

Zac

Archived

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

×
×
  • Create New...