Integrate Wayfair CastleGate Fulfillment

Overview

CastleGate is a logistics and supply chain solution provided by Wayfair that works with many suppliers and offers easy deliveries at low costs- similar to Fulfillment by Amazon (FBA). Shipping with CastleGate Fulfillment involves storing your products in warehouses operated by Wayfair. When a customer places an order on Wayfair’s platform, the products are picked, packed, and shipped directly from these CastleGate warehouses to the customer. This approach can help improve the efficiency of order fulfillment, reduce shipping times, and enhance the overall customer experience. After the items have been shipped, Sellercloud receives the tracking information for these orders and sends back the corresponding invoice.


Prerequisites

Sellercloud integrates with CastleGate via EDI plugins and transactions. Reach out to the Sellercloud Support team to have the following plugins installed on your server:

  • CastleGate EDI850 Order Import – Creates the orders in Sellercloud with a Dropship Requested status (this prevents them from being imported into Shipbridge).
  • AR CastleGate EDI945 Tracking Import – Marks the order as fully shipped and adds the tracking information.
  • CastleGate EDI 810 Order Export – Exports the invoice information after the order is shipped.
  • MH CastleGate Inventory Import – Imports the product inventory from the channel.
It is strongly recommended to integrate CastleGate into a separate company other than the regular Wayfair account. Otherwise, it may be confusing to differentiate orders since both are marked as Wayfair orders; the only difference is that CastleGate orders have CastleGate in the username.
Testing may be required before going live with CastleGate. To have a dedicated representative complete the testing for your account and ensure that the setup is configured correctly, we recommend Premium Support.

Following the plugin installation, create the following custom columns and settings. Reach out to our Support team to have them created for you on the backend.

PLUGINCUSTOM COMPANY SETTINGS

These custom settings must be on the default company.

CUSTOM ORDER COLUMNS
CastleGate EDI850 Order Import
  • CastleGate_ISAID – CastleGate’s ISA ID.
    Important! This should be set to CASTLEGATE. By default, they will use the regular Wayfair ID; you must request CastleGate to use this as their ISA ID.
The plugin writes the information to these fields:

  • CastleGate_SuppID
  • CastleGate_WarehouseID
AR CastleGate EDI945 Tracking ImportNot applicableNot applicable
CastleGate EDI 810 Order Export
  • CastleGate_CustomerISAID – Client’s ISA ID. Typically, this is the client’s phone number but can be whatever you set up with CastleGate.
  • CastleGate_ISAID – CastleGate’s ISA ID.
    Important! This should be set to CASTLEGATE. By default, they will use the regular Wayfair ID; you must request CastleGate to use this as their ISA ID.

  • ISAControlNumber – Control numbers: set to 1 (auto-incremented within the plugin).
  • STControlNumber – Control numbers:  set to 1 (auto-incremented within the plugin).
  • GSControlNumber – Control numbers:  set to 1 (auto-incremented within the plugin).
The plugin exports the information from these fields to send back to CastleGate:

  • CastleGate_SuppID
  • CastleGate_WarehouseID

If you’d prefer to handle the configuration on your own, follow these general instructions to set up a plugin integration through scheduled tasks. Keep in mind that, unlike other channels, this particular integration has Sellercloud receiving both order information and tracking information so the task types must correspond with this.


Integrate CastleGate Fulfillment

The integration between Wayfair CastleGate and Sellercloud has three main transactions: 850, 945, and 810.

  1. During the initial setup, you will be asked to test the transactions for a test PO generated by Wayfair CastleGate.
  2. After this is done, you will be asked to test a new vendor ID for your regular Wayfair account. Note that after this step, you will start using this ID instead of your old ID.
  3. You will be asked to test the 846 transactions for your regular Wayfair account.

Inventory for your dropship (CastleGate) warehouses is managed entirely on CastleGate’s end. To ensure that your CastleGate orders do not deduct inventory from your warehouses in Sellercloud upon import, create the custom company setting EnableInventoryCountForCastleGateOrders with False value, which works hand in hand with the 850 import plugin.

To choose whether the orders are imported as Paid or Unpaid, use the order import setting CastleGate_CreateOrderPayment with True/False values. If set to False, the orders come in without payment, and thus their status will remain In process even after the tracking has been received. The status will only update to Completed once payment has been applied to these orders.


Multiple Location Workflow

To use the multi-location workflow, you will need to create the custom company setting CastleGate_EnableLocationMapping.

Multiple locations mapping for CastleGate means that if you have more than one location (warehouse) set up on CastleGate, then Sellercloud plugins will support it and will automatically detect the location from which this item is supposed to ship.  This will occur as long as the same location (warehouse) is created in Sellercloud with the exact same name. 

If you have more than one CastleGate location (warehouse) set up, please contact Sellercloud support to ensure that your plugins are up to date. This is important for 810 documents.

The multi-locations support is only relevant to the 850 and 810 transactions ,and your inventory will continue to be managed on CastleGate’s end.


Was this article helpful?

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