Auto Map Macro
Automatically map inventory items with channel listings using SKU-based matching rules.
Overview
The RIS-SM-1002 – Auto Map Macro automatically links inventory items in Linnworks with their corresponding listings on sales channels like Amazon and eBay.
It uses predefined SKU formats to intelligently match products, eliminating the need for manual mapping and ensuring seamless synchronization.
Ensure SKU formats are consistent across inventory and channel listings for best results.
Purpose
This macro:
-
Retrieves inventory and channel listing data
-
Matches items using SKU format rules
-
Automatically links (maps) items across systems
👉 In short:
Automatically connects inventory items with channel listings using SKU patterns.
When It Runs
Used for channel integration & inventory mapping
Typically runs:
-
Manually during setup
-
During ongoing maintenance of listings
Parameters
Sales channel (e.g., Amazon, eBay).
Sub-channel or regional marketplace.
SKU matching rule (e.g., AMZ-#SKU).
Example: Inventory SKU = ABC123 Channel SKU = AMZ-ABC123 skuformat = AMZ-#SKU Here, #SKU is dynamically replaced with the inventory SKU.
How It Works
Retrieve Sales Channels
Fetch all connected sales channels (e.g., Amazon, eBay).
Apply Filters
Apply source and subsource filters if provided.
Auto-Link Attempt
Execute built-in auto-linking using existing system logic.
Find Unlinked Listings
Identify channel listings not yet linked to inventory.
Fetch Inventory Items
Retrieve all relevant inventory products.
Match SKUs
Replace #SKU in format and compare with channel SKUs.
Prepare Mapping Data
Build structured mapping pairs between inventory and channel items.
Link Items
Map inventory items to channel listings using system APIs.
Final Result
-
Inventory items successfully mapped to channel listings
-
Unlinked items significantly reduced
-
Stock, pricing, and order synchronization works correctly
Usefulness
This macro is highly beneficial for:
-
Reducing manual mapping effort
-
Speeding up product onboarding
-
Minimising human errors
-
Ensuring consistent stock synchronization
Important Notes
-
SKU formats must be consistent across systems
-
Incorrect SKU patterns may cause mapping failures
-
Already linked items are automatically skipped
Example Scenario
Key Insight
Using structured SKU patterns for automated mapping simplifies multi-channel integration, improves accuracy, and reduces operational overhead.
Last updated today
Built with Documentation.AI