Bottle Wine Split Macro
Automatically split orders containing multiple bottles of wine into separate orders for each bottle type and assign them to respective warehouse locations.
Overview
The RIS-RM-2005 – Bottle Wine Split Macro splits orders containing multiple wine bottles into separate orders for each bottle type.
It ensures that different bottle types are separated and assigned to their respective warehouse locations, enabling efficient multi-warehouse processing.
Ensure bottletypelist and locationlist are correctly mapped in sequence to avoid incorrect warehouse assignment.
Purpose
This macro:
-
Identifies items that are wine bottles
-
Splits orders based on bottle type
-
Assigns each split order to the correct warehouse location
👉 In short:
Split one order into multiple based on bottle type and route to correct warehouse.
When It Runs
Used for order routing & warehouse optimization for wine products.
Typically runs:
-
Manually triggered
-
During order processing (before picking & packing)
Parameters
List of orders to be evaluated.
List of wine bottle types (comma-separated).
Corresponding warehouse locations for bottle types.
Example:
bottletypelist = Red Wine, White Wine, Sparkling Wine
locationlist = WarehouseA, WarehouseB, WarehouseC
Mapping:
Red Wine → WarehouseA
White Wine → WarehouseB
Sparkling Wine → WarehouseC
How It Works
Prepare Mapping
Map each bottle type to its corresponding warehouse location.
Evaluate Orders
Review all items within each selected order.
Check Split Requirement
✔ Multiple items with different bottle types → proceed
❌ Same bottle type → no split
Group Items
Group items based on their wine bottle types.
Assign Locations
Assign each group to its mapped warehouse location.
Handle Unmapped Items
Items without matching bottle type are grouped into an “other” order.
Split Order
Create separate orders while retaining the original shipping method.
Final Result
-
Orders are split based on bottle types
-
Each order contains only relevant bottle type items
-
Warehouse locations are correctly assigned
Usefulness
This macro is highly beneficial for:
-
Multi-warehouse operations
-
Faster picking and packing
-
Reducing warehouse confusion
-
Improving order accuracy
Important Notes
-
Applies only when orders contain multiple wine bottle types
-
Bottle types must be properly mapped
-
No split occurs if all items belong to same bottle type
-
Unmapped items go into a separate “other” order
Example Scenario
Key Insight
Splitting orders by wine bottle type and routing them to correct locations significantly improves warehouse efficiency and simplifies fulfilment workflows.
Last updated today
Built with Documentation.AI