Fulfillment Connection Products

GET{{api_url}}/shop/connection/fulfillment/{{fulfillment_id}}/products

Lists the products a fulfillment connection has reported to InfiPlex: the 3PL's or drop shipper's own view of the catalog, under the partner's SKUs, with the stock level it last sent for each item and the partner warehouse it sits in. These rows are written by the connection's inventory pull and are what InfiPlex's inventory sync for that partner reads from. Compare against Inventory Get to explain a difference between what the partner reports and what InfiPlex stores.

Path

Segment	Description
`{{fulfillment_id}}`	The connection key, `id` from Fulfillment List, for example `wayfair_castlegate`, `logiwa_fbl`, `keystone`.

Parameters

All parameters are optional.

Parameter	Type	Description
`sku`	string	Return only the rows for this exact SKU, as the partner identifies it.
`ds_warehouse_id`	string	Return only rows from this partner warehouse, as the partner identifies it, for example `wayfair1`.
`limit`	integer	Maximum number of rows to return.
`limit_start`	integer	Number of leading rows to skip, for paging. With `limit` 100 and `limit_start` 100 you get rows 101 through 200.

Examples

Everything Wayfair Castlegate has reported:

{{api_url}}/shop/connection/fulfillment/wayfair_castlegate/products

One SKU:

{{api_url}}/shop/connection/fulfillment/wayfair_castlegate/products?sku=example_sku_1

One partner warehouse, first 100 rows:

{{api_url}}/shop/connection/fulfillment/wayfair_castlegate/products?ds_warehouse_id=wayfair1&limit=100

Response

A JSON array, one object per item per partner warehouse. A SKU stocked in two partner warehouses appears twice.

[
    {
        "shop_marketplace_drop_shipper_item_id": "402796",
        "shop_marketplace_drop_shipper_item_siteareaid": "16",
        "ds_identifier": "wayfair_castlegate",
        "ds_item_id": "example_sku_1",
        "sku": "example_sku_1",
        "stock_level": "65",
        "date_created": "2026-08-15 10:31:21",
        "last_update_time": "2026-08-27 10:31:21",
        "ds_warehouse_id": "wayfair1",
        "infiplex_warehouse_id": "4",
        "lot_number": null,
        "misc_id_1": "95717130",
        "misc_id_2": null,
        "misc_id_3": null
    }
]

Field	Type	Description
`shop_marketplace_drop_shipper_item_id`	string	Id of this row.
`shop_marketplace_drop_shipper_item_siteareaid`	string	The InfiPlex site area the row belongs to.
`ds_identifier`	string	The connection key, same as the path segment.
`ds_item_id`	string	The partner's own item identifier, when it keys items by something other than the SKU. Often the same value as `sku`.
`sku`	string	The SKU at the fulfillment connection, as the partner reports it. Translate through the connection's SKU Map to reach the InfiPlex SKU when they differ.
`stock_level`	string	The quantity stored from the partner's last report for this item at this warehouse. For connections with an inventory offset setting, the offset is already applied: an EJD offset of -10 means every stored value is the partner's figure minus 10. Inventory Buffers are not applied here; they act later, when InfiPlex sends quantities out to sales channels.
`date_created`	string	When InfiPlex first recorded this item from this partner.
`last_update_time`	string	When the partner last reported it. An old value here with current orders flowing means the inventory pull is not running or the partner stopped sending the item.
`ds_warehouse_id`	string	The partner's own warehouse code for where this stock sits.
`infiplex_warehouse_id`	string	The InfiPlex warehouse the partner warehouse maps to, where `stock_level` is applied.
`lot_number`	string or null	Lot number when the partner reports stock by lot.
`misc_id_1`, `misc_id_2`, `misc_id_3`	string or null	Extra values some connections require InfiPlex to send back with the item, such as a GTIN or the partner's variation and child ids. What each slot holds depends on the connection; most connections leave them `null`.

The response is a plain array with no total. A connection that is enabled but has no inventory pull, or has not pulled yet, returns []. An unknown or disabled connection key returns 404.

Connections with their own row format

Seven connections predate the shared format above and return rows from their own tables instead. The fields differ per connection; every one carries a sku, a stock figure, and a last-updated or last-checked date, but under its own names. Check the id from Fulfillment List before reading rows from:

three_pl_central, american_tire, flexe, infiplex_fbi, midwest, shipstream, zhenhub

3PL Central:

{
    "shop_marketplace_3pl_central_sku_inventory_get_id": "71",
    "sm3csig_siteareaid": "16",
    "sku": "example_sku_1",
    "date_created": "2026-08-02 12:13:47",
    "date_last_checked": "2026-08-25 12:13:47",
    "inventory": "177",
    "do_initial_check": "0",
    "website_inventory": "119"
}

Field	Description
`sku`	The SKU at 3PL Central.
`inventory`	The quantity 3PL Central last reported.
`date_last_checked`	When InfiPlex last asked 3PL Central for this SKU.
`website_inventory`	InfiPlex's own inventory for the SKU at the time of that check.
`do_initial_check`	`1` while the SKU is queued for its first pull, `0` after.

American Tire:

{
    "shop_marketplace_american_tire_fba_item_id": "11",
    "shop_marketplace_american_tire_fba_item_siteareaid": "16",
    "sku": "200570",
    "stock_level": "99",
    "date_created": "2022-08-17 12:32:35",
    "last_update_time": "2022-08-17 12:32:59",
    "american_tire_warehouse_id": null,
    "infiplex_warehouse_id": null,
    "american_tire_id": "200570",
    "american_tire_sku_id": null,
    "website_inventory": null
}

Field	Description
`sku`	The SKU at American Tire.
`stock_level`	The quantity American Tire last reported. `null` when the SKU has never been reported.
`last_update_time`	When American Tire last reported it. `null` when never.
`american_tire_id`, `american_tire_sku_id`	American Tire's own identifiers for the item.
`american_tire_warehouse_id`, `infiplex_warehouse_id`	Partner and InfiPlex warehouse, when the feed carries one.

Flexe:

{
    "shop_marketplace_flexe_fbf_item_id": "3",
    "shop_marketplace_flexe_fbf_item_siteareaid": "16",
    "sku": "17898663",
    "stock_level": "1748",
    "date_created": "2020-11-25 13:33:21",
    "last_update_time": "2020-12-11 21:14:06",
    "flexe_warehouse_id": "238",
    "infiplex_warehouse_id": "3",
    "website_inventory": null
}

Field	Description
`sku`	The SKU at Flexe.
`stock_level`	The quantity Flexe last reported at this warehouse.
`last_update_time`	When Flexe last reported it.
`flexe_warehouse_id`	Flexe's own warehouse id.
`infiplex_warehouse_id`	The InfiPlex warehouse that Flexe warehouse maps to.

InfiPlex (another InfiPlex instance acting as the 3PL):

{
    "shop_marketplace_infiplex_fbi_item_id": "80",
    "shop_marketplace_infiplex_fbi_item_siteareaid": "16",
    "sku": "SQ0638051",
    "stock_level": "2000",
    "date_created": "2022-12-05 14:56:42",
    "last_update_time": "2022-12-05 14:56:43",
    "infiplex_remote_warehouse_id": "29",
    "infiplex_local_warehouse_id": "3",
    "lot_number": null,
    "website_inventory": "2003"
}

Field	Description
`sku`	The SKU on the remote InfiPlex instance.
`stock_level`	The quantity the remote instance last reported at that warehouse. Can be negative when the remote instance is oversold.
`last_update_time`	When the remote instance last reported it.
`infiplex_remote_warehouse_id`	The warehouse id on the remote instance.
`infiplex_local_warehouse_id`	The warehouse on this instance that remote warehouse maps to.
`lot_number`	Lot number when the remote instance reports stock by lot.

Midwest:

{
    "shop_marketplace_midwest_fbm_item_id": "266",
    "shop_marketplace_midwest_fbm_item_siteareaid": "16",
    "sku": "20REM-F",
    "stock_level": "4924",
    "date_created": "2021-09-17 16:32:46",
    "last_update_time": "2021-09-17 16:32:46",
    "midwest_warehouse_id": "07",
    "infiplex_warehouse_id": "3",
    "lot_number": "(none)",
    "uom": "EA",
    "inventory_class": "RG",
    "inventory_status": "AV",
    "midwest_weight": "68936",
    "midwest_cube": "22819.0926",
    "lip_count": "248",
    "website_inventory": null
}

Field	Description
`sku`	The SKU at Midwest.
`stock_level`	The quantity Midwest last reported at this warehouse, in the row's `uom`.
`last_update_time`	When Midwest last reported it.
`midwest_warehouse_id`	Midwest's own warehouse code.
`infiplex_warehouse_id`	The InfiPlex warehouse that Midwest warehouse maps to.
`lot_number`	Midwest's lot. `(none)` when the stock is not lot tracked. One row per SKU per lot, so a lot tracked SKU can appear several times.
`uom`	Unit of measure the row is counted in, for example `EA` each, `CA` case.
`inventory_class`, `inventory_status`	Midwest's inventory classification and availability codes, for example `RG` regular and `AV` available.
`midwest_weight`, `midwest_cube`, `lip_count`	Midwest's totals for the stock on this row: weight, cubic volume, and number of licence plates (pallets or containers) it occupies.

ShipStream:

{
    "shop_marketplace_shipstream_fbs_item_id": "22",
    "shop_marketplace_shipstream_fbs_item_siteareaid": "16",
    "sku": "54-364-4584",
    "stock_level": "22",
    "date_created": "2020-09-03 15:56:53",
    "last_update_time": "2020-09-03 15:58:32",
    "shipstream_warehouse_id": "3",
    "infiplex_warehouse_id": "8",
    "website_inventory": null
}

Field	Description
`sku`	The SKU at ShipStream.
`stock_level`	The quantity ShipStream last reported at this warehouse.
`last_update_time`	When ShipStream last reported it.
`shipstream_warehouse_id`	ShipStream's own warehouse id.
`infiplex_warehouse_id`	The InfiPlex warehouse that ShipStream warehouse maps to.

ZhenHub:

{
    "shop_marketplace_zhenhub_fbz_item_id": "10",
    "shop_marketplace_zhenhub_fbz_item_siteareaid": "16",
    "sku": "0996168907",
    "stock_level": "0",
    "date_created": "2022-03-16 16:26:15",
    "last_update_time": "2022-03-16 16:26:15",
    "zhenhub_warehouse_id": "AU Melbourne",
    "infiplex_warehouse_id": "3",
    "zhenhub_id": "5866264125194240",
    "zhenhub_sku_id": "5866264125210624",
    "lip_count": null,
    "website_inventory": null
}

Field	Description
`sku`	The SKU at ZhenHub.
`stock_level`	The quantity ZhenHub last reported at this warehouse.
`last_update_time`	When ZhenHub last reported it. `null` with the warehouse and id fields also `null` means the row was created on this side and ZhenHub has never reported it.
`zhenhub_warehouse_id`	ZhenHub's warehouse name, for example `AU Melbourne`.
`infiplex_warehouse_id`	The InfiPlex warehouse that ZhenHub warehouse maps to.
`zhenhub_id`, `zhenhub_sku_id`	ZhenHub's own product and SKU identifiers, needed when sending orders back.

The sku and ds_warehouse_id filters and limit paging work the same way on these connections.

Authorization

Bearer token, sent in the Authorization header. Inherited from the collection.

Query Parameters

Key	Value	Description
`sku` optional	`example_sku_1`	Return only the rows for this exact SKU, as the partner identifies it
`ds_warehouse_id` optional	`wayfair2`	This is the drop shipper warehouse ID to filter on
`limit` optional	`1`	The number of products to return
`limit_start` optional	`1`	Number of leading rows to skip, for paging. With limit 100 and limit_start 100 you get rows 101 through 200

Example Request

curl --location --request GET '{{api_url}}/shop/connection/fulfillment/{{fulfillment_id}}/products' \
--header 'Authorization: Bearer {{auth_token}}'

Example Responses