Export CSV

  • Resolved blackbird69

    (@blackbird69)


    5 years, 6 months ago

    When exporting to CSV the “Totals” are not placed right as it is missing an empty cell for “Tax rate” or is it “Customer Country”.

    Test CSV:

    "
							
								
									Currency for VAT returns:
									DKK
								
								
									Exchange rates used:
									Rates saved with each order
								
							
						"
"EU","Customer country","Tax rate","Total Sales (ex. tax)","Total Tax","Total Sales (inc. tax)"
"
				EU Sales
				This section shows sales made to EU countries.
			"
"eu","CZ","25.00","DKK606.60","DKK151.65","DKK758.25"
"eu","DK","25.00","DKK799.91","DKK199.98","DKK999.89"
"
				Non-EU Sales
				This section shows sales made to countries outside the EU.
			"
"non-eu","VE","25.00","DKK133.32","DKK33.33","DKK166.65"
"Totals","","DKK1,539.82","DKK384.96","DKK1,924.78"
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Diego

    (@daigo75)

    I’m not sure I understand what the issue is, could you please provide more details about it?

    Also, the posted data has a broken layout, it’s hard to decipher it. I would suggest to upload a sample CSV file to a file sharing service and post the link to it, or send it to us via our contact form (https://aelia.co/contact/). You can just send the file and a link to this discussion, so that we can associate it easily. Thanks.

    Thread Starter blackbird69

    (@blackbird69)

    This is the sample of the CSV! I have sent you the file by your contact form.

    Plugin Author Diego

    (@daigo75)

    Thanks for the file, the issue is clear now.

    Technical details
    The report page shows a table with five columns in the table body, because there is a hidden “EU/non-EU” column. The “CSV Export” function exports that hidden column, therefore the resulting CSV file has six columns in the table body.

    The glitch occurs because the table footer always uses five columns. The “Total” field uses two columns, and each of the three total uses one. That causes the “gap” that you reported, which is only visible when you export the data.

    It’s just a minor issue, it should be easy enough to fix it. Thanks for taking the time to report it. ??

    Plugin Author Diego

    (@daigo75)

    Fixed in EU VAT Assistant 1.9.12.190516.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Export CSV’ is closed to new replies.