[manicolaus]

The CSV file that the Export All button generates for downloading all sales repeats the sum of the merchandise prices, the total tax, and the total shipping for the customer on each line of the file. So for example if customer John Doe orders three items priced at $5, $7, and $9 respectively, and the total tax on the order is $2.00 and the shipping for the whole order is $15, the CSV file reads:

customer name   sku    order_subtotal  order_tax  order_shipping
John Doe            888          $21               $2             $15
John Doe            999          $21               $2             $15
John Doe           1000          $21              $2              $15

What it should look like is

John Doe            ---           $21              $2              $15
John Doe            888          $5                --               --
John Doe            999          $7                --               --
John Doe           1000          $9               --               --

I mean, we can work with the current setup, but it means that our office database has to look up the item prices in the local table, instead of picking the prices off the shopping cart. No real biggie, but something to think about.

[Qetzal]

Originally Posted by manicolaus

The CSV file that the Export All button generates for downloading all sales repeats the sum of the merchandise prices, the total tax, and the total shipping for the customer on each line of the file. So for example if customer John Doe orders three items priced at $5, $7, and $9 respectively, and the total tax on the order is $2.00 and the shipping for the whole order is $15, the CSV file reads:

..

I mean, we can work with the current setup, but it means that our office database has to look up the item prices in the local table, instead of picking the prices off the shopping cart. No real biggie, but something to think about.

The "order_subtotal" column always contains order subtotal, i.e. the sum of all the product prices. If you want to export your product costs too, enable the "Item total" column when you export your orders. The new column will appear in the generated CSV file and it will contain the information your need.