Ashley’s Furniture Account Integration

Overview

Ashley Furniture designs, manufactures, and sells a wide range of furniture and home decor. Known for its affordable prices, stylish designs, and quality craftsmanship. The company is one of the largest furniture retailers globally, operating across 123 countries. 

Integrating Ashley into your Sellercloud account allows you to seamlessly import orders, upload tracking and invoice information, and ensure your listings are 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 Ashley into Sellercloud, complete the following requirements.

Ashley Support

You must contact Ashley for your SFTP details: Server Name, Username, and Password. You will need them when setting up the scheduled tasks to automate the plugins.

Sellercloud Support

Open a ticket with Sellercloud Support and request the following plugins to be installed on your server:

• Ashleys EDI850 and EDI820 Order Import Plugin – Imports orders from Ashley to Sellercloud in EDI 850 format and imports remittance in EDI 820 format.
• Ashleys EDI855 Order Ack Export – Sends order acknowledgment to Ashley in EDI 855 format.
• Ashleys EDI856 Order Tracking Export – Exports tracking information to Ashley in EDI 856 format.
• Ashleys EDI810 Order Invoice Export – Exports invoices to Ashley in EDI 810 format.
• Ashleys Inventory Export EDI 846 – Exports inventory to Ashley in EDI 846 format.
• Ashleys EDI812 Credit Memo Order Export – Exports credit memos to Ashley in EDI 812 format.
• Ashley Packing Slip – Generates a printable PDF packing slip in a format that complies with Ashley’s requirements.

Custom Company Settings

Create the following Custom Company Settings:

On your default company:

• STControlNumber
• GSControlNumber
• ISAControlNumber
• AshleyIsInProduction – The value should be set to False during the EDI testing process. Once you have completed it, set it to True to move into production. Set the Data Type to Boolean.

On the company created for the integration:

• Ashley_CustomerISAID – Your ISA ID. Enter a unique phone number that you don’t use for any other EDI integration.
• Ashley_ISAID – Ashley’s ISA ID. Contact Ashley for the value of this setting.
• Ashley_Qualifier – Ashley’s Qualifier. Typically, it’s ZZ. Contact Ashley for the value of this setting.
• Ashley_RecieverQualifier – Your Qualifier. Set to 12.
• Ashley_Customer_Number – Used by the Ashleys EDI810 Order Invoice Export plugin. Contact Ashley for the value of this setting.
• Ashley_DUNS_Number – Your DUNS number. Contact Ashley for the value of this setting. Set the Data Type to Integer.
• Ashleys_VendorNumber – Used by the Ashleys Inventory Export EDI 846 plugin. Contact Ashley for the value of this setting. Set the Data Type to String.
• AshleyRemittanceEmailTo – Specify the email address where remittance notifications and payment information from Ashley will be sent. Set the Data Type to String.
• (Optional) Ashley_ImportOrdersAsPaid – If enabled, the Order Import plugin will mark the imported orders as Paid. Set the Data Type to Boolean.
• (Optional) Ashleys997UploadFolder – Enter the path to the folder where the EDI 997 from the Order Import plugin will be saved. The default is /out. Set the Data Type to String.
• (Optional) Ashley_AlwasySendProductIDRequested – Set to True to always send Ashley the original product IDs to prevent discrepancies and ensure they won’t reject any EDI documents.
• Consider replenishable products – Defaults to False. If the Available Qty is 0 or less and this setting is True, the plugin will export the quantity from the next setting. Set the Data Type to Boolean.
• Replenishable qty – The quantity exported if Available Qty is 0 or less and Consider replenishable products is True. Set the Data Type to Integer.

Custom Product Columns

Create the following Custom Product Columns:

• Ashley_SKU – The product’s SKU at Ashley. Set the Data Type to String.
• (Optional) Ashley_Enabled – Enable only specific products for Ashley. Set to True for any products you want to send with the Inventory Export plugin. Set the Data Type to Boolean.
• Ashleys_NextAvailableDate – Used by the Ashleys Inventory Export EDI 846 plugin. Checks the estimated arrival date of POs and uses the nearest date. If not populated, it will send 30 days from today. Set the Data Type to Datetime.
• Ashleys_NextAvialableQty – Used by the Ashleys Inventory Export EDI 846 plugin. If not populated, it will send 1 as the next Available Quantity. Set the Data Type to Integer.

Custom Order Columns

Create the following Custom Order Columns:

• Ashley_InternalVendorNumber – Used by the Order Import, Order Acknowledgement, and Inventory Export plugins. Set the Data Type to String.
• Ashley_InternalOrderNumber – Ashley’s internal order number. Used by the majority of Ashley plugins. Set the Data Type to String.

Order Import

The Ashleys EDI850 and EDI820 Order Import Plugin imports order data from Ashley to Sellercloud in EDI 850 format and imports remittance in EDI 820 format.

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 Ashleys EDI850 and EDI820 Order Import Plugin.
6. In the Import Options panel, set Import From to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
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

The Ashleys EDI855 Order Ack Export plugin sends order acknowledgment to Ashley in EDI 855  format and marks orders as acknowledged after export. The plugin can handle Split Orders.

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

• Company – The company you created for the integration
• Shipping Status – Unshipped
• Exported – Not Exported
• Invoice Uploaded – No
• Order Ack (Accept) – No

Automate Order Acknowledgement

To create a Scheduled Task that 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. 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 Ashleys EDI855 Order Ack Export.
   4. Check This is Order Ack (Accept).
6. In the Export Options panel, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
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.

Tracking Export

The Ashleys EDI856 Order Tracking Export plugin exports tracking from Sellercloud to Ashley in EDI 856 format. The plugin can handle Split Orders – when an order is split, any child orders will get the tracking combined with the parent’s order export.

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 Ashleys EDI856 Order Tracking Export.
   4. Check Mark Orders As Exported.
   5. Check This Is Tracking Export.
6. In the Export Options panel, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
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 Ashleys EDI810 Order Invoice Export plugin exports invoices from Sellercloud to Ashley 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 Ashleys EDI810 Order Invoice Export.
   4. Check This Is Invoice Export.
6. In the Export Options panel, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
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 Ashleys Inventory Export EDI 846 plugin exports inventory from Sellercloud to Ashley in EDI 846 format. 

Optionally, you can enable only specific products for Ashley by setting their Ashley_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 Ashley_Enabled column, and Save.
• For multiple products in bulk: follow the steps to Bulk Update Products and use the Ashley_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 Ashley_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 Ashleys Inventory Export EDI 846.
6. In the Export Options panel, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
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.

Credit Memo Export

The Ashleys EDI812 Credit Memo Order Export plugin exports credit memos from Sellercloud to Ashley in EDI 812 format.

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

• Company – The company you created for the integration
• Order Status – Completed
• Exported – Not Exported
• Payment Status – Partial or Full Refund
• Invoice Uploaded – Yes
• Tracking Uploaded – Yes

Automate Credit Memo Export

To create a Scheduled Task that exports credit memo:

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 Ashleys EDI812 Credit Memo Order Export.
   4. Check This Is Invoice Export.
6. In the Export Options panel, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
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.

Order PDF Invoice

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