Price calculation is not working during import
Home > Public Forum > OpenCart Users Forum > Store Manager for OpenCart > Price calculation is not working during import

Price calculation is not working during import

Sep 26 (7 months ago)
Anonymous wrote
While doing my database import I need to increase dealer cost field by 10%. According to the expression editor this is done by creating an expression, [CSV_COL(3)]*1.1 CSV_COL(3) is my dealer cost. This should do a 10% increase during import but it is not.

When I execute the expression I get the original dealer and the Last Execution Result: is 0

It seems the expression editor is not functioning correctly.

Suggestions, ideas are appreciated.
Reply
4 Answers
Sep 26 (7 months ago)
Yana Kostyk agent wrote
Thanks you for letting us know your issue
You get a " $ " at your price field that is why the expression does not work correct

If all your prices starts with "$" you can use this expression SUBSTR([CSV_COL(3)], 2)*1.1

It will start to read your price correct without that "$" and will increase that price for 10%

Please check it out and let us know how it is going
Wish you a great day
Sep 26 (7 months ago)
Anonymous wrote
Worked! Your the best.

I'll buy you a bear if you're ever in Milwaukee.

Thanks.
Sep 26 (7 months ago)
Anonymous wrote
Make that a BEER you really don't want a bear.
Sep 27 (7 months ago)
Yana Kostyk agent wrote
=) happy to know that it works for you

Feel free to contact us again also via live chat ( you can find live chat icon here at our main page https://emagicone.com/ ) of submit us a ticket here https://support.emagicone.com/submit_ticket with tech issues

Have a great day ))