ConfirmDirectFulfillmentShipment

Submits a single shipment confirmation to Amazon, notifying them that an order has been dispatched to the customer.

Stored Procedure-Specific Information

To confirm a single shipment, enter:

EXEC VendorCentral.ConfirmDirectFulfillmentShipment
  PurchaseOrderNumber = 'PO-12345-67890',
  SellingPartyId = 'VENDOR-123',
  SellingPartyName = 'ABC Corporation',
  SellingPartyAddressLine1 = '123 Main Street',
  SellingPartyCity = 'Seattle',
  SellingPartyStateOrRegion = 'WA',
  SellingPartyPostalCode = '98101',
  SellingPartyCountryCode = 'US',
  ShipFromPartyId = 'WAREHOUSE-001',
  ShipFromAddressLine1 = '456 Industrial Blvd',
  ShipFromCity = 'Tacoma',
  ShipFromStateOrRegion = 'WA',
  ShipFromPostalCode = '98402',
  ShipFromCountryCode = 'US',
  ShippedDate = '2025-10-16T10:00:00Z',
  ShipmentStatus = 'SHIPPED',
  EstimatedDeliveryDate = '2025-10-18T17:00:00Z',
  ShipmentItems = '[
    {
      "itemSequenceNumber": "1",
      "buyerProductIdentifier": "B00EXAMPLE1",
      "vendorProductIdentifier": "SKU-001",
      "shippedQuantity": {
        "amount": 10,
        "unitOfMeasure": "Each"
      }
    }
  ]',
  Containers = '[
    {
      "containerType": "carton",
      "containerIdentifier": "CARTON-001",
      "trackingNumber": "1Z999AA10123456784"
    }
  ]';

Input


Name	Type	Required	Description
ShipFromAddressLine1	String	True	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 person, business or institution is located.
Containers	String	False	A container used for shipping and packing items.
ShipFromCountryCode	String	True	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.
EstimatedDeliveryDate	Datetime	False	The date on which the shipment is expected to reach the buyer's warehouse. The date is estimated based on the average transit time between the ship-from location and the destination. Usually, the exact appointment time is unknown when creating the shipment confirmation and is later provided by the buyer.
IsPriorityShipment	Bool	False	Indicates whether the shipment is a priority shipment.
ShipmentItems	String	True	The details of the items being shipped.
ShipFromName	String	False	The name of the person, business or institution at that address.
ShipFromPartyId	String	True	The identifier of the party.
ShipFromPhone	String	False	The phone number of the person, business or institution located at the address.
ShipFromPostalCode	String	False	The postal code of the address. This value can include letters, digits, spaces, or punctuation.
PurchaseOrderNumber	String	True	The purchase order number corresponding to the shipment.
ShipmentStatus	String	True	The shipment status.
ShippedDate	Datetime	True	The date of the shipment's departure from vendor's location. Vendors send Advanced Shipment Notices (ASNs) within 30 minutes of departure from their warehouse/distribution center or six hours prior to the appointment time at the Amazon destination warehouse. The shipped date mentioned in the shipment confirmation cannot be in the future.
ShipFromStateOrRegion	String	False	The state or region where the party is located.
ShipFromTaxRegistrationDetails	String	False	The tax registration details of the entity.
VendorOrderNumber	String	False	A unique identifier generated by a vendor for their reference.
SellingPartyAddressLine1	String	True	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 where the party is located.
SellingPartyCountryCode	String	True	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	True	The name of the person, business, or institution at the address.
SellingPartyId	String	True	The identifier of the party.
SellingPartyPhone	String	False	The phone number 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.
SellingPartyTaxRegistrationDetails	String	False	The tax registration details of the entity.

Result Set Columns


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

Power BI Connector for Amazon Marketplace

ConfirmDirectFulfillmentShipment

Stored Procedure-Specific Information

Input

Result Set Columns