Tractor Supply Account Integration

Overview

Tractor Supply is a retail chain that focuses on a wide range of products for various needs, including agriculture, pet care, home improvement, lawn and garden maintenance, and livestock care.

Integrating Tractor Supply allows you to sell on their platform through Sellercloud. 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 Tractor Supply to Sellercloud in EDI 850 format.
• Tracking Export  – Exports tracking information to Tractor Supply in EDI 856 format.
• Invoice Export – Exports invoices to Tractor Supply in EDI 810 format.
• Inventory Export – Exports inventory to Tractor Supply in EDI 846 format.
• Order Cancellation Export – Exports cancellations to Tractor Supply in EDI 855 format.
• RMA Export – Exports RMAs to Tractor Supply in EDI 180 format.

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

---

Prerequisites

Before you can integrate Tractor Supply into Sellercloud, complete the following requirements.

First, contact Tractor Supply’s support team:

• Request an EDI Vendor Profile Form, then fill it out and send it to the designated contact.
• Request the value of their ISA ID for EDI documents exchange.

Custom Company Settings

Next, create the following Custom Company Settings.

On your default company:

• STControlNumber
• GSControlNumber
• ISAControlNumber
• TSC_InternalVendorNumber_CompanySetting
• TSC_InventoryReferenceNumber – A counter that ensures a unique control number in each exported file. Set to 1 for new setups.

On the company created for the integration:

• Tractor_CustomerISAID – Enter a phone number that you don’t use for another integration.

• Tractor_CustomerQualifier – Set to ZZ.
• Tractor_ISAID – Tractor Supply’s unique identifier used for EDI document exchange.
• Tractor_Qualifier – Set to 08.
• Tractor_UseProductionMode – Enter True or False. 
• Tractor_997UploadFolder – Optional setting. Enter the path of the folder where the EDI 997 from the Order Import plugin will be saved.
• TS_SkipKitItemPackages – Defaults to False. When True, the Tracking Export plugin will ignore packages assigned to Kit Components. When kit items are shipped in multiple packages, Sellercloud will only send a single tracking number to Tractor Supply.
• TSC_VendorName – The Vendor Name to be sent in the REF segment by the Inventory Export plugin.

Sellercloud Support

Contact Sellercloud Support and request:

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

Custom Product Columns

• TS_Enabled – Optionally used to enable only specific products for Tractor Supply. Set to True for any products you want to send with the Inventory Export plugin.
• TSC_ProductItemNumber – A product’s Tractor Supply SKU.
• TractorSupplySafetyQty – A Safety Quantity for products on Tractor Supply.

Custom Order Columns

• TSC_CustomerOrderNumber
• TSC_InternalVendorNumber 

---

Order Import

This plugin imports the following from Tractor Supply:

• Orders in EDI 850 format. It sets the values of the TSC_CustomerOrderNumber and TSC_InternalVendorNumber Custom Order Columns and the TSC_ProductItemNumber Custom Product Column. It tries to match the imported product info by SKU or UPC.
• Order Changes in EDI 860 format. It either voids orders or adds/alters/removes their items.
• RMAs in EDI 180 format. 

Finally, it produces a combined EDI 997 for all the imported files, including order acknowledgment.

Automate Order Import

To create a Scheduled Task that regularly 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 the Create Orders For Company menu and select the company you designated for this integration.
   2. Click the Plugin menu and select Tractor Supply EDIs 850, 860, and 180 Order Import.
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.
10. Click Save on the top right.

---

Tracking Export

This plugin exports tracking from Sellercloud to Tractor Supply following the 856 EDI format. Orders must have a Fully Shipped status, otherwise, the plugin won’t export them.

When testing Less Than Truckload (LTL) orders, set the Shipping Carrier to LTL or CNWY.

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 regularly exports tracking information:

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 Tractor Supply EDI856 Order Export.
   4. Check This Is Tracking Export.
7. In the Export Options section, set Export To 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 toggle button.
10. Click Save on the top right.

---

Invoice Export

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

Your orders must have an internal vendor number in the Custom Order Column TSC_InternalVendorNumber – this is done by the Order Import plugin.

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 – Fully Shipped
• Invoice Uploaded – No
• Tracking Uploaded – Yes

Automate Invoice Export

To create a Scheduled Task that regularly 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 Tractor Supply EDI810 Order Invoice Export.
   4. Check This Is Invoice Export.
7. In the Export Options section, set Export To 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 toggle button.
10. Click Save on the top right.

---

Inventory Export

This plugin exports product information like product numbers and inventory quantities from Sellercloud to Tractor Supply in EDI 846 format.

Optionally, you can enable only specific products for Tractor Supply by setting their TS_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 TS_Enabled column, and Save.
• For multiple products in bulk: follow the steps to Bulk Update Products and use the TS_Enabled column – set it to True for all products you want to enable.

Next, create a Saved Search for products filtered by TS_Enabled – True. Optionally, you can add more filters to the search.

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

Automate Inventory Export

To create a Scheduled Task that regularly 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 Tractor Supply EDI846 Inventory Export.
7. In the Export Options section, set Export To 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 toggle button.
10. Click Save on the top right.

---

Order Cancellation Export

This plugin exports order cancellations from Sellercloud in EDI 855 format and cancels the orders on Tractor Supply.

Your orders must have an internal vendor number in the Custom Order Column TSC_InternalVendorNumber, and order items must have their Tractor Supply SKU in the Custom Product Column TSC_ProductItemNumber. The Order Import plugin performs these actions.

To partially cancel an order:

1. Split Off the items you want to cancel.
2. Set the split order’s status to Canceled.
3. Export the split order with this plugin.

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

• Company – The company you created for the integration
• Order Status – Canceled
• Exported – Not Exported

Automate Order Cancellation Export

To create a Scheduled Task that regularly exports order cancellations:

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 Tractor Supply Order Cancellation Export EDI 855.
   4. Check Mark Orders As Exported.
7. In the Export Options section, set Export To 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 toggle button.
10. Click Save on the top right.

---

RMA Export

This plugin exports RMAs from Sellercloud to Tractor Supply in EDI 180 format.

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

• Company – The company you created for the integration
• Exported – Not Exported
• Tracking Uploaded – Yes
• Has RMA – Yes

Automate RMA Export

To create a Scheduled Task that regularly exports RMAs:

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 Tractor Supply EDI 180 RMA Export.
7. In the Export Options section, set Export To 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 toggle button.
10. Click Save on the top right.

---