Categories
View Replies (7)

Resolved Virtuemart DBTax in Order Export

  1. jure
    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,
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
As Roland already mentioned VirtueMart does not store the discount as percentage in database. You can write your own custom rule to read the before and after values and calculate the percentage based on that.
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. # Permalink
Responses (7)
rolandd
rolandd
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. more than a month ago
  2. RO CSVI
  3. # 1
jure
jure
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. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
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. more than a month ago
  2. RO CSVI
  3. # 3
jure
jure
Accepted Answer Pending Moderation
Hi Roland,

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

Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 4
jure
jure
Accepted Answer Pending Moderation
Hi Roland,

the custom value worked until now, as we only had 1 price modifier for all categories, but now we have different values for different categories, so I would need this to be dynamic.

Is there any other way of getting the value of the modifier, order export does provide the before/after price but I also need the percent that these values were calculated with.

I see the values if I use a template to export the Calculation rules any way to connect the rules to the order export?

Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 5
jure
jure
Accepted Answer Pending Moderation
Hi Roland and Tharuna

I've solved this with a custom rule plugin, thank you.
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


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