Wayfair Integration for Linnworks
Packages Available: £29.99 + VAT per month
Step 1: Integrate the Channel into Linnworks.net

The Wayfair connector is an application which is embedded into Linnworks, and developed and supported by eBusiness Guru.

1. Login to Linnworks.net
2. Select Settings in the left-hand menu bar

3. Select the Channel Integration option.
4. Select Add New to return a list of available Channel Integrations.

5. Locate Wayfair on the list, and click on Integrate.

6. After reading the warning, please click on Accept to move onto the next step of the integration. You can click on the link at the bottom to review the Wayfair Connector’s Terms and Conditions first.

7. Enter your Wayfair account name to start the actual integration.

8. After reading the Disclaimer, please tick ‘I agree to the terms and conditions’ and Next to continue integrating Wayfair.

9. Wayfair Integration Guide

To integrate a Wayfair channel into Linnworks, you need the following information:

Wayfair controlled FTP connection which requires you to pull and push applicable files from Wayfair.

If you choose this option, Wayfair will set up your account and provide you with a username and password.

A) FTP Host Name :
Wayfair Provide FTP Host name .

B) FTP Username :
Wayfair provide FTP Username.

C) FTP Password :
Wayfair provide FTP Password.

D) Country:
This is the region or country for the Wayfair channel, eg. United Kingdom, United States, Germany, Canada.

E) File Type Name:
There are file type of order and product file. Ex. EDI, TXT.

F) Order Folder Name:
This is order folder name of FTP Access.
We access order files from that order folder.

G) Product Folder Name:
This is order folder name of FTP Access.
We access order files from that order folder.

To complete the integration, please click on Finish.

After successfully wayfair integration you have to upload current stock and your wayfair products list file to the outgoing folder of your given ftp.

Click here to download ProductFeed.csv (This file content the linnworks stock)

Click here to download ProductList.csv (This file content the wayfair products)

Your Wayfair integration should now show in Channel Integrations.

Step 2: Edit Channel Details


Account Status
1) In Linnworks .Net, Select Settings.
2) Select Channel Integration.
3) Locate the Wayfair entry, and look to the right. Click on the Configuration button.
4) To Enable or Disable the Account, locate the Account section.
5) If the Enabled option is unticked, the channel will not download or update orders, or provide inventory level updates.
6) The Test button allows you to confirm there are no errors preventing Linnworks and Wayfair communicating. Contact EBG Support if Test Reports any errors.
7) Click Save at the bottom of this window to apply any changes.

Channel Inventory Settings
1) In Linnworks .Net, Select Settings.
2) Select Channel Integration.
3) Locate the Wayfair entry, and look to the right. Click on the Configuration button.
4) In the Inventory section, the first entry is Update Inventory. If this is disabled, then Linnworks will not tell the listings on the Wayfair marketplace when Available Stock Levels change in Linnworks. If enabled, then Linnworks will provide these updates.
5) Update Inventory only works where a listing has been Mapped to a Linnworks Inventory item. See the end of this document for more information on Mapping.
6) The Price Change feature allows Linnworks to send new prices directly to the listing when they are correctly imported or updated.
a. Price Change only works where a listing has been Mapped to a Linnworks Inventory item. See the end of this document for more information on Price Change and Mapping.
7) Max Listed allows you to filter the highest quantity that Linnworks can/will send to the listings on this Wayfair channel. If Max Listed is set to 50, and your Available Stock moves from 30 to 60, Linnworks can only send 50, and this will not change until the Available Stock level drops below 50.
8) Stock Percentage acts in a similar fashion, but only updates the listings with the specified percentage of your actual Available Stock level.
a. End when allows you to set a ‘false zero’ for the channel. This means it will send Out of Stock when the available stock reaches the value set in this value.
9) Click Save at the bottom of this window to apply any changes.

Channel Listing Settings
Linnworks.net periodically checks the channel for the current listings you have on the channel, their titles and SKUs, so that the Mapping Tool can be used correctly. It can be triggered manually, should you have made changes directly on the channel and outside of Linnworks.
1) In Linnworks .Net, Select Settings.
2) Select Channel Integration.
3) Locate the Wayfair entry, and look to the right. Click on the Configuration button.
4) In the Listings section, the information reflects the information Linnworks currently has about your listed items on the Wayfair marketplace.
5) If there is a tick by Listing download in progress, Linnworks is downloading the current listings, and cannot be interrupted.
6) The Listing download start time value is the time the last download/update was started.
7) The Last listing download completion time value tells you the last successful download completed and was imported into Linnworks.
8) The Listing download estimated completion reflects Linnworks’ best estimate of when the most recent or current download should complete.The Download Listings button instructs Linnworks to retrieve the latest listing information, and ticks the Listing Download in Progress box. This can only be used once every 4 hours maximum, and will warn you if you try to use it more frequently.
9) Click Save at the bottom of this window to apply any changes.

Order settings
This section reflects activities affecting the Linnworks Order Sync on your Wayfair channel integration. Linnworks downloads orders from Wayfair with the status Shipping in Progress. 1) In Linnworks .Net, Select Settings.
2) Select Channel Integration. 3) Locate the Wayfair entry, and look to the right. Click on the Configuration button.
4) In the Order section, there are 2 options.
5) Despatch Notes, when enabled, allows Linnworks to send information about orders that have been Processed in Linnworks. Orders that are Processed in Linnworks are updated to the status Shipped on Wayfair.
6) The Order Sync Date reflects the date and time of the last successful order download and update for the current Wayfair channel integration.
7) Click Save at the bottom of this window to apply any changes.

API Settings
These settings are used to enable Linnworks and your Wayfair account to connect, and are covered in Step 1.
Click Save at the bottom of this window to apply any changes.

Mapping
Linnworks.net uses the Mapping Tool to ensure that it knows which SKUs in its inventory are connected to which listings on Wayfair. As such, you should ensure that all of your listings are mapped correctly, or stock levels and prices will not update correctly, and orders may not be picked accurately.
1) In Linnworks .Net, Select Settings.
2) Select Channel Integration.
3) Locate the Wayfair entry, and look to the right. Click on the Mapping button (see above).
This screen is divided into 2 sections.
On the left is the listings Linnworks is aware of on your Wayfair Channel. If this is not correct, or a change is missing, you should see the Download Listings button in the Listings section of the Channel Configuration. On the right is a Linnworks Inventory Search Tool.
Each has its own Search box.

In the bottom left hand corner of the window is a status section. It shows the Total number of listings on the channel, and then beside it the Unlinked and Linked numbers – Linked listings are connected to a Linnworks Inventory item to allow updates and recognition, Unlinked are not. Ideally there should be no Unlinked listings.

Linking items Automatically
If the SKUs in your inventory match the SKUs used on the listings, you can ask Linnworks to link them all for you.
1) Click the button in the top left hand corner with a gear on it.
2) Select Link all by.
3) Select SKU.
4) Linnworks will map all those listings that have a SKU which matches a SKU in the Linnworks Inventory.
5) Check the Linked and Unlinked values once this is complete.

Linking Items Manually
If the SKUs in your inventory do not match the SKUs used on the listings, you can make the link manually.
1) Use the left hand list and Search to find the listing to be linked.
2) Click on it to highlight and select it.
3) In the right hand list, use the Search box to find the correct Linnworks Inventory item to link it to.
4) Click on the Link button beside it with the listing highlighted.
5) Repeat for other listings to be linked manually.

Creating Linnworks Inventory items and mapping them
If there is no SKUs in your inventory match to the SKUs on the listings, you can ask Linnworks to create basic Inventory items for you, and link them.
1) Use the left hand list and Search to find the listing to be linked.
2) Click on Create button.
3) A new item will be created in the Linnworks inventory using the Name, Price and stock level, as well as the SKU from the listing. This will be linked to the SKU.
4) This can be updated with other information later in the Inventory.
5) Repeat this for other Listings that have no Linnworks inventory equivalent.

Price Change Functionality
Price Change only works for listings that are correctly linked to a Linnworks Inventory item in the Mapping Tool.
1) Open Linnworks.Net.
2) Select Inventory.
3) Select My Inventory.
4) Use Search to locate the Inventory item that requires a Price Change on Wayfair.
5) Click on the SKU to edit the item.
6) Click on the Listing descriptions tab.
7) Under the Product pricing by channel section, click on Add New.
8) Enter the Source as Wayfair.
9) Enter the SubSource as the name of the Wayfair channel.
10) Enter the Price.
11) Click on + Add to complete.
12) If there is already an entry present for the correct Source and SubSource, double click the Price to edit it, and then hit Enter.
13) Close the SKU window when you have finished.

Step 3: Location Mapping


1) In Linnworks .Net, Select Settings.
2) Select Channel Integration.
3) Locate the Wayfair entry, and look to the right. Click on the Configuration button.
4) Locate the Location Mapping button, and click on it.
5) This opens the Location Mapping window.
6) The first option is the Order Download location. This is initially Default, but can be changed. Click on the dropdown list and select which inventory/fulfillment location will initially receive the orders from this Wayfair integration.
7) Under Inventory Sync Locations, you control which Linnworks Inventory locations are used to calculate the Available Stock values for your Wayfair listings.
8) If you have only the Default location, this can be ignored, with Default left enabled.
9) If you have multiple Inventory Locations, you can switch Off locations (Slide switch to the left) that you don’t want to be included in the stock numbers on the listings.

Click Save when you have finished to update Linnworks. You should also click Save at the bottom of the configuration window to apply any changes.

Step 4: Mapping

Linnworks.net uses the Mapping Tool to ensure that it knows which SKUs in its inventory are connected to which listings on Wayfair. As such, you should ensure that all of your listings are mapped correctly, or stock levels and prices will not update correctly, and orders may not be picked accurately.
1) In Linnworks .Net, Select Settings.
2) Select Channel Integration.
3) Locate the Wayfair entry, and look to the right. Click on the Mapping button (see above).
This screen is divided into 2 sections.
On the left is the listings Linnworks is aware of on your Wayfair Channel. If this is not correct, or a change is missing, you should see the Download Listings button in the Listings section of the Channel Configuration. On the right is a Linnworks Inventory Search Tool.
Each has its own Search box.

In the bottom left hand corner of the window is a status section. It shows the Total number of listings on the channel, and then beside it the Unlinked and Linked numbers – Linked listings are connected to a Linnworks Inventory item to allow updates and recognition, Unlinked are not. Ideally there should be no Unlinked listings.

Linking items Automatically
If the SKUs in your inventory match the SKUs used on the listings, you can ask Linnworks to link them all for you.
1) Click the button in the top left hand corner with a gear on it.
2) Select Link all by.
3) Select SKU.
4) Linnworks will map all those listings that have a SKU which matches a SKU in the Linnworks Inventory.
5) Check the Linked and Unlinked values once this is complete.

Linking Items Manually
If the SKUs in your inventory do not match the SKUs used on the listings, you can make the link manually.
1) Use the left hand list and Search to find the listing to be linked.
2) Click on it to highlight and select it.
3) In the right hand list, use the Search box to find the correct Linnworks Inventory item to link it to.
4) Click on the Link button beside it with the listing highlighted.
5) Repeat for other listings to be linked manually.

Creating Linnworks Inventory items and mapping them
If there is no SKUs in your inventory match to the SKUs on the listings, you can ask Linnworks to create basic Inventory items for you, and link them.
1) Use the left hand list and Search to find the listing to be linked.
2) Click on Create button.
3) A new item will be created in the Linnworks inventory using the Name, Price and stock level, as well as the SKU from the listing. This will be linked to the SKU.
4) This can be updated with other information later in the Inventory.
5) Repeat this for other Listings that have no Linnworks inventory equivalent.

Price Change Functionality
Price Change only works for listings that are correctly linked to a Linnworks Inventory item in the Mapping Tool.
1) Open Linnworks.Net.
2) Select Inventory.
3) Select My Inventory.
4) Use Search to locate the Inventory item that requires a Price Change on Wayfair.
5) Click on the SKU to edit the item.
6) Click on the Listing descriptions tab.
7) Under the Product pricing by channel section, click on Add New.
8) Enter the Source as Wayfair.
9) Enter the SubSource as the name of the Wayfair channel.
10) Enter the Price.
11) Click on + Add to complete.
12) If there is already an entry present for the correct Source and SubSource, double click the Price to edit it, and then hit Enter.
13) Close the SKU window when you have finished.

Step 5: Payment Mapping


1) In Linnworks .Net, Select Settings.
2) Select Channel Integration.
3) Locate the Wayfair entry, and look to the right. Locate the Payment Method button (see above), and click on it.
4) This opens the Edit Payment Methods window, the list will initially be blank.
5) When mapped, Linnworks will ensure the orders it downloads from Wayfair reflect correctly which payment methods/providers have been used on the site.
6) Click Save at the bottom of the channel integration window to apply any changes.

Map Wayfair Payment Methods


1. Select the Channel Payment Method value, and select one of the Payment Methods from Wayfair that show in the dropdown list.
2. Then click on the Linnworks Payment Method dropdown. Select the appropriate Linnworks Payment Method that should be used in Linnworks orders when they are downloaded including the above payment method.
3. Press Add to save the mapping, and return to the list.
4. Repeat this for all of the Wayfair payment methods that are being used by you.
5. Click Save at the bottom of the channel configuration window to apply any changes.

Step 6: Shipping Mapping


The next step is to map your Wayfair Shipping services to Postal Services in Linnworks, so orders don’t need to have their Postal Service set manually. Initially, all are mapped to Default.
1) In Linnworks .Net, Select Settings.
2) Select Channel Integration.
3) Locate the Wayfair entry, and look to the right. Locate the Shipping Mapping button (see above), and click on it. 4) In the Edit Shipping Allocation window, you should have an empty list.
5) To add a new entry for one of your Wayfair shipping services, click on Create New.

Create New Shipping Service Mapping

1. For Channel Service Name, Enter the name of the Shipping Service in Wayfair.
2. In Channel Service Tag, enter the Tag value used for the service in Wayfair.
3. In the Linnworks Postal Service dropdown, select the name of the Linnworks Postal Service that should be used for orders imported from Wayfair with the Shipping Service to dispatch them correctly.
4. The Add button will save the mapping, and display it in the Edit Shipping Allocation screen.
5. Repeat this for all the other Wayfair Shipping methods you are using. This ensures your Linnworks order processing will run smoothly, and with minimal distractions.
6. Click Save at the bottom of the channel integration window to apply any changes.

Get your free quote

Call 0208 090 4547

Hear From Our Clients

Best website/e-commerce vendor I've worked with in my 10 years of being an IT PM! We hired eBusiness Guru to create our e-commerce website for our premium brand. This was no easy task as it was not your traditional e-commerce site. They delivered on-time, on-budget, and all with a successful release to the public and established partnership with us. We enjoyed working with the whole team. I would highly recommend them for any website need.
Bastien Peyronnel

Certifications