Export Labels to 3PL via SFTP

Overview

Export Labels to 3PL via SFTP is a scheduled label-export solution for Linnworks. It identifies eligible open orders, generates a PDF label file for each qualifying order, uploads the file to a configured SFTP folder, and marks successful orders with an export identifier.

The macro searches open orders associated with a configured Linnworks stock location. It then applies additional eligibility checks, including the vendor channel source, current despatch date, label-print status, and whether the export identifier has already been assigned.

For each eligible order, the macro generates PDF output using its configured print template and printer setup. The generated PDF URL and SFTP connection details are then passed to the configured upload service.

Only orders whose files upload successfully are assigned the export identifier.

Generate vendor-channel PDF labels automatically and deliver them to a 3PL through a scheduled SFTP export workflow.

Who Should Use Export Labels to 3PL via SFTP

Key Features

How Export Labels to 3PL via SFTP Works

Export Labels to 3PL via SFTP follows a defined sequence whenever its configured schedule runs.

Configure the Macro

Once the app has been installed, create a macro configuration so the system knows when the macro should run, which stock location should be checked, and where the generated PDF labels should be uploaded.

This configuration can be updated at any time to suit your operational requirements.

Steps to Configure

Key Benefits

Generating labels manually and transferring each file to SFTP can be repetitive and prone to delay. Export Labels to 3PL via SFTP combines order selection, PDF generation, upload, and successful-export identification into one scheduled process.

Reduce manual label handling while giving the 3PL a consistent SFTP location for incoming PDF files.

Usage of App

Export Labels to 3PL via SFTP is designed to run through the Linnworks Macro Schedule Engine.

It does not require selected OrderIds. Each execution searches open orders at the configured location and evaluates them against the macro's eligibility rules.

Execution

Trigger via Schedule

Configure a one-time or recurring schedule, enter the required location and SFTP values, save the configuration, and enable the macro.

Outcome

When the scheduled macro runs, it:

The remote file name follows this format:

{OrderNumber}_Shipping Labels.pdf

For example:

100245_Shipping Labels.pdf

A representative result is:

Input Parameters

Export Labels to 3PL via SFTP uses the following configuration values:

Example configuration:

The macro also relies on internal or previously configured values that are not named in the supplied parameter list:

The supplied documentation does not state the exact names or values of these internal settings.

Best Practices

Test order filtering, PDF generation, SFTP access, and identifier assignment with controlled orders before enabling a recurring production schedule.

The following checks can help diagnose common issues:

FAQ

How is Export Labels to 3PL via SFTP triggered?

The macro runs through a one-time or recurring schedule configured in Linnworks Macro Configuration.

Does the macro use OrderIds?

No. It retrieves open orders directly from the configured stock location.

Which macro should be selected in Macro Configuration?

Select Vendor Label SFTP Export.

Which parameters are mandatory?

LocationName, SFTP_server, SFTP_user, and SFTP_password are required.

What happens when SFTP_port is blank?

The macro uses port 22.

What happens when SFTP_fullPath is blank?

The macro uses its default configured processing folder.

Must LocationName match exactly?

Yes. The value must match the Linnworks stock location name used by the macro.

Which orders are searched?

The macro retrieves recent open orders from the configured stock location.

What date range is used for the open-order search?

The documented range covers the previous 14 days through the next day.

Which orders remain eligible after retrieval?

Orders must match the configured vendor channel, have a despatch date equal to the current date, have no label-printed flag, and not already carry the export identifier.

What happens when no orders match?

The macro logs that no matching orders were found and stops.

How is the PDF created?

The macro uses its configured print template and printer setup.

What happens when no PDF URL is returned?

The order is skipped and an error is written to the log.

How are uploaded files named?

Each file uses the order number followed by _Shipping Labels.pdf.

Does the macro connect directly to SFTP?

The source states that the PDF URL and SFTP details are sent to a configured upload service.

When is the export identifier applied?

Only after the upload service confirms that the PDF was uploaded successfully.

What happens when the upload fails?

The failure is logged and the order is not added to the successful-upload list.

Does the macro create the export identifier?

Yes. It creates the configured identifier when required before assigning it to successful orders.

Are orders with the identifier processed again?

No. They are skipped.

Does the macro set the label-printed flag?

The source states that the label-printed flag is checked during filtering. It does not state that this macro changes the flag.

Can multiple orders be processed during one run?

Yes. The macro can generate and upload multiple PDF files in one scheduled execution.

Does an error on one order stop all processing?

The documented behaviour states that an order-level error is logged and processing continues with the next order.

What happens when a general error occurs?

The error details are written to the macro log.

What should be checked when an expected order is missing?

Review its stock location, vendor source, despatch date, label-print status, and existing identifiers.

What should be checked when the SFTP file is missing?

Review the upload response, remote path, connection details, permissions, and order-specific log entries.

What should be checked when the macro does not run?

Confirm that the macro configuration is enabled and that the schedule has been saved and enabled.

Legal Information

• Privacy Policy: https://rishvi.co.uk/privacy-policy/
• Terms and Conditions: https://rishvi.co.uk/terms-conditions/

Please review these pages to understand how data is handled and the terms governing the use of this application.

Access to the macro configuration should be restricted because it contains SFTP connection details and controls the automatic export of shipping-label documents.

Summary

Export Labels to 3PL via SFTP automates scheduled PDF label generation and transfer for eligible vendor-channel orders.

Once configured and enabled, the macro validates the SFTP settings, finds the required Linnworks stock location, retrieves recent open orders, applies the vendor, despatch-date, label-status, and identifier filters, generates PDF label files, and uploads them to the configured SFTP folder.

For orders or files that do not process as expected, review the macro schedule and enabled status, confirm the exact stock location name, verify the SFTP connection and path, check the print-template output, and inspect the order-specific upload logs.