Printing Labels via SFTP to 3PL
Identify orders ready for dispatch, generate shipping label PDFs, send them to a 3PL system via SFTP, and mark orders as exported.
Overview
The RIS-SM-2210 – Printing Labels via SFTP to 3PL macro automates shipping label creation and delivers them to the warehouse or 3PL system via SFTP, ensuring smooth dispatch operations.
Ensure correct SFTP credentials and warehouse location configuration before running this macro.
Purpose
This macro:
-
Identifies orders ready for dispatch
-
Generates shipping label PDFs
-
Sends files to a 3PL system via SFTP
-
Marks orders as exported
👉 In short:
Create labels → send via SFTP → mark orders as processed.
When It Runs
Typically executed:
-
During daily shipping batch processing
-
Before order dispatch
-
After order confirmation
-
Manually or via scheduled 3PL integration workflows
-
For Amazon Vendor order handling
Parameters
Warehouse location filter.
SFTP server address.
SFTP username.
SFTP password.
Destination folder path on the SFTP server.
SFTP port (default: 22).
All SFTP parameters and LocationName must be provided for successful label upload.
Simple Explanation
The macro retrieves eligible orders, generates their shipping labels, uploads them to the 3PL system via SFTP, and marks the orders as exported.
Step-by-Step Flow
Fetch Orders
Retrieve open orders from the selected warehouse (last 14 days).
Filter Eligible Orders
Orders must:
Loop Through Orders
Process each order individually.
Generate Label PDF
Create shipping label using the template and return a downloadable file link.
Download Label File
Download the PDF and convert into the required file format.
Prepare Upload Data
Build the payload with:
Send to SFTP / 3PL
Upload the file to the 3PL system using SFTP API.
Track Processed Orders
Maintain a list of successfully processed orders.
Assign Identifier
Assign the tag "Export Labels to Delamode" and create identifier if not exists.
Error Handling & Logging
Log successes and failures, skipping failed orders safely.
Final Result
-
Shipping labels generated (PDF)
-
Files uploaded to 3PL system via SFTP
-
Orders marked as exported
Usefulness
-
Automation – Eliminates manual label handling
-
3PL Integration – Direct communication with warehouse systems
-
Time Saving – Processes bulk orders efficiently
-
Error Tracking – Logs any failures clearly
-
Accuracy – Processes only valid and eligible orders
Example Scenario
Key Insight
By automating label generation and SFTP upload, this macro streamlines warehouse operations, reduces manual effort, ensures accurate order processing, and enables seamless integration with third-party logistics systems.
Last updated today
Built with Documentation.AI