Change Country to UK
Normalize orders by converting country "Jersey" to "United Kingdom" for shipping and billing addresses, ensuring correct CountryId mapping and courier compatibility.
Overview
The RIS-SM-2270 – Change Country to UK macro standardizes address data by converting orders with country set as "Jersey" into "United Kingdom".
Use this macro before shipping label generation to avoid courier and tax issues caused by Jersey being treated as a separate country.
Purpose
This macro:
-
Identifies orders with country "Jersey"
-
Converts them to "United Kingdom"
-
Updates both shipping and billing addresses
-
Applies correct CountryId mapping
👉 In short:
Detect Jersey → convert to UK → update → save.
When It Runs
Typically executed:
-
After order import
-
Before shipping label generation
-
For UK-based fulfillment
-
During data cleanup
-
When sales channels send Jersey separately
-
Manually or via automation
Parameters
Optional list of orders to process.
Note: Even if OrderIds are provided, the macro processes open orders from the last 45 days.
Simple Explanation
The macro scans open orders, detects those with country set to "Jersey", converts them to "United Kingdom", updates the CountryId, and saves the changes.
Step-by-Step Flow
Start Macro
Log macro start and initialize execution.
Apply Date Filter
Fetch open orders from the last 45 days.
Get UK Country Reference
Retrieve "United Kingdom" and its corresponding CountryId.
Loop Through Orders
Process each order individually.
Check Shipping Address
If shipping country = "Jersey":
Check Billing Address
If billing country = "Jersey":
Save Changes
Save order only if updates were made.
Logging
Log updated orders, skipped cases, and errors.
Final Result
-
Country updated from Jersey to United Kingdom
-
Shipping and billing addresses standardized
-
Correct CountryId applied
Usefulness
-
Courier Compatibility – Works with systems treating Jersey as UK
-
Data Standardization – Ensures consistent country values
-
Automation – Eliminates manual correction
-
Error Prevention – Avoids shipping and tax issues
Example Scenario
Key Insight
This macro follows a simple flow:
Order → Detect Jersey → Convert to UK → Update → Save.
It prevents incorrect shipping zones, courier failures, inconsistent country data, and tax-related issues.
Last updated today
Built with Documentation.AI