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 Office Depot into your Sellercloud account allows you to seamlessly import orders, upload tracking information, and ensure your Office Depot store is always up-to-date with the latest inventory data.  The 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.

---

Prerequisites

To integrate Office Depot with Sellercloud, you must complete the following requirements.

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.

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:

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

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 vendor name – contact them for the value of this setting.
• OfficeDepot_VendorNumber – Your Office Depot account’s identifier – contact them for the value of this setting.
• (Optional) OFFICEDEPOT_USEREPLENISHABLEQTY – Set to True to enable the setting below.
• (Optional) OFFICEDEPOT_DEFAULTREPLENISHABLEQTY – 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.

On the company created for the integration:

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

Custom Product Columns

Create the following Custom Product Columns:

• (Optional) OfficeDepot_Enabled – Enable only specific products for Office Depot. Set to True for any products you want to send with the Inventory Export plugin.
• OFFICEDEPOT_SKU – The product’s SKU at Office Depot.
• OFFICEDEPOT_SAFETYQTY – A Safety Quantity for products on Office Depot.
• OFFICEDEPOT_MANUFACTURER_PART_NUMBER – The product’s manufacturer number.

Custom Order Columns

Create the following Custom Order Columns:

• OfficeDepot_Department – Set the Data Type to String.
• OfficeDepot_ReleaseNumber – Set the Data Type to String.
• OfficeDepot_Desktop – Set the Data Type to String.
• OfficeDepot_CustomerPO – Set the Data Type to String.
• OFFICEDEPOT_CUSTOMERNUMBER – Set the Data Type to String.
• OFFICEDEPOT_SHIPMENTMETHODOFPAYMENT – Set the Data Type to String and check the Dropdown box. This column can contain one of 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 – Set the Data Type to String and check the Dropdown box. This column can contain one of the following values:
  • DE – FOB Destination
  • OR – FOB Origin
• OFFICEDEPOT_REJECTION_CODE – Set the Data Type to String and check the Dropdown box. This column can contain one of the following rejection codes:
  • I3 – Out of Stock (Reason – IR)
  • I4 – Bad SKU (Reason – IR)
  • I5 – Product Has Been Discontinued (Reason – IR)
  • IB – Backorder (Reason – IR)
  • O1 – Duplicate Order (Reason – IR)
  • O2 – Order Info Missing (Reason – IR)
  • S1 – Cannot Ship USPS (Reason – IR)
  • S2 – Cannot Ship to PO Box (Reason – IR)
  • S3 – Cannot Ship to Country (Reason – IR)
  • S4 – Invalid Method of Shipment (Reason – IR)
  • S5 – Bad Address (Reason – IR)
  • S6 – Cannot Ship as Ordered (Reason – IR)
• OfficeDepot_TermsTypeCode – Set the Data Type to String.
• OfficeDepot_TermsBasisDateCode – Set the Data Type to String.
• OfficeDepot_TermsDiscountPercent – Set the Data Type to Decimal.
• OfficeDepot_TermsDiscountDaysDue – Set the Data Type to Integer.
• OfficeDepot_TermsNetDays – Set the Data Type to Integer.

---

Order Import

The OfficeDepot Order Import 850 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. 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 OfficeDepot Order Import 850.
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.

---

Order Acknowledgement Export

The Office Depot Order Export 855 EDI plugin confirms the receipt and acceptance of an order to Office Depot in EDI 855 format. The acknowledgment export includes the order number, date, details of the ordered products, delivery date, and any potential rejection that may affect your ability to fulfill the order.

First, create a Saved Search for orders filtered by:

• Company – The company you created for the integration
• Order Status – InProcess Or Completed
• Shipping Status – Unshipped
• Exported – Not Exported
• Payment Status – Charged
• Order Ack (Accept) – No

Automate Order Acknowledgment

Next, create a Scheduled Task that regularly 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. Select your email from the User ID dropdown.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select Office Depot Order Export 855 EDI.
   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 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. Once done, click the Enable toggle button in the General panel.
9. Click Save.

---

Tracking Export

The Office Depot Tracking Export EDI 856 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. 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 Office Depot Tracking Export EDI 856.
   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

The Office Depot Invoice Export EDI 810 plugin exports invoices from Sellercloud to Office Depot 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 Office Depot Invoice Export EDI 810.
   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

The Office Depot Inventory Export EDI 846 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 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 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. 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 Office Depot Inventory Export EDI 846.
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 Office Depot PackingSlip plugin set up under your designated company, you can print PDF invoices with information about your Office Depot orders and the products they include through Sellercloud or Shipbridge. 

The plugin gets the delivery date for the packing slip from the order’s EstimatedDeliveryDate; if this date is unavailable, it will use the date when the PDF was generated.

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.
   

---