Integrate with Wayfair CastleGate Fulfillment

Overview

CastleGate is a fulfillment platform that works with many suppliers and offers easy deliveries at low costs- similar to Fulfilled by Amazon (FBA). They keep inventory in their warehouses and when an order arrives they notify Sellercloud that they have the order and it will be shipped. After shipping, they send Sellercloud the tracking information, and Sellercloud sends them back the invoice.


Specialized Plugins

Sellercloud can integrate with CastleGate to provide Wayfair order fulfillment via EDI documents using the specialized plugins below:

  • CastleGate EDI850 Order Import – Creates the order in Sellercloud with a Dropship Requested status (so they don’t go to 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.
It is strongly recommended to integrate CastleGate with 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.

Plugin Requirements

Contact Sellercloud Support if you need help with any of these settings. Testing may be required before going live with CastleGate. During this process, you can direct any questions you have to our Support team by email or ticket or enroll in Premium Support with a dedicated representative to guide you through the entire process.

PLUGIN CUSTOM 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 Import Not applicable Not 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).
Plugin exports the information from these fields to send back to CastleGate:

  • CastleGate_SuppID
  • CastleGate_WarehouseID

Follow these general instructions to set up a plugin integration. Keep in mind that, unlike other channels, this particular integration has Sellercloud receiving both order information and the tracking information so the task types must correspond with this.


Integration Between Wayfair CastleGate and Sellercloud

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?

Related Articles