Wayfair

The Wayfair plugin is the official plugin for using PlentyONE to sell items on the Wayfair marketplace. The plugin provides multiple integrations with Wayfair’s interfaces, including - but not limited to - the following operations:

  • Automatic retrieval of Wayfair orders, with conversion to PlentyONE orders

  • Automatic sending of PlentyONE inventory information to Wayfair to keep item availability accurate

  • Automatic transfer of Wayfair-generated shipping documents to plentymarkets

  • Sending order status changes from PlentyONE to Wayfair, to keep Wayfair customers and Wayfair Customer Support up to date.

1. Selling on Wayfair

Wayfair is a closed marketplace. Use of the Wayfair plugin is limited to organizations that have registered as Wayfair suppliers.

If you are not currently selling on Wayfair, please head to the Wayfair website and register as a partner to get started.

2. Preparing to use the Wayfair plugin

Use of the Wayfair plugin requires Wayfair API credentials that have been granted the appropriate rights.

Prior to installation, please use these instructions to contact Wayfair and obtain proper API credentials.

2.1. Wayfair plugin: Getting API Credentials

In order for the Wayfair plugin to connect to Wayfair’s systems, you need to provide your unique API credentials. To receive the API credentials for you organization, follow these steps:

2.1.1. Send an Email to Wayfair

Please send an email to your Wayfair Account Manager, and copy (CC) johara1@wayfair.com to request assistance:

Subject : Access to PlentyONE plugin / (Name of your company) (Wayfair Supplier ID) Body: Your contact information. Short description of how you intend to use the PlentyONE plugin. Date when you are ready to use the Wayfair PlentyONE Plugin. You will promptly receive a response containing these details:

Confirmation of your API access being set up. Supplier ID(s) for your Warehouses.

2.1.2. Generate Application Credentials

  • Go to https://partners.wayfair.com/developer/applications.

  • Enter your Wayfair Partner Home credentials. You should be redirected to the Application Management page for Wayfair.

  • On the Application Management page, click the New Application button at the bottom of the page.

  • On the Create Application form, provide the new application’s details:

    Name: A useful identifier such as [My Supplier] PlentyONE plugin. Description: something like PlentyONE plugin application for [My Supplier] Go-Live in Fall 2020.

  • Use the slider switch at the bottom of dialog to set it to Production, unless otherwise instructed by Wayfair.

  • Click Save on the Create Application dialog, which will display the application’s credentials - Client ID and Client Secret.

  • Copy the Client ID and Client Secret to a secure location.

    The Client Secret cannot be retrieved after this point and a new one must be generated if the original is lost. These credentials will be used for authorizing the Wayfair plugin for use of Wayfair’s systems.

  • Close the credentials dialog to protect the information.

3. Installing and setting up the Wayfair plugin

3.1. Prerequisites

  • A PlentyONE system

  • Administrative rights on the PlentyONE system where the Wayfair plugin will be used

  • The PlentyONE user’s Access setting must be Admin

  • The PlentyONE user must be able to modify Plugin Sets

  • Active Wayfair supplier status

  • Wayfair API credentials

  • Installation of the Wayfair plugin

3.2. Authorizing the Wayfair Plugin to access Wayfair interfaces

After the plugin is installed in your PlentyONE Plugin Set, the plugin must be configured to use the correct credentials when connecting to Wayfair’s interfaces.

The authorization procedure must be performed for any Plugin Set that contains the Wayfair plugin. The authorization steps are as follows:

Authorizing the Wayfair Plugin to access Wayfair interfaces:

  1. From the main PlentyONE page, go to Plugins » Plugin set overview.

  2. Click on the Plugin Set that is linked to the client with which Wayfair will be used to open it.

  3. Locate the Wayfair plugin from the list and click on it to open the configurations page.

  4. In the Supplier Settings area, enter the Client ID and Client Secret values that correspond with your Wayfair API credentials.

  5. Change the Mode setting to Live.

  6. Click the Save button in the toolbar above the settings.

3.3. 2. Activate order referrer Wayfair

Activate order referrer Wayfair:

  1. Go to Setup » Orders » Order referrer.

  2. Activate Wayfair

  3. Save the settings

3.4. 3. Setting up PlentyONE for shipping through Wayfair

3.4.1. Creating the Shipping Service Provider

In order to create a Shipping Profile to be used for Orders, a Shipping Service Provider object must first be set up, which associates the Shipping Profile with a carrier. Follow these steps to create the Wayfair-specific Shipping Service Provider:

Creating the Shipping Service Provider:

  1. From the main PlentyONE page, go to Setup » Orders » Shipping » Settings.

  2. Select the Shipping service provider tab

  3. Click the New button to add a new row to the table.

  4. In the new row that is created, populate the Name fields (we recommend `WayfairShipping' for all names).

  5. In the Shipping service provider field for the row, choose the WayfairShipping option - this reflects the type that is provided by the Wayfair plugin. All other fields in the row may be left blank.

  6. Click Save button

3.4.2. Creating the Shipping Profile

Each order has a Shipping Profile that is used for working with the shipping service provider to ship items from an order. Use these steps to set up the Wayfair-specific Shipping Profile.

Creating the Shipping Profile:

  1. From the main PlentyONE page, go to Setup » Orders » Shipping » Settings.

  2. Select the Shipping profiles tab

  3. If a Wayfair row already exists, click on it. Otherwise, click the New button to open the Shipping Profile’s settings page.

  4. Select your Wayfair Shipping service provider from the menu provided (WayfairShipping if you have created the suggested Shipping Service Provider).

  5. Populate the Name fields (we recommend WayfairShipping for all names).

  6. Set the language using the menu to the right of the Name field

  7. In the Flag field, choose the icon that will represent Wayfair orders (6 and 126 are good options, as they reflect the Wayfair color scheme)

  8. In the Priority field, optionally change the priority (we recommend leaving it as the default, highest priority).

  9. In the Clients (stores) field, make sure to select all stores that may be set up for Wayfair.

  10. In the Order referrer list, place a check mark next to any Wayfair-related entries.

  11. Click on the Save button save button. at the top of the page. You may need to scroll up in order to reveal the button.

3.4.3. Optional: selecting the Wayfair Shipping Profile automatically for Wayfair orders

Optionally selecting the Wayfair Shipping Profile automatically for Wayfair orders:

  1. From the main PlentyONE page, go to Setup » Orders » Events.

  2. Click on Add event procedure (the + button on the bottom left-hand side of the page)

  3. Enter a Name such as Wayfair order Shipping Mapping.

  4. Select the event New order from the dropdown list.

  5. Click the Save button save button on the dialog. The new procedure will now be selected, with the Settings section in view.

  6. In the Settings section of the event procedure, check the Active checkbox

  7. Click on Add Filter and choose Referrer: Wayfair in the Order category.

  8. Click the Add button plus add button.

  9. In the Filter section, a box should appear with a list of all available Order referrers. Place a checkmark next to all Wayfair order referrers.

  10. Click on Add procedure.

  11. Select Order » Change shipping profile.

  12. Click the Add button to complete the dialog.

  13. A Change shipping profile Procedure will appear in the Procedures area.

  14. Click on the left-most carat icon collapsed carat on the left of the Change shipping profile Procedure’s row (this is NOT the large square button that also happens to have a carat icon on it) to expand the Procedure’s details

  15. In the drop-down list on the Procedure, choose the Shipping Profile created for WayfairShipping

  16. Click the Save button at the top of the page to complete the creation of the Event Procedure.

3.5. 4. Matching items ordered on Wayfair with Item Variations in PlentyONE

In order to properly handle incoming orders from Wayfair, the Wayfair plugin must match the Supplier Part Numbers in Wayfair’s systems with a specific field of Item Variations in PlentyONE. By default, the Wayfair plugin operates on the assumption that the Variation Number (not to be confused with the Variation’s ID) of an Item’s Variation in PlentyONE will match the Wayfair Supplier Part Number.

If the Wayfair Supplier Part Numbers for your organization are to be reflected in an alternative field in your PlentyONE Item Variations, change the value of the Item Mapping Method setting and update the Variations accordingly.

3.6. 5. Making items available for sale on Wayfair

Items that you want to sell on the Wayfair market must be considered active in PlentyONE and have Referrer: Wayfair. The PlentyONE user may also choose to limit which Items are for sale on Wayfair. Note that Inventory and ordered items are controlled at the Variation level.

3.7. 6. Configuring the Warehouse mappings to match Wayfair Supplier IDs.

In order to update the inventory data in Wayfair’s system, you need to map the Warehouses in your PlentyONE system to the Supplier IDs in Wayfair’s system, on the Warehouses page of the plugin’s settings.

3.8. 7. Configuring PlentyONE to send Confirmation of Delivery (ASN) to Wayfair

##Setting the Wayfair Plugin to send the correct shipping information to Wayfair Wayfair Plugin users that wish to ship orders by using their own accounts (rather than using Wayfair’s shipping services) must update the Ship Confirmation (ASN) configuration settings to reflect their specific configuration.

If Wayfair’s shipping services are to be used, the Wayfair plugin’s ASN settings should be left in their default (Wayfair Shipping) state.

3.8.1. Creating an Event for PlentyONE Orders that sends shipment information to Wayfair

Creating an Event for PlentyONE Orders that sends shipment information to Wayfair:

  1. From the main PlentyONE page, go to Setup » Orders » Events.

  2. Click on Add event procedure (the + button on the bottom left-hand side of the page).

  3. Enter any Name in the appropriate field.

  4. In the Event drop down list, select Status change (in the category Order Change).

  5. In the field below Event select the status change that should initiate the sending of an ASN to Wayfair, such as In preparation for shipping

  6. Click the Save button save button

  7. You should automatically be redirected to the newly created event procedure. In the Settings section of the event procedure, place a checkmark next to Active

  8. Click on the + symbol next to Filter

  9. Choose Referrer in the Order category

  10. Click the Add button.

  11. In the Filter section, a box should appear with a list of all available Order referrers. Place a checkmark next to all Wayfair order referrers.

  12. Click on the + next to Procedures.

  13. Choose Send Ship Confirmation (ASN) to Wayfair in the Plugins category.

  14. Click the Add button plus add button.

  15. Click the Save button save button.

3.8.2. First inventory synchronization

Once everything has been set up, then it is time for the Wayfair plugin to start listing items for sale on Wayfair.

  • Navigate to the Inventory page in the Wayfair Market Settings.

  • Wait a minute while the system updates inventory information.

  • Review the information displayed on the page.

  • If issues are reported for the full inventory synchronization, attempt to resolve them by reviewing the instructions for the Inventory page, viewing the PlentyONE logs and using the troubleshooting guide.

4. Plugin customization and monitoring

The Wayfair plugin presents PlentyONE users with the ability to customize and monitor its behavior.

4.1. Home page

The Home page is activated by clicking Home in the left-side menu or by clicking Wayfair in the Wayfair navigation bar. Currently, it provides no information.

4.2. Warehouses page

The Warehouses page is used for associating the Warehouses that the supplier is using in PlentyONE with the Wayfair Supplier IDs that have been issued to the supplier. The mappings are utilized by the Wayfair plugin when it reports inventory to Wayfair and also when it is processing Wayfair orders coming into PlentyONE. When choosing a relationship between Warehouses and Supplier IDs that is not one-to-one, make sure to review the behavior of the Stock Buffer setting. In addition, when more than one warehouse has been assigned to a Wayfair Supplier ID, item to warehouse assignment will be prioritized based on stock and country location of the warehouse.

4.2.1. Adding a Warehouse mapping

Adding a Warehouse mapping:

  1. Click on the Add Mapping button add mapping.

  2. Use the left column to choose a PlentyONE Warehouse by name.

    • If a Warehouse was recently added to the PlentyONE system, it may take up to five minutes to become available for use on this page.

    • Do not attempt to use the same PlentyONE Warehouse for more than one row on this page, as that is an unsupported configuration.

  3. Use the right column to enter a numeric Supplier ID.

  4. Click the Save button save once the new row(s) have been completed.

4.2.2. Removing a Warehouse mapping

Removing a Warehouse mapping:

  1. Locate the row to be removed.

  2. Click on the delete button delete icon in the row.

  3. Click the Save button save once the desired row(s) have been removed.

4.3. Settings page

The Settings page contains general settings for the operation of the Wayfair plugin. Settings do not automatically save when changed. Use the Save button save button at the bottom of the page.

4.3.1. Stock Buffer

The Stock Buffer setting is a non-negative integer that sets a reserved amount of stock for each Item Variation, for each Wayfair Supplier ID. The buffer amount is subtracted after all other stock calculations are made, including aggregating the stocks for multiple PlentyONE Warehouses that have been assigned the same Wayfair Supplier ID.

To disable the Stock Buffer, leave this setting empty, or set it to 0.

4.3.2. Default Order Status

The Default Order Status setting determines which state a new PlentyONE Order should be in after creation by the Wayfair plugin.

Notice: The Order creation does not qualify as an Order status change. Setting Default Order Status to a value higher than configured PlentyONE Order Actions may prevent said Actions from taking place!

4.3.3. Item Mapping Method

The Item Mapping Method setting determines the behavior for matching the PlentyONE Item Variations to the Wayfair Products. It is used when the inventory listings are sent to Wayfair, and also to select the requested products in a Wayfair Purchase Order. The PlentyONE user should configure this setting to match the way their Item Variations are populated.

  • Using Variation Number as the Item Mapping Field. By default, the Variation Number field is used for mapping Wayfair Orders’ items to PlentyONE Item Variations

  • Using EAN (Barcode) as the Item Mapping Method When the Item Mapping Method is set to EAN, each Item Variation in PlentyONE should be set up to have a Barcode that mirrors the Wayfair Supplier Part Number that Wayfair will send in incoming order data.

  • Using SKU as the Item Mapping Method. When the Item Mapping Method is set to SKU, each Item Variation in PlentyONE should be set up to have a Wayfair-specific SKU that mirrors the Wayfair Supplier Part Number that Wayfair will send in incoming order data.

4.3.4. Import orders since

The optional Import orders since setting determines a date on which new Wayfair purchase orders are considered eligible for being imported into the PlentyONE system. This setting can improve performance by preventing the Wayfair plugin from requesting orders created before the specified date. It can also be used to prevent the PlentyONE system from accepting Orders prior to the desired go-live date. The Import orders since will update after each successful orders import process and will constantly reflect up to which date the process ran.

4.4. Inventory page

The Inventory page does not contain any settings to configure. It is used for checking the status of syncing the PlentyONE inventory with Wayfair. The page’s data refreshes on a regular basis, as denoted by the timestamp toward the bottom.

4.4.1. Main synchronization status

The top of the Inventory page always displays an icon and message to describe the overall health of the inventory synchronization process.

  • A calendar icon will appear if the Wayfair plugin has yet to attempt inventory synchronizations

    • This happens right after the plugin is installed

    • This may happen if the plugin was recently upgraded

    • The page will change within 15-30 minutes, as the synchronization system initializes

  • A cloud with a checkmark will appear if the Wayfair plugin is regularly synchronizing inventory without detecting any issues

  • An icon with a crossed-out cloud will appear if the Wayfair plugin detects irregularities in inventory synchronization

    • Errors are expected if the Wayfair plugin was recently installed and the setup process has not been completed yet. Finish setting up the plugin prior to using the Inventory page again

    • Details may appear lower on the page, to help explain what is wrong.

    • View the PlentyONE logs to obtain error details

    • View the Wayfair plugin’s troubleshooting guide for ideas on how to solve inventory synchronization issues

4.4.1.1. Synchronization details

  • When it is possible to do so, the Inventory page will provide details to support the main status that is displayed at the top of the page

    • A calendar icon indicates a piece of information that is not yet available

    • A cloud icon with a checkmark indicates a positive event

    • An icon with a crossed-out cloud indicates a negative event

    • An icon with an arrow pointing upwards to a cloud indicates that an event is currently happening and will be reported on once it has been completed

4.5. Ship Confirmation (ASN) page

The Ship Confirmation (ASN) page is used for configuring the shipment interactions between PlentyONE. the Wayfair Plugin and Wayfair. The information set here will inform the Send Ship Confirmation (ASN) to Wayfair Order Procedure that the Wayfair Plugin provides.

4.5.1. Shipping type

The radio button at the top of the page has these options. During Wayfair plugin onboarding, Wayfair will instruct on which option is appropriate for the PlentyONE user.

  • Wayfair shipping

    • Your orders’ shipments are arranged by Wayfair, to be shipped by a carrier chosen by Wayfair

    • Your PlentyONE system needs to Wayfair when the order is ready for shipment

    • Your PlentyONE system needs to get tracking information back from Wayfair

  • Own account shipping

    • You ship your own orders via your own carriers

    • Your PlentyONE system needs to tell Wayfair when you are shipping an order

    • Your PlentyONE system needs to tell Wayfair the tracking information (carrier and tracking number)

4.5.2. Matching PlentyONE Carriers to Wayfair Carriers

When you choose the Own Account shipping option, Wayfair needs to translate the PlentyONE shipping information into data it understands.

Matching PlentyONE carriers to Wayfair carriers:

  1. Locate the carrier information provided by Wayfair. Contact johara1@wayfair.com if necessary.

  2. For each PlentyONE side Shipping Carrier listed on the left-side column, enter the Wayfair-provided SCAC code in the right-side Wayfair carrier column.

  3. Click Save at the bottom of the page.

5. Troubleshooting: common issues

Is the Wayfair Plugin not working as expected? Here is a list of common issues that may occur:

Table 1. Troubleshooting for Wayfair
Issue Possible causes

General lack of data coming from Wayfair or going to Wayfair

  • Missing or incorrect credentials for the Wayfair Plugin in the active Plugin Set.* Internet connectivity issues.

  • Temporary Wayfair downtime.

An item is missing from inventory sent to Wayfair

  • The Item Mapping Method setting in Wayfair’s settings is not set to the desired value.

  • The Variation in PlentyONE is associated with a PlentyONE Warehouse that is not mapped to a Wayfair Supplier ID on the Warehouses page of the Wayfair settings.

  • The PlentyONE Item Variation has an empty or incorrect value in the field that is associated with the Item Mapping Method setting in Wayfair’s settings.

Inventory amount sent to Wayfair for an item is less than the expected value

  • None of the PlentyONE Warehouses associated with Wayfair currently contain positive inventory for the PlentyONE Item Variation.

  • The Stock Buffer setting’s value is greater than or equal to the current amount of inventory for the PlentyONE Item Variation in PlentyONE Warehouses associated with Wayfair .

No orders coming from Wayfair

  • The Wayfair Supplier ID for the Wayfair Purchase Order is not mapped to a PlentyONE Warehouse on the Warehouses page of the Wayfair settings.

Orders coming from Wayfair are not properly getting associated with Items in PlentyONE

  • The Item Mapping Method setting in Wayfair’s settings is set to the incorrect value.

  • The PlentyONE Item Variation has an empty or incorrect value in the field that is associated with the Item Mapping Method setting in Wayfair’s settings.

Warehouses missing or incorrect for Order coming from Wayfair

  • Issues in Warehouse assignments on the Warehouses page of the Wayfair settings.

  • Multiple Warehouses associated with one Wayfair Supplier ID on the Warehouses page of the Wayfair settings.

Shipping label download button does not appear in the Overview tab of an Order in the PlentyONE Shipping centre

  • Order’s shipment has not been registered.

  • Shipping Centre was not yet refreshed after shipment registration was performed.

  • Document downloading failed during the shipment registration process.

Inventory updates not being sent to Wayfair

  • Wayfair settings do not match the PlentyONE setup - see An item is missing from inventory sent to Wayfair.

  • Connectivity issues - see General lack of data coming from Wayfair or going to Wayfair.