Wayfair Account Integration

Integrating with Wayfair is accomplished with the following steps:

  1. Complete the required integration form and return it to Wayfair. Usually, the client will already have contacted Wayfair and received the form. 
  2. Enter Wayfair credentials into the Wayfair settings in SellerCloud.
  3. Shipping method mapping for Wayfair. This is not required, but it will place the correct method of shipping on the order.
  4. Configuring Wayfair Invoices/Packing Slips
  5. Client's SellerCloud server must be whitelisted on Wayfair. The server IP can be provided to you by SellerCloud Support.

Complete the  Integration Form - Follow these instructions to complete the integration form properly. Some information you can get from the form itself.
  1. Section 1 - Contact Information
    • Complete contact information.
  2. Section 2 – Connectivity Options
    • FTP Direct Connection - Enter "Yes".
  3. Section 3 - Configuration
    1. Production ISA:
      • Qualifier - Enter "ZZ"
      • ID - Use company telephone number.
    2. Test ISA 
      • Qualifier - Enter "01" 
      • ID - Issued to customer from Wayfair
    3. Version – enter “Yes” in the 4010 box.
  4. 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
  5. Inventory Options
    • Frequency – choose "Hourly" – enter  "2"
    • Format – choose EDI 846 Transaction – Enter "Yes"

Wayfair Settings  - Now go to Settings > Company Settings > Toolbox > Wayfair Settings > General Settings.

Complete the following fields with the following credentials.
 ISA Qualifier ZZ
 ISA ID The Wayfair ID you created. For example,  you  can use your company telephone number.
 Wayfair Qualifier             01
 Wayfair ISA ID Obtained from Wayfair
 Wayfair Seller ID leave blank
 SupplierID Obtained from Wayfair
Warehouse ID Typically, this is the Zip code for the warehouse.
 Order Handling Fee 
 Wayfair FTP Server information given by Wayfair
 Wayfair FTP User Name information given by Wayfair
 Wayfair FTP User Name information given by Wayfair
 Wayfair FTP Password information given by Wayfair
 Login Email information given by Wayfair
 Login Password information given by Wayfair
 Safety Qty A safety quantity helps reduce the risk of overselling by subtracting a number of units from the available quantity.
 Default Qty When item is set as replenishable, the value set here can be used as a default qty for Wayfair.

Remember to enable the channel from the checkbox on top after entering the settings.

Wayfair Shipping Method Mapping
Company Settings >  Toolbox > Wayfair Settings >  Shipping Method Mapping. 
Wayfair has unique codes to indicate shipping services. Those codes can be mapped to services in SellerCloud to ensure the correct shipping service will be utilized when shipping the order. 

Wayfair Invoices
As a fulfillment channel, the Wayfair packing slip must be printed and inserted into the shipping package together with the order. The Wayfair packing slip will print out automatically for Wayfair order. However, if you are utilizing the Per Channel Invoice Preferences option, you will need to initially configure the Wayfair packing slip. Read more here

How did we do?