Rishvi
Schedule MacroRIS-SM-2035 – ShippingLableInFTP

Shipping Label Generation & FTP Upload

Generate shipping labels for recent open orders and upload them as PDF files to an FTP server for external access and warehouse integrations.

Overview

The RIS-SM-2035 – ShippingLableInFTP macro generates shipping label PDFs for recent open orders and uploads them to an FTP server.

It enables external systems or warehouses to access shipping labels directly from a centralized FTP location.

Ensure FTP configuration and label templates are correctly set before running this macro.

Purpose

This macro:

  • Fetches recent open orders
  • Generates shipping label PDFs
  • Uploads files to FTP server
  • Automates label distribution

👉 In short:
Generate shipping labels and upload them to FTP.

When It Runs

Used for label generation and integration workflows

Typically runs:

  • Scheduled execution (recommended)
  • Manual execution
  • After order import or before dispatch

Parameters

Note:

  • This macro does not use dynamic parameters
  • FTP configuration and filters are hardcoded inside the macro

How It Works

Initialize Date Filter

Select orders from the last 1 day.

Fetch Open Orders

Retrieve recent open orders from Linnworks.

Identify Eligible Orders

Intended to filter orders without printed labels (currently processes all orders due to logic issue).

Generate Shipping Labels

Generate PDF labels using shipping label template.

Download Label Files

Convert label URLs into file byte data.

Upload to FTP

Upload files using naming format: OrderNumber.pdf

Log Execution

Record success and failure of uploads.

Final Result

  • Shipping labels generated successfully

  • PDF files created for each order

  • Files uploaded to FTP server

  • Orders processed automatically

Usefulness

This macro is highly beneficial for:

  • Automating shipping label generation
  • Centralizing label storage on FTP
  • Reducing manual handling
  • Supporting warehouse integrations
  • Improving operational efficiency

Important Notes

  • Label filtering logic is incorrect (bug present)

  • File download method may fail (null response issue)

  • FTP credentials are hardcoded

  • No retry mechanism for failed uploads

  • No duplicate file handling

  • Processes only last 1 day orders

  • Risk of null reference errors

Example Scenario

Key Insight

While this macro automates label generation and FTP upload, fixing filtering and file handling issues is critical to ensure reliable and production-ready performance.

Was this page helpful?

Last updated today

Built with Documentation.AI