SQL - Mass Product Changer
Apr 22 (3 months ago)
Martin wrote
Im trying to use Mass Product Changer to set the Field value of the Location field to the value currently stored in the field Reference. Can someone help me how to write the SQL lines for doing that?

So I want field_Location = field_Reference

Reply
2 Answers
Avatar image
Apr 26 (2 months ago)
Nadia Bezpalko agent wrote
Thanks for your post. If you want to replace the Location field with the value in the Reference, then you need to use just the expression https://prnt.sc/123g0m8
https://prnt.sc/123g2ew

[FIELD([FIELD(reference)VALUE])VALUE]
May 03 (2 months ago)
System wrote
Hello,

We haven't heard back from you for last 7 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com

Maybe we are waiting for some information from your side? In this case please get back to us.

In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.

If you do not reply us back, the ticket will be automatically closed within 24 hours.

With kind regards,

The eMagicOne Administration Team