Adding this as a quick note here, will expand explanation later:
Manual run
- Export in spreadsheeet
- Calculate the new number
=CONCATENATE(ROUND(C4*1.19, 2), " EUR")
- Set as sup feed
Automatic calculation with Shopstory
- Create supplemental feed through Shopstory which calculates what you need to do
- Connect it to Feed & Language
- Set attribute rule
Notes on updating the supplemental feed through a Google Drive speadsheet:
- If you're updating the price through the supplemental feed you need to have the price format in "X [CURRENCY", for example "473 USD". Skipping the currency makes it not work (but without showing an error)
- This will then result in the price being a text field, not numeric or price field.
