#1  
Old 06-17-2010, 06:10 PM
LifeRing's Avatar
LifeRing LifeRing is offline
Junior Member
 
Join Date: May 2010
Posts: 8
Default Export Sales as CSV file issue

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

Last edited by qetzal; 06-18-2010 at 02:00 PM. Reason: formatting changes
Reply With Quote
  #2  
Old 06-18-2010, 01:59 PM
Qetzal's Avatar
Qetzal Qetzal is offline
Ecwid Team
 
Join Date: Sep 2009
Posts: 11,062
Default

Quote:
Originally Posted by manicolaus View Post
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.
__________________
Eugene K.
Ecwid Team

@ecwid | Facebook Page | Ecwid Knowledge Base
Reply With Quote
Reply

Tags
csv, download, export, sales

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:46 AM.
Powered by vBulletin® Version 3.8.6. Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.