1. jure
  2. RO CSVI
  3. Thursday, 13 February 2020
  4.  Subscribe via email
Hi,

I'm using RO CSVI to export orders from Virtuemart. I'm successful at exporting the VatTax percentage value, but I've also setup a price modifier before tax (DBTax) of -3% as a discount for all products.
Now I would need to export the value of the discount (-3% in this case) but I can't find the field that has this value. To clarify I need the value of the percentage not the discounted price which I was able to export.

Thanks for your help and kind regards,
Accepted Answer Pending Moderation
Hello,

The actual percentage is not stored in the order table as a single value by VirtueMart. There is the field order_billTax which has some info, does this field contain the info you are looking for? If yes, please post how this looks like in your export file. We can then check if we can do something with it.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi Roland

This is the output of order_billTax in the xml file:


<![CDATA[{
"2": {
"virtuemart_calc_id": 2,
"calc_name": "DDV",
"calc_value": "22.0000",
"result": 14.218952
}
}]]>


This is for the 22% VAT, but I also have one rule of ID 3, which has a type of Arithmetic Operation as DBTax. I can't get this one to show in export.
  1. 2 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

In that case I am afraid VirtueMart doesn't store this information anywhere. If it is not stored, RO CSVI cannot export it. The only option I have is to add a field called custom to the list of export fields and set a default value of -3%. You can also set the header to a name of your liking. RO CSVI will then export this value for every row.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hi Roland,

Thats what I thought, I'll add the field manually to the export.

Thank you
  1. 2 weeks 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!