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
    •  Ready for Pickup Notice  
    •  Ship Notice - Yes
    •  Order Status Inquiry - No
    •  Order Status Report - No
    •  Functional acknowledgment - Yes
  5. Inventory Options
    • Frequency – choose "Hourly" – enter  "2"
    • Format – choose EDI 846 Transaction – Enter "Yes"
  6. Format - Enter YES in EDI section

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
 Supplier/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.

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?