Price calculation is not working during import

Sep 26, 2016

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.

emagic1.jpg

emagic2.jpg

emagic3.jpg

4 Answers

Sep 26, 2016

Yura Senkiv 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, 2016

wrote

Worked! Your the best.

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

Thanks.

Sep 26, 2016

wrote

Make that a BEER you really don't want a bear.

Sep 27, 2016

Yura Senkiv 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 ))