Macro to Update Composite Bin Racks
Retrieves composite SKUs, collects bin rack locations of component items, generates a CSV report, and uploads it to an FTP server.
Overview
The RIS-SM-2136 – Macro to Update Composite Bin Racks helps warehouse teams visualize where all components of bundled (composite) SKUs are stored, streamlining picking and stock audits.
In simple terms:
It creates a file showing where all components of bundle products are stored and uploads it to an FTP server.
Purpose
This macro:
-
Retrieves composite (parent) SKUs
-
Collects bin locations of all component items
-
Generates a structured CSV report
-
Uploads the CSV to an FTP server
-
Logs success or failure
When It Runs
Typically executed:
-
On daily or hourly schedules
-
Before picking operations
-
During warehouse audits
-
For bin location analysis of composite products
Parameters
FTP server address used for uploading CSV file.
FTP username for authentication.
FTP password for authentication.
Enable or disable secure connection.
FTP port number.
Destination folder path for the CSV file.
These parameters allow the macro to securely connect and upload the generated CSV file to the FTP server.
Tables Used
-
StockItem – Composite (parent) SKU details
-
Stock_ItemComposition – Links parent SKUs to component items
-
ItemLocation – Stores bin/rack locations
Simple Explanation
The macro finds all bundle (composite) products, retrieves bin locations of their component items, creates a CSV file listing all bins per parent SKU, and uploads the file to an FTP server for warehouse visibility.
Step-by-Step Process
Fetch Composite Data
Use Api.Dashboards.ExecuteCustomScriptQuery to retrieve master SKUs, child items, and bin rack locations.
Prepare Data Structure
Convert query results into a structured format suitable for CSV export.
Group by Master SKU
Combine all component bin racks under each parent SKU.
Clean Bin Data
Remove null or empty bin locations to ensure data quality.
Create CSV File
Format: Master SKU → BinRacks
Separate multiple bins using "|" symbol.
Upload to FTP
Connect using provided FTP parameters and upload CSV via ProxyFactory.GetFtpUploadProxy.
Logging & Validation
Log success or failure, handle errors safely.
Final Result
The macro generates and uploads a CSV file containing:
-
Master SKU (Composite item)
-
Combined bin rack locations of all components
Usefulness
-
Warehouse Optimization – Locate all components easily
-
Picking Efficiency – Faster collection of items
-
Inventory Visibility – Clear storage mapping
-
Automation – Eliminates manual tracking of composite SKUs
Example Scenario
Key Insight
This macro links composite SKUs with all their component bin locations, enabling faster picking, reducing errors, and improving overall warehouse efficiency by ensuring no components are missed during order processing.
Last updated today
Built with Documentation.AI