Apr 10, 2013
Bawul Lee wrote
Say that you published 5000 products...
and you forgot to say "please contact us at ......"
Then you would have to either edit each product or export the description as csv and fix it and reupload... this is a very time consuming work.
How about let us do this by using your mass changer?
We can go to the advanced modifier and go to either the short description or description. Then you would see [current description] there.
If you want to say "thank you" before the existing description, all you have to do is add thank you before [current description].
If you want to say "thank you" after the existing description, all you have to do is add thank you after [current description]. Like [current description]
Thank you.
This would make our life so much easier. especially when you have to make a quick announcement or warning about multiple products.
and you forgot to say "please contact us at ......"
Then you would have to either edit each product or export the description as csv and fix it and reupload... this is a very time consuming work.
How about let us do this by using your mass changer?
We can go to the advanced modifier and go to either the short description or description. Then you would see [current description] there.
If you want to say "thank you" before the existing description, all you have to do is add thank you before [current description].
If you want to say "thank you" after the existing description, all you have to do is add thank you after [current description]. Like [current description]
Thank you.
This would make our life so much easier. especially when you have to make a quick announcement or warning about multiple products.
New
1 vote
Vote
Reply
9 Answers
Apr 11, 2013
Alex Pryshlivskiy
agent
wrote
Hello Kevin!
You can use expressions in Mass Product Changer.
Please use SQL syntax to replace test of description
example : =REPLACE([x],'test','ololol')
see screenshot - http://screencast.com/t/pBELm1UE7LSo
If you need to append text - use CONCAT in expression
=CONCAT([x], 'some text after descr. ')OR
=CONCAT('some text before descr. ', [x])OR
=CONCAT('some text before descr. ', [x], 'some text after descr.')
Don't forget to set Description filed
see screenshot - http://screencast.com/t/BaPdXCUe
You can use expressions in Mass Product Changer.
Please use SQL syntax to replace test of description
example : =REPLACE([x],'test','ololol')
see screenshot - http://screencast.com/t/pBELm1UE7LSo
If you need to append text - use CONCAT in expression
=CONCAT([x], 'some text after descr. ')OR
=CONCAT('some text before descr. ', [x])OR
=CONCAT('some text before descr. ', [x], 'some text after descr.')
Don't forget to set Description filed
see screenshot - http://screencast.com/t/BaPdXCUe
May 06, 2013
Bawul Lee
wrote
Thanks for your help.
What about the title? (item name)
Is there a way to do the something?
or is it just working for the descriptions?
What about the title? (item name)
Is there a way to do the something?
or is it just working for the descriptions?
May 07, 2013
Bawul Lee
wrote
I tried your expressions but I get errors.
Can expressions take things like "<b></b> or <br />" or does it take only plain text?
Can expressions take things like "<b></b> or <br />" or does it take only plain text?
May 19, 2013
Alex Pryshlivskiy
agent
wrote
Kevin, please check once again. It should work. See video example - http://screencast.com/t/ZIPtCc4w3Z
I've tried to replace text for Description -
=REPLACE([x],'Support','<b></b>Support<br />')
I've tried to replace text for Description -
=REPLACE([x],'Support','<b></b>Support<br />')
May 20, 2013
Alex Pryshlivskiy
agent
wrote
There is no possibility to modify product title, BUT, you can do the same operation in product import through expression
see screenshot - http://screencast.com/t/hVl97zWD4iS
see screenshot - http://screencast.com/t/hVl97zWD4iS
Sep 12, 2013
Bawul Lee
wrote
Hi, what would be the following expressions be when you you import the product?
These expressions do not work when you import.
=CONCAT([x], 'some text after descr. ')OR
=CONCAT('some text before descr. ', [x])OR
=CONCAT('some text before descr. ', [x], 'some text after descr.')
These expressions do not work when you import.
=CONCAT([x], 'some text after descr. ')OR
=CONCAT('some text before descr. ', [x])OR
=CONCAT('some text before descr. ', [x], 'some text after descr.')
Sep 13, 2013
Alex Pryshlivskiy
agent
wrote
Hmm... It depend on what field have you have chosen. I don't know what value did you select in current field.
VIDEO Example - http://screencast.com/t/PlYrTYhV
Please watch this short video example of expression concat([FIELD_VALUE], " test")
you need to select Field value for current field where expression was located ....
VIDEO Example - http://screencast.com/t/PlYrTYhV
Please watch this short video example of expression concat([FIELD_VALUE], " test")
you need to select Field value for current field where expression was located ....
Sep 15, 2013
Caroline
wrote
Hi
Do you have any documentation that gives us a list of the possible expressions that could be used in this software?
Thanks
Do you have any documentation that gives us a list of the possible expressions that could be used in this software?
Thanks
Sep 16, 2013
Alex Pryshlivskiy
agent
wrote
Hello Caroline!
You can use SQL logical and conditional operations.
This docimentation was included in Mass Product Changer and Product Import (Expressions Ediotr Window)
Tip: you can use F1 help in Expression window - see screenshot - http://screencast.com/t/djFyt1LZJ0
You can use SQL logical and conditional operations.
This docimentation was included in Mass Product Changer and Product Import (Expressions Ediotr Window)
Tip: you can use F1 help in Expression window - see screenshot - http://screencast.com/t/djFyt1LZJ0