1. liaskas
  2. RO CSVI
  3. Monday, 07 June 2021
  4.  Subscribe via email
Hello

When we import products from xml to our store, in some cases the xml prices include vat, and in some other cases they do not.

When the xml prices do not include VAT it is easy for us to copy the price and add a 24% to the copied field, so here there is no problem.

The problem exists when the prices of the XML include VAT. In this case, we copy the price_with_tax to product_price and there we have to calculate by dividing it by 1,24 to correctly subtract the 24% tax.

Is there a workaround for this, as this is the only correct way to subtract vat from a price?

Thank you.
Accepted Answer Pending Moderation
Hello,
You can use RO CSVI Combine field rule plugin with Operation as calculation and perform operation as Division to divide fields set in Source field. Target field is product_price. Apply the rule on product_price in RO CSVI template fields page. Run the import and check.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 5 days ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Thank you for your reply Tharuna.

As we mentioned... we copied price_with_tax to product_price.

Now we need to divide the product_price with 1,24

RO CSVI Combine field rule plugin with Operation as calculation and perform operation as Division does not have anywhere to set 1,24. With what number will the product_price be devided?

divide_to_subtract_vat.png
Attachments (1)
  1. 5 days ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
You can use combine field and set default value to 1,24 in template fields page. You can then use this combine field in the Field combine rule. Let me know on how that goes.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 5 days ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
This did the trick! Thank you Tharuna.
  1. 4 days 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!