The Logicbroker Blog

Wayfair EDI Integration

Dec 27, 2017 5:21:14 PM / by Phillip Berrouet

An EDI Solution for integrating Wayfair

If you are reading this article, then you are likely interested in an EDI (Electronic Data Interchange) integration with Wayfair to simplify the flow of electronic documents coming from and going into Wayfair. Logicbroker offers a REST API interface, commerceapi.io, as an alternative to traditional EDI.

To get started, you will need to have a Wayfair supplier extranet account. Navigate to the Help Center and submit an Inventory and EDI Set-Up ticket. An EDI Data Integration Team member will reach out to you with a warm introduction. Once received, you can copy your dedicated Logicbroker client delivery representative in your response. Logicbroker will complete the test process on your behalf, copying you in all subsequent communications. When testing is complete, we will need you to green-light Wayfair to go live with the successfully tested connection.

How to get started:

Step 1: Submit an EDI Set-Up ticket

To submit a ticket, go to the homepage and click the submit ticket button on the left. Please fill in all of the required information.

Step 2: Fill out the Data Integration Requirement (DIR) Form

Here you will need to provide Wayfair with the information that will be used to process the EDI documents. Logicbroker will provide you with this information.

Step 3: Setting up the Connection

Wayfair supports the following connection methods:

  • AS2 (Logicbroker Preferred)
  • FTP Direct Connection (Wayfair Preferred)
  • Value Added Network (VAN)

Logicbroker prefers to connect using AS2 protocol to eliminate VAN charges. New Wayfair integrations are setup on an existing AS2 connection. Logicbroker will setup testing both in a staging (stageportal.Logicbroker.com) and production environments (portal.Logicbroker.com). Details for Logicbroker’s AS2 information used to connect can be found here. Wayfair does not have a test environment, so Logicbroker will pull an order sent in Production and push it to the Stage environment to generate return documents. During this step, test documents will be sent to establish a successful connection to your system.

Step 4: Setting up the Documents

Wayfair will send a test order (850) and will expect return documents for review (997, 855, 856, and 810). Logicbroker can also complete this process with you or on your behalf. For more information on the documents and their functionality, see the table below:

Step 5: Testing with Logicbroker

All document logic and compliance for Wayfair’s EDI format is baked into the Logicbroker schema. Detailed documentation will be provided for all data that will need to be provided for the various formats (JSON, XML, CSV, etc.). This detailed data will include all fields required for all types of scenarios. Logicbroker will coordinate with Wayfair to ensure all parties are ready to transmit documents.

We will request the following information:

  • For the 855, we will request an average number of days to ship so that we can automate the creation of an 855 document upon receipt of a new order
  • For the 856, we will need you to provide what ship from locations you will use, and a default ship from address.
  • For the 810, we will need you to provide a remit to address that we will generate upon the creation of an invoice.

Step 5A: Inventory Management

Inventory management with Wayfair is very simple. We have certified EDI inventory with Wayfair and can automate the inventory file to be sent at an interval that works best for you—whether it be hourly, daily, weekly or even monthly.

In order to go live with inventory, we will need to know how often you wish for us to send the inventory file if different from our default, which is daily. Logicbroker will set this up to send automatically. Wayfair will need us to send a sample inventory file, and approve the structure of the inventory EDI. As we have Inventory certified, we will just need to send one of your SKUs to Wayfair from our test environment for confirmation. Testing inventory is also a training exercise in managing inventory from our portal.

We have an interface in our portal that is driven by .csv files.  You have the ability to update the inventory and add new items, as well as download the current inventory we are sending to Wayfair on your behalf. You can find more information on inventory management in our knowledge base here. Inventory is driven in Logicbroker by a matching file, which matches up your local SKU numbers to the SKU numbers Wayfair is expecting. This allows you to upload your inventory and have the power to choose what items to send to Wayfair via EDI.

Unmatched SKUs will be considered inactive, and orders that come in that have inactive SKUs will fail. The SKUs in a failed order will have to be activated through a matching file in order to allow the order to flow. Our support team will work with you to manage SKUs and preemptively reach out to you to resolve any SKU issues we encounter after you’ve gone live. We are always happy to help!

 

Step 6: Going Live

When all testing is complete and all documents have been verified by Wayfair, testing will be considered complete. At this point, Logicbroker will inform you via email that we are ready to go live, and Wayfair will need your approval to go live with the connection that has passed testing. Once live, Logicbroker will continue to monitor incoming documents and follow-up regularly to ensure all is well with your new integration. Throughout the first few weeks, support will be active and making sure that you are happy with the new integration. Afterwards, support will be ongoing, but from a proactive perspective— preemptively reaching out to you to resolve any possible issues as we encounter them.

 

Some important information to note during the testing process:

  • What kind of packages will be sent?

It will need to be noted what kind of carriers will be used, these can be either small package carriers like FedEx and UPS or LTL (less than truckload) carriers. Typically an LTL will be used when the shipment weight is over 150 lbs. Based on the carrier type, different information may need to be provided on the return shipping documents. This may include Bill of Lading and PRO/Tracking numbers.

  • Setting up Shipping Methods in Logicbroker

Being that not everyone shares the same shipping codes or identifies their shipping methods the same way, you can setup which carriers that you will be using and in addition customize the corresponding codes that match with Wayfair.

For Example (With ShipStation), if Wayfair requires the “UPSN” SCAC code for UPS and in your system you will provide “ups_ground”, you can map these. When Wayfair sends UPSN on the order, UPSN will appear as your carrier code. In addition, when you send “ups_ground” on outbound documents, this will automatically be converted to the “UPSN” standard for Wayfair.

  • ShipStation Customers

We offer an EDI solution for ShipStation Customers that can automate the flow of orders and return documents. We take advantage of ShipStation’s robust API to send orders, and receive shipments. Our solution automates the process and simplifies the experience for shipping Wayfair orders through the ShipStation platform.

When an order arrives we automatically acknowledge the order. When the order is shipped we automatically invoice the shipment going out to Wayfair, thus simplifying the process for ShipStation customers.

For more information about Logicbroker Certified Channels® visit https://www.logicbroker.com/channels/. To learn more about the platform and schedule a demo, contact us.

 

Topics: Blog

Phillip Berrouet

Written by Phillip Berrouet

Subscribe to Email Updates

Recent Posts