Bill To Change Based on SubSource
Automatically update billing address based on order source (SubSource) for improved accuracy and automation.
Overview
The RIS-RM-2001 – Bill To Change Based on SubSource macro updates the billing address of orders dynamically based on their originating sales channel (SubSource).
It ensures that orders from platforms like Amazon or eBay are assigned predefined billing details automatically, maintaining consistency across all channels.
Ensure that SubSource values and address mappings are correctly aligned in comma-separated format to avoid mismatches.
Purpose
This macro:
-
Detects the order source (SubSource)
-
Matches it with predefined billing configurations
-
Replaces existing billing details automatically
👉 In short:
Orders from specific platforms get the correct billing address automatically.
When It Runs
Used for billing automation & order standardization
Typically runs:
-
Manually when triggered by a user
-
Automatically during order processing workflow
Parameters
List of order IDs to be updated.
Order origin (e.g., Amazon, eBay).
Email address assigned to billing.
Address line 1.
Address line 2.
Address line 3.
City name.
ZIP / PIN code.
Company name.
Country name.
Customer full name.
All parameter values must be provided in comma-separated format and mapped sequentially to ensure correct alignment between SubSource and corresponding address details.
How It Works
Fetch Orders
Retrieve the list of orders to process using provided OrderIds.
Identify Source
Detect the SubSource of each order.
Match Configuration
Compare SubSource with predefined mapping values.
Apply Address
Select and assign corresponding billing address details.
Update Order
Replace existing billing address and save the order.
Final Result
-
Billing address updated automatically
-
No manual intervention required
-
Consistent and accurate data maintained
Usefulness
This macro is highly beneficial for:
-
B2B and wholesale workflows
-
Multi-channel order management
-
Reducing manual effort
-
Ensuring billing consistency
Example Scenario
Key Insight
Automating billing address updates based on SubSource improves operational efficiency, minimizes human errors, and ensures consistent data across all sales channels.
Last updated today
Built with Documentation.AI