Searching...

Big Lots Account Integration

Overview

Big Lots is a large retail company that offers a wide range of consumer goods at discounted prices. The company also lets merchants sell products, including food, furniture, seasonal items, and electronics, through their online store using their dropship program.

Integrating Big Lots into your Sellercloud account allows you to seamlessly import orders, upload tracking information and invoices, and ensure your listings are 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 Big Lots into 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 and request an FTP for the integration, as well as the following plugins be installed on your server:

  • Big Lots Stores Order Import 850 with 997 – Imports orders from Big Lots to Sellercloud in EDI 850 format and exports functional acknowledgment in EDI 997 format.
  • Big Lots Order Export EDI 855 – Sends order acknowledgment to Big Lots in EDI 855 format.
  • Big Lots Stores Tracking Export EDI 856 – Exports tracking information to Big Lots in EDI 856 format.
  • Big Lots Stores Invoice Export EDI 810 – Exports invoices to Big Lots in EDI 810 format.
  • Big Lots Inventory Export EDI 846 – Exports inventory to Big Lots in EDI 846 format.
  • Big Lots Stores PDF Invoice – Generates a printable PDF packing slip in a format that complies with Big Lots’s requirements.

Custom Company Settings

Create the following Custom Company Settings.

On your default company:

  • STControlNumber – Set to 1.
  • GSControlNumber – Set to 1.
  • ISAControlNumber – Set to 1.
ISAControlNumber, GSControlNumber, and STControlNumber can all start at 1. The 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.

On the company created for the integration:

  • BigLots_Qualifier – Big Lots’ Qualifier. Set to ZZ. 
  • BigLots_ISAID – Big Lots’ unique identifier for EDI document transmission. Contact them for the value of this setting.
  • BigLots_CustomerQualifier – Your Qualifier. Set to ZZ.
  • BigLots_CustomerISAID – Your ISA ID. Enter a unique phone number that you don’t use for any other EDI integration.
  • BigLots_InternalVendorNumber – Your Internal Vendor Number. Contact Big Lots for the value of this setting.
  • BigLots_IsInProduction – Set to True when ready for production. Otherwise, we will send T for testing.
  • BigLots_Net_Term_Days –The total number of days allowed for payment, starting from the invoice date. Defaults to 30 days if not specified.
  • (Optional) Big Lots Discount – A discount percentage applied to the invoice. Enter the value as a decimal. For example, for 5%, you would enter 0.05; for 25%, you would enter 0.25; etc. Defaults to 0 if not specified.
  • (Optional) BigLotsStores_ShippingRequiresThirdPartyBilling – Enter True to require Third-Party Billing for Big Lots orders.

Custom Product Columns

Create the following Custom Product Columns:

  • (Optional) BIGLOTS_Enabled – Enable only specific products for Big Lots. Set to True for any products you want to send with the Inventory Export plugin. Set the Data Type to Boolean.
  • BIGLOTS_SKU – The product’s SKU for Big Lots. Set the Data Type to String.
  • BIGLOTS_SAFETYQTY – The Safety Quantity, which is to be subtracted from the Available Quantity to prevent overselling on Big Lots. Set the Data Type to Integer.

Custom Order Columns

Create the following Custom Order Columns. All of them are automatically populated by the Order Import plugin.

  • BIGLOTS_TERM_DESCRIPTION – A textual summary of the payment terms. Set the Data Type to String.
  • BIGLOTS_TERM_NET_DAYS – The total number of days allowed for payment, starting from the invoice date. Populated based on the value of the BigLots_Net_Term_Days Custom Company Setting. Set the Data Type to String.
  • BIGLOTS_TERM_DAYS_DUE – The payment due date. Set the Data Type to String.
  • BIGLOTS_NET_DISCOUNT_PERCENTAGE – The discount percentage applied based on the value specified in the Big Lots Discount Custom Company Setting. Set the Data Type to String.
  • BIGLOTS_CUSTOMERID – The customer ID on Big Lots. Set the Data Type to String.
  • BIGLOTS_SERVICE_LEVEL_CODE – The order’s service level code. Set the Data Type to String.

Order Import

The Big Lots Stores Order Import 850 with 997 plugin imports order data from Big Lots to Sellercloud in EDI 850 format and returns a functional acknowledgment in EDI 997 format.

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. On the Scheduled Task page, 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 Big Lots Stores Order Import 850 with 997.
  6. In the Import Options panel, set Import From to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
  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.

Order Acknowledgment

The Big Lots Order Export EDI 855 plugin sends information to Big Lots in 855 EDI format when items have been rejected and are being removed from the order due to insufficient inventory.

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
  • Payment Status – Charged
  • Exported – Not Exported
  • Order Ack (Accept) – No

Automate Order Acknowledgment

To create a Scheduled Task that sends order acknowledgment:

  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 email.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select Big Lots Order Export EDI 855.
    4. Check Mark Orders As Exported.
    5. Check This is Order Ack (Accept).
  6. In the Export Options panel, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
  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.

Tracking Export

The Big Lots Stores Tracking Export EDI 856 plugin exports tracking information from Sellercloud to Big Lots for accepted orders in the 856 EDI format, ignoring cancelled orders. It retrieves the applicable warehouse address for the order and sends it as the Ship From location. 

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 email.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select Big Lots Stores Tracking Export EDI 856.
    4. Check This Is Tracking Export.
  6. In the Export Options panel, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
  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

The Big Lots Stores Invoice Export EDI 810 plugin exports invoices from Sellercloud to Big Lots 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 email.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select Big Lots Stores Invoice Export EDI 810.
    4. Check This Is Invoice Export.
  6. In the Export Options panel, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
  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

The Big Lots Inventory Export EDI 846 plugin exports inventory from Sellercloud to Big Lots in EDI 846 format. 

Optionally, you can enable only specific products for Big Lots by setting their BIGLOTS_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 BIGLOTS_Enabled column, and Save.
  • For multiple products in bulk: follow the steps to Bulk Update Products and use the BIGLOTS_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 BIGLOTS_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 email.
    2. Click the Saved Search menu and select the saved search you created earlier.
    3. Click the Export Via menu and select Big Lots Inventory Export EDI 846.
  6. In the Export Options panel, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
  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 Big Lots Stores PDF Invoice plugin set up under your designated company, you can print PDF invoices with information about your orders and the products they include for your Big Lots orders through Sellercloud or Shipbridge. 

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 > Big Lots Stores PDF Invoice.
  5. Click Save.

Was this article helpful?

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