All Collections
Advanced Configurations & FAQ
Communicating Inventory from Prodsmart to Wayfair
Communicating Inventory from Prodsmart to Wayfair
Learn how to sync your Prodsmart stock with Wayfair
Vânia Lourenço avatar
Written by Vânia Lourenço
Updated over a week ago

Autodesk Prodsmart allows you to communicate your current stock to other applications such as Wayfair, Shopify, Quickbooks and more. In this article we will explain how to do it for Wayfair.

If you want to know more about stock communication in QBD check this article, for QBO check this and for Shopify check this one.

The communication of Inventory information is only possible from Prodsmart to other applications.

Lets start!

The exchange of Stock information is only possible from Prodsmart to other applications.

To do this you need to have an activate/configure the integration with the desired software, in this case Wayfair, speak to your Account Manager to activate it.

Update the Inventory

After the integration being active this you should add 'Wayfair' under the “Marketplace” field in the Edit product page. This will allow you to communicate inventory of that specify product to the marketplace selected (image below).

If the option Marketplace it's not available on your end please reach out to us or your CSM.

You must repeat this procedure for all the products that you want to communicate stock for.

The exchange of Stock information is performed considering that the ‘Product Part number’ in Wayfair will corresponds to the ‘Product code’ in Prodsmart. If those do not match, the sync doesn’t occur.

The product also needs to be “Active” in the store listing and it should be marked as available to receive inventory feeds (this can be setup with the Wayfair team), otherwise the communication won't happen.

In the integrations page now you have access to other options (image below):

  • Send daily true-up feed (send fixed inventory counts to Wayfair) - You can define a dummy inventory value and that value will be sent to Wayfair. To set this value go to Inventory and you use the Bulk edit in the inventory page - SET EXTERNAL STOCK;

  • Send real data inventory feed to Wayfair (true-up feeds) - The values of quantity on Hand, on ordered and backordered are send to Wayfair. This will happen at 13h30, 16h30, 18h30 and 23h30 in UTC time;

  • Send real data inventory feed to Wayfair (differential feeds) - Inventory updates take place every 30 minutes.

What is being communicated?

To know what inventory is being send to Wayfair you can press 'Communicate Inventory to external sources' in the Inventory menu.

There you can find a table, as in the image below, of the inventory being communicated and how those calculations are made.

In this table the communicated information to Wayfair is:

  • Quantity at hand that is the quantity available for new orders.

    • formula = quantity in stock - Quantity on orders

  • Quantity on orders is the quantity not shipped in open sales orders that can be fulfilled. (open/closed orders that haven’t yet been archived or the ASN sent)

Note: Even if it is shipped through the back office, it will not be discounted in the quantity on orders. To discount it is necessary that the ASN is sent or that the sales order is archived.

  • Quantity backordered which is missing quantity to fulfil the current sales orders.

    • formula = Quantity in open and closed orders where the ASN was not sent yet - Quantity in Stock. If this value is negative (such as -3), we use the modulus of it (which is 3). Else, is set to 0.

Important notes:

  • This page is only to Check the stocks being sent at a specific moment. We advise not to edit or confirm anything in it without the help of your CSM or the Support team.

  • Canceled Orders should be archived by the user so that they won't impact quantity on orders.

If after reading this article you still have some doubts, feel free to reach out to us through our Live-chat feature, or directly to your CSM.

Did this answer your question?