Categories
View Replies (4)

Resolved Export virtuemart order: tax percentage and other

  1. ThijsGaublomme
    ThijsGaublomme
  2. RO CSVI
  3. Thursday, 16 March 2017
  4.  Subscribe via email
Hello,

Few questions about the virtuemart order export function.

1. How to have the tax percentage for every ordeline exported (I have 3 tax percentages and I only manage to have the amounts exported)
This in order to import the exported file in our ERP program to have the math done there.

2. I've set the options set to comma for the decimals. But there are also fields exported with a point in stead of a comma.
See exported order in attachement.

3. Could you explain me or point me to the manual how the group fields work or do in the order export (can't seem to figure out what this does)

4. I'm experimenting with 2 exports. Csv and xml (advanced export).
The advanced export is working great. I can manage the layout pretty good.

But for the import in our ERP they would prefer csv.

There's a problem.
I need to have billing and shipping address in the order. So i've set the options like that. So far so good.
But when I export the csv file, I get duplicate lines with every line an 1 of the 2 addresses.
I thought the addresses would be exported one after the other and have them repeated for every orderline (without duplicates).
See file and log in attachement.

5. Could you give me a manual for the rules option you provide and also what the field mapper does.

A lot of questions, I'm sorry...
Tried to find answers but couldn't find them.

Thanks for your help and kind regards,

Thijs Export_order.csv com_csvi.log.57.zip
0
Responses (4)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Thijs,

1. How to have the tax percentage for every ordeline exported (I have 3 tax percentages and I only manage to have the amounts exported)
This in order to import the exported file in our ERP program to have the math done there.

If you are looking for vat tax percent in order export, you can have a look at Using VatTax percent in VirtueMart order export document to know how to get the tax fields.

2. I've set the options set to comma for the decimals. But there are also fields exported with a point in stead of a comma.
See exported order in attachement.

There were two fields which are exporting default separator which is point instead of comma, i have added them to use decimal separator as in the template settings. Please apply the attached patch file for the fix.

3. Could you explain me or point me to the manual how the group fields work or do in the order export (can't seem to figure out what this does)

Have a look at Group by and Sort by document for the same.

4. I'm experimenting with 2 exports. Csv and xml (advanced export).
The advanced export is working great. I can manage the layout pretty good.

But for the import in our ERP they would prefer csv.

There's a problem.
I need to have billing and shipping address in the order. So i've set the options like that. So far so good.
But when I export the csv file, I get duplicate lines with every line an 1 of the 2 addresses.
I thought the addresses would be exported one after the other and have them repeated for every orderline (without duplicates).
See file and log in attachement.

You should not be seeing these duplicates once you set group by and sort by fields set in your template as explained in the above linked document.

5. Could you give me a manual for the rules option you provide and also what the field mapper does.

You can take a look at Field mapper document to know more about it. For the rules option, can you be specific for the rule you are looking to use in your export?

patch_vm_order_2017_03_17.zip
Attachments (1)
patch_vm_order_2017_03_17.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
ThijsGaublomme
ThijsGaublomme
Accepted Answer Pending Moderation
Hello Thijs,

1. How to have the tax percentage for every ordeline exported (I have 3 tax percentages and I only manage to have the amounts exported)
This in order to import the exported file in our ERP program to have the math done there.

If you are looking for vat tax percent in order export, you can have a look at Using VatTax percent in VirtueMart order export document to know how to get the tax fields.

I allready found the VatTax export fields. But that wasn't what I was looking for.
I needed the percentage inline with the product because now in the export there are only amounts...
Example:
SKU Descripton Qty Price Tax%
12345 Name of prod. 5 12.50 21%

2. I've set the options set to comma for the decimals. But there are also fields exported with a point in stead of a comma.
See exported order in attachement.

There were two fields which are exporting default separator which is point instead of comma, i have added them to use decimal separator as in the template settings. Please apply the attached patch file for the fix.

OK, installed it and will test again.

3. Could you explain me or point me to the manual how the group fields work or do in the order export (can't seem to figure out what this does)

Have a look at Group by and Sort by document for the same.

Thx, I'll tak a look

4. I'm experimenting with 2 exports. Csv and xml (advanced export).
The advanced export is working great. I can manage the layout pretty good.

But for the import in our ERP they would prefer csv.

There's a problem.
I need to have billing and shipping address in the order. So i've set the options like that. So far so good.
But when I export the csv file, I get duplicate lines with every line an 1 of the 2 addresses.
I thought the addresses would be exported one after the other and have them repeated for every orderline (without duplicates).
See file and log in attachement.

You should not be seeing these duplicates once you set group by and sort by fields set in your template as explained in the above linked document.

Tried to set it to group the SKU but didn't work. Any idea where I can set the group on?

5. Could you give me a manual for the rules option you provide and also what the field mapper does.

You can take a look at Field mapper document to know more about it. For the rules option, can you be specific for the rule you are looking to use in your export?

[attachment]patch_vm_order_2017_03_17.zip[/attachment]


Ok, field mapper. Will look into it. Hope I can figure out what it can be used for.
For the rules I have no clue what the possibilities are so cannot specify what I'm looking for...

Kind regards,

Thijs
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Thijs,
I allready found the VatTax export fields. But that wasn't what I was looking for.
I needed the percentage inline with the product because now in the export there are only amounts...
Example:
SKU Descripton Qty Price Tax%
12345 Name of prod. 5 12.50 21%

VirtueMart saves the tax as amount in Orders table and not as percentage and so your export shows them as amounts. One way to do this is you can create an override for your order export and add some custom code to change them to percentage.

Tried to set it to group the SKU but didn't work. Any idea where I can set the group on?

As per the file attached in your previous post, order_number is been duplicated in your export. What if you try to group by order_number field? But then even with grouping by order_number field you should be seeing two rows, one for shipping address and one for billing address. There is no way to get both shipping address and billing address in one row with a csv file.

For the rules I have no clue what the possibilities are so cannot specify what I'm looking for...

There are six types of rules CSVI supports. Each one of them does a different job so to help you with specific rule you need to tell us the use of the rules in your export. You can also check the documentation of these rule plugins on our website.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

In addition to what Tharuna said, VirtueMart stores the values and not the actual percentages. This means you can't calculate that back due to rounding differences as you would get percentages like 20.9 or 21.01. That is something to think about as well.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!