Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the adapter beyond simple SELECT/INSERT/UPDATE/DELETE operations with Amazon Marketplace.
Stored procedures accept a list of parameters, perform their intended function, and then return, if applicable, any relevant response data from Amazon Marketplace, along with an indication of whether the procedure succeeded or failed.
Amazon Marketplace Adapter Stored Procedures
| Name | Description |
| CancelFeed | The CancelFeed cancels one or more feed submissions and returns a count of the canceled feed submissions and the feed submission information. Note that if you do not specify a FeedSubmmissionId, all feed submissions are canceled. |
| CancelReportRequests | CancelReportRequests operation cancels one or more report requests and returns the number of report requests canceled and report request information. |
| CreateSchema | Creates a schema file for the specified table or view. |
| GetReport | Creates and/or returns data for a specific report. |
| RequestReport | The RequestReport operation creates a report request. |
| SubmitImageFeed | The Image feed allows you to upload various images for a product. Amazon can display several images for each product. |
| SubmitInventoryFeed | The Inventory feed allows you to update inventory quantities (stock levels) for your items. |
| SubmitOrderAcknowledgementFeed | The Order Acknowledgment feed allows you to acknowledge your success or failure with downloading an order. |
| SubmitOrderAdjustmentFeed | The Order Adjustment feed allows you to issue a refund (adjustment) for an order. You must provide a reason for the adjustment, such as Customer Return, and the adjustment amount, broken down by price component (principle, shipping, tax, and so on). |
| SubmitOrderFulfillmentFeed | The Order Fulfillment feed allows your system to update Amazon's system with order fulfillment information. |
| SubmitOverrideFeed | The Override feed allows you to set an exception to your account-level shipping settings for an individual product (SKU). |
| SubmitPriceFeed | The Price feed allows you to set the current price and sale price (when applicable) for an item. |
| SubmitProductFeed | The Product feed contains descriptive information about the products in your catalog. This information allows Amazon to build a record and assign a unique identifier known as an ASIN (Amazon Standard Item Number) to each product. |
| SubmitRelationshipFeed | The Relationship feed allows you to set up optional relationships between items in your catalog. |
| SubmitSourcingOnDemandFeed | Usage information for the operation SubmitSourcingOnDemandFeed.rsb. |