Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Export Orders (or invoices) to CSV


Guest

Recommended Posts

As far as I can see sales data is stored as Net Sales and the tax and gross are calculated on the invoice sub total.

 

Unfortunately, when a new product is entered the gross amount (to two decimal places) viz dollars and cents is converted to net and stored as 'products_price' and/or 'final_price' (to four decimal places).

 

The existing php script exports the Net Amount of an order on a line by line basis, and the Gross for the whole invoice total to two decimal places.

 

Rounding by mySQL means that when the individual lines are multiplied back to obtain a Gross Line figure we run into errors that the accounting software will not tolerate.

 

I am not a php programmer and would appreciate guidance on how the full detail shown on the standard invoice could be incorporated into the export file generated by exportorders.php

 

Regards,

peter_of_stirling

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