Feb 27, 2013
Mark
wrote
Exactly how do I do it? I grabbed Store Manager just for this particular function. So far the software is ok...
Whats the expression if I want to increase prices by 10%
Whats the expression if I want to increase prices by an exact amount such as $15
I think some clearer explanation needs to be made in http://virtuemart-manager.com/useful-articles/tips-tricks/accomplish-virtuemart-products-update-in-bulk-with-mass-product-changer/
Whats the expression if I want to increase prices by 10%
Whats the expression if I want to increase prices by an exact amount such as $15
I think some clearer explanation needs to be made in http://virtuemart-manager.com/useful-articles/tips-tricks/accomplish-virtuemart-products-update-in-bulk-with-mass-product-changer/
Reply
3 Answers
Feb 28, 2013
Kateryna Beliukh
agent
wrote
Thank you for your questions.
To increase the product price from your database by 10%, use the formula [FIELD_VALUE]*1.1
To increase the price specified in the .csv file, use the formula [CSV_COL(INDEX)]*1.1, where the INDEX is the number of the .csv column. If you want to increase price by an exact amount such as $15, use following expression: [FIELD_VALUE]+15
We will add this information to users manual. Let us know if any other assistance is needed!
To increase the product price from your database by 10%, use the formula [FIELD_VALUE]*1.1
To increase the price specified in the .csv file, use the formula [CSV_COL(INDEX)]*1.1, where the INDEX is the number of the .csv column. If you want to increase price by an exact amount such as $15, use following expression: [FIELD_VALUE]+15
We will add this information to users manual. Let us know if any other assistance is needed!
Feb 28, 2013
Mark
wrote
Doesnt work
Cannot evaluate expression "[product_price]*1.1". Error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[product_price]*1.1' at line 1"
Cannot evaluate expression "[product_price]*1.1". Error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[product_price]*1.1' at line 1"
Mar 01, 2013
Kateryna Beliukh
agent
wrote
Unfortunately, we can not reproduce this issue from our side.
Please, submit a ticket here:
http://support.emagicone.com/submit_ticket
and attach your database backup. so we could check this using your data. Waiting to hear from you!
Please, submit a ticket here:
http://support.emagicone.com/submit_ticket
and attach your database backup. so we could check this using your data. Waiting to hear from you!