ODBC Driver for ShipStation

Build 26.0.9770

ReceivePurchaseOrderProducts

Records receipt of products for a purchase order.

Procedure Specific Information

Records receipt of products for a purchase order. The purchase order Id, SKU, and inventory location Id are required. Optionally specify the received quantity, rejected quantity, lot number, and expiration date. The procedure is executed as below:
EXEC ReceivePurchaseOrderProducts PurchaseOrderId = 'po-123', Sku = 'SKU-001', InventoryLocationId = 'loc-456', ReceivedQuantity = 10

EXEC ReceivePurchaseOrderProducts PurchaseOrderId = 'po-123', Sku = 'SKU-001', InventoryLocationId = 'loc-456', ReceivedQuantity = 10, RejectedQuantity = 2, Lot = 'LOT-001', ExpirationDate = '2024-11-13T23:47:25.293-05:00'

Input

Name Type Description
PurchaseOrderId String The Id of the purchase order.
Sku String The SKU of the product being received.
InventoryLocationId String The Id of the inventory location where items are received.
ReceivedQuantity Integer The quantity of items received.
RejectedQuantity Integer The quantity of items rejected.
Lot String The lot number for the received items.
ExpirationDate Datetime The expiration date of the received items.

Result Set Columns

Name Type Description
Status String The status of the operation.
ReceiveStatus String The receipt status returned by the server.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770