I have a question about modifying customer order data that we extract from Shopify orders before sending to a Purchase order in Xero.
The issue I’m having is this…
Some information has been blanked out in yellow for customer privacy
Some of our Shopify orders originate in eBay and are imported into Shopify via an integration.
This integration communicates some information with Shopify that we want to remove before sending to a Xero purchase order. This information is as follows:
- The eBay-Shopify integration places the eBay username in the Shopify “Shipping Address Last name” field. You’ll see it in brackets in the above screenshot (jonesmal). We want to remove this before sending the “Shipping Address Last name” field data to Xero. I’m wondering if there’s a way we can do a find and replace or similar to tell Make to look at the “Shipping Address Last name” field and if it includes an opening bracket “(” then remove the bracket and everything after it.
- The eBay-Shopify integration also places an eBay unique code on one of the address lines — in the screenshot you’ll see this as ebayq24dvx6. As per the above, I’m wondering if we can tell Make to strip out any text from the address field that starts “ebay”
Any advice would be greatly appreciated!