Ace Hardware Account Integration

Overview

Ace Hardware operates on a franchise model with individual store owners and offers a comprehensive selection of products, including tools, hardware, paint, plumbing supplies, electrical equipment, gardening supplies, and more.

Integrating Ace Hardware into your Sellercloud account allows you to seamlessly import orders, upload tracking information, and ensure your Ace Hardware 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 contact Sellercloud Support to request additional customizations or other plugins for this integration. Any such modifications will be billable.

Prerequisites

Before you can integrate Ace Hardware with Sellecloud, complete the following requirements.

Order Import

The Ace Hardware Order Import 850 with 997 EDI plugin imports order data from Ace Hardware to Sellercloud in EDI 850 format and exports functional acknowledgment in EDI 997 format. Orders will be created with the username AceHardware_[CompanyID]@SellerCloud.com.

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 the Create Orders For Company menu and select the company designated for this integration.
   2. Click the Plugin menu and select Ace Hardware Order Import EDI 850 with 997.
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.

Tracking Export

The Ace Hardware TrackingExport 856 EDI plugin exports tracking information from Sellercloud to Ace Hardware in EDI 856 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
• AceHD_SSCCProcessed – True 

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 AceHardware TrackingExport 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 Ace Hardware Invoice Export 810 EDI plugin exports invoices from Sellercloud to Ace Hardware in EDI 810 format. 

If the invoice item does not have UPC, ProductID, ACEHARDWARE_SKU, the invoice export will not be generated 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:
   • Click Task Type and select Export Orders.
   • Set the Task Name.
   • Select the Company.
   • Select the Start Time.
   • 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 Ace Hardware 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 Ace Hardware Inventory Export EDI 852 plugin exports inventory from Sellercloud to Ace Hardware in EDI 852 format. 

Optionally, you can enable only specific products for Ace Hardware by setting their AceHardware_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 AceHardware_Enabled column, and Save.
• For multiple products in bulk: follow the steps to Bulk Update Products and use the AceHardware_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 AceHardware_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 regularly exports inventory from Sellercloud to Ace Hardware:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the green + icon: Create New Scheduled Task.
3. Complete as follows:
   • Click Task Type and select Export Products.
   • Set the Task Name.
   • Select the Company.
   • Select the Start Time.
   • Click CREATE.
4. On the Scheduled Task page, click the Edit button at the top right corner.
5. In the Details panel:
   • Click the User ID menu and select your email.
   • Click the Saved Search menu and select the saved search you created earlier.
   • Click the Export Via menu and select Ace Hardware Inventory Export EDI 852.
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 GS1-128 Labels

With the Ace Hardware GS1-128 Label plugin set up under your designated company, you can print PDF product labels that include Code 128 barcodes for your orders and the products they include through Sellercloud or Shipbridge. Any orders processed by the label plugin will have the AceHD_SSCCProcessed custom column value set to True.

To set up theGS1-128 Label 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 > Ace Hardware GS1-128 Label.
5. Click Save.