Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Export to .XLS


Guest

Recommended Posts

I've been working on a contrib for someone who wants to have an excel list of all of the products order.... simple right?

 

I thought so, I found a simple export table to XLS script on line and setup a simple form to call that data. Works fantastic! BUT here's the problem......

 

She wants the XLS file to also contain the size of the product ordered and the scrip i have only exports one table and the size of the product ordered isn't located in the "orders_products" table it's found in the "orders_products_attributes" table. I don't know enough about MySQL statements to combine the two tables in the XLS file. Can anyone help me figure this out?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...