Issue In Tax Field In Exported Orders File

Multi-Vendor Questions
1

Dears,

I am trying to get the exact tax paid for each order. I have exported the orders but the data showing is not clear to me.

Attached is an example of the data exported and the setup I did in the Export page.

Kindly assist.

Regards,

data Capture.JPG

data 2 Capture.JPG

2

you will see it buried under all the other text. Not ideal but its there

tax.JPG

3

Any idea to resolve the export issue? Is there any setup I need to do to show the data properly?

4

I think its always going to export that way, and when you open in excel you may have to do data to colums or filter it some way.

John

5

I think its always going to export that way, and when you open in excel you may have to do data to colums or filter it some way.

John

Hi,

Yah that's what I did but it still shows extra data and not as per the export configuration ie. Semicolon or comma.

6

Please check the attached screenshots.

I have attached the Export fields. Look at the exported data in excel, there are extra things which was exported as well.

data Capture.JPG

data 2 Capture.JPG

data 3 Capture.JPG

7

any luck ok this ?

What is the extra fields shows in the report and why it is showing like this?!

8

Yes, the tax field is difficult to deal with but can be filtered through using some advanced Excel formulas. I had been doing it this way for many years until now. We now have more than one tax which has complicated things greatly. So...I began my search for a solution.

You can calculate the tax based on subtotal, total ,shipping but ion my case we have a lot of discounts in the orders due to coupons and what not. Unfortunately CSC does not include the extra field for this in the export field choices. You need to add the "subtotal_discount" field to export of orders.

I have figured out how to do this with the help of another post that ecomlabs has responded to. THANKS ECOM

It can be done through my changes:

Create the following file:

app/addons/my_changes/schemas/exim/orders.post.php

add this code to the file

$schema[‘export_fields’][‘Subtotal Discount’] = array(

‘db_field’ => ‘subtotal_discount’,

);


return $schema;

Clear your cache and the field will now be available to select in Export Orders.