Wayfair Account Integration

Updated 1 month ago

SellerCloud integrates with Wayfair for both B2B and B2C companies.


The workflow for SellerCloud's for integration with Wayfair comprises the following steps:

  1. Complete the required integration form and return it to Wayfair. (Usually, the client has already contacted Wayfair and received the form.) 
  2. Enter credentials into SellerCloud's Wayfair settings.
  3. Configure the shipping method mapping for Wayfair. While this is optional, it will put the correct shipping method on the order.
  4. Configure Wayfair Invoices/Packing Slips.
  5. 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):

Section 1 Contact Information - Complete contact information.

Section 2 Connectivity Options - FTP Direct Connection - Enter "Yes."

Section 3 Configuration

  • Production ISA:
    • Qualifier - Enter "ZZ"
    • ID - Use company telephone number
  • Test ISA:
    • Qualifier - Enter "01" 
    • ID - Issued to customer from Wayfair
    • Version – enter “Yes” in the 4010 box

Transaction Set and Process Detail - Enter the following values for the fields below:

  • Invoice -  Yes
  • Purchase Order - Yes
  • Purchase Order Acknowledgment - Yes
  • Ship Notice - Yes
  • Order Status Inquiry - Leave blank
  • OrderStatus Response - Leave blank
  • Inventory - Yes
  • Purchase Order Change - Leave blank
  • Purchase Order Change Response - Leave blank
  • Functional acknowledgment - Yes

Inventory Options

  • Frequency – choose "Hourly" – Enter  "2"
  • Format – choose EDI 846 Transaction – Enter "Yes"

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

FIELD

 VALUE

Customer ISA Qualifier

ZZ

Customer ISA ID

Wayfair ID you create. For example, your company telephone number.

Wayfair ISA Qualifier            

01

Wayfair ISA ID

 From Wayfair

Wayfair Seller ID

Leave blank

 Supplier ID

From Wayfair

Supplier Warehouse ID

Typically, this is the zip code of the warehouse

Order Handling Fee

 

Wayfair FTP Server

From Wayfair

Wayfair FTP User Name

From Wayfair

Wayfair FTP Password

From Wayfair

Login Email

From Wayfair

Login Password

From Wayfair

Safety Qty

This helps reduce the risk of overselling by subtracting a number of units from the available quantity

 Default Qty

When an item is set as replenishable, the value set here can be used as a default quantity for Wayfair



Wayfair shipping method mapping

  1. Go to Company Settings > Toolbox > Wayfair Settings >  Shipping Method Mapping
  2. Wayfair has unique codes to indicate shipping services. You can map these codes to services in SellerCloud to ensure the correct shipping service is used when shipping the order. 

Wayfair 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 > Save.


How did we do?