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.
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 Senkivagentwrote
=) 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