Wayfair Products and Listings Management


Overview

The Wayfair Account Integration allows you to easily manage your inventory directly from Sellerlcoud. This article explains how to manage your products for Wayfair. It also covers how to update Replenishable Products within the Wayfair system.


Configure your Wayfair Settings

To configure your Wayfair Properties on Sellercloud:

  1. Navigate to Inventory > Manage Inventory > Choose and open a Product. 
  2. Open the Toolbox > Wayfair Properties > Click Edit.

General Panel

Option Description
Enabled  This option allows Sellercloud to start sending automatic inventory updates for that SKU.
Discontinued  Notes whether or not the product has been discontinued.
Merchant SKU Alternate SKU used to communicate a product to а specific channel.
Wayfair Product ID A unique Wayfair Product ID. Once you list your product, Sellercloud will pull this information and populate the field.

Inventory Panel

Option Description
Composite Wood The product is related to composite wood.
Replenishable  Enabling this option allows you to sell a specific item regardless of the available quantity. When updating different channels, Sellercloud sends a fixed quantity for replenishable products, so it consistently shows a specific available quantity.
Enable Default Qty This only applies to Replenishable products. For these products, the Default Quantity is the number that will always be sent to the channel in inventory updates regardless of the actual available inventory.
Safety Qty The buffer between the amount of inventory you have and the amount Sellercloud is sending to the channel to prevent overselling on high-selling items. It is used to subtract a number from the available quantity. When a product is set to Replenishable, the Safety Quantity is ignored.
Available Qty The inventory available quantity for sale, i.e., the physical quantity in all sellable warehouses, minus unshipped orders and reserves.
Qty for Wayfair The available inventory for Wayfair.
You will notice that there is a Default checkbox next to Default Qty, Max Qty, and Safety Qty. If you enable it, the Product level quantity will be overwritten by the corresponding value set on the company level.

Pricing Panel

Option Description
Wayfair Price The product’s price on Wayfair.
Default Enable Default to use the product’s Site Price instead of a separate unique price.
Wayfair Cost The price the seller pre-determined with Wayfair, and it can overwrite the Product Price on orders coming in from Wayfair.

Actions Explained

From the Actions menu at the top-right corner on the Wayfair Properties page, you can perform the following actions:

  • Download Inventory Update – This allows you to download the inventory as an EDI file directly to your device.
  • Upload Inventory Update – Exports the inventory update for the product to Wayfair.
  • Disconnected from Inventory – Disconnects the inventory feed when, for example, you have a different system to update your listings.
  • Restrict/Unrestrict For Channel – When a product is restricted, Sellercloud will not allow updates for it on the channel, and will not include the SKU in inventory feeds.
You can also Restrict/UnRestrict products in bulk by going to Catalog Manage Catalog > Search for and select products > Actions > Restrict/Unrestrict for Channel > Select Wayfair in the pop-up > Click Update.

Update Inventory on Wayfair

You can update your inventory to Wayfair manually and automatically.

Manually

The manual Wayfair inventory updates can be done individually or in bulk.

  • Individually
    • Navigate to Catalog > Manage Catalog > Open a product > ToolboxWayfair Properties > Actions menu > Upload Inventory Update
  • In Bulk
    • Navigate to Catalog > Manage Catalog > Select your products > Action menu > Update Inventory on Channel
    • In the newly opened window, select Wayfair > Update.

Automatically

Automation is controlled by Wayfair’s General Setting Enable Inventory Upload. When enabled, Sellercloud periodically sends automatic inventory updates for your Wayfair-enabled products.

Pricing changes must be negotiated with a Wayfair representative. Currently, no option exists to update pricing in the inventory feeds. The Wayfair Price field on the product’s Wayfair Properties page is only for reference.

If you have multiple warehouses for Wayfair, use the Channel Warehouse Mapping feature.

Additional Product Configuration

Update Replenishable Products

For products marked as Replenishable (product is sold regardless of the available quantity), select the Enable Default Qty setting. Otherwise, the inventory feed will only send a quantity of 1. The following options will become available once this setting is enabled:

  • Use Default (pre-selected) — Keep this selected if you want to use the Default Qty from the Wayfair Settings page; or
  • Default Qty (used for replenishable products only) — Uncheck the Use Default box and enter a specific number that will always be sent to Wayfair in inventory updates, regardless of the actual inventory available for this product.

Discontinue Wayfair products

If an item has no available quantity, an order can still be placed on Wayfair for it unless it is discontinued. For a product to be discontinued on Wayfair, it must be marked as Discontinued in Sellercloud and have 0 quantity on the product’s Wayfair Properties page. To reactivate the item, simply uncheck Discontinued and Save.

Variations

Wayfair has its own way of processing variations listed on its platform. All matrix children on Wayfair will have the same Wayfair ID attached to them, so it is important you set them up properly in Sellercloud.
Make sure the Wayfair Merchant ID of each variation child matches the corresponding Sellercloud Product ID. This way, when an order comes in from Wayfair, Sellercloud will be able to recognize which variation needs to be shipped out.

Backorder Quantity

When you are using the Backorder option for Wayfair, you need to enable Send Backorder Information on the Wayfair General Company Settings Page. When enabled, we will send inventory for out-of-stock products following these rules:

  • If the OnOrder quantity of the product is > 0, and the expected delivery date is set to a date in the future, then Sellercloud will send the quantity on order, and the set expected delivery date automatically.
  • If there is an OnOrder quantity but no expected delivery date set, Sellercloud will send both fields. However, the expected delivery date will be set to one month in the future.
  • If there is no OnOrder quantity and no expected delivery date, Sellercloud will send the quantity as zero.

Overview

The Wayfair Account Integration allows you to easily manage your inventory directly from Sellerlcoud. This article explains how to manage your products for Wayfair. It also covers how to update Replenishable Products within the Wayfair system.


Configure your Wayfair Settings

To configure your Wayfair Properties on Sellercloud:

  1. Navigate to Inventory > Manage Inventory > Choose a Product > Toolbox > Wayfair Properties.
  2. Update the desired fields > Click Save.

General Panel

Option Description
Enabled  This option allows Sellercloud to start sending automatic inventory updates for that SKU.
Discontinued  Notes whether or not the product has been discontinued.
Merchant SKU Alternate SKU used to communicate a product to а specific channel.
Wayfair Product ID A unique Wayfair Product ID. Once you list your product Sellercloud will pull this information and populate the field.

Inventory Panel

Option Description
Composite Wood The product is related to composite wood.
Replenishable  Enabling this option allows you to sell a specific item regardless of the available quantity. When updating different channels, Sellercloud sends a fixed quantity for replenishable products, so it consistently shows a specific available quantity.
Enable Default Qty This only applies to Replenishable products. For these products, the Default Quantity is the number that will always be sent to the channel in inventory updates regardless of the actual available inventory.
Safety Qty The buffer between the amount of inventory you have and the amount Sellercloud is sending to the channel to prevent overselling on high-selling items. It is used to subtract a number from the available quantity. When a product is set to Replenishable, the Safety Quantity is ignored.
Available Qty The inventory quantity is available for sale, i.e., the physical quantity in all sellable warehouses minus unshipped orders and reserves.
Qty for Wayfair The available inventory for Wayfair.
You will notice that there is a Default checkbox next to Default Qty, Max Qty, and Safety Qty. If you enable it, the Product level quantity will be overwritten by the corresponding value set on the company level.

Pricing Panel

Option Description
Wayfair Price The product’s price on Wayfair.
Default Enable Default to use the product’s Site Price.
Wayfair Cost The price the seller pre-determined with Wayfair, and it can overwrite the Product Price on orders coming in from Wayfair.

Actions Explained

From the Actions menu at the top-right corner on the Wayfair Properties page, you can perform the following actions:

  • Download Inventory Update – This allows you to download the inventory as an EDI file directly to your device.
  • Upload Inventory Update – Exports the inventory update for the product to Wayfair.
  • Disconnected from Inventory – Disconnects the inventory feed when, for example, you have a different system to update your listings.
You can also Restrict a product for Wayfair by going to Manage Inventory > Search and Select a product > Action Menu > Restrict/UnRestrict For Channel > Select Wayfair on the following page > Click Continue. When a product is restricted, Sellercloud will not allow updates for it on the channel, and will not include the SKU in inventory feeds.

Update Inventory on Wayfair

You can update your inventory to Wayfair manually and automatically.

Manually

The manual Wayfair inventory updates can be done individually or in bulk.

  • To upload Individually:
    • Navigate to Inventory > Open a product > ToolboxWayfair Properties > Action menu > Upload Inventory Update > Go.
  • In Bulk
    • Navigate to Inventory > Select your products > Action menu > Update Inventory on Channel > Go.
    • In the newly opened window, select Wayfair > Continue.

Automatically

Automation is controlled by Wayfair’s General Setting Enable Inventory Upload. When enabled, Sellercloud periodically sends automatic inventory updates for your Wayfair-enabled products.

Pricing changes must be negotiated with a Wayfair representative. Currently, no option exists to update pricing in the inventory feeds. The Wayfair Price field on the product’s Wayfair Properties page is only for reference.

If you have multiple warehouses for Wayfair, use the Channel Warehouse Mapping feature.

Additional Product Configuration

Update Replenishable Products

For products marked as Replenishable (product is sold regardless of the available quantity), select the Enable Default Qty setting. Otherwise, the inventory feed will only send a quantity of 1. The following options will become available once this setting is enabled:

  • Use Default (pre-selected) — Keep this selected if you want to use the Default Qty from the Wayfair Settings page; or
  • Default Qty (used for replenishable products only) — Uncheck the Use Default box and enter a specific number that will always be sent to Wayfair in inventory updates, regardless of the actual inventory available for this product.

Discontinue Wayfair products

If an item has no available quantity, an order can still be placed on Wayfair for it unless it is discontinued. For a product to be discontinued on Wayfair, it must be marked as Discontinued in Sellercloud and have 0 quantity on the product’s Wayfair Properties page. To reactivate the item, simply uncheck Discontinued and Save.

Variations


 

Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support