Wayfair Integration Overview

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


  1. Extensiv Integration Manager retrieves new orders from Wayfair
  2. Integration Manager delivers orders to WMS/OMS
  3. Integration Manager retrieves shipment tracking and inventory levels from WMS/OMS
  4. Integration Manager delivers shipment tracking, inventory levels, and invoice to Wayfair. 

Required Parameters

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

Important Integration Notes

Before setting up this connection to Wayfair, please review these important notes to ensure the integration is successful:


File Format

Integration Manager supports the WayFair EDI Flat File format Version 2. Make sure to have Wayfair enable that format and not the full edi format.

Product SKUs

Make sure you setup your Wayfair part numbers to match your warehouse's primary SKU so that inventory levels will sync properly.

Inventory Sync

Please keep in mind that Wayfair has a 5-unit buffer in place. Wayfair will display "out of stock" once an item has less than 5 units in stock. This number can be lowered by Wayfair if you have a low backorder rate.

Enable Wayfair inventory sync AT LEAST once every 8 hours in Integration Manager in order to prevent Wayfair issues.
Shipping Labels

Please reach out to your warehouse to make sure that the PO Number is placed under Reference Field #1 of Shipping Labels!

Integration Manager can not pull pre-printed labels from Wayfair. Integration Manager passes the order data to your warehouse, but your warehouse must print the shipping label. In some situations, users download labels from Wayfair and manually send them to the warehouse. In others, the warehouse can generate its own labels.

Wayfair Setup Guide

Follow the step-by-step instructions on the Wayfair Setup Guide to connect your Wayfair account to Integration Manager.



    • Related Articles

    • Wayfair UCC-128 Labels

      Extensiv Integration Manager does not generate UCC-128 labels. If Wayfair requires that you place UCC-128 labels on your boxes there are two main options: Have your warehouse generate the UCC-128 labels Manually download your UCC-128 labels from the ...

    • 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 ...

    • 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 ...

    • 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 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 ...