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.

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  

Open Settings > Company Settings > Toolbox > Wayfair Settings > General Settings and complete the following fields with the following credentials.

Note: See instructions about setting co-op fees here for dropship

 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 quantity for Wayfair.

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

Wayfair Shipping Method Mapping

Go to 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 is used 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 orders. However, if you are using the Per Channel Invoice Preferences option, you must initially configure the Wayfair packing slip. Read more here


How did we do?