Wayfair Account Integration

Overview

Sellercloud integrates with Wayfair for both B2B and B2C accounts. Sellercloud’s Wayfair integration allows sellers to seamlessly manage their Wayfair stores from one central location. The integration eliminates the need for manual entry and updates and provides automatic inventory and pricing updates to ensure the seller’s store is always up-to-date.

Additionally, Sellercloud’s Wayfair integration offers order management, shipping management, and customer service functions. All of these tools are designed to make it easier for sellers to manage their Wayfair store and improve their customer experience.

Sellercloud also integrates with Wayfair Castlegate Fulfillment. For additional information, refer to the linked article.

If your account is already integrated, check out our Wayfair Listings Management article. 

Prerequisites

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

1. Complete the required integration form and return it to Wayfair. Enter credentials into Sellercloud’s Wayfair settings.
2. Configure the shipping method mapping for Wayfair. While this is optional, it will put the correct shipping method on the order.
3. Configure Wayfair Invoices/Packing Slips.
4. The client’s Sellercloud server must be whitelisted on Wayfair. Contact Sellercloud Support for your server’s IP address.

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 Settings Explained

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 Settings.

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 in the ShipFrom address with tracking uploads sent.

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.

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.