Kirklands Account Integration

Overview

Kirkland’s Home is a site that focuses on selling home furniture and decorations.

Sellercloud integrates with Kirkland’s via scheduled tasks and specialized plugins. The following plugins are currently available:

• Order Import – Imports your orders from Kirkland’s to Sellercloud in EDI 850 format.
• Tracking Export – Exports your orders from Sellercloud to Kirkland’s in EDI 856 format with the related shipping information.
• Invoice Export – Export Invoices to Kirkland’s in EDI 810 format.
• Inventory Export – Exports inventory to Kirkland’s in EDI 846 format.
• Kirkland’s Packing Slip – Creates printable PDF packing slips.

You can contact Sellercloud Support to request additional billable customizations or other plugins for this integration if necessary.

Prerequisites

Before you can integrate Kirkland’s with Sellercloud, complete the following requirements.

The integration method for Kirkland’s works with plugins that import and export via a VAN (Value-Added Network). Open a ticket to Sellercloud Support to request a VAN.

Custom Company Settings

Create the following Custom Company Settings on your Default Company:

• ISAControlNumber
• GSControlNumber
• STControlNumber

• KirklandSeller_ISAID
• Kirkland_ISAID
• KirklandSeller_VendorNumber

Optional Custom Company settings on your Default Company:

• Consider Replenishable Products – If the setting is set to True and the available quantity is 0 or less, the plugin will export the qty from the Replenishable Qty custom setting.
• Replenishable Qty – The quantity exported if the available is 0 or less and Consider Replenishable Products is set to True. This setting acts identically to a core channel Default Qty field. Learn more about Replenishable Products.
• SetOrderOnHoldWhenItemsAreChanged – If you set the setting to True and we receive an EDI 860 Order Change Request document with a new order item quantity, the plugin will set the order On Hold for manual processing.
• UseReplacementLogicForOrderImport – If you set the setting to True, we will assign a value to an order if it has a $0 grand total. We will also try to link the replacement to a parent order automatically.
• Set2DayInteadOfExpress – Set to True if you want to have the orders choose FedEx 2Day instead of FedEx Express.
• Kirkland_ShippingRequiresThirdPartyBilling – if set to True, the order ShippingRequiresThirdParty will be set to True.
• Kirkland855UploadFolder – The folder you want to upload to. You can enter the folder name without any slashes.

Sellercloud Support

You must contact Sellercloud Support and request:

1. To install Kirkland’s Plugins on your server.
2. A VAN for the integration.
3. The following custom product columns:

Custom Product Columns:

• KIRKLANDS_SKU
• KIRKLANDS_SAFETY_QTY – If you set a quantity above 0 in this setting, we will deduct it from your available quantity when we upload it to the channel. Learn more about Safety Quantity.
• KIRKLANDS_DISCONTINUED – We will send 0 inventory if the setting is set to True on the product.
• KIRKLANDS_ENABLED – True/False value; recommended custom column for Inventory Export saved view.

Order Import

This plugin imports order data from Kirkland’s to Sellercloud in EDI 850 format and supports Purchase Order Change Requests from buyers in EDI 860. Any time the plugin imports a change request, it is matched to the original order. The custom setting SetOrderOnHoldWhenItemsAreChanged controls whether the order is placed on hold for manual processing or if the change is automatically accepted.

We export an EDI 855 Purchase Order Acknowledgement and an EDI 997 Functional Acknowledgement document to the channel for each order and order change to let the channel know you have successfully received an order. Once the plugin generates a document, it uploads it to the VAN.

Automate Order Import

To create a Scheduled Task that regularly imports orders from Kirkland’s to Sellercloud:

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 the Create Orders For Company menu and select the company you designated for this integration.
   2. Click the Plugin menu and select Kirkland’s 850-860 Order Import plugin.
7. In the Import Options section, set Import From to FTP and fill out the 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 and leave a job note of the task – VAN.
10. Click Save on the top right.

Tracking Export

This plugin exports your order shipping information from Sellercloud to Kirkland’s in EDI 856 format.

Before you move on, create a Saved View 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 regularly exports orders from Sellercloud to Kirkland’s:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the green + icon: Create New Scheduled Task.
3. Complete as follows:
   1. 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. User ID: Enter your Email Address.
   2. Saved Search: Select the Saved View you created.
   3. Export Via: Select Kirklands 856 Tracking Export plugin.
7. In the Export Options section, set Import From to FTP and fill out the 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 and leave a job note of the task – VAN.
10. Click Save on the top right.

Invoice Export

This plugin exports invoices from Sellercloud to Kirkland’s EDI 810 format.

Before you move on, create a Saved View 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 regularly exports invoices from Sellercloud to Kirkland’s:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the green + icon: Create New Scheduled Task.
3. Complete as follows:
   1. 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 view you created earlier.
   3. Click the Export Via menu and select Kirkland 810 Invoice Export plugin.
   4. Check This Is Invoice Export.
7. In the Export Options section, set Import From to FTP and fill out the 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 and leave a job note of the task – VAN.
10. Click Save on the top right.

Inventory Export

This plugin exports inventory from Sellercloud to Kirkland’s in EDI 846 format. 

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

For products with the custom column KIRKLANDS_SAFETY_QTY, the plugin will deduct the value specified in that column from the exported quantity.

Before you move on, create a Saved View for products filtered by:

• Company – The company where products are set.
• KIRKLANDS_ENABLED – With this custom column set to True, the saved view will filter only Kirkland’s products and will export their inventory.

Automate Inventory Export

To create a Scheduled Task that regularly exports inventory from Sellercloud to Integration:

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 view you created earlier.
   3. Click the Export Via menu and select Kirklands 846 Inventory Export Plugin.
7. In the Export Options section, set Import From to FTP and fill out the 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 and leave a job note of the task – VAN.
10. Click Save on the top right.

PDF Packing Slip

This plugin creates packing slips with information about your orders and the products they include. This plugin doesn’t require a scheduled task.

To set up the invoice plugin:

1. Go to the Company Settings of the company where you set up Kirkland’s Integration.
2. Click Toolbox and select Invoice Settings.
3. Click Per Channel Preferences.
4. Scroll down to Website > select Kirkland’s Packing Slip plugin.
5. Click Save.