Setting Up Wayfair

Setting Up Wayfair

Required Parameters

Credentials from Wayfair that need to be entered in Extensiv Integration Manager. The setup guide below will explain how to request/obtain these:

  • FTP Username
  • FTP Password
  • Supplier ID

Premium Setup
Wayfair setup or testing performed by Integration Manager has a setup fee. Please  create a support ticket to get a new setup started.

Step-by-step guide

Integrating with Wayfair is completed with the following steps. This process takes one week on average (including testing):

Wayfair EU Only (Skip this step for Wayfair US Connections):

Download and finish filling out the Wayfair_Automation_Questionnaire.docx

  • Enter your contact info in the Supplier Technical Contact section
  • Select the Invoices box if you will also have Integration Manager generate invoices for Wayfair. Otherwise leave it blank.

All Connections:

Step 1: Download the "Wayfair Data Integration Requirements - Flat File" form → → → Wayfair EDI DIR Form-SFTP.docx

Step 2: On page 2 of the form, fill out your contact info. Save the file. 

Step 3: Enter a support ticket in the Wayfair Extranet to request a data connection. Attach the Wayfair EDI DIR Form in your message (you may have to do this after creating the ticket).

You can paste the following message:

Wayfair Integrations team,

I would like to request a data integration using the Wayfair EDI Flat File format Version 2018 for my company. I will be using the Integration Manager application for this connection and have filled out the "Wayfair Data Integration Requirements - Flat File" form. Please also provide FTP credentials and our Supplier ID.

Step 4: Whitelist the Integration Manager servers in your Wayfair Extranet account:

  1. Navigate to Account Management > Supplier Account Details
  2. Select the EDI/Marketing Data Transfer Methods tab
  3. Enter each of the following IP address and press  Add after adding each one:

Step 5: Setup a Wayfair cart in Integration Manager. (Carts tab > New Setup > Wayfair) Copy your SFTP credentials and Supplier ID into the Integration Manager Wayfair Cart Setup page. 

Step 7: Click on the Test button to validate your FTP credentials. 

Step 8: Click on OK button to save current page. 

Step 9: Contact CartRover Support to request to begin the testing process. Once testing is complete, Wayfair will move your account into production. 

      You may perform testing on your own with Wayfair. This requires loading test orders and generating tracking information to send back to them. However this can delay your time to go live.

Setup From Address

Wayfair requires you to provide the address that each order ships from. To set this up in Integration Manager:

  • From the Merchant tab in Integration Manager click on Locations & Products

  • Select your warehouse from the list or add a new one if there isn't one.
  • Click the Edit Warehouse button
  • Click on Add Address and enter the address. You can leave additional fields like "AddressTypeCode" blank.

Wayfair File Types

Integration Manager can load the following Wayfair file formats:
  1. CSV 2018
  2. CSV V2 (Pre 2018)
  3. EDI
You must select the proper file format in your Integration Manager settings that matches your Wayair account. 

    • Related Articles

    • Wayfair EU Invoice Setup

      If you will be sending invoices back to Wayfair EU, you need to perform the following additional setup steps in Extensiv Integration Manager. Step-by-step guide Be sure you have filled out the Supplier Info section in the cart settings. From ...
    • Overdue Inventory for Wayfair

      Problem Wayfair has sent an email notifying you that your inventory has "gone beyond our accepted reliability threshold and has expired." Solution This happens if Wayfair does not receive inventory information every day. To solve this issue, make ...
    • Wayfair Data Integration Requirements - Flat File form

      See Wayfair Setup Guide for context.  Complete the Data Integration Requirements - Flat File Form  Follow these instructions to complete the integration form properly. Some information you can get from the form itself. Section 1: Contact Information ...
    • Wayfair Integration Overview

      Supported Marketplaces Integration Manager supports both Wayfair North America and Wayfair Europe. Separate connections are needed for each.  Supported functions Order Download Inventory Sync Shipment Confirmation - Detailed Invoice Workflow Extensiv ...
    • Setting Up ChannelAdvisor

      Integration Specs: Supported functions: Order Download Shipment Confirmation - Detailed Inventory Sync Required Parameters ChannelAdvisor Admin Username ChannelAdvisor Admin Password Step-by-step guide On the New ChannelAdvisor setup page, click the ...