CData Python Connector for Amazon Marketplace

Build 25.0.9540

UpdateDirectFulfillmentShipmentStatus

Updates the status of a previously submitted shipment, allowing vendors to communicate changes such as delivery completion, failed deliveries, or returns.

Stored Procedure-Specific Information

To update a single shipment status to delivered, enter:
EXEC VendorCentral.UpdateDirectFulfillmentShipmentStatus
  PurchaseOrderNumber = 'PO-12345-67890',
  SellingPartyId = 'VENDOR-123',
  ShipFromPartyId = 'WAREHOUSE-001',
  StatusCode = 'Delivered',
  StatusDate = '2025-10-18T14:30:00Z',
  TrackingNumber = '1Z999AA10123456784';

Common status codes include Delivered, InTransit, OutForDelivery, and DeliveryAttemptFailed.

Input

Name Type Required Description
ShipFromAddressLine1 String False The first line of the address.
ShipFromAddressLine2 String False Additional street address information, if required.
ShipFromAddressLine3 String False Additional street address information, if required.
ShipFromCity String False The city where the party is located.
ShipFromCountryCode String False The two-letter country code in [ISO 3166-1 alpha-2](https://www.iban.com/country-codes) format.
ShipFromCounty String False The county where the party is located.
ShipFromDistrict String False The district where the party is located.
ShipFromName String False The name of the person, business or institution at that address.
ShipFromPhone String False The phone number of the party associated with the address.
ShipFromPostalCode String False The postal code for the address. This value can include letters, digits, spaces, or punctuation.
ShipFromStateOrRegion String False The state or region where the party is located.
ApptWindowEndDateTime Datetime False The date and time at the end of the appointment window when the shipment is expected to be delivered. Values are in [ISO 8601](https://developer-docs.amazon.com/sp-api/docs/iso-8601) date-time format, with UTC time zone or UTC offset. For example, 2020-07-16T23:00:00Z or 2020-07-16T23:00:00+01:00.
ApptWindowStartDateTime Datetime False The date and time at the start of the appointment window when the shipment is expected to be delivered. Values are in [ISO 8601](https://developer-docs.amazon.com/sp-api/docs/iso-8601) date-time format, with UTC time zone or UTC offset. For example, 2020-07-16T23:00:00Z or 2020-07-16T23:00:00+01:00.
EstimatedDeliveryDateTime Datetime False The date on which the shipment is expected to reach the customer delivery location. Values are in [ISO 8601](https://developer-docs.amazon.com/sp-api/docs/iso-8601) date-time format, with UTC time zone or UTC offset. For example, 2020-07-16T23:00:00Z or 2020-07-16T23:00:00+01:00.
ShipFromPartyId String False The identifier of the party.
PurchaseOrderNumber String False The purchase order number of the shipment for which to update the shipment status.
ReasonCode String False Provides a reason code for the status of the package, which provides additional information about the transportation status. For more information, refer to the [Additional Fields Explanation](https://developer-docs.amazon.com/sp-api/docs/vendor-direct-fulfillment-shipping-api-use-case-guide#additional-fields-explanation).
StatusCode String False Indicates the shipment status code of the package that provides transportation information for Amazon tracking systems and ultimately for the final customer. For more information, refer to the [Additional Fields Explanation](https://developer-docs.amazon.com/sp-api/docs/vendor-direct-fulfillment-shipping-api-use-case-guide#additional-fields-explanation).
StatusDateTime Datetime False The date and time when the shipment status was updated. Values are in [ISO 8601](https://developer-docs.amazon.com/sp-api/docs/iso-8601) date-time format, with UTC time zone or UTC offset. For example, 2020-07-16T23:00:00Z or 2020-07-16T23:00:00+01:00.
ShipFromTaxRegistrationDetails String False The tax registration details of the entity.
TrackingNumber String False The shipment tracking number is required for every package and should match the trackingNumber sent for the shipment confirmation.
SellingPartyAddressLine1 String False The first line of the address.
SellingPartyAddressLine2 String False Additional street address information, if required.
SellingPartyAddressLine3 String False Additional street address information, if required.
SellingPartyCity String False The city where the party is located.
SellingPartyCountryCode String False The two-letter country code in [ISO 3166-1 alpha-2](https://www.iban.com/country-codes) format.
SellingPartyCounty String False The county where the party is located.
SellingPartyDistrict String False The district where the party is located.
SellingPartyName String False The name of the person, business or institution at that address.
SellingPartyId String False The identifier of the party.
SellingPartyPhone String False The phone number of the party associated with the address.
SellingPartyPostalCode String False The postal code for the address. This value can include letters, digits, spaces, or punctuation.
SellingPartyStateOrRegion String False The state or region where the party is located.
StatusLocationAddressLine1 String False The first line of the address.
StatusLocationAddressLine2 String False Additional street address information, if required.
StatusLocationAddressLine3 String False Additional street address information, if required.
StatusLocationCity String False The city where the party is located.
StatusLocationCountryCode String False The two-letter country code in [ISO 3166-1 alpha-2](https://www.iban.com/country-codes) format.
StatusLocationCounty String False The county where the party is located.
StatusLocationDistrict String False The district where the party is located.
StatusLocationName String False The name of the person, business or institution at that address.
StatusLocationPhone String False The phone number of the party associated with the address.
StatusLocationPostalCode String False The postal code for the address. This value can include letters, digits, spaces, or punctuation.
StatusLocationStateOrRegion String False The state or region where the party is located.
SellingPartyTaxRegistrationDetails String False The tax registration details of the entity.

Result Set Columns

Name Type Description
Success Boolean Boolean indicating whether the stored procedure was successfully executed.
TransactionId String GUID to identify this transaction. This value can be used with the Transaction Status API to return the status of this transaction.

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