FBA Transfer Macro
Automatically create warehouse stock transfers from orders and optionally cancel processed orders.
Overview
The RIS-SM-1010 – FBA Transfer Macro converts eligible orders into warehouse stock transfers between locations.
It automates stock movement (e.g., Default → FBA) and can optionally cancel the original orders after successful transfer completion.
Ensure warehouse locations and folders are correctly configured before running this macro to avoid incorrect stock movement.
Purpose
This macro:
-
Identifies eligible orders
-
Creates warehouse stock transfers
-
Optionally cancels processed orders
👉 In short:
Convert orders into stock transfers between locations.
When It Runs
Used for stock movement & warehouse automation
Typically runs:
-
Scheduled execution
-
Manually triggered
Parameters
Source warehouse location.
Destination warehouse location.
True to cancel order after transfer.
Filter orders by company or customer name.
Process only orders within this folder.
Process orders created within the last specified number of days.
Specific order number for testing purposes.
Example:
Move stock from Default → FBA and process only orders in the FBA Transfer folder.
How It Works
Validate Locations
Verify source and destination warehouse locations.
Fetch Orders
Retrieve open orders from the source location.
Apply Filters
Filter orders by date, folder, company name, or test order.
Create Transfer
Generate a warehouse transfer with a unique reference.
Add Items
Add all order items to the transfer, including composite items.
Assign Bin
Create and assign bin using order reference.
Process Transfer
Move transfer through stages: Request → Accepted → Delivered
Update Quantities
Update sent quantities for all items.
Optional Order Cancellation
Cancel order if isorderdelete = True.
Finalize Transfer
Mark transfer as Delivered.
Final Result
-
Orders converted into warehouse transfers
-
Stock moved between locations
-
Composite items handled correctly
-
Orders optionally cancelled after processing
Usefulness
This macro is highly beneficial for:
-
Automating FBA and internal transfers
-
Reducing manual warehouse work
-
Ensuring accurate stock movement
-
Handling bundled/composite items
-
Supporting bulk transfer operations
Important Notes
-
Processes only orders in specified folder
-
Company name must match Company or Full Name
-
All items in the order are included
-
Order cancellation is irreversible
-
Composite items are split into components
-
testorder overrides bulk processing
-
Requires correct warehouse configuration
Example Scenario
Key Insight
Converting orders into structured warehouse transfers ensures accurate inventory movement, improves operational efficiency, and simplifies multi-location stock management.
Last updated today
Built with Documentation.AI