Office Depot Account Integration

Overview

Office Depot is an office supply retail company offering a wide range of products and services, including various office essentials, furniture, and electronics. They serve both businesses and individual consumers through online and physical stores. 

Integrating your Sellercloud account with Office Depot allows you to update the inventory levels of your listings, manage your Office Depot orders, and more. This integration works through EDI documents transmitting information between the two services. The following plugins are currently available in Sellercloud:

  • Order Import – Imports orders from Office Depot to Sellercloud in EDI 850 format.
  • Tracking Export  – Exports tracking information to Office Depot in EDI 856 format.
  • Invoice Export – Exports invoices to Office Depot in EDI 810 format.
  • Inventory Export – Exports inventory to Office Depot in EDI 846 format.
  • PDF Invoice – Creates printable PDF packing slips.

If necessary, you can contact Sellercloud Support to request additional customizations or other plugins for this integration.

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

Prerequisites

To integrate Office Depot with Sellercloud, you must 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.

To establish a connection with Office Depot, contact their support team and ask for their GS ID, ISA ID, and your unique account number. You must enter them into the OfficeDepot_GSID, OfficeDepot_ISAID, and OfficeDepot_VendorName custom company settings listed below.

Custom Company Settings

Create the following Custom Company Settings.

On your default company:

  • STControlNumber
  • GSControlNumber
  • ISAControlNumber
  • OfficeDepot_GSID – Office Depot’s group identifier for EDI document transmission – contact them for the value of this setting.
  • OfficeDepot_ISAID – Office Depot’s unique identifier for EDI document transmission – contact them for the value of this setting.
  • OfficeDepot_Qualifier – Set to 08.
  • OfficeDepot_CustomerQualifier – Set to ZZ.
  • OfficeDepot_CustomerISAID – Enter a unique phone number not used for any other integration.
  • OfficeDepot_VendorName – Your Office Depot account’s unique identifier – contact them for the value of this setting.
  • OFFICEDEPOT_USEREPLENISHABLEQTY – Optional setting. Must be set to True for the setting below to work.
  • OFFICEDEPOT_DEFAULTREPLENISHABLEQTY – Optional setting. When a Replenishable product is exported, the quantity you specify here will be sent, ignoring the safety quantity from the OFFICEDEPOT_SAFETYQTY custom product column.
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:

  • DestinationFolder997OfficeDepot – Optional setting. Enter the full VAN folder path where the EDI 997 documents will be uploaded. The default output folder is /out.
  • SendOrderCompanyAddressOnEDI – Optional setting. Can be True or False. If True, Sellercloud will send the order’s company address in the Ship From address on the Tracking Export EDI.

Sellercloud Support

You must contact Sellercloud Support and request:

  1. To install the Office Depot Plugins on your server.
  2. A VAN for the integration.
  3. The following Custom Product and Order Columns:

Custom Product Columns

  • OfficeDepot_Enabled – Optional column used to enable only specific products for Office Depot. Set to True for any products you want to send with the Inventory Export plugin.
  • OFFICEDEPOT_SKU – A product’s SKU at Office Depot.
  • OFFICEDEPOT_SAFETYQTY – A Safety Quantity for products on Office Depot.

Custom Order Columns

  • OfficeDepot_Department – Type String.
  • OfficeDepot_ReleaseNumber – Type String.
  • OfficeDepot_Desktop – Type String.
  • OfficeDepot_CustomerPO – Type String.
  • OFFICEDEPOT_CUSTOMERNUMBER – Type String.
  • OFFICEDEPOT_SHIPMENTMETHODOFPAYMENT – Dropdown column with the following values:
    • ColumnValue – ColumnDescription
    • CC – Collect
    • CF – Full Freight Allowance
    • DF – Other
    • X – Prepaid to Consolidator
    • PC – Prepay and Add to Invoice
    • PP – Prepaid
  • OFFICEDEPOT_SHIPMENTPAYMENTLOCATION – Dropdown column with the following values:
    • DE – FOB Destination
    • OR – FOB Origin
  • OfficeDepot_TermsTypeCode – Type String.
  • OfficeDepot_TermsBasisDateCode – Type String.
  • OfficeDepot_TermsDiscountPercent – Type Decimal.
  • OfficeDepot_TermsDiscountDaysDue – Type Integer.
  • OfficeDepot_TermsNetDays – Type Integer.

Order Import

This plugin imports order data from Office Depot to Sellercloud in EDI 850 format and returns acknowledgment in EDI 997 format.

If the country code and name are missing, then they are guessed by the state name. If nothing is found, then US is used by default.

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 following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
  5. Click the Edit button on the top right.
  6. In the Details section:
    1. Click Create Orders For Company and select the company designated for this integration.
    2. Click the Plugin menu and select OfficeDepot Order Import 850.
  7. In the Import Options section, set Import From to FTP and fill out the FTP fields with your VAN details.
  8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General section, click the Enable button.
  10. Click Save on the top right.

Tracking Export

This plugin exports tracking from Sellercloud to Office Depot 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. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
  5. Click the Edit button on the top right.
  6. In the Details section:
    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 Office Depot Tracking Export EDI 856.
    4. Check This Is Tracking Export.
  7. In the Export Options section, set Export To to FTP and fill out the FTP fields with your VAN details.
  8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General section, click the Enable toggle button.
  10. Click Save on the top right.

Invoice Export

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

A UPC must be set on all products to be able to export 810 invoices successfully.

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. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
  5. Click the Edit button on the top right.
  6. In the Details section:
    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 Office Depot Invoice Export EDI 810.
    4. Check This Is Invoice Export.
  7. In the Export Options section, set Export To to FTP and fill out the FTP fields with your VAN details.
  8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General section, click the Enable toggle button.
  10. Click Save on the top right.

Inventory Export

This plugin exports inventory from Sellercloud to Office Depot in EDI 846 format. 

Optionally, you can enable only specific products for Office Depot by setting their OfficeDepot_Enabled Custom Column for Products to True:

  • For one product at a time: go to the Product Details Page > click Toolbox and select Custom Columns > click Edit, update the OfficeDepot_Enabled column, and Save.
  • For multiple products in bulk: follow the steps to Bulk Update Products and use the OfficeDepot_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 OfficeDepot_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. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
  5. Click the Edit button on the top right.
  6. In the Details section:
    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 Office Depot Inventory Export EDI 846.
  7. In the Export Options section, set Export To to FTP and fill out the FTP fields with your VAN details.
  8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
  9. In the General section, click the Enable toggle button.
  10. Click Save on the top right.

Configure PDF Invoices

With the Invoice PDF plugin set up under your designated company, you can print PDF invoices with information about your orders and the products they include for your Office Depot 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 > Office Depot PackingSlip.
  5. Click Save.


Was this article helpful?

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