Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with Amazon Marketplace.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Amazon Marketplace, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Amazon Marketplace Stored Procedures
| Name | Description |
| AcknowledgeDirectFulfillmentOrder | Submits an acknowledgement for a purchase order. |
| AcknowledgeDirectFulfillmentOrderBatch | Submits acknowledgements for one or more purchase orders. |
| CancelReport | CancelReport operation cancels report request for the given ReportId. |
| CheckDirectFulfillmentTransaction | Returns the processing status of the transaction for the specified transactionId, including checking the status of shipment confirmations, monitoring bulk operations for completion, and retrieving error details for failed transactions. |
| CheckVendorTransactionStatus | Returns the status of the transaction that you specify. |
| ConfirmDirectFulfillmentShipment | Submits a single shipment confirmation to Amazon, notifying them that an order has been dispatched to the customer. |
| ConfirmDirectFulfillmentShipmentBatch | Enables bulk submission of multiple shipment confirmations in a single API call, improving efficiency when processing high volumes of daily shipments. |
| CreateDirectFulfillmentContainer | Creates a container (pallet) label for the associated shipment package. |
| CreateReportSchema | Creates a schema file based on the specified report. |
| CreateSchema | Creates a schema file for the specified table or view. |
| DownloadVendorCustomerInvoice | This stored procedure is part of Vendor Direct Fulfillment Shipping API. Returns a customer invoice based on the purchaseOrderNumber that you specify. |
| DownloadVendorPackingSlip | This stored procedure is part of Vendor Direct Fulfillment Shipping API. Returns a packing slip based on the purchaseOrderNumber that you specify. |
| GetOAuthAccessToken | Gets an authentication token from Amazon. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. You will request the OAuthAccessToken from this URL. |
| GetReport | Creates and/or returns data for a specific report. |
| RefreshOAuthAccessToken | Exchanges a access token for a new access token. |
| RequestReport | The RequestReport operation creates a report request. |
| SubmitDirectFulfillmentShippingLabel | Generates and submits shipping label requests for individual direct fulfillment orders, obtaining carrier-specific labels required for package shipping. |
| SubmitDirectFulfillmentShippingLabelBatch | Enables bulk generation of shipping labels for multiple orders in a single request, streamlining label creation for high-volume fulfillment operations. |
| SubmitVendorOrderAcknowledgement | Submits acknowledgements for one purchase order. |
| SubmitVendorPayments | Submit new invoices to Amazon Marketplace for a vendor's direct fulfillment orders. |
| SubmitVendorShipmentConfirmations | Submits shipment confirmations for vendor orders. |
| UpdateDirectFulfillmentInventory | Submits real-time inventory updates for the specified warehouse for either a partial or full feed of inventory items. |
| UpdateDirectFulfillmentShipmentStatus | Updates the status of a previously submitted shipment, allowing vendors to communicate changes such as delivery completion, failed deliveries, or returns. |
| UpdateDirectFulfillmentShipmentStatusBatch | Enables bulk updates of shipment statuses, allowing vendors to efficiently process status changes for multiple shipments simultaneously. |