Setting Up Wayfair

Setting Up Wayfair


Required Parameters

Credentials from Wayfair that need to be entered in CartRover. 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 CartRover 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 CartRover generate invoices for Wayfair. Otherwise leave it blank.


All Connections:

Step 1: Download the "Wayfair Data Integration Requirements - Flat File" form → → → FTP DIR Form 2018.doc

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 DIR Flat File 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 2 for my company. I will be using the CartRover 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 CartRover 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:
    1. 50.18.194.14
    2. 54.241.171.180
    3. 98.179.251.146


Step 5: Setup a Wayfair cart in CartRover. (Carts tab > New Setup > Wayfair) Copy your SFTP credentials and Supplier ID into the CartRover 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 CartRover:

  • From the Merchant tab in CartRover 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

CartRover 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 CartRover 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 CartRover. Step-by-step guide Be sure you have filled out the Supplier Info section in the cart settings. From the Merchant page in ...
    • 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 CartRover 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 CartRover ...
    • 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 ...