Burlington Account Integration

Overview

Burlington is a retail company with over 1,000 stores across the United States, offering a wide variety of brand-name clothing, footwear, accessories, home goods, and baby items at discounted prices. Burlington also promotes savings through its credit card and loyalty programs.

Integrating Burlington into your Sellercloud account allows you to seamlessly import orders, upload tracking information, and ensure your Burlington store is always up-to-date with the latest inventory data. This integration works through EDI documents, transmitting information between the two services via plugins and Scheduled Tasks.

If necessary, you can open a ticket with Sellercloud Support to request additional customizations or other plugins for this integration. Any such modifications will be billable.

To have a dedicated representative complete the testing for your account and ensure that the setup is configured correctly, we recommend Premium Support.

Prerequisites

Before you can integrate Burlington with Sellercloud, complete the following requirements.

We recommend creating a Company where you will set up the Custom Company Settings and automate the plugins with Scheduled Tasks.

Sellercloud Support

Open a ticket with Sellercloud Support to request a VAN for the integration, as well as the following plugins be installed on your server:

  • Burlington 850 Order Import – Imports orders from Burlington to Sellercloud in EDI 850 format.
  • Burlington 856 Tracking Export – Exports tracking information to Burlington in EDI 856 format.
  • Burlington 810 Invoice Export – Exports invoices to Burlington in EDI 810 format.
  • Burlington 846 Inventory Export – Exports inventory to Burlington in EDI 846 format.
  • Burlington Packing Slip – Generates a printable PDF packing slip in a format that complies with Burlington’s requirements.

Custom Company Settings

Create the following Custom Company Settings.

On your default company:

  • STControlNumber
  • GSControlNumber
  • ISAControlNumber
ISAControlNumber, GSControlNumber, and STControlNumber can all start at 1. Tracking and inventory exports will increment this number accordingly as jobs are processed. If the settings already exist and have values in them, do not edit them.

Either on the company created for the integration or on the default company:

  • Burlington_CustomerISAID – Enter a unique phone number that is not used for any other integration.
  • Burlington_ISAID – Burlington’s unique identifier for EDI document transmission – contact them for the value of this setting.
  • Burlington_CustomerQualifier – Set to ZZ.
  • Burlington_Qualifier – Set to ZZ.
  • (Optional) Burlington_MarkOrdersUnpaid – Set to True to mark orders as Unpaid.
  • (Optional) Burlington_HandlingFeePerOrder – Enter an amount to be added as the Handling Fee on each order.

Custom Product Columns

Create the following Custom Product Columns:

  • Burlington_ItemID – The product’s SKU at Burlington.
  • (Optional) Burlington_Enabled – Enable only specific products for Burlington. Set to True for any products you want to send with the Inventory Export plugin.
  • (Optional) Burlington_SafetyQty – A Safety Quantity for products on Burlington.

Order Import

This plugin imports order data from Burlington to Sellercloud in EDI 850 format.

It matches products in Sellercloud by the value in their Burlington_ItemID Custom Product Column. If this value doesn’t match, it uses the SKU, and if that doesn’t match, it uses the UPC.

This is how the plugin processes orders:

  • The Shipping Method is set as follows:
    • Domestic orders as FedEx Ground
    • AL or PR orders as FedEx International Economy
  • Orders cancelled on Burlington will be marked as Cancelled in Sellercloud only if they are not shipped.
  • Replacement orders on Burlington are deleted and recreated in Sellercloud based on the new order details. 
  • When the plugin marks an order as Unpaid, it also marks it as a Wholesale Order.
  • Upon import, the plugin adds Order Item Notes with the Size, Color, and Style of the product as set up on Burlington. This information is used in the PDF Invoices.

Automate Order Import

To create a Scheduled Task that imports orders:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:
    1. Click Task Type and select Import Orders.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. The newly created Scheduled Task Details page will open automatically. Click the Edit button at the top right corner.
  5. In the Details panel:
    1. Click Create Orders For Company and select the company designated for this integration.
    2. Click the Plugin menu and select Burlington 850 Order Import.
  6. In the Import Options panel, set Import From to FTP and enter your VAN credentials.
  7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. In the General panel, click the Enable button.
  9. Click Save.


Tracking Export

This plugin exports tracking from Sellercloud to Burlington following the 856 EDI format. 

Before you move on, create a Saved Search for orders filtered by:

  • Company – The company you created for the integration
  • Order Status – InProcess Or Completed
  • Shipping Status – FullyShipped
  • Payment Status – Charged
  • Tracking Uploaded – No

Automate Tracking Export

To create a Scheduled Task that exports order tracking:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:
    1. Click Task Type and select Export Orders.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. On the Scheduled Task page, click the Edit button at the top right corner.
  5. In the Details panel:
    1. Click the User ID menu and select your ID.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select Burlington 856 Tracking Export.
    4. Check This Is Tracking Export.
  6. In the Export Options panel, set Export To to FTP and enter your VAN credentials.
  7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. In the General panel, click the Enable toggle button.
  9. Click Save.


Invoice Export

This plugin exports invoices from Sellercloud to Burlington in EDI 810 format.

Before you move on, create a Saved Search for orders filtered by:

  • Company – The company you created for the integration
  • Shipping Status – Fully Shipped
  • Order Status – InProcess Or Completed
  • Invoice Uploaded – No
  • Tracking Uploaded – Yes

Automate Invoice Export

To create a Scheduled Task that exports invoices:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:
    1. Click Task Type and select Export Orders.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. On the Scheduled Task page, click the Edit button at the top right corner.
  5. In the Details panel:
    1. Click the User ID menu and select your ID.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select Burlington 810 Invoice Export.
    4. Check This Is Invoice Export.
  6. In the Export Options panel, set Export To to FTP and enter your VAN credentials.
  7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. In the General panel, click the Enable toggle button.
  9. Click Save.


Inventory Export

This plugin exports inventory from Sellercloud to Burlington in EDI 846 format. The vendor address comes from the Company Settings page of the company where the Scheduled Task is running.

The plugin exports products only if they have both a Burlington_ItemID and a UPC.

To set a Safety Quantity for your products, use the Custom Product Column Burlington_SafetyQty.

Optionally, you can enable only specific products for Burlington by setting their Burlington_Enabled Custom Product Column to True:

  • For one product at a time: go to the Product Details Page > click Toolbox and select Custom Columns > click Edit, update the Burlington_Enabled column, and Save.
  • For multiple products in bulk: follow the steps to Bulk Update Products and use the Burlington_Enabled column – set it to True for all products you want to enable.

Unlike core integrations, plugin integrations don’t require products to be in the company with the scheduled tasks. The export will include the products you select with your Saved Search.

Next, create a Saved Search for products filtered by Burlington_Enabled True. Optionally, you can add more filters to the search to narrow down the export further.

Automate Inventory Export

To create a Scheduled Task that exports inventory:

  1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
  2. Click the green + icon: Create New Scheduled Task.
  3. Complete as follows:
    1. Click Task Type and select Export Products.
    2. Set the Task Name.
    3. Select the Company.
    4. Select the Start Time.
    5. Click CREATE.
  4. On the Scheduled Task page, click the Edit button at the top right corner.
  5. In the Details panel:
    1. Click the User ID menu and select your ID.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select Burlington 846 Inventory Export.
  6. In the Export Options panel, set Export To to FTP and enter your VAN credentials.
  7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  8. In the General panel, click the Enable toggle button.
  9. Click Save.


Configure PDF Invoices

With the Burlington Packing Slip plugin set up under your designated company, you can print PDF invoices with information about your orders and the products they include through Sellercloud or Shipbridge. 

The plugin gets the Style, Color, and Size from the Order Item Notes set by the Order Import plugin.

To set up the invoice plugin:

  1. Go to the Company Settings of the company you created for the integration.
  2. Click Toolbox and select Invoice Settings.
  3. Click Per Channel Preferences.
  4. For Website, select Plugin > Burlington Packing Slip.
  5. Click Save.

Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support