Categories
View Replies (2)

Resolved 2 questions about rules

  1. liaskas
    liaskas
  2. RO CSVI
  3. Thursday, 06 May 2021
  4.  Subscribe via email
Hello

Question 1

We are creating an import of products from an XML file to Hikashop. The xml file has the product_price and we want to add a 20% and on the increased by 20% value to add a 24% VAT.

We created the template field to get the product_price from the XML and assigned to it a rule to add a 20% on it. This is our profit. We also added a rule to copy the increased by 20% price to price_with_tax field.

Then we created another rule to add a 24% VAT to template price_with_tax field.

On the import preview, the product_price is correctly increased by 20%
The price_with_tax does not get the increased by 20% product_price and it calculates the VAT from the imported product_price.

We are probably missing something here. Can you please advise?

Question 2

We need to skip importing of products that their price is less than 16 euros. How can we do this by creating a rule? This can not be done with a comma separated list of values. Can you please point us to the right direction?

Thank you
0
Responses (2)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
On the import preview, the product_price is correctly increased by 20%
The price_with_tax does not get the increased by 20% product_price and it calculates the VAT from the imported product_price.

How do you have price_with_tax value set in template? You should copy the value from product_price using RO CSVI field copy rule to get the 20% more of product_price.

We need to skip importing of products that their price is less than 16 euros. How can we do this by creating a rule? This can not be done with a comma separated list of values. Can you please point us to the right direction?

Please check RO CSVI Skip rule plugin. This rule will skip the record based on the values. The problem i see here is that skip rule does not have a condition to check if a value is less than 16 euros so what i would suggest is to create a conditional rule first and replace the values less than 16 euros to some standard value like Yes or replace. You can then use this standard value in Skip rule to skip the record. The order of the rule applied on template field should be Conditional rule first and then Skip rule. I hope i have explained it clear.
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
liaskas
liaskas
Accepted Answer Pending Moderation
Thank you...
everything works great now.
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


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