Resolved Discount from the total

Hello Davide,
Try using CSVI Margin plugin. The document explains for import but creating rule is same for export. Create the rule and apply it on the export field.

Hi Tharuna,

thank you very much.

Which is the VM field with the subtotal?

Thanks,
Davide

Just found ordersalesPrice, applied Margin rule, but the calculation is not done.

In the order_total, yes, but I need to do it in the ordersalesPrice.

How can I do it?


Thanks.
Davide

Hello Davide,
The field is order_salesPrice and not ordersalesPrice. If the calculation is working on order_total then it is the same way for order_salesPrice field. Can you post screenshot on how you have set your rule?

Hello,

yes, I wrote wrong, sorry.
In attachment the screenshots.

Thanks.
Davide

Hello Davide,
Rule settings looks good. The only reason i could see the rule not working or applied could be that values of order_salesPrice field is not greater than 1800. Are you sure the exported values for order_salesPrice are all above 1800?

Yes, the export in attachment.

Hello,
I created a test VirtueMart order export on my local site with margin rule applied to order_salesPrice field and it does work. I am not sure why the rule is not working for you. Is it only the issue with order_salesPrice price field?

Hello,

it seems yes...

Thanks.
Davide

Hello Davide,
Can you send me the backup of your export template? I will run it here and see what happens. You can get the backup of your template by going to Maintenance -> CSVI Pro -> Backup template. Download the XML file and post it.

Hello,

just sent to you in pm.


Thanks.

Hello Davide,
You have two order_salesPrice fields in your export template. One with margin rule applied and another without rule. I guess you are checking the field without the rule in your export. Remove this field or check the field with rule applied on export.