Wayfair Account Integration

Overview

Wayfair is a large and growing marketplace dedicated to home products that range from furniture, linens, décor, and kitchenware to home office furniture, home improvement, and patio – anything and everything for home and garden. It operates as a fulfillment channel, where merchants dropship orders for Wayfair. This means that Wayfair will buy products from a merchant and market them online, while the customers’ online orders will be forwarded to that merchant to be fulfilled. As with most fulfillment channels, listings must be created directly on Wayfair, and pricing negotiated with your assigned Wayfair representative.

The integration between Sellercloud and Wayfair allows you to seamlessly import orders, upload tracking information and invoices, and ensure your listings are always up-to-date with the latest inventory data. Sellercloud integrates with both B2B and B2C Partner accounts, as well as Wayfair Castlegate Fulfillment.

Prerequisites

There are two ways to integrate Wayfair into Sellercloud – via EDI or API. EDI involves transmitting documents through an FTP, whereas API establishes a direct connection between the two platforms.

The workflow for Sellercloud’s EDI integration with Wayfair is comprised of the following steps:

1. Complete the required integration form and return it to Wayfair.
2. Enter your Wayfair credentials into Sellercloud’s Wayfair Company Settings.
3. Configure the Shipping Method Mapping for Wayfair. While this is optional, it will set the correct shipping method for each order.
4. Configure Wayfair Invoices/Packing Slips.
5. Your Sellercloud server must be whitelisted on Wayfair Partner. Contact Sellercloud Support for your server’s IP address.

Follow the next sections in this article to set up the EDI integration step by step.

The workflow for Sellercloud’s API integration is the following:

1.  Submit a ticket to Wayfair to request the API integration.
2. Grant your Wayfair account access to their APIs, and then follow the steps in Wayfair’s Onboarding Guide to complete the API testing. You must complete this stage before you can go live.
3. Generate API credentials and then enter them into Sellercloud’s Wayfair Company Settings.
4. Configure the Shipping Method Mapping for Wayfair. While this is optional, it will set the correct shipping method for each order.
5. Configure Wayfair Invoices/Packing Slips.
6. Note that we currently do not support Wayfair Order Cancellation import via API. For now, order cancellation can come in automatically only if you have integrated via EDI.

Skip to the last section of this article (Integrate Wayfair via API) for a detailed walkthrough of steps 1-4.

Wayfair Integration Form

Follow these instructions to complete the integration form (some information is on the form itself):

1. Section One: Contact Information— Complete contact information.
2. Section Two: Connectivity & Documents Options
   1. Connection Type – FTP Direct Connection – Enter Yes
   2. Transaction Type – ANSI X12 – EDI – Enter Yes
   3. Process:
      1. Inventory – Yes
      2. Purchase Orders – Yes
      3. Order Acknowledgment – Yes
      4. Advanced Shipment Notifications –Yes
      5. Invoice – Yes
   4. EDI Configuration Version – enter Yes in the 4010 box
   5. Production ISA:
      1. Qualifier – Enter ZZ
      2. ID – Use the company telephone number
   6. Test ISA:
      1. Qualifier – Enter ZZ
      2. ID – use the company telephone number and add an optional “T” at the end
3. Section Three: Inventory Options
   1. Frequency— choose Hourly and enter 2

Wayfair General Settings

1. In Sellercloud, click Settings > Company Settings > Toolbox > Wayfair Settings > General Settings.
2. Complete the fields using the field values below for reference. See these instructions for setting co-op fees here for dropship.
3. When done with these settings, select the Wayfair Enabled checkbox.
4. Click Save.

Map Warehouses

(Optional) If you have multiple warehouses set up in Wayfair, you can map your warehouse(s) in Sellercloud to their corresponding Wayfair locations. When mapping multiple warehouses, the Supplier Warehouse ID must be blank. Instead, the Supplier Warehouse ID will be entered for each warehouse individually:

1. Go to Settings > Company > Toolbox > Channel Warehouse Mapping.
2. Select Channel > Wayfair.
3. Populate the IDs under Channel Warehouse Codes. The ID entered will be referenced as the ShipFrom address with the tracking upload documents.

Wayfair Shipping Method Mapping

Wayfair has unique codes to indicate shipping services. You can map these codes to services in Sellercloud to ensure the correct shipping service is assigned when shipping the order.

You must check Enable Wayfair Shipping Method Mapping per Carrier in your Client Settings. This allows more flexibility when adding various shipping services.

Once you’ve enabled this setting, follow these next steps:

1. Access Company Settings > Company > Wayfair Settings > Shipping Method Mapping.
2. Here, you can add existing mapping and create a new mapping. For the new mapping, you’ll need Zenith Freight Lines (ZEFL).
3. Enter the required information.
4. Click on Save.

Configure PDF Invoices

As a fulfillment channel, Wayfair’s packing slip must be printed and inserted into the shipping package with the order.

The Wayfair packing slip will print automatically for Wayfair orders. However, if you are using the Per Channel Invoice Preferences option, you must initially configure the Wayfair packing slip:

1. Click Company Settings > Toolbox > Invoice Settings.
2. Click Per-Channel Preferences.
3. Find the channel in the list > Select Channel Specific from the Invoice Type dropdown.
4. Click on Save.

Wayfair Backorders

To send Backorder information to Wayfair, you need to be enrolled in the OOSP (Out of Stock Purchasing) program. To use this feature in Sellercloud, you need to enable Send Backorder Information on the company’s Wayfair General Settings page. When enabled, we will send inventory for out-of-stock products following these rules:

• If the OnOrder quantity of the product is > 0, and the expected delivery date is set to a date in the future, then Sellercloud will send the quantity on order and the specified expected delivery date automatically.
• If there is an OnOrder quantity but no expected delivery date set, Sellercloud will send the quantity on order and the expected delivery date will be set to one month in the future.
• If there is no OnOrder quantity and no expected delivery date, Sellercloud will send the quantity as zero.

Shipping Containers

If your workflow includes Shipping Containers, you need to enable the Enable Shipping Containers for PO Client Setting in Sellercloud. When this setting is enabled, we will send the Qty On Order and Estimated Arrival Date fields of a container as backorder information instead of the Qty On Order and Estimated Delivery Date fields of Purchase Orders.

If the above Client Setting is enabled but shipping container details are not populated, App Setting WayfairSendOnOrderQtyIfOnOrderContainerQtyIsNotAvailable ensures that we will still make an attempt to send the purchase order fields as backorder information. Contact Sellercloud Support to have this setting enabled on your server.

Integrate Wayfair via API

You can also integrate Wayfair into Sellercloud via API.

To set up the API integration on Wayfair’s end:

1. Sign in to the Wayfair Partner Home portal.
2. Click the Tickets tab in the menu on the left and then select Submit a Ticket.
3. Set the Submit a Ticket for option to Inventory & EDI.
4. Set the Ticket Type to Set Up an Inventory Feed or EDI Connection with Wayfair.
5. Submit your contact information in the Tech Contact Name and Tech Contact Email fields. 
6. Under What Would You Like To Set Up? select API Integration.
7. Optionally, add Any Additional Comments.
8. Click Submit.
   
9. Next, go to the User Management Page.
10. Grant your account access to the Wayfair APIs by clicking Edit (the pencil Icon) and checking the API box under Access Permissions. You can also click the Create New User button to create a new Partner Home account.
11. Follow the steps outlined in Wayfair’s Onboarding Guide to complete the API testing. You must complete this stage before you can go live.
12. Update the ticket with a list of the API queries and mutations you want to set up. Wayfair will validate that your testing steps have been completed and grant you access to go live.

To go live and enable the API integration:

1. On the Wayfair Partner Home portal, select the Applications tab in the menu on the left and click the + New Application button.
2. Set the Name to Sellercloud and enter a Description for the new application into the Create Application pop-up.
3. Toggle the selection from Sandbox to Production, then click Save. This will open the Client Secret pop-up.
4. Copy your Client ID and Client Secret from the pop-up. This information is only accessible until you close the pop-up – don’t close it until you copy the details and save them somewhere.
5. Open Sellercloud and go to your Company Settings.
6. Click Toolbox and select Wayfair > General Settings.
7. Click Edit.
8. Check the Enable Wayfair API box.
9. Enter your Wayfair details into the Client ID and Client Secret fields.
   
10. Click Actions and select Download Auth Token. If this action is successful, it will populate the Authentication Token, AuthToken Received On, and AuthToken Expires On fields.
    
11. Click Save.