Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Daily order download in delimited format


Guest

Recommended Posts

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:

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 2 years later...

Could you please email it to me also?

 

Thanks,

Chris Behnke

chris@delightfulgourmetwonders.com

 

 

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

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...