This page provides a guide to Establishing a Connection to Amazon Marketplace in CData Cloud, as well as information on the available resources, and a reference to the available connection properties.

Connecting to Amazon Marketplace

Establishing a Connection shows how to authenticate to Amazon Marketplace and configure any necessary connection properties to create a database in CData Cloud

Accessing Data from CData Cloud Services

Accessing data from Amazon Marketplace through the available standard services and CData Cloud administration is documented in further details in the CData Cloud Documentation.

Connect to Amazon Marketplace by selecting the corresponding icon in the Database tab. Required properties are listed under Settings. The Advanced tab lists connection properties that are not typically required.

Connecting to Amazon Marketplace

Amazon MWS API vs Selling Partner API

Amazon MWS (Marketplace Web Services) API is the older API for the Amazon Marketplace while Selling Partner (SP) API provides number of improvements over MWS API including JSON-based REST API design standards and OAuth 2.0. SP-API includes all functionality available in Amazon MWS API.

You may specify which API to connect to by setting Schema. Please be aware that each API has different available connection options as described below.

Connecting to Selling Partner API

When using the Amazon Selling Partner API to connect to the Amazon Marketplace, the following properties are required:

• Schema: Set this to SellingPartner.
• InitiateOAuth: Set this to GETANDREFRESH.
• Marketplace: Set this to the Marketplace region that you are registered to sell in.

Also, you can use the SellingPartner property to choose Seller or Vendor authentication.

Connecting to the MWS API

When using the Amazon MWS API to connect to the Amazon Marketplace, SellerId, Marketplace, Marketplace are required connection properties. Set Schema to Marketplace.

Configure Access to Amazon Marketplace

To connect to Amazon Marketplace first authorize CData developer. To do so follow the steps below:

• Using the CData MWS developer id: 195280669143.
• Go to the Manage your apps page in Seller Central and log into your Amazon seller account as the primary account holder.
• Click the Authorize new developer button and follows the authorization workflow using the developer id provided by the Cloud.

Or you can go to Amazon Marketplace CData Driver and click Authorize Now on the right panel.

Obtaining the MWS Auth Token

To obtain the MWS Auth Token, follow the steps below:

• Go to the Manage your apps page in Seller Central and log into your Amazon seller account as the primary account holder.
• Find the CData App.
• Under the MWS Auth Token Column click View.

Obtaining the Seller ID

To obtain the Seller ID follow the steps below:

• Login to your seller account.
• Select Settings, then Account Info on upper right of screen.
• Under Business Information select "Your Merchant Token".

Authenticate to Amazon Marketplace

Amazon Marketplace Accounts

Set the following connection properties to connect:

• SellerId: Set the Seller ID of Amazon marketplace web service settings.
• Marketplace: Set the Amazon marketplace location (for example, United States).
• Schema: Set Schema to Marketplace.

OAuth

Amazon Marketplace uses the OAuth authentication standard.

To authenticate using OAuth, you must either use the embedded application or create a new custom OAuth app. The embedded application supports desktop applications and headless machines. Web applications require that you create a custom OAuth application.

You can use a custom OAuth application to authenticate with a service account or a user account. See Creating a Custom OAuth App for more information.

Downloading Embedded Credentials

Because Amazon Marketplace requires that embedded credentials rotate every six months, CData credentials are hosted on oa.cdata.com. If you do not specify custom credentials, the embedded credentials are downloaded from our web service and saved in the location specified in OAuthClientLocation by default. NOTE:Make sure your firewall does not block oa.cdata.com.

For security, Amazon Marketplace restricts access to PII (Personally Identifiable Information). You can only retain PII for 30 days after order delivery and only for the purpose of, and as long as is necessary to

• fulfill orders
• calculate and remit taxes
• produce tax invoices
• meet legal requirements, including tax or regulatory requirements.

If you are required by law to retain archival copies of PII for tax or other regulatory purposes, you must store PII as a "cold" or offline encrypted backup (e.g., not available for immediate or interactive use).

This means, for example, that the Amazon Marketplace driver no longer displays customer shipping address information after 30 days. See the Amazon documentation for more information:

Amazon Marketplace Data Protection Policy

Customizing the SSL Configuration

By default, the Cloud attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store.

To specify another certificate, see the SSLServerCert property for the available formats to do so.

Connecting Through a Firewall or Proxy

HTTP Proxies

To connect through the Windows system proxy, you do not need to set any additional connection properties. To connect to other proxies, set ProxyAutoDetect to false.

In addition, to authenticate to an HTTP proxy, set ProxyAuthScheme, ProxyUser, and ProxyPassword, in addition to ProxyServer and ProxyPort.

Other Proxies

Set the following properties:

• To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
• To tunnel the connection, set FirewallType to TUNNEL.
• To authenticate, specify FirewallUser and FirewallPassword.
• To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

The CData Cloud models Amazon Marketplace objects as relational tables and views. An Amazon Marketplace object has relationships to other objects; in the tables, these relationships are expressed through foreign keys. The following sections show the available API objects and provide more information on executing SQL to Amazon Marketplace APIs.

Schemas for most database objects are defined in simple, text-based configuration files.

Using Marketplace API

See Marketplace Data Model for the available entities in the Marketplace API.

Using SellingPartner API

See Selling Partner Data Model for the available entities in the Selling Partner API.

The CData Cloud models the Amazon Marketplace API as relational views, and stored procedures.

To use Marketplace Data Model, simply set Schema to Marketplace.

Views

Views are tables that cannot be modified, such as Orders, Products. Typically, model data that is read-only and cannot be updated are shown as views.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

Using Reports

Created reports can be exposed as views by setting IncludeReports connection property to true. Reports can be created with the RequestReport stored procedure.

After a report has been created and finished processing with a status _DONE_ it will be exposed as a view with the name "Report{ReportType}{ReportID}".

Only Tab-Delimited reports can be used as views. You can find a full list of reports here: Report Types.

In order to avoid API throttling, it is suggested to use the CreateSchema stored procedure to create report table schemas.

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Cloud - Amazon Marketplace Views

Name	Description
FeedSubmissionList	The GetFeedSubmissionList operation returns a list of feed submissions.
FeedSubmissionResult	The GetFeedSubmissionResult operation returns the feed processing report for a specific feed.
InboundShipmentItems	Returns a list of items in a specified inbound shipment.
InboundShipments	Returns a list of inbound shipments based on criteria that you specify.
InventorySupply	Returns information about the availability of inventory that a seller has in Amazon's fulfillment network and in current inbound shipments. You can check the current availability status for your Fulfillment by Amazon inventory as well as discover when availability status changes.
OrderItems	Returns order items based on the Amazon Order Id that you specify.
Orders	Returns orders created or updated during a time frame that you specify.
Products	The Products Table helps you get information to match your products to existing product listings on Amazon Marketplace websites.
ReportList	Usage information for the operation ReportList.rsd.
ReportRequestList	Usage information for the operation ReportRequestList.rsd.

The GetFeedSubmissionList operation returns a list of feed submissions.

Select

The Cloud will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud. For example, the following query is processed server side:

SELECT * FROM FeedSubmissionList WHERE FeedSubmissionId = '50377017868'

SELECT * FROM FeedSubmissionList WHERE FeedType = '_POST_PRODUCT_DATA_

SELECT * FROM FeedSubmissionList WHERE SubmittedDate = '2018-12-03T09:42:06'

SELECT * FROM FeedSubmissionList WHERE FeedProcessingStatus = '_DONE_'

Columns

Name	Type	References	Description
FeedSubmissionId [KEY]	String		The Id of the FeedSubmission.
FeedType	String		The Type of the feed.
SubmittedDate	Datetime		The Date when the feed is submitted.
FeedProcessingStatus	String		The Status of the Feed. The allowed values are _AWAITING_ASYNCHRONOUS_REPLY_, _CANCELLED_, _DONE_, _IN_PROGRESS_, _IN_SAFETY_NET_, _SUBMITTED_, _UNCONFIRMED_.
StartedProcessingDate	Datetime		The Date when the feed started processing.
CompletedProcessingDate	Datetime		The Date when the feed stopped processing.

The GetFeedSubmissionResult operation returns the feed processing report for a specific feed.

Select

The Cloud will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud. For example, the following query is processed server side:

SELECT * FROM FeedSubmissionResult WHERE FeedSubmissionId = '50377017868'

Columns

Name	Type	References	Description
DocumentTransactionID [KEY]	String		The Transaction ID of the Document.
FeedSubmissionId	String		The Feed Submission Id.
StatusCode	String		The status code of the feed.
MessagesProcessed	Integer		The number of messages processed.
MessagesSuccessful	Integer		The number of messages processed successfully.
MessagesWithError	Integer		The number of messages processed with errors.
MessagesWithWarning	Integer		The number of messages processed with warnings.
MessageID [KEY]	String		The Message ID.
ResultCode	String		The Result Code.
ResultMessageCode	String		The Result Message Code.
ResultDescription	String		The result description.
AdditionalInfo_SKU	String		The SKU.
AdditionalInfo_FulfillmentCenterID	String		The Fulfillment Center Id.
AdditionalInfo_AmazonOrderID	String		The Amazon Order Id.
AdditionalInfo_AmazonOrderItemCode	String		The Amazon Order Item Code.

Returns a list of items in a specified inbound shipment.

Select

The Cloud will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud. For example, the following query is processed server side:

SELECT * FROM InboundShipments WHERE ShipmentId = '503-9993250-1405404'

Columns

Name	Type	References	Description
ShipmentId [KEY]	String	InboundShipments.ShipmentId	The ID of the shipment.
SellerSKU [KEY]	String		The Seller SKU of the item.
QuantityShipped	Int		The item quantity that you are shipping.
QuantityInCase	Int		The item quantity in each case, for case-packed items.
QuantityReceived	Int		The item quantity that has been received at an Amazon fulfillment center.
FulfillmentNetworkSKU	String		Amazon's fulfillment network SKU of the item.
PrepDetailsListPrepInstruction	String		Preparation instructions for shipping an item to Amazon's fulfillment network.
PrepDetailsListPrepOwner	String		Indicates who will prepare the item.
ReleaseDate	Date		The date that a pre-order item will be available for sale.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
LastUpdatedDate	Datetime

Returns a list of inbound shipments based on criteria that you specify.

Select

The Cloud will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud. For example, the following query is processed server side:

SELECT * FROM InboundShipments WHERE ShipmentStatus = 'Working'

SELECT * FROM InboundShipments WHERE ShipmentStatus IN ('Working', 'SHIPPED', 'IN_TRANSIT')

SELECT * FROM InboundShipments WHERE ShipmentId = '503-9993250-1405404'

SELECT * FROM InboundShipments WHERE LastUpdatedDate >= '2016-12-12'

Columns

Name	Type	References	Description
ShipmentId [KEY]	String		The ID of the shipment.
ShipmentStatus	String		The status of your inbound shipment. Possible values are WORKING, SHIPPED, IN_TRANSIT, DELIVERED, CHECKED_IN, RECEIVING, CLOSED, CANCELLED, DELETED, and ERROR.
ShipmentName	String		The unique name of the inbound shipment.
ShipFromPostalCode	String		The PostalCode of the return address.
ShipFromName	String		The Name of the return address.
ShipFromCountryCode	String		The CountryCode of the return address.
ShipFromStateOrProvinceCode	String		The State Or Province Code of the return address.
ShipFromAddressLine1	String		The AddressLine of the return address.
ShipFromCity	String		The City of the return address.
LabelPrepType	String		The type of label preparation.
AreCasesRequired	Boolean		Boolean that indicates whether or not an inbound shipment contains case-packed boxes.
DestinationFulfillmentCenterId	String		The Amazon fulfillment center identifier created by Amazon.
ConfirmedNeedByDate	Date		Date that the shipment must arrive at an Amazon fulfillment center for pre-ordered items.
EstimatedBoxContentsFeeTotalUnits	Int		The number of units to ship for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsFeePerUnitCurrencyCode	String		The currency code for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsFeePerUnitValue	Decimal		The manual processing fee per unit for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsTotalFeeCurrencyCode	String		The Total fee currency code for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsTotalFeeValue	Decimal		The Total fee value for an estimate of the manual processing fee charged by Amazon for boxes without box content information.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
LastUpdatedDate	Datetime

Returns information about the availability of inventory that a seller has in Amazon's fulfillment network and in current inbound shipments. You can check the current availability status for your Fulfillment by Amazon inventory as well as discover when availability status changes.

Select

The Cloud will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud. For example, the following query is processed server side:

SELECT * FROM InventorySupply WHERE SellerSKU = 'Stest'

SELECT * FROM InventorySupply WHERE  QueryStartDateTime = '2016-03-16'

Columns

Name	Type	References	Description
UID [KEY]	String		Auto Generated Primary Key field.
FNSKU	String		The Fulfillment Network SKU (FNSKU) of the item. The FNSKU is a unique identifier for each inventory item stored in an Amazon fulfillment center.
SellerSKU	String		The Seller SKU of the item. Required if the QueryStartDateTime is not specified.
ASIN	String		The Amazon Standard Identification Number (ASIN) of the item.
Condition	String		The condition of the item.
TotalSupplyQuantity	Integer		The total item quantity that a seller has in Amazon's fulfillment network supply chain. This includes inventory that is available for shipping, inventory in inbound shipments, and inventory being transferred between Amazon fulfillment centers.
InStockSupplyQuantity	Integer		The item quantity that a seller has in Amazon fulfillment centers that is available for shipping.
EarliestAvailability_TimepointType	String		Indicates whether inventory is immediately available for picking, whether inventory availability is unknown, or whether inventory is expected to be available for picking by a specific date.
EarliestAvailability_DateTime	Datetime		The date and time by which inventory is expected to be available for picking.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
QueryStartDateTime	Datetime		A date used for selecting items that have had changes in inventory availability after (or at) a specified time. Required if SellerSKU is not specified.

Returns order items based on the Amazon Order Id that you specify.

Select

The Cloud will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud. OrderItems table supports server side filtering with = and IN operators for AmazonOrderId field. For example, the following query is processed server side:

SELECT * FROM OrderItems WHERE AmazonOrderId = '503-9993250-1405404'

SELECT * FROM OrderItems WHERE AmazonOrderId IN ('503-9993250-1405404', '503-9993250-1405404')

Columns

Name	Type	References	Description
OrderItemId [KEY]	String		The item ID of the order.
AmazonOrderId	String	Orders.AmazonOrderId	The Amazon ID of the order.
ASIN	String		The ASIN Code.
SellerSKU	String		The SellerSKU.
BuyerCustomizedInfoCustomizedURL	String		The Buyer CustomizedURL.
Title	String		Title.
QuantityOrdered	Integer		The quantity of items ordered.
QuantityShipped	Integer		The quantity of items shipped.
GrantedPointsNumber	Integer		The Granted Points Number.
GrantedPointsMonetaryValueAmount	Decimal		The Granted Points Amount.
GrantedPointsMonetaryValueCurrencyCode	String		The Granted Points CurrencyCode.
NumberOfItems	Integer		The Number Of Items.
ItemPriceAmount	Decimal		The Item Price Amount.
ItemPriceCurrencyCode	String		The Item Price Currency Code.
ShippingPriceAmount	Decimal		The Shipping Price Amount.
ShippingPriceCurrencyCode	String		The Shipping Price Currency Code.
GiftWrapPriceAmount	String		The Gift Wrap Price Amount.
GiftWrapPriceCurrencyCode	String		The Gift Wrap Price Currency Code.
TaxCollectionName	String		The TaxCollection Name.
TaxCollectionValue	String		The TaxCollection Value.
ItemTaxAmount	Decimal		The Item Tax Amount.
ItemTaxCurrencyCode	String		The Item Tax Currency Code.
ShippingTaxAmount	String		The Shipping Tax Amount.
ShippingTaxCurrencyCode	String		The ShippingTax Currency Code.
GiftWrapTaxAmount	Decimal		The Gift Wrap Tax Amount.
GiftWrapTaxCurrencyCode	String		The Gift Wrap Tax Currency Code.
ShippingDiscountAmount	String		The Shipping Discount Amount.
ShippingDiscountCurrencyCode	String		The Shipping Discount Currency Code.
PromotionDiscountAmount	Decimal		The Promotion Discount Amount.
PromotionDiscountCurrencyCode	String		The Promotion Discount Currency Code.
PromotionIds	String		The IDs of Promotions.
CODFeeAmount	Decimal		The COD FeeAmount.
CODFeeCurrencyCode	String		The COD FeeCurrency Code.
CODFeeDiscountAmount	String		The COD FeeDiscount Amount.
CODFeeDiscountCurrencyCode	String		The COD FeeDiscount Currency Code.
IsGift	Boolean		Boolean specifying if the item is gift.
GiftMessageText	String		The Gift Message Text.
GiftWrapLevel	String		The Gift Wrap Level.
InvoiceDataInvoiceRequirement	String		The requirement of InvoiceData.
InvoiceDataBuyerSelectedInvoiceCategory	String		The selected categories of the InvoiceData.
InvoiceDataInvoiceTitle	String		The Title of the InvoiceData.
InvoiceDataInvoiceInformation	String		The Information of the InvoiceData.
ConditionNote	String		The Condition Note.
ConditionId	String		The Condition Id.
ConditionSubtypeId	String		The Condition Subtype Id.
ScheduledDeliveryStartDate	Datetime		The Scheduled Delivery StartDate.
ScheduledDeliveryEndDate	Datetime		The Scheduled Delivery EndDate.
PriceDesignation	String		The Price Designation.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
LastUpdateDate	Datetime		The last time the order is updated.

Returns orders created or updated during a time frame that you specify.

Select

The Cloud will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud. For example, the following query is processed server side:

SELECT * FROM Orders WHERE AmazonOrderId = '249-7638334-8161403'

SELECT * FROM Orders WHERE LastUpdateDate >= '2016-12-12'

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12'

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12' AND OrderStatus = 'Canceled'

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12' AND FulfillmentChannel = 'MFN'

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12' AND BuyerEmail = '[email protected]'

SELECT * FROM Orders WHERE PurchaseDate >= '2016-12-12' AND PaymentMethod = 'Other'

Columns

Name	Type	References	Description
AmazonOrderId [KEY]	String		The Amazon ID of the order.
SellerOrderId	String		The Seller ID of the order.
PurchaseDate	Datetime		The date of the purchase.
LastUpdateDate	Datetime		The last update date.
OrderStatus	String		Status of the order.
FulfillmentChannel	String		The Fulfillment Channel.
SalesChannel	String		The Sales Channel.
OrderChannel	String		The Order Channel.
ShipServiceLevel	String		The level of the Ship Service.
ShippingAddressName	String		The Shipping Address Name.
ShippingAddressAddressLine1	String		The Shipping Address AddressLine.
ShippingAddressAddressLine2	String		The Shipping Address AddressLine.
ShippingAddressAddressLine3	String		The Shipping Address AddressLine.
ShippingAddressCity	String		The Shipping Address City.
ShippingAddressCountry	String		The Shipping Address Country.
ShippingAddressDistrict	String		The Shipping Address District.
ShippingAddressStateOrRegion	String		The Shipping Address State Or Region.
ShippingAddressPostalCode	String		The Shipping Address Postal Code.
ShippingAddressCountryCode	String		The Shipping Address Country Code.
ShippingAddressPhone	String		The Shipping Address Phone.
ShippingAddress_AddressType	String		The Shipping Address Type.
OrderTotalCurrencyCode	String		The Order Currency Code.
OrderTotalAmount	Decimal		The Order Amount.
NumberOfItemsShipped	Integer		The Number Of Items Shipped.
NumberOfItemsUnshipped	Integer		The Number Of Items Unshipped.
PaymentExecutionDetail	String		The Payment Execution Detail.
PaymentMethod	String		The Payment Method.
PaymentMethodDetail	String		The Details of payment method.
IsReplacementOrder	Boolean		Boolean specifying if it is a replacement order.
ReplacedOrderId	String		The Replaced OrderId.
MarketplaceId	String		The MarketplaceId.
BuyerEmail	String		The Buyer Email.
BuyerName	String		The Buyer Name.
BuyerCounty	String		The Buyer Country.
BuyerTaxInfo	String		The Buyer Tax Info.
ShipmentServiceLevelCategory	String		The Shipment Service Level Category.
ShippedByAmazonTFM	Boolean		The Shipped By Amazon TFM.
TFMShipmentStatus	String		The TFM Shipment Status.
CbaDisplayableShippingLabel	String		The Cba Displayable Shipping Label.
OrderType	String		The Type of Order.
EarliestShipDate	Datetime		The Earliest Ship Date.
LatestShipDate	Datetime		The Latest Ship Date.
EarliestDeliveryDate	Datetime		The Earliest Delivery Date.
LatestDeliveryDate	Datetime		The Latest Delivery Date.
IsBusinessOrder	Boolean		Boolean specifying if it is a Business Order.
IsIBA	Boolean		When true, the item within this order was bought and re-sold by Amazon Business EU SARL (ABEU).
PurchaseOrderNumber	String		The Purchase Order Number.
IsPrime	Boolean		Boolean specifying if it is a Prime Order.
IsPremiumOrder	Boolean		Boolean specifying if it is a Premium Order.

The Products Table helps you get information to match your products to existing product listings on Amazon Marketplace websites.

Select

The Cloud will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud. For example, the following query is processed server side:

SELECT * FROM Products WHERE SearchTerms = '249-7638334-8161403'

SELECT * FROM Products WHERE idType = 'SellerSKU' AND idlist = '{SellerSku code}'

SELECT * FROM Products WHERE idType = 'ASIN' AND idlist = '{ASIN code}'

SELECT * FROM Products WHERE idType = 'GCID' AND idlist = '{GCID code}'

SELECT * FROM Products WHERE idType = 'UPC' AND idlist = '{UPC code}'

SELECT * FROM Products WHERE idType = 'EAN' AND idlist = '{EAN code}'

SELECT * FROM Products WHERE idType = 'ISBN' AND idlist = '{ISBN code}'

SELECT * FROM Products WHERE idType = 'JAN' AND idlist = '{JAN code}'

SELECT * FROM Products WHERE idType = 'JAN' AND idlist IN ('{JAN code}', '{ISBN code}', '{GCID code}')

Columns

Name	Type	References	Description
MarketplaceASIN [KEY]	String		The Marketplace ASIN.
MarketplaceASINMarketplaceId	String		The MarketplaceId of Marketplace ASIN.
SKUIdentifierMarketplaceId	String		The SKUIdentifier of MarketplaceId.
SKUIdentifierSelerId	String		The MarketplaceId of SellerId.
SKUIdentifierSellerSKU	String		The MarketplaceId of SellerSKU.
AttributeSets	String		The product attributes.
Relationships	String		The product relationships.
SalesRankings	String		The product sales rankings.
SearchTerms	String
IdType	String		The product ID type. The allowed values are ASIN, GCID, SellerSKU, UPC, EAN, ISBN, JAN.
IdList	String		A list of product IDs.

Usage information for the operation ReportList.rsd.

Select

The Cloud will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud. For example, the following query is processed server side:

SELECT * FROM ReportList WHERE ReportType IN '_GET_MERCHANT_LISTINGS_INACTIVE_DATA_'

SELECT * FROM ReportList WHERE ReportRequestId = '50566018029'

SELECT * FROM ReportList WHERE ReportRequestId IN ('50566018029', '50564018026')

SELECT * FROM ReportList WHERE AvailableDate > '2016-12-12' AND AvailableDate < '2018-11-12 12:00:00'

SELECT * FROM ReportList WHERE AvailableDate >= '2016-12-12' AND Acknowledged = 'true'

Columns

Name	Type	References	Description
ReportId [KEY]	String		Report ID.
ReportType	String		The type of the Report.
ReportRequestId	String		The Report Request ID.
Acknowledged	Boolean		A boolean value that indicates whether the order report has been acknowledged.
AvailableDate	Datetime		Date on which the report was available. By default, reports available from the last 90 days will be returned.

Usage information for the operation ReportRequestList.rsd.

Select

The Cloud will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud. For example, the following query is processed server side:

SELECT * FROM ReportRequestList WHERE ReportType = '_GET_MERCHANT_LISTINGS_INACTIVE_DATA_'

SELECT * FROM ReportRequestList WHERE ReportType IN ('_GET_MERCHANT_LISTINGS_INACTIVE_DATA_', '_GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_')

SELECT * FROM ReportRequestList WHERE ReportRequestId = '50566018029'

SELECT * FROM ReportRequestList WHERE ReportRequestId IN ('50566018029', '50564018026')

SELECT * FROM ReportRequestList WHERE RequestedDate > '2016-12-12'

SELECT * FROM ReportRequestList WHERE RequestedDate > '2016-12-12' AND RequestedDate > '2018-12-12 13:00'

SELECT * FROM ReportRequestList WHERE RequestedDate <= '2016-12-12' AND ReportProcessingStatus = '_DONE_'

SELECT * FROM ReportRequestList WHERE ReportProcessingStatus IN ('_DONE_', '_SUBMITTED_', '_CANCELLED_')

Columns

Name	Type	References	Description
ReportRequestId [KEY]	String		The Report Request Id.
ReportType	String		The type of the Report.
StartDate	Datetime		The start date of the request.
EndDate	Datetime		The end date of the request.
Scheduled	Boolean		A boolean value that indicates whether the report request was scheduled.
SubmittedDate	Datetime		The date and time the report was submitted.
ReportProcessingStatus	String		Processing status of the report. Possible values are: _SUBMITTED_, _IN_PROGRESS_, _CANCELLED_, _DONE_, _DONE_NO_DATA_
GeneratedReportId	String		The report id generated from Amazon MWS.
StartedProcessingDate	Datetime		The date and time that the report stated to be processed.
CompletedDate	Datetime		The date and time that the report was completed.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
RequestedDate	Datetime		The date and time that the report was requested. By default, reports requested within the range of the last 90 days will be returned.

Stored procedures are function-like interfaces that extend the functionality of the Cloud 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 Cloud - Amazon Marketplace 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.
CreateReportSchema	Creates a schema file based on the specified report.
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.

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.

Input

Name	Type	Required	Description
FeedSubmissionId	String	True	Required. A unique identifier for the feed submission.
FeedType	String	False	The type of feed submitted.
SubmittedFromDate	Datetime	False	Beginning of the date range specified when the feed was submitted.
SubmittedToDate	Datetime	False	End of the date range specified when the feed was submitted.
CancelFeedAggregate	String	False	An aggregate representing the feed. Can be in the form of XML or a #TEMP table.

Result Set Columns

Name	Type	Description
FeedSubmissionId	String	Required. A unique identifier for the feed submission.
FeedType	String	The type of feed submitted.
SubmittedDate	Datetime	The date and time when the feed was submitted.
FeedProcessingStatus	String	The processing status of the feed submission
StartedProcessingDate	Datetime	The date when the feed processing started.
CompletedProcessingDate	Datetime	The date when the feed processing completed.
SwitchFulfillmentTo	String	Used only when switching the fulfillment of an item from MFN (merchant fulfilled) to AFN (Amazon fulfilled) or vice versa.
OperationType	String	Required. Used to specify the type of operation (Update or Delete) to be performed on the data.

CancelReportRequests operation cancels one or more report requests and returns the number of report requests canceled and report request information.

Input

Name	Type	Required	Description
ReportRequestIdList	String	False	A structured list of ReportRequestId values. If a ReportRequestId value is specified, other query conditions are ignored. If not specified, all report requests will be canceled.
ReportTypeList	String	False	A structured list of ReportType values.
ReportProcessingStatusList	String	False	A structured list of report processing statuses used to filter report requests. The values for ReportProcessingStatusList are: _SUBMITTED_,_IN_PROGRESS_,_CANCELLED_,_DONE_,_DONE_NO_DATA_
RequestedFromDate	Datetime	False	The start date of the date range used to select the data to report. Default: 90 days ago.
RequestedToDate	Datetime	False	End of the date range used to select the data to report. Default: current date.

Result Set Columns

Name	Type	Description
Count	Integer	A nonnegative integer representing the total number of canceled report requests.

Creates a schema file based on the specified report.

CreateReportSchema

CreateReportSchema creates a schema file based on the specified report. This schema adds a table to your existing list that corresponds with the results of your report, which can then be queried like other tables. (Reports from the Amazon Marketplace are not modeled by Cloud as queryable tables by default.)

The generated schema file outlines the metadata for the report, such as columns and column data types. You can edit the file to adjust data types, rename columns, and include or exclude columns.

Updating a Report Schema

In the following example, the SP CreateReportSchema creates a new report using TestReportTest1 as a base template. It appends new columns to TestReportTest1 and creates a new report, named TestReport2. The new report is saved as ...\\TestReportTest2.rsd.

EXECUTE [CreateReportSchema] 
    [ReportName] = "TestReportTest2",
    [CustomFieldIdsPrimitive] = "1459925,1459928",
    [CustomFieldIdsDropdown] = "1469785",
    [CustomDimensionKeyIds] = "13539564",
    [BaseReportName] = "TestReportTest1", 
    [FileName] = "...\\TestReportTest2.rsd"

Input

Name	Type	Required	Description
TableName	String	True	The name for the new table.
ReportId	String	True	The report id.
ReportName	String	True	The name of the report.
FileName	String	False	The full file path and name of the schema to generate. Begin by choosing a parent directory (this parent directory should be set in the Location property). Complete the filepath by adding a directory corresponding to the schema used (Marketplace), followed by a .rsd file with a name corresponding to the desired table name. For example : 'C:\\Users\\User\\Desktop\\AmazonMarketplace\\Marketplace\\Filters.rsd'
Description	String	False	An optional description for the table.
WriteToFile	String	False	Whether to write the contents of the generated schema to a file or not. The input defaults to true. Set it to false to write to FileStream or FileData.

Result Set Columns

Name	Type	Description
Success	String	Whether or not the schema was created successfully.
FileData	String	The generated schema encoded in base64. Only returned if FileName is not set.

Creates and/or returns data for a specific report.

Execute

We can use GetReport stored procedure in two ways:
To create and download a report in which case you must at least set ReportType, StartDate and DownloadPath attributes. The stored procedure will wait until the report is processed server side.

  EXEC GetReport
  @ReportType = '_GET_FLAT_FILE_ORDERS_DATA_',
  @StartDate = '08-27-2020',
  @DownloadPath = 'C:\Tests\AmazonMarketplaceTest'

To download an existing report in which case you must at least set ReportID and DownloadPath attributes for ex:

  EXEC GetReport
  @ReportID = '50815018501',
  @DownloadPath = 'C:\Tests\AmazonMarketplaceTest'

Note: This procedure makes use of indexed parameters. Indexed parameters facilitate providing multiple instances a single parameter as inputs for the procedure.

Suppose there is an input parameter named Param#. To input multiple instances of an indexed parameter like this, execute:

EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"

In the table below, indexed parameters are denoted with a '#' character at the end of their names.

Input

Name	Type	Required	Description
ReportId	String	False	Unique ID of the report to download.
DownloadPath	String	True	The File path to write the report data.
CheckSum	Boolean	False	Boolean used to check sum of the report. The default value is false.
ReportType	String	False	Indicates the report type to request.
StartDate	Datetime	False	The start date of the date range used to select the data to report. By default it is the current date. If specified, it must be before the current date.
EndDate	Datetime	False	End date of the date range used to select the data to report. By default it is the current date. If specified, it must be before the current date.
ReportOptions	String	False	Additional information to pass to the report. If the report accepts ReportOptions, the information is displayed in the report description in the ReportType enumerator section.
MarketplaceIdList#	String	False	One or more marketplace IDs for the marketplace that registered the listing account. Default: The marketplace where you first registered your Selling Account.

Result Set Columns

Name	Type	Description
Success	Boolean	Boolean indicating the result of the operation.
MD5SUM	String	The MD5 Sum of the report content.
GeneratedReportId	String	A unique identifier for the report.
ReportRequestId	String	A unique identifier for the report request.
ReportProcessingStatus	String	The processing status of the request.

The RequestReport operation creates a report request.

Note: This procedure makes use of indexed parameters. Indexed parameters facilitate providing multiple instances a single parameter as inputs for the procedure.

Suppose there is an input parameter named Param#. To input multiple instances of an indexed parameter like this, execute:

EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"

In the table below, indexed parameters are denoted with a '#' character at the end of their names.

Input

Name	Type	Required	Description
ReportType	String	True	Required. Indicates the report type to request.
StartDate	Datetime	False	The start date of the date range used to select the data to report.By default it is the current date. If specified, it must be before the current date.
EndDate	Datetime	False	End date of the date range used to select the data to report. By default it is the current date. If specified, it must be before the current date.
ReportOptions	String	False	Additional information to pass to the report. If the report accepts ReportOptions, the information is displayed in the report description in the ReportType enumerator section.
MarketplaceIdList#	String	False	One or more marketplace IDs for the marketplace that registered the listing account. Default: The marketplace where you first registered your Selling Account.

Result Set Columns

Name	Type	Description
ReportRequestId	String	A unique identifier for the report request.
ReportProcessingStatus	String	The processing status of the request.

The Image feed allows you to upload various images for a product. Amazon can display several images for each product.

Execute

The stored procedure accepts two aggregated formats: #TEMP tables and XML aggregate

For #TEMP tables

You must include in your query:

INSERT INTO ImageFeedAggregate#TEMP (SKU, ImageType, ImageLocation, OperationType) VALUES ('15700', 'Main', 'https://www.cdata.com/ui/img/home/adapters.png', 'Update')

Then you execute the procedure by specifying the value of ImageFeedAggregate with the name of #TEMP table used ImageFeedAggregate#TEMP.

EXEC SubmitImageFeed ProductImageFeedAggregate = 'ImageFeedAggregate#TEMP'

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

For XML aggregate

The XML aggregate must follow the API structure (https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_4_1/ProductImage.xsd):

  <Message>
    <MessageID>1</MessageID>
    <OperationType>Update</OperationType>
    <ProductImage>
        <SKU>15700</SKU>
        <ImageType>Main</ImageType>
        <ImageLocation>https://www.cdata.com/ui/img/home/adapters.png</ImageLocation>
    </ProductImage>
  </Message>

EXEC SubmitImageFeed ProductImageFeedAggregate = '...(the above XML)...'

Input

Name	Type	Required	Description
SKU	String	True	Required. Used to identify an individual product. Each product must have a SKU, and each SKU must be unique.
ImageType	String	False	Required. Available Values are Main, Swatch, BKLB, PT1, PT2, PT3, PT4, PT5, PT6, PT7, PT8, Search, PM01, MainOfferImage, OfferImage1, OfferImage2, OfferImage3, OfferImage4, OfferImage5, PFEE, PFUK, PFDE, PFFR, PFIT, PFES, EEGL, PT98, PT99, and ELFL.
ImageLocation	String	False	The exact location of the image using a full URL (such as http://mystore.com/images/1234.jpg).
OperationType	String	True	Required. Used to specify the type of operation (Update or Delete) to be performed on the data.
ProductImageFeedAggregate	String	False	An aggregate representing the feed. Can be in the form of XML or a #TEMP table.

Result Set Columns

Name	Type	Description
FeedSubmissionId	String	A unique identifier for the feed submission.
FeedType	String	The type of feed submitted.
SubmittedDate	Datetime	The date and time when the feed was submitted.
FeedProcessingStatus	String	The processing status of the feed submission.

The Inventory feed allows you to update inventory quantities (stock levels) for your items.

Execute

The stored procedure accepts two aggregated formats: #TEMP tables and XML aggregate

For #TEMP tables

You must include in your query:

INSERT INTO InventoryFeed#TEMP (SKU, Quantity, FulfillmentLatency) VALUES ('15700', 11, '2')

INSERT INTO InventoryFeed#TEMP (SKU, Quantity, FulfillmentLatency) VALUES ('99987867', 10, '2')

Then you execute the procedure by specifying the value of InventoryFeedAggregate with the name of #TEMP table used InventoryFeed#TEMP.

EXEC SubmitInventoryFeed InventoryFeedAggregate = 'InventoryFeed#TEMP'

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

For XML aggregate

The XML aggregate must follow the API structure (https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_4_1/Inventory.xsd):

    <Message>
        <MessageID>1</MessageID>
        <Inventory>
          <SKU>15700</SKU>
          <Quantity>11</Quantity>
          <FulfillmentLatency>2</FulfillmentLatency>
        </Inventory>
      </Message>
      <Message>
        <MessageID>2</MessageID>
        <Inventory>
          <SKU>99987867</SKU>
          <Quantity>10</Quantity>
          <FulfillmentLatency>2</FulfillmentLatency>
        </Inventory>
      </Message>

EXEC SubmitInventoryFeed InventoryFeedAggregate = '...(the above XML)...';

Input

Name	Type	Required	Description
SKU	String	False	Required. Used to identify an individual product. Each product must have a SKU, and each SKU must be unique.
FulfillmentCenterID	String	False	Seller-defined identifier for a fulfillment center.
Available	Boolean	False	Indicates whether or not the item is available (true = available; false = not available).
Quantity	Integer	False	Indicates whether or not an item is available (any positive number = available; 0 = not available).
RestockDate	Date	False	Date the item will be restocked, if not currently available.
FulfillmentLatency	String	False	The number of days between the order date and the ship date (a whole number between 1 and 30).
SwitchFulfillmentTo	String	False	Used only when switching the fulfillment of an item from MFN (merchant fulfilled) to AFN (Amazon fulfilled) or vice versa.
OperationType	String	False	Required. Used to specify the type of operation (Update or Delete) to be performed on the data.
InventoryFeedAggregate	String	False	An aggregate representing the feed. Can be in the form of XML or a #TEMP table or a #TEMP table.

Result Set Columns

Name	Type	Description
FeedSubmissionId	String	A unique identifier for the feed submission.
FeedType	String	The type of feed submitted.
SubmittedDate	Datetime	The date and time when the feed was submitted.
FeedProcessingStatus	String	The processing status of the feed submission.

The Order Acknowledgment feed allows you to acknowledge your success or failure with downloading an order.

Execute

The stored procedure accepts two aggregated formats: #TEMP tables and XML aggregate

For #TEMP tables

You must include in your query:

INSERT INTO OrderAcknowledgementFeedAggregate#TEMP (AmazonOrderId, StatusCode, AmazonOrderItemCode, CancelReason) VALUES ('249-6070298-2783041', 'Failure', '25959136016214', 'NoInventory')

Then you execute the procedure by specifying the value of OrderAcknowledgementFeedAggregate with the name of #TEMP table used OrderAcknowledgementFeedAggregate#TEMP.

EXEC SubmitOrderAcknowledgementFeed OrderAcknowledgementFeedAggregate = 'OrderAcknowledgementFeedAggregate#TEMP'

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

For XML aggregate

The XML aggregate must follow the API structure (https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_4_1/OrderAcknowledgement.xsd):

    <Message>
        <MessageID>1</MessageID>
        <OrderAcknowledgement>
          <AmazonOrderID>249-6070298-2783041</AmazonOrderID>
          <StatusCode>Failure</StatusCode>
		  <Item>
			<AmazonOrderItemCode>25959136016214</AmazonOrderItemCode>
			<CancelReason>NoInventory</CancelReason>
		  </Item>
        </OrderAcknowledgement>
      </Message>

EXEC SubmitOrderAcknowledgementFeed OrderAcknowledgementFeedAggregate = '...(the above XML)...'

Input

Name	Type	Required	Description
AmazonOrderID	String	False	Amazon's unique identifier for an order, which identifies the entire order, regardless of the number of individual items in the order.
MerchantOrderID	String	False	Optional seller-supplied order ID. Amazon will map the MerchantOrderID to the AmazonOrderID, and you can then use your own order ID (MerchantOrderID) for subsequent feeds relating to the order.
StatusCode	String	False	Allows you to acknowledge your success or failure with downloading an order. StatusCode can be either Success or Failure.
AmazonOrderItemCode	String	False	Amazon's unique identifier for an item in an order.
MerchantOrderItemID	String	False	Optional seller-supplied ID for an item in an order. If the MerchantOrderItemID is specified with the AmazonOrderItemCode, Amazon will map the two IDs and you can then use your own order item ID for subsequent feeds relating to that order item.
CancelReason	String	False	Used only when sending a StatusCode of Failure.
ItemAggregate	String	False	An aggregate representing an order Item. Can be in the form of XML or a #TEMP table. Use this field when multiple items in the order need to be acknowledged.
OrderAcknowledgementFeedAggregate	String	False	An aggregate representing the feed. Can be in the form of XML or a #TEMP table.

Result Set Columns

Name	Type	Description
FeedSubmissionId	String	A unique identifier for the feed submission.
FeedType	String	The type of feed submitted.
SubmittedDate	Datetime	The date and time when the feed was submitted.
FeedProcessingStatus	String	The processing status of the feed submission.

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).

Execute

The stored procedure accepts two aggregated formats: #TEMP tables and XML aggregate

For #TEMP tables

You must include in your query:

INSERT INTO ItemPriceAdjustmentsAggregate#TEMP (ItemPriceAdjustmentsComponentType, ItemPriceAdjustmentsComponentAmount, ItemPriceAdjustmentsComponentAmountCurrency) VALUES ('Shipping', '150', 'JPY')

INSERT INTO AdjustedItemAggregate#TEMP (AdjustedItemAmazonOrderItemCode, AdjustedItemAdjustmentReason, ItemPriceAdjustmentsAggregate) VALUES ('25959136016214', 'CustomerReturn', 'ItemPriceAdjustmentsAggregate#TEMP')

INSERT INTO OrderAdjustmentFeedAggregate#TEMP (AmazonOrderID, OperationType, AdjustedItemAggregate) VALUES ('503-0717426-9080645', 'Update', 'AdjustedItemAggregate#TEMP')

Then you execute the procedure by specifying the value of OrderAdjustmentFeedAggregate with the name of #TEMP table used OrderAdjustmentFeedAggregate#TEMP.

EXEC SubmitOrderAdjustmentFeed OrderAdjustmentFeedAggregate = 'OrderAdjustmentFeedAggregate#TEMP'

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

For XML aggregate

The XML aggregate must follow the API structure (https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_4_1/OrderAdjustment.xsd):

    <Message>
        <MessageID>1</MessageID>
        <OperationType>Update</OperationType>
        <OrderAdjustment>
          <AmazonOrderID>503-0717426-9080645</AmazonOrderID>
          <AdjustedItem>
            <AmazonOrderItemCode>25959136016214</AmazonOrderItemCode>
            <AdjustmentReason>CustomerReturn</AdjustmentReason>
            <ItemPriceAdjustments>
              <Component>
                <Type>Shipping</Type>
                <Amount currency="JPY">150</Amount>
              </Component>
            </ItemPriceAdjustments>
          </AdjustedItem>
        </OrderAdjustment>
    </Message>

EXEC SubmitOrderAdjustmentFeed OrderAdjustmentFeedAggregate = '...(the above XML)...'

Input

Name	Type	Required	Description
AmazonOrderID	String	False	Amazon's unique identifier for an order, which identifies the entire order regardless of the number of individual items in the order.
OperationType	String	False	Required. Used to specify the type of operation (Update or Delete) to be performed on the data.
MerchantOrderID	String	False	Optional seller-supplied order ID. The first step is to establish the MerchantOrderID in the acknowledgment feed. Amazon will map the MerchantOrderID to the AmazonOrderID, and you can then use your own order ID (MerchantOrderID) for subsequent feeds relating to that order. See the base XSD for the definition.
AdjustedItemQuantityCancelled	Integer	False	Quantity of items being canceled. Used only for partial cancellations.
AdjustedItemAmazonOrderItemCode	String	False	Amazon's unique ID for an item in an order.
AdjustedItemMerchantOrderItemID	String	False	Optional seller-supplied ID for an item in an order. It can be used in order processing if the pairing was established in the acknowledgment feed.
AdjustedItemMerchantAdjustmentItemID	String	False	Optional seller-supplied unique ID for the adjustment (not used by Amazon).
AdjustedItemAdjustmentReason	String	False	Reason for the adjustment.
ItemPriceAdjustmentsComponentType	String	False	The Type of price adjustment for the item. Values include: Principal, Shipping, Tax, ShippingTax, RestockingFee, RestockingFeeTax, GiftWrap, GiftWrapTax, Surcharge, ReturnShipping, Goodwill, ExportCharge, COD, CODTax, Other, FreeReplacementReturnShipping
ItemPriceAdjustmentsComponentAmount	Decimal	False	The Amount of the adjustment.
ItemPriceAdjustmentsComponentAmountCurrency	String	False	The Currency for the Amount.
ItemPriceAdjustmentsAggregate	String	False	An aggregate representing the Amount the buyer is to be refunded for the item. Can be in the form of XML, JSON, or a #TEMP table. Use this field if multiple item price adjustments need to be applied.
PromotionAdjustmentsPromotionClaimCode	String	False	The ClaimCode for the Promotion Adjustment.
PromotionAdjustmentsMerchantPromotionID	String	False	The Promotion Id for the Promotion Adjustment.
PromotionAdjustmentsComponentType	String	False	The Type of price adjustment for the promotion.
PromotionAdjustmentsComponentAmount	Decimal	False	The Amount of price adjustment for the promotion.
PromotionAdjustmentsComponentAmountCurrency	String	False	The Currency for the Amount.
PromotionAdjustmentsComponentAggregate	String	False	An aggregate representing the Amount the buyer is to be refunded for the promotion, broken down by type. Can be in the form of XML, JSON, or a #TEMP table. Use this field if multiple promotion price adjustments need to be applied.
PromotionAdjustmentsAggregate	String	False	An aggregate representing the promotion. Child Elements include PromotionClaimCode, MerchantPromotionID, ComponentAggregate (Type, Amount and Amount@Currency). Use this field if multiple promotions need to be applied.
AdjustedItemAggregate	String	False	An aggregate representing order adjustment information for a specific item. Can be in the form of XML, JSON, or a #TEMP table. Use this field if multiple items need adjusting in 1 order.
OrderAdjustmentFeedAggregate	String	False	An aggregate representing the feed. Can be in the form of XML or a #TEMP table.

Result Set Columns

Name	Type	Description
FeedSubmissionId	String	A unique identifier for the feed submission.
FeedType	String	The type of feed submitted.
SubmittedDate	Datetime	The date and time when the feed was submitted.
FeedProcessingStatus	String	The processing status of the feed submission.

The Order Fulfillment feed allows your system to update Amazon's system with order fulfillment information.

Execute

The stored procedure accepts two aggregated formats: #TEMP tables and XML aggregate

For #TEMP tables

You must include in your query:

INSERT INTO ItemAggregate#TEMP (ItemAmazonOrderItemCode, ItemQuantity) VALUES ('25959136016214', '1');

INSERT INTO OrderFulfillmentFeedAggregate#TEMP (AmazonOrderID, FulfillmentDate, FulfillmentDataCarrierName, FulfillmentDataShippingMethod, FulfillmentDataShipperTrackingNumber, ItemAggregate) VALUES ('249-6070298-2783041', '2017-02-01T00:00:00Z', 'CData Delivery Company', 'Normal Delivery', '1223525345234', 'ItemAggregate#TEMP')

Then you execute the procedure by specifying the value of OrderFulfillmentFeedAggregate with the name of #TEMP table used OrderFulfillmentFeedAggregate#TEMP.

EXEC SubmitOrderFulfillmentFeed OrderFulfillmentFeedAggregate = 'OrderFulfillmentFeedAggregate#TEMP'

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

For XML aggregate

The XML aggregate must follow the API structure (https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_4_1/OrderFulfillment.xsd):

    <Message>
    <MessageID>1</MessageID>
    <OrderFulfillment>
        <AmazonOrderID>249-6070298-2783041</AmazonOrderID>
        <FulfillmentDate>2017-02-01T00:00:00Z</FulfillmentDate>
        <FulfillmentData>
            <CarrierName>CData Delivery Company</CarrierName>
            <ShippingMethod>Normal Delivery</ShippingMethod>
            <ShipperTrackingNumber>1223525345234</ShipperTrackingNumber>
        </FulfillmentData>
        <Item>
            <AmazonOrderItemCode>25959136016214</AmazonOrderItemCode>
            <Quantity>1</Quantity>
        </Item>
    </OrderFulfillment>
</Message>

EXEC SubmitOrderFulfillmentFeed OrderFulfillmentFeedAggregate = '...(the above XML)...'

Input

Name	Type	Required	Description
AmazonOrderID	String	False	Amazon's unique identifier for an order, which identifies the entire order regardless of the number of individual items in the order.
MerchantOrderID	String	False	Optional seller-supplied order ID. The first step is to establish the MerchantOrderID in the acknowledgment feed. Amazon will map the MerchantOrderID to the AmazonOrderID, and you can then use your own order ID (MerchantOrderID) for subsequent feeds relating to that order. See the base XSD for the definition.
OperationType	String	True	Required. Used to specify the type of operation (Update or Delete) to be performed on the data.
MerchantFulfillmentID	Integer	False	Seller-supplied unique identifier for the shipment (not used by Amazon).
FulfillmentDate	Datetime	False	The date the item was actually shipped or picked up, depending on the fulfillment method specified in the order.
FulfillmentDataCarrierCode	String	False	The shipping carrier code.
FulfillmentDataCarrierName	String	False	The shipping carrier name.
FulfillmentDataShippingMethod	String	False	The shipping method used to deliver the item.
FulfillmentDataShipperTrackingNumber	String	False	The tracking number for the shipment.
CODCollectionMethod	String	False	Cash on delivery collection mode of an order.
ItemAmazonOrderItemCode	String	False	Amazon's unique ID for an item in an order.
ItemMerchantOrderItemID	String	False	The shipping Optional seller-supplied ID for an item in an order.
ItemMerchantFulfillmentItemID	String	False	Seller-supplied unique identifier for an item in the shipment (not used by Amazon).
ItemQuantity	Integer	False	The quantity of an item shipped.
ItemAggregate	String	False	An aggregate representing order-fulfillment information for a specific item. Can be in the form of XML, JSON, or a #TEMP table. Use this field when multiple Items need to be included in the feed.
FulfillmentDataAggregate	String	False	An aggregate representing order-fulfillment information for a specific item. Can be in the form of XML, JSON, or a #TEMP table. Use this field when multiple Items need to be included in the feed.
OrderFulfillmentFeedAggregate	String	False	An aggregate representing the feed. Can be in the form of XML, JSON, or a #TEMP table.

Result Set Columns

Name	Type	Description
FeedSubmissionId	String	A unique identifier for the feed submission.
FeedType	String	The type of feed submitted.
SubmittedDate	Datetime	The date and time when the feed was submitted.
FeedProcessingStatus	String	The processing status of the feed submission.

The Override feed allows you to set an exception to your account-level shipping settings for an individual product (SKU).

Execute

The stored procedure accepts two aggregated formats: #TEMP tables and XML aggregate

For #TEMP tables

You must include in your query:

INSERT INTO ShippingOverrideAggregate#TEMP (ShipOption, IsShippingRestricted) VALUES ('Std JP Kanto8', 'true')

INSERT INTO ShippingOverrideAggregate#TEMP (ShipOption, Type, ShipAmount, ShipAmountCurrency) VALUES ('Std JP Kantoa8', 'Exclusive', '400.0', 'JPY')

INSERT INTO OverrideFeedAggregate#TEMP (SKU, OperationType, ShippingOverrideAggregate) VALUES ('15700', 'Update', 'ShippingOverrideAggregate#TEMP')

Then you execute the procedure by specifying the value of OverrideFeedAggregate with the name of #TEMP table used OverrideFeedAggregate#TEMP.

EXEC SubmitOverrideFeed OverrideFeedAggregate = 'OverrideFeedAggregate#TEMP'

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

For XML aggregate

The XML aggregate must follow the API structure (https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_4_1/Override.xsd):

    <Message>
        <MessageID>1</MessageID>
        <OperationType>Update</OperationType>
        <Override>
          <SKU>15700</SKU>
          <ShippingOverride>
            <ShipOption>Std JP Kanto8</ShipOption>
            <IsShippingRestricted>true</IsShippingRestricted>
          </ShippingOverride>
          <ShippingOverride>
            <ShipOption>Std JP Kantoa8</ShipOption>
            <Type>Exclusive</Type>
            <ShipAmount currency="JPY">400.0</ShipAmount>
          </ShippingOverride>
        </Override>
      </Message>

EXEC SubmitOverrideFeed OverrideFeedAggregate = '...(the above XML)...'

Input

Name	Type	Required	Description
SKU	String	False	Required. Used to identify an individual product. Each product must have a SKU, and each SKU must be unique.
OperationType	String	False	Required. Used to specify the type of operation (Update or Delete) to be performed on the data.
ShipOption	String	False	Locale and shipping service.
IsShippingRestricted	Boolean	False	Indicates whether the SKU can or cannot be shipped to the specified locale using the specified shipping service (ShipOption).
Type	String	False	The type of override shipping charge (Additive or Exclusive) being applied to the SKU.
ShipAmount	Decimal	False	The Additive or Exclusive shipping charge amount.
ShipAmountCurrency	Decimal	False	The currency used for the ShipAmount.
ShippingOverrideAggregate	String	False	An aggregate representing the the shipping override. Can be in the form of XML or a #TEMP table. Use this field if multiple Shipping Overrides are needed.
OverrideFeedAggregate	String	False	An aggregate representing the feed. Can be in the form of XML or a #TEMP table.

Result Set Columns

Name	Type	Description
FeedSubmissionId	String	A unique identifier for the feed submission.
FeedType	String	The type of feed submitted.
SubmittedDate	Datetime	The date and time when the feed was submitted.
FeedProcessingStatus	String	The processing status of the feed submission.

The Price feed allows you to set the current price and sale price (when applicable) for an item.

Execute

The stored procedure accepts two aggregated formats: #TEMP tables and XML aggregate

For #TEMP tables

You must include in your query:

INSERT INTO PriceFeedAggregate#TEMP (SKU, StandardPrice, StandardPriceCurrency, MAP, MAPCurrency, SalePrice, SalePriceCurrency, SaleStartDate, SaleEndDate) VALUES ('15700', '134', 'JPY', '100', 'JPY', '150', 'JPY', '2017-02-01T00:00:00Z', '2020-02-01T00:00:00Z')

INSERT INTO PriceFeedAggregate#TEMP (SKU, StandardPrice, StandardPriceCurrency, MAP, MAPCurrency, SalePrice, SalePriceCurrency, SaleStartDate, SaleEndDate) VALUES ('99987867', '134', 'JPY', '100', 'JPY', '150', 'JPY', '2017-02-01T00:00:00Z', '2020-02-01T00:00:00Z')

Then you execute the procedure by specifying the value of PriceFeedAggregate with the name of #TEMP table used PriceFeedAggregate#TEMP.

EXEC SubmitPriceFeed PriceFeedAggregate = 'PriceFeedAggregate#TEMP'

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

For XML aggregate

The XML aggregate must follow the API structure (https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_4_1/Price.xsd):

    <Message>
        <MessageID>1</MessageID>
        <Price>
          <SKU>15700</SKU>
          <StandardPrice currency="JPY">134</StandardPrice>
          <MAP currency="JPY">100</MAP>
          <Sale>
            <StartDate>2017-02-01T00:00:00Z</StartDate>
            <EndDate>2020-02-01T00:00:00Z</EndDate>
            <SalePrice currency="JPY">150</SalePrice>
          </Sale>
        </Price>
      </Message>
      <Message>
        <MessageID>2</MessageID>
        <Price>
          <SKU>99987867</SKU>
          <StandardPrice currency="JPY">134</StandardPrice>
          <MAP currency="JPY">100</MAP>
          <Sale>
            <StartDate>2017-02-01T00:00:00Z</StartDate>
            <EndDate>2020-02-01T00:00:00Z</EndDate>
            <SalePrice currency="JPY">150</SalePrice>
          </Sale>
        </Price>
      </Message>

EXEC SubmitPriceFeed PriceFeedAggregate = '...(the above XML)...'

Input

Name	Type	Required	Description
SKU	String	False	Required. Used to identify an individual product. Each product must have a SKU, and each SKU must be unique.
OperationType	String	False	Required. Used to specify the type of operation (Update or Delete) to be performed on the data.
StandardPrice	Double	False	Required. Price of the item (non-sale price).
StandardPriceCurrency	String	False	Required. The currency for the Standard Price.
MAP	String	False	Minimum Advertised Price. Use only if dictated by the manufacturer. Both the standard and sale price (if applicable) must be higher than the MAP value.
MAPCurrency	String	False	Minimum Advertised Price. Use only if dictated by the manufacturer. Both the standard and sale price (if applicable) must be higher than the MAP value.
SalePrice	Double	False	The price of the sale.
SalePriceCurrency	String	False	The currency of the sale.
SaleStartDate	Datetime	False	The starting date of the sale.
SaleEndDate	Datetime	False	The ending date of the sale.
PriceFeedAggregate	String	False	An aggregate representing the feed. Can be in the form of XML or a #TEMP table.

Result Set Columns

Name	Type	Description
FeedSubmissionId	String	A unique identifier for the feed submission.
FeedType	String	The type of feed submitted.
SubmittedDate	Datetime	The date and time when the feed was submitted.
FeedProcessingStatus	String	The processing status of the feed submission.

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.

Execute

The Driver Uses #TEMP tables as fields for aggregate information entered.

SubmitProductFeed Has Two main aggregates that need to be entered.

• ProductDescriptionDataAggregate
• ProductDataAggregate

You must include in your query :

ProductDescriptionDataAggregate information needs to be entered using ProductDescriptionDataAggregate#TEMP temp table.

INSERT INTO ProductDescriptionDataAggregate#TEMP (Title, Brand, Description, BulletPoint, Manufacturer) VALUES ('test Title', 'test Brand', 'test Description', 'test BulletPoint', 'test Manufacturer')

ProductDataAggregate info varies by the Category used. The List of all XSD provided by amazon can be found here https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_1_9/Product.xsd

This example will be using the Sports category https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_1_9/Sports.xsd

To add a valid ProductData Sports.xsd must be followed thoroughly and the xml aggregate must be created correctly. This example has the following product Data

• ProductType = SportingGoods
• Parentage = Parent
• VariationTheme = Size (Based on the ProductType selected some of the VariationTheme will be invalid. In these example the Design variation is invalid.)
• Size = S
• MaterialComposition = Metal

By following the order of Sports.xsd XSD file the aggregate is :

<Sports>
	<ProductType>SportingGoods</ProductType>
	<VariationData>
		<Parentage>parent</Parentage>
		<VariationTheme>Size</VariationTheme>
		<Size>S</Size>
	</VariationData>
	<MaterialComposition>Metal</MaterialComposition>
</Sports>

This Aggregate is the value of ProductDataAggregate.

INSERT INTO ProductFeedAggregate#TEMP (SKU, ProductDescriptionDataAggregate, ProductDataAggregate) VALUES ('test SKU', 'ProductDescriptionDataAggregate#TEMP', '<Sports>
	<ProductType>SportingGoods</ProductType>
	<VariationData>
		<Parentage>parent</Parentage>
		<VariationTheme>Size</VariationTheme>
		<Size>S</Size>
	</VariationData>
	<MaterialComposition>Metal</MaterialComposition>
</Sports>')

Then you execute the procedure by specifying the value of ProductFeedAggregate with the name of #TEMP table used ProductFeedAggregate#TEMP.

EXEC SubmitProductFeed ProductFeedAggregate = 'ProductFeedAggregate#TEMP'

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

Input

Name	Type	Required	Description
SKU	String	True	Required. Used to identify an individual product. Each product must have a SKU, and each SKU must be unique.
OperationType	String	True	Required. Used to specify the type of operation (Update, Delete or PartialUpdate) to be performed on the data.
StandardProductID	String	False	A standard, unique identifier for a product, consisting of a type (ISBN, UPC, or EAN) and a value that conforms to the appropriate format for the type specified. This is a required field if Type is provided for StandardProductID in the base XSD.
ProductTaxCode	String	False	Amazon's standard code to identify the tax properties for a product.
LaunchDate	Datetime	False	Controls when the product appears from searches and browsing on the Amazon website.
DiscontinueDate	Datetime	False	Controls when the product disappears from searches and browsing on the Amazon website.
ReleaseDate	Datetime	False	The date a product is released for sale.
Condition	String	False	The condition of the item.
Rebate	String	False	The rebate of the product.
ItemPackageQuantity	Integer	False	Number of the same product contained within one package. For example, if you are selling a case of 10 packages of socks, ItemPackageQuantity would be 10.
NumberOfItems	Integer	False	Number of discrete items included in the product you are offering for sale, such that each item is not packaged for individual sale. For example, if you are selling a case of 10 packages of socks, and each package contains 3 pairs of socks, NumberOfItems would be 30.
Title	String	True	Required. Short description of the product.
Brand	String	False	Brand of the product.
Designer	String	False	Designer of the product.
Description	String	False	Long Description of the product.
BulletPoint	String	False	Brief descriptions of the product's features.
PackageDimensionsLength	String	False	Calculated dimensions of the package.
PackageDimensionsWidth	String	False	Calculated dimensions of the package.
PackageDimensionsHeight	String	False	Calculated dimensions of the package.
PackageDimensionsWeight	String	False	Calculated dimensions of the package.
ItemDimensionsLength	String	False	Calculated dimensions of the item.
ItemDimensionsWidth	String	False	Calculated dimensions of the item.
ItemDimensionsHeight	String	False	Calculated dimensions of the item.
ItemDimensionsWeight	String	False	Calculated dimensions of the item.
PackageWeight	String	False	Weight of the package
ShippingWeight	String	False	Weight of the product when packaged to ship.
MerchantCatalogNumber	String	False	Seller's catalog number for the product, if different from the SKU.
MSRP	Double	False	Manufacturer's suggested retail price.
MaxOrderQuantity	Integer	False	Maximum quantity of the product that a customer can order.
SerialNumberRequired	Boolean	False	Indicates whether the product must have a serial number.
Prop65	Boolean	False	Used if the product is subject to prop 65 regulations in California. US only.
LegalDisclaimer	String	False	Any legal disclaimer needed for the product.
Manufacturer	String	False	Maker of the product.
MfrPartNumber	String	False	Part number provided by the original manufacturer.
SearchTerms	String	False	Terms you submit that give product search results.
PlatinumKeywords	String	False	Values used to map products to nodes in a custom browse structure.
RecommendedBrowseNode	String	False	Value used to classify an item.
Memorabilia	Boolean	False	Used if the product is a memorabilia item.
Autographed	Boolean	False	Used if the product is an autographed item.
UsedFor	String	False	What the product is used for (affects the product's placement in the Amazon browse structure).
ItemType	String	False	Pre-defined value that specifies where the product should appear within the Amazon browse structure.
OtherItemAttributes	String	False	Used to further classify the product within the Amazon browse structure.
TargetAudience	String	False	Used to further classify the product within the Amazon browse structure.
SubjectContent	String	False	Used to relate the product to a specific idea or concept for merchandising.
IsGiftWrapAvailable	Boolean	False	Indicates whether gift wrapping is available for the product.
IsGiftMessageAvailable	Boolean	False	Indicates whether gift messaging is available for the product.
IsDiscontinuedByManufacturer	Boolean	False	Indicates that the manufacturer has stopped making the item.
MaxAggregateShipQuantity	Integer	False	The maximum number of the same item that can be shipped in the same package.
ProductDescriptionDataAggregate	String	False	Section containing category-specific information such as variations. Can be in the form of XML or a #TEMP table.
ProductDataAggregate	String	False	Section containing category-specific information such as variations. Can be in the form of XML or a #TEMP table.
ProductFeedAggregate	String	False	An aggregate representing the feed. Can be in the form of XML or a #TEMP table.

Result Set Columns

Name	Type	Description
FeedSubmissionId	String	A unique identifier for the feed submission.
FeedType	String	The type of feed submitted.
SubmittedDate	Datetime	The date and time when the feed was submitted.
FeedProcessingStatus	String	The processing status of the feed submission.

The Relationship feed allows you to set up optional relationships between items in your catalog.

Execute

The stored procedure accepts two aggregated formats: #TEMP tables and XML aggregate

For #TEMP tables

You must include in your query:

INSERT INTO RelationAggregate#TEMP (Type, SKU) VALUES ('Variation', '99987867')

INSERT INTO RelationAggregate#TEMP (Type, SKU) VALUES ('Variation', '99987867')

INSERT INTO RelationshipFeedAggregate#TEMP (ParentSKU, RelationAggregate) VALUES ('15700', 'RelationAggregate#TEMP')

Then you execute the procedure by specifying the value of RelationshipFeedAggregate with the name of #TEMP table used RelationshipFeedAggregate#TEMP.

EXEC SubmitRelationshipFeed RelationshipFeedAggregate = 'RelationshipFeedAggregate#TEMP'

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

For XML aggregate

The XML aggregate must follow the API structure (https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_4_1/Relationship.xsd):

    <Message>
        <MessageID>1</MessageID>
        <Relationship>
          <ParentSKU>15700</ParentSKU>
          <Relation>
            <SKU>99987867</SKU>
            <Type>Variation</Type>
          </Relation>
          <Relation>
            <SKU>99987867</SKU>
            <Type>Variation</Type>
          </Relation>
        </Relationship>
      </Message>

EXEC SubmitRelationshipFeed RelationshipFeedAggregate = '...(the above XML)...'

Input

Name	Type	Required	Description
ParentSKU	String	False	Required. The master SKU for a product with variations.
OperationType	String	False	Required. Used to specify the type of operation (Update or Delete) to be performed on the data.
Type	String	False	Type of relationship; currently supported are Variation or Accessory.
SKU	String	False	Used to identify an individual product, one (child) variation of the parent SKU.
RelationAggregate	String	False	An aggregate representing the the relation. Can be in the form of XML, JSON or a #TEMP table. Use this field when applying multiple relations
RelationshipFeedAggregate	String	False	An aggregate representing the feed. Can be in the form of XML or #TEMP table.

Result Set Columns

Name	Type	Description
FeedSubmissionId	String	A unique identifier for the feed submission.
FeedType	String	The type of feed submitted.
SubmittedDate	Datetime	The date and time when the feed was submitted.
FeedProcessingStatus	String	The processing status of the feed submission.

Usage information for the operation SubmitSourcingOnDemandFeed.rsb.

Execute

The stored procedure accepts two aggregated formats: #TEMP tables and XML aggregate

For #TEMP tables

You must include in your query:

INSERT INTO OrderSourcingOnDemandFeedAggregate#TEMP (AmazonOrderID, SKU, EstimatedShipDate) VALUES ('250-4747727-9303810', '15700', '2018-12-08T00:00:00Z');

Then you execute the procedure by specifying the value of OrderSourcingOnDemandFeedAggregate with the name of #TEMP table used OrderSourcingOnDemandFeedAggregate#TEMP.

EXEC SubmitSourcingOnDemandFeed OrderSourcingOnDemandFeedAggregate = 'OrderSourcingOnDemandFeedAggregate#TEMP'

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

For XML aggregate

The XML aggregate must follow the API structure (https://m.media-amazon.com/images/G/01/rainier/help/xsd/release_4_1/OrderSourcingOnDemand._CB475945388_.xsd):

    <Message>
        <MessageID>1</MessageID>
        <OrderSourcingOnDemand>
            <AmazonOrderID>250-4747727-9303810</AmazonOrderID>
            <SKU>15700</SKU>
            <EstimatedShipDate>2018-12-08T00:00:00Z</EstimatedShipDate>
        </OrderSourcingOnDemand>
      </Message>

EXEC SubmitSourcingOnDemandFeed OrderSourcingOnDemandFeedAggregate = '...(the above XML)...'

Input

Name	Type	Required	Description
AmazonOrderID	String	False	Amazon Order ID.
SKU	String	True	Required. Used to identify an individual product. Each product must have a SKU, and each SKU must be unique.
EstimatedShipDate	Datetime	True	Required. Estimated ship date.
OrderSourcingOnDemandFeedAggregate	String	False	An aggregate representing the feed. Can be in the form of XML or a #TEMP table.

Result Set Columns

Name	Type	Description
FeedSubmissionId	String	A unique identifier for the feed submission.
FeedType	String	The type of feed submitted.
SubmittedDate	Datetime	The date and time when the feed was submitted.
FeedProcessingStatus	String	The processing status of the feed submission.

The CData Cloud models the Selling Partner API as relational views, and stored procedures.

To use Amazon Selling Partner Data Model, simply set Schema to SellingPartner.

Views

Views are tables that cannot be modified, such as Orders, Products. Typically, data that are read-only and cannot be updated are shown as views.

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

Using Reports

For each report type there is a view exposed. For example, report type FEE_DISCOUNTS_REPORT will be exposed as a view named REPORT_FEE_DISCOUNTS_REPORT. These views can then be queried by using 'DataStartTime' and 'DataEndTime' optional datetime parameters. When both datetime parameters are specified, the driver automatically searches for an existing report that matches the specified interval, and if not found a new report is created. Reports can be manually created with the RequestReport stored procedure. You can also use ReportOptions JSON-aggregate pseudo-column to specify additional fields that may be required depending on report type. For more details about report options please check Amazon Selling-Partner API Documentation

After a report has been created and pushed to the result set, the next time you query this report type with the 'DataStartTime' and 'DataEndTime' same filters, the previously created report is downloaded instead of creating a new report.

The Cloud models the data in Amazon Marketplace as a list of tables in a relational database that can be queried using standard SQL statements.

CData Cloud - Amazon Marketplace Tables

Name	Description
Destinations	Returns information about all destinations.
InboundShipments	Returns a list of inbound shipments based on criteria that you specify.
InboundShipmentTransportDetails	Inbound shipment information, including carrier details, shipment status, and the workflow status for a request for shipment with an Amazon-partnered carrier.
ListingsItems	Returns details about a listings item for a selling partner.
ListingsItemsAttributes	The GetFeedSubmissionList operation returns a list of feed submissions.
OutboundFulfillmentOrders	Returns a list of fulfillment orders fulfilled after (or at) a specified date-time, or indicated by the next token parameter.
Subscriptions	Returns information about subscriptions of the specified notification type.
VendorShippingLabels	This table is part of Vendor Direct Fulfillment Shipping API. Returns a list of shipping labels created during the time frame that you specify. You define that time frame using the createdAfter and createdBefore parameters. The date range to search must not be more than 7 days.

Returns information about all destinations.

Columns

Name	Type	ReadOnly	References	Description
DestinationId [KEY]	String	False		The destination identifier generated when you created the destination.
Name	String	False		The developer-defined name for this destination.
ResourceSqsArn	String	False		The Amazon Resource Name (ARN) associated with the SQS queue (Amazon Simple Queue Service queue destination).
ResourceEventBridgeName	String	False		The name of the partner event source associated with the destination (Amazon EventBridge destination).
ResourceEventBridgeRegion	String	False		The AWS region in which you will be receiving the notifications (Amazon EventBridge destination).
ResourceEventBridgeAccountId	String	False		The identifier for the AWS account that is responsible for charges related to receiving notifications (Amazon EventBridge destination).

Returns a list of inbound shipments based on criteria that you specify.

Select

The Cloud will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• ShipmentId supports the '=' and 'IN' comparisons.
• ShipmentStatus supports the '='and 'IN' comparisons.
• MarketplaceId supports the '=' comparison.
• LastUpdatedDate supports the '=', '<', '>', '<=', '>=' comparisons.

For example, the following query is processed server side:

SELECT * FROM InboundShipments WHERE ShipmentStatus = 'Working'

SELECT * FROM InboundShipments WHERE ShipmentStatus IN ('Working', 'SHIPPED', 'IN_TRANSIT')

SELECT * FROM InboundShipments WHERE ShipmentId = '503-9993250-1405404'

SELECT * FROM InboundShipments WHERE MarketplaceId = 'ATVPDKIKX0DER'

SELECT * FROM InboundShipments WHERE LastUpdatedDate >= '2016-12-12'

Columns

Name	Type	ReadOnly	References	Description
ShipmentId [KEY]	String	False		The ID of the shipment.
ShipmentStatus	String	False		The status of your inbound shipment.
ShipmentName	String	False		The unique name of the inbound shipment.
ShipFromPostalCode	String	False		The PostalCode of the return address.
ShipFromName	String	False		The Name of the return address.
ShipFromCountryCode	String	False		The CountryCode of the return address.
ShipFromDistrictOrCounty	String	False		The district or county of the return address.
ShipFromStateOrProvinceCode	String	False		The State Or Province Code of the return address.
ShipFromAddressLine1	String	False		The street address information of the return address.
ShipFromAddressLine2	String	False		Additional street address information of the return address.
ShipFromCity	String	False		The City of the return address.
LabelPrepType	String	False		The type of label preparation.
AreCasesRequired	Boolean	False		Boolean that indicates whether or not an inbound shipment contains case-packed boxes.
DestinationFulfillmentCenterId	String	False		The Amazon fulfillment center identifier created by Amazon.
ConfirmedNeedByDate	Date	False		Date that the shipment must arrive at an Amazon fulfillment center for pre-ordered items.
MarketplaceId	String	False		Marketplace identifier for the report.
BoxContentsSource	String	False		Where the seller provided box contents information for a shipment.
EstimatedBoxContentsFeeTotalUnits	Int	False		The number of units to ship for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsFeePerUnitCurrencyCode	String	False		The currency code for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsFeePerUnitValue	Decimal	False		The manual processing fee per unit for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsTotalFeeCurrencyCode	String	False		The Total fee currency code for an estimate of the manual processing fee charged by Amazon for boxes without box content information.
EstimatedBoxContentsTotalFeeValue	Decimal	False		The Total fee value for an estimate of the manual processing fee charged by Amazon for boxes without box content information.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
LastUpdatedDate	Datetime	A date used for selecting inbound shipments that were last updated before/after a specified time.
InboundShipmentItemList	String	A list of inbound shipment item information.

Inbound shipment information, including carrier details, shipment status, and the workflow status for a request for shipment with an Amazon-partnered carrier.

Columns

Name	Type	ReadOnly	References	Description
ShipmentId [KEY]	String	True		A shipment identifier originally returned by the createInboundShipmentPlan operation.
PartneredSmallParcelData	String	False		Information that is required by an Amazon-partnered carrier to ship a Small Parcel inbound shipment.
NonPartneredSmallParcelData	String	False		Information that you provide to Amazon about a Small Parcel shipment shipped by a carrier that has not partnered with Amazon.
PartneredLtlData	String	False		Information that is required by an Amazon-partnered carrier to ship a Less Than Truckload/Full Truckload (LTL/FTL) inbound shipment.
NonPartneredLtlData	String	False		Information that you provide to Amazon about a Less Than Truckload/Full Truckload (LTL/FTL) shipment by a carrier that has not partnered with Amazon.
IsPartnered	Boolean	False		Indicates whether a putTransportDetails request is for a partnered carrier.
SellerId	String	False		The Amazon seller identifier.
ShipmentType	String	False		Specifies the carrier shipment type in a putTransportDetails request.
ErrorCode	String	False		An error code that identifies the type of error that occured.
ErrorDescription	String	False		A message that describes the error condition.
TransportStatus	String	False		Indicates the status of the Amazon-partnered carrier shipment.

Returns details about a listings item for a selling partner.

The following filters are required:

• SKU
• SellerId: You can either specify SellerId as a pseudo-column condition in WHERE filters, or in the connection string.

Some example queries:

SELECT * FROM ListingsItems WHERE SKU = '12345' AND SellerId = 'XXXXXXXXXXXXXX'

INSERT INTO ListingsItems (ProductType, Requirements, Attributes, SKU, SellerId)
VALUES ('product_type', 'LISTING', '{\"AttributeName\": \"test_attribute\", \"AttributeValue\": \"value\"}', '12345', 'XXXXXXXXXXXXXX')

DELETE FROM ListingsItems WHERE SKU = '12345' AND SellerId = 'XXXXXXXXXXXXXX'

When inserting, you can also use temp tables in order to insert multiple attributes, as shown in the example below:

INSERT INTO Attributes#TEMP (AttributeName, AttributeValue) VALUES ('attr1', 'val1')
INSERT INTO Attributes#TEMP (AttributeName, AttributeValue) VALUES ('attr2', 'val2')
INSERT INTO Attributes#TEMP (AttributeName, AttributeValue) VALUES ('attr3', 'val3')

INSERT INTO ListingsItems (ProductType, Requirements, Attributes, SKU, SellerId)
VALUES ('product_type', 'LISTING', 'Attributes#TEMP', '12345', 'XXXXXXXXXXXXXX')

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

Columns

Name	Type	ReadOnly	References	Description
SKU [KEY]	String	True		A selling partner provided identifier for an Amazon listing.
FulfillmentAvailability	String	False		Fulfillment availability for the listings item.
ProcurementCostCurrency	String	True		The price (ISO4217 currency code) that you want Amazon to pay you for this product.
ProcurementCostAmount	String	True		The price (numeric value) that you want Amazon to pay you for this product.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
Attributes	String	This field is required for INSERT statements. Aggregate field containing structured 'AttributeName' and 'AttributeValue' fields.
SellerId	String	A selling partner identifier, such as a merchant account or vendor code.
Requirements	String	This field can be specified for INSERT statements. The allowed values are LISTING, LISTING_PRODUCT_ONLY, LISTING_OFFER_ONLY.
ProductType	String	This field is required for INSERT statements.

The GetFeedSubmissionList operation returns a list of feed submissions.

The following filters are required:

• SKU
• SellerId: You can either specify SellerId as a pseudo-column condition in WHERE filters, or in the connection string.

Some example queries:

SELECT * FROM ListingsItemsAttributes WHERE SKU = '12345' AND SellerId = 'XXXXXXXXXXXXXX'
UPDATE ListingsItemsAttributes SET AttributeValue = 'test_value', ProductType = 'LUGGAGE'
       WHERE SKU = '12345' AND AttributeName = 'item_name_value'

You can also retrieve all SKU fields from another sub-query, for example:

SELECT * FROM ListingsItems WHERE SellerId = 'XXXXXXXXXXXXXX' AND SKU IN (
        SELECT DISTINCT(SKUIdentifierSellerSKU) FROM CatalogItems WHERE MarketplaceId = 'XXXXXXXXXXXXXX' AND Query = 'test' AND SkuIdentifierSellerSku IS NOT NULL
)

Columns

Name	Type	ReadOnly	References	Description
SKU [KEY]	String	True		A selling partner provided identifier for an Amazon listing.
AttributeName [KEY]	String	False		The attribute name for the listings item.
AttributeValue	String	False		The attribute value for the listings item.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
ProductType	String	The Amazon product type of the listings item. Required for Updating an attribute.
SellerId	String	A selling partner identifier, such as a merchant account or vendor code.

Returns a list of fulfillment orders fulfilled after (or at) a specified date-time, or indicated by the next token parameter.

Columns

Name	Type	ReadOnly	References	Description
SellerFulfillmentOrderId [KEY]	String	False		The fulfillment order identifier.
DisplayableOrderId	String	False		A fulfillment order identifier submitted when creating a fulfillment order. Displays as the order identifier in recipient-facing materials such as the packing slip.
DisplayableOrderComment	String	False		A text block submitted when creating a fulfillment order. Displays in recipient-facing materials such as the packing slip.
DisplayableOrderDate	Datetime	False		A date and time submitted when creating a fulfillment order. Displays as the order date in recipient-facing materials such as the packing slip.
FeatureConstraints	String	False		A list of features and their fulfillment policies to apply to the order.
FulfillmentAction	String	False		Specifies whether the fulfillment order should ship now or have an order hold put on it.
FulfillmentOrderStatus	String	False		The current status of the fulfillment order.
FulfillmentPolicy	String	False		The FulfillmentPolicy value specified when creating a fulfillment order.
ReceivedDate	Datetime	False		The date and time that the fulfillment order was received by an Amazon fulfillment center.
ShippingSpeedCategory	String	False		The shipping method used for the fulfillment order.
StatusUpdatedDate	Datetime	False		The date and time that the status of the fulfillment order last changed, in ISO 8601 date time format.
AddressLine1	String	False		The first line of the address.
AddressLine2	String	False		Additional address information.
AddressLine3	String	False		Additional address information.
City	String	False		The city where the person, business, or institution is located. This property is required in all countries except Japan. It should not be used in Japan.
CountryCode	String	False		The two digit country code. In ISO 3166-1 alpha-2 format.
DistrictOrCounty	String	False		The district or county where the person, business, or institution is located.
AddressName	String	False		The name of the person, business or institution at the address.
PostalCode	String	False		The postal code of the address.
StateOrRegion	String	False		The state or region where the person, business or institution is located.
Phone	String	False		The phone number of the person, business, or institution located at the address.
ReturnAuthorizations	String	False		A JSON object of return authorization information.
ReturnItems	String	False		A JSON object of items that Amazon accepted for return. Returns empty if no items were accepted for return.
FulfillmentShipments	String	False		A JSON object of fulfillment shipment information.
FulfillmentOrderItems	String	False		A JSON object of fulfillment order item information.
MarketplaceId	String	False		The marketplace identifier.
QueryStartDate	String	False		A date used to select fulfillment orders that were last updated after (or at) a specified time. An update is defined as any change in fulfillment order status, including the creation of a new fulfillment order.

Returns information about subscriptions of the specified notification type.

Columns

Name	Type	ReadOnly	References	Description
SubscriptionId [KEY]	String	False		The subscription identifier generated when the subscription is created.
NotificationType [KEY]	String	False		The type of notification. The allowed values are ACCOUNT_STATUS_CHANGED, ANY_OFFER_CHANGED, B2B_ANY_OFFER_CHANGED, BRANDED_ITEM_CONTENT_CHANGE, FBA_INVENTORY_AVAILABILITY_CHANGES, FBA_OUTBOUND_SHIPMENT_STATUS, FEE_PROMOTION, FEED_PROCESSING_FINISHED, FULFILLMENT_ORDER_STATUS, ITEM_PRODUCT_TYPE_CHANGE, LISTINGS_ITEM_STATUS_CHANGE, LISTINGS_ITEM_ISSUES_CHANGE, ORDER_STATUS_CHANGE, PRICING_HEALTH, PRODUCT_TYPE_DEFINITIONS_CHANGE, REPORT_PROCESSING_FINISHED.
PayloadVersion	String	False		The version of the payload object to be used in the notification.
DestinationId	String	False		The identifier for the destination where notifications will be delivered.
MarketplaceIds	String	False		A list of marketplace identifiers to subscribe to (e.g. ATVPDKIKX0DER). To receive notifications in every marketplace, do not provide this list.
AggregationTimePeriod	String	False		The supported time period to use to perform marketplace-ASIN level aggregation. The allowed values are FiveMinutes, TenMinutes.
EventFilterType	String	False		An eventFilterType value that is supported by the specific notificationType. This is used by the subscription service to determine the type of event filter.

This table is part of Vendor Direct Fulfillment Shipping API. Returns a list of shipping labels created during the time frame that you specify. You define that time frame using the createdAfter and createdBefore parameters. The date range to search must not be more than 7 days.

Select

The following fields are filtered server-side:

• PurchaseOrderNumber supports the '=' comparison
• CreatedDate supports all the >, >=, =, <=, < comparisons

Some example queries:

SELECT * FROM VendorShippingLabels WHERE PurchaseOrderNumber = '12345'

SELECT * FROM VendorShippingLabels WHERE CreatedDate > '2022-09-10T12:00:00' AND CreatedDate < '2022-09-15T12:00:00'

INSERT

When inserting, you can also use temp tables in order to insert fields for aggregate objects, as shown in the example below:

INSERT INTO Items#TEMP (ItemSequenceNumber, BuyerProductIdentifier, VendorProductIdentifier, Amount, UnitOfMeasure) 
                VALUES (                 1,              'item_id',               'prod_id',     10,        'unit');

INSERT INTO Container#TEMP (ContainerType, ContainerIdentifier, TrackingNumber,  PackedItems) 
                    VALUES (     'carton',      'container_id',       'string', 'Items#TEMP');

INSERT INTO Address1#TEMP (  Name,     AddressLine1,          City,           County, CountryCode)
                  VALUES ('Name', 'Fayettville NC', 'Fayettville', 'North Carolina',        'NC');

INSERT INTO TaxTest#TEMP (RegistrationType, RegistrationNumber, RegistrationMessages, RegistrationAddress) 
                  VALUES (           'VAT',           'string',             'string',    'Address1#TEMP');

INSERT INTO VendorShippingLabels (PurchaseOrderNumber, SellingPartyPartyId,  SellingPartyTaxRegistrationDetails, ShipFromPartyPartyId,       Containers)
                          VALUES ('1234567890',                    '11111',                      'TaxTest#TEMP',              '22222', 'Container#TEMP');

In order to get the Transaction ID returned from the API for the INSERT statement, you can issue a select statement from the LastResultInfo temp table, as shown below:

SELECT * FROM LastResultInfo#TEMP 

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

Container temporary table schema info:

Column Name	Type	Required	Description
ContainerType	String	True	The type of container.
ContainerIdentifier	String	True	The container identifier.
TrackingNumber	String	False	The tracking number.
ContainerSequenceNumber	Integer	False	An integer that must be submitted for multi-box shipments only, where one item may come in separate packages.
ManifestId	String	False	The manifest identifier.
ManifestDate	String	False	The date of the manifest.
ShipMethod	String	False	The shipment method.
ScacCode	String	False	SCAC code required for NA VOC vendors only.
Carrier	String	False	Carrier required for EU VOC vendors only.
Length	String	False	Physical dimensional measurements of a container.
Width	String	False	Physical dimensional measurements of a container.
Height	String	False	Physical dimensional measurements of a container.
DimensionUnit	String	False	Physical dimensional measurements of a container.
Value	String	False	The weight.
WeightUnit	String	False	The weight.
PackedItems	Aggregate	True	A list of packed items. See: PackedItems table schema.

PackedItems temporary table schema info:

Column Name	Type	Required	Description
ItemSequenceNumber	Integer	True	Item Sequence Number for the item. This must be the same value as sent in the order for a given item.
BuyerProductIdentifier	String	False	Buyer's Standard Identification Number (ASIN) of an item. Either buyerProductIdentifier or vendorProductIdentifier is required.
VendorProductIdentifier	String	False	The vendor selected product identification of the item. Should be the same as was sent in the Purchase Order, like SKU Number.
Amount	Decimal	True	Quantity of units shipped for a specific item at a shipment level. If the item is present only in certain packages or pallets within the shipment, please provide this at the appropriate package or pallet level.
UnitOfMeasure	String	True	Unit of measure for the shipped quantity.

TaxRegistrationDetails temporary table schema info:

Column Name	Type	Required	Description
RegistrationType	String	True	Tax registration type for the entity. Allowed Values: VAT, GST.
RegistrationNumber	String	True	Tax registration number for the party. For example, VAT ID.
RegistrationMessages	String	False	Tax registration message that can be used for additional tax related details
RegistrationAddress	Aggregate	False	Address of the party. See: AddressDetails table schema.

Address temporary table schema info:

Column Name	Type	Required	Description
Name	String	True	The name of the person, business or institution at that address.
AddressLine1	String	True	First line of street address.
AddressLine2	String	False	Additional address information, if required.
AddressLine3	String	False	Additional address information, if required.
City	String	False	The city where the person, business or institution is located.
County	String	False	The county where person, business or institution is located.
District	String	False	The district where person, business or institution is located.
StateOrRegion	String	False	The state or region where person, business or institution is located.
PostalOrZipCode	String	False	The postal or zip code of that address. It contains a series of letters or digits or both, sometimes including spaces or punctuation.
CountryCode	String	True	The two digit country code. In ISO 3166-1 alpha-2 format.
Phone	String	False	The phone number of the person, business or institution located at that address.

Columns

Name	Type	ReadOnly	References	Description
PurchaseOrderNumber [KEY]	String	False
LabelFormat	String	True		The allowed values are PNG, ZPL.
LabelData	String	True
SellingPartyPartyId	String	False
SellingPartyAddressLine1	String	False
SellingPartyAddressLine2	String	False
SellingPartyAddressLine3	String	False
SellingPartyAddressCity	String	False
SellingPartyAddressCountryCode	String	False
SellingPartyAddressCounty	String	False
SellingPartyAddressDistrict	String	False
SellingPartyAddressName	String	False
SellingPartyAddressPhone	String	False
SellingPartyAddressPostalCode	String	False
SellingPartyAddressStateOrRegion	String	False
SellingPartyTaxRegistrationDetails	String	False
ShipFromPartyPartyId	String	False
ShipFromPartyAddressLine1	String	False
ShipFromPartyAddressLine2	String	False
ShipFromPartyAddressLine3	String	False
ShipFromPartyAddressCity	String	False
ShipFromPartyAddressCountryCode	String	False
ShipFromPartyAddressCounty	String	False
ShipFromPartyAddressDistrict	String	False
ShipFromPartyAddressName	String	False
ShipFromPartyAddressPhone	String	False
ShipFromPartyAddressPostalCode	String	False
ShipFromPartyAddressStateOrRegion	String	False
ShipFromPartyTaxRegistrationDetails	String	False

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
CreatedDate	String
Containers	String

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Cloud - Amazon Marketplace Views

Name	Description
CatalogItems	The Catalog Items table helps you retrieve item details for items in the catalog.
CompetitivePricing	Returns competitive pricing information for a seller's offer listings based on seller SKU or ASIN.
Feeds	The GetFeedSubmissionList operation returns a list of feed submissions.
FeesEstimate	Returns the estimated fees for the listed products.
InboundItemsGuidance	Returns a list of items in a specified inbound shipment.
InboundPreparationInstructions	Returns labeling requirements and item preparation instructions to help prepare items for shipment to Amazon's fulfillment network.
InboundShipmentItems	Returns a list of items in a specified inbound shipment.
InboundShipmentPreorders	Returns a list of items in a specified inbound shipment.
InventorySupply	Returns information about the availability of inventory that a seller has in Amazon's fulfillment network and in current inbound shipments. You can check the current availability status for your Fulfillment by Amazon inventory as well as discover when availability status changes.
ItemOffers	Returns the lowest priced offers for a single item based on ASIN.
ListingOffers	Generated schema file.
ListingsItemsIssues	The GetFeedSubmissionList operation returns a list of feed submissions.
ListingsItemsOffers	The GetFeedSubmissionList operation returns a list of feed submissions.
ListingsItemsSummaries	The GetFeedSubmissionList operation returns a list of feed submissions.
OrderItems	Returns order items based on the Amazon Order Id that you specify.
OrderMetrics	Returns aggregated order metrics for a given interval, broken down by granularity, for a given buyer type.
Orders	Returns orders created or updated during a time frame that you specify.
OrderScheduleDetailsListInternal	Usage information for the operation OrderScheduleDetailsListInternal.rsd.
OutboundFeatures	Returns a list of features available for Multi-Channel Fulfillment orders in the marketplace you specify, and whether the seller for which you made the call is enrolled for each feature.
OutboundFulfillmentOrderItems	Returns the fulfillment order items indicated by the specified order identifier.
OutboundFulfillmentsPreview	Returns a list of fulfillment order previews based on shipping criteria that you specify.
OutboundPackageTracking	Returns delivery tracking information for a package in an outbound shipment for a Multi-Channel Fulfillment order.
OutboundReturnItems	An array of items that Amazon accepted for return. Returns empty if no items were accepted for return.
OutboundReturnReasons	Returns a list of return reason codes for a seller SKU in a given marketplace.
PackageItemsInternal	Usage information for the operation PackageItemsInternal.rsd.
ProductPricing	Generated schema file.
ReportList	Returns report details for the reports that match the filters that you specify.
ReportTypes	Returns report details for the reports that match the filters that you specify.
ShippingDocuments	Returns the shipping documents associated with a package in a shipment.
ShippingRates	Returns the available shipping service offerings.
ShippingTracking	Returns tracking information for a purchased shipment.
UpdatePackageDetailsListInternal	Usage information for the operation UpdatePackageDetailsListInternal.rsd.
VendorCustomerInvoices	This view is part of Vendor Direct Fulfillment Shipping API. Returns a list of customer invoices created during a time frame that you specify. The date range to search must be no more than 7 days.
VendorOrders	The Selling Partner API for Retail Procurement Orders provides programmatic access to vendor orders data.
VendorPackingSlips	This view is part of Vendor Direct Fulfillment Shipping API. Returns a list of packing slips for the purchase orders that match the criteria specified. Date range to search must not be more than 7 days.

The Catalog Items table helps you retrieve item details for items in the catalog.

The following filters are required:

• MarketplaceId
• One of the following: Query, SellerSKU, UPC, EAN, ISBN, JAN

For example:

SELECT * FROM CatalogItems WHERE MarketplaceID = 'XXXXXXXXXXXXX' AND ISBN = 'XXXXXXXXXXXXX'

Columns

Name	Type	References	Description
MarketplaceASIN [KEY]	String		The Marketplace ASIN.
AdultProduct	Boolean		Identifies an Amazon catalog item is intended for an adult audience or is sexual in nature.
Autographed	Boolean		Identifies an Amazon catalog item is autographed by a player or celebrity.
Brand	String		Name of the brand associated with an Amazon catalog item.
BrowseClassificationClassificationId	String		Classification Id (browse node) associated with an Amazon catalog item.
BrowseClassificationDisplayName	String		Classification Name (browse node) associated with an Amazon catalog item.
Color	String		Name of the color associated with an Amazon catalog item.
ContributorsRole	String		Role of an individual contributor in the creation of an item, such as author or actor.
ContributorsName	String		Name of the contributor.
ItemClassification	String		Classification type associated with the Amazon catalog item.
ItemName	String		Name, or title, associated with an Amazon catalog item.
Manufacturer	String		Name of the manufacturer associated with an Amazon catalog item.
Memorabilia	Boolean		Identifies an Amazon catalog item is memorabilia valued for its connection with historical events, culture, or entertainment.
ModelNumber	String		Model number associated with an Amazon catalog item.
PackageQuantity	Integer		Quantity of an Amazon catalog item in one package.
PartNumber	String		Part number associated with an Amazon catalog item.
ReleaseDate	String		First date on which an Amazon catalog item is shippable to customers.
Size	String		Name of the size associated with an Amazon catalog item.
Style	String		Name of the style associated with an Amazon catalog item.
TradeInEligible	Boolean		Identifies an Amazon catalog item is eligible for trade-in.
WebsiteDisplayGroup	String		Identifier of the website display group associated with an Amazon catalog item.
WebsiteDisplayGroupName	String		Display name of the website display group associated with an Amazon catalog item.
Attributes	String		A JSON object containing structured item attribute data keyed by attribute name. Catalog item attributes conform to the related Amazon product type definitions available in the Selling Partner API for Product Type Definitions.
Dimensions	String		A JSON object of the dimensions for an item in the Amazon catalog.
Identifiers	String		A JSON object of the identifiers associated with the item in the Amazon catalog, such as UPC and EAN identifiers.
Images	String		A JSON object of the images for an item in the Amazon catalog.
ProductTypes	String		A JSON object of the product types associated with the Amazon catalog item.
Relationships	String		A JSON object of the relationship details of an Amazon catalog item (for example, variations).
SalesRankings	String		A JSON object of the sales ranks of an Amazon catalog item.
VendorDetails	String		A JSON object of the vendor details associated with an Amazon catalog item. Vendor details are available to vendors only.
ASIN	String		Amazon Standard Identification Number that identifies a product.
EAN	String		A European Article Number that uniquely identifies the catalog item, manufacturer, and its attributes.
GTIN	String		A Global Trade Item Number that uniquely identifies a product.
ISBN	String		The unique commercial book identifier used to identify books internationally.
JAN	String		A Japanese article number that uniquely identifies the product, manufacturer, and its attributes.
MINSAN	String		A Minsan Code that uniquely identifies an item.
SellerSKU	String		Used to identify an item in the given marketplace. SellerSKU is qualified by the seller's SellerId
UPC	String		A 12-digit bar code used for retail packaging.
IncludedData	String		A comma-delimited list of item details to request. If none are specified, will default to returning summaries data. Values: attributes, dimensions, identifiers, images, productTypes, relationships, salesRanks, summaries, vendorDetails.
Locale	String		Locale for retrieving localized summaries. Defaults to the primary locale of the marketplace.
SellerId	String		A selling partner identifier, such as a seller account or vendor code. Note: Required when setting identifier SellerSKU.
PageSize	String		Number of results to be returned per page.
Query	String		Keyword(s) to use to search for items in the catalog.
BrandNames	String		A comma-delimited list of brand names to limit the search for keywords-based queries. Note: Cannot be used with identifiers.
ClassificationIds	String		A comma-delimited list of classification identifiers to limit the search for keywords-based queries. Note: Cannot be used with identifiers.
KeywordsLocale	String		The language of the keywords provided for keywords-based queries. Defaults to the primary locale of the marketplace. Note: Cannot be used with identifiers.
MarketplaceId	String		Specifies the marketplace for which items are returned.

Returns competitive pricing information for a seller's offer listings based on seller SKU or ASIN.

Columns

Name	Type	References	Description
ASIN [KEY]	String		The value of Amazon Standard Identification Number for the product.
SellerSKU	String		Stock Keeping Unit that identifies a product in the Amazon catalog.
MarketplaceId	String		A marketplace identifier. Specifies the marketplace for which prices are returned.
CompetitivePriceId	String		The competitive price Id of the product.
LandedPriceAmount	Decimal		The landed price amount of the price.
LandedPriceCurrencyCode	String		The landed price currency code of the price.
ListingPriceAmount	Decimal		The listing price amount of the price.
ListingPriceCurrencyCode	String		The listing price currency code of the price.
PointsNumber	Integer		The points number of the price.
PointsMonetaryValueAmount	Decimal		The points monetary value amount of the price.
PointsMonetaryValueCurrencyCode	String		The points monetary value currency code of the price.
ShippingAmount	Decimal		The shipping amount of the buyying price.
ShippingCurrencyCode	String		The shipping currency code of the buyying price.
TradeInValueAmount	Decimal		The trade-in value amount of the buyying price.
TradeInValueCurrencyCode	String		The trade-in value currency code of the buyying price.
ProductCategoryId	String		The product category Id.
Rank	Integer		The value of the sales rankings.
BelongsToRequester	Boolean		The boolean value if the product belongs to the requester.
Condition	String		The condition of the product.
Status	String		The status of the product.
ItemType	String		Required. Indicates whether ASIN values or seller SKU values are used to identify items. The allowed values are Asin, Sku.
CustomerType	String		Indicates whether to request pricing information from the point of view of consumer or business buyers. Default is Consumer. The allowed values are Consumer, Business.

The GetFeedSubmissionList operation returns a list of feed submissions.

Select

The Cloud will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

Note: 'FeedType' attribute is required to query the view. You can view available values for 'FeedType' here.

• FeedId supports the '=' comparison.
• FeedType supports the '=' and 'IN' comparisons.
• MarketplaceIds supports the '=' and 'IN' comparisons.
• ProcessingStatus supports the '=' and 'IN' comparisons.
• CreatedTime supports the '=', '<', '>', '<=' and '>=' comparisons.

Following are example queries that are processed server side:

SELECT * FROM Feeds WHERE FeedId = '50950018754'

SELECT * FROM Feeds WHERE FeedType = 'POST_PRODUCT_PRICING_DATA'

SELECT * FROM Feeds WHERE FeedType IN ( 'POST_PRODUCT_PRICING_DATA', 'POST_INVENTORY_AVAILABILITY_DATA' )

SELECT * FROM Feeds WHERE FeedType = 'POST_PRODUCT_PRICING_DATA' AND MarketplaceIds = 'A1VC38T7YXB528'

SELECT * FROM Feeds WHERE FeedType = 'POST_PRODUCT_PRICING_DATA' AND ProcessingStatus = 'DONE'

SELECT * FROM Feeds WHERE FeedType = 'POST_PRODUCT_PRICING_DATA' AND CreatedTime > '2021-06-20' AND CreatedTime < '2021-08-01 12:00:00'

Note: When filtering with CreatedTime, values older than 90 days will not be accepted.

Columns

Name	Type	References	Description
FeedId [KEY]	String		The Id of the Feed. This identifier is unique only in combination with a seller ID.
FeedType	String		The Type of the feed. FeedType is not required when UseSandbox=True.
MarketplaceIds	String		A list of marketplace identifiers for the report.
CreatedTime	Datetime		The date and time when the feed was created. While filtering, CreatedTime value is only accepted till 90 days old.
ProcessingStatus	String		The processing status of the report.
ProcessingStartTime	Datetime		The Date when the feed processing started.
ProcessingEndTime	Datetime		The Date when the feed processing completed.
ResultFeedDocumentId	String		The identifier for the feed document. This identifier is unique only in combination with a seller ID.

Returns the estimated fees for the listed products.

Columns

Name	Type	References	Description
IdValue [KEY]	String		Required. The item identifier.
SellerID	String		The seller identifier.
TimeOfFeesEstimation	Datetime		The time at which the fees were estimated.
TotalFeesEstimateAmount	Decimal		Total estimated fees for a given item, price and fulfillment channel.
TotalFeesEstimateCurrencyCode	String		The currency code for the total estimated fees.
FeeType	String		The type of fee charged to a seller.
FeeAmount	Decimal		The amount charged for a given fee.
FeeAmountCurrencyCode	String		The currency code for the charged amount.
FeePromotionAmount	Decimal		The promotion amount for a given fee.
FeePromotionCurrencyCode	String		The currency code for the promotion amount.
TaxAmount	Decimal		The tax amount for a given fee.
TaxCurrencyCode	String		The currency code for the tax amount .
FinalFeeAmount	Decimal		The final fee amount for a given fee.
FinalFeeCurrencyCode	String		The currency code for the final fee amount.
MarketplaceId	String		Required. The marketplace identifier.
IdType	String		Required. The item type. The allowed values are ASIN, SellerSku.
Identifier	String		Required. The unique identifier provided by the caller to track this request.
IsAmazonFulfilled	Boolean		When true, the offer is fulfilled by Amazon.
ListingPriceAmount	Decimal		Required. The price of the item.
ListingPriceCurrencyCode	String		Required. The currency code for the price of the item.
ShippingAmount	Decimal		Required. The shipping cost.
ShippingCurrencyCode	String		Required. The currency code for the shipping cost.
PointsNumber	Decimal		Required. The number of Amazon Points offered with the purchase of an item.
PointsAmount	Decimal		Required. The monetary value for points.
PointsCurrencyCode	String		Required. The currency code for points.

Returns a list of items in a specified inbound shipment.

Columns

Name	Type	References	Description
ASIN [KEY]	String		The Amazon Standard Identification Number (ASIN) of the item.
SellerSKU [KEY]	String		The seller SKU of the item.
MarketplaceId	String		Required. Marketplace identifier for the report.
GuidanceReasonList	String		A list of reasons for the current inbound guidance for this item.
InboundGuidance	String		Specific inbound guidance for an item.
ErrorReason	String		The reason why the seller SKU or ASIN is invalid.

Returns labeling requirements and item preparation instructions to help prepare items for shipment to Amazon's fulfillment network.

Columns

Name	Type	References	Description
ASIN [KEY]	String		The Amazon Standard Identification Number (ASIN) of the item.
SellerSKU [KEY]	String		The seller SKU of the item.
ShipToCountryCode	String		Required. The country code of the country to which the items will be shipped.
BarcodeInstruction	String		Labeling requirements for the item. For more information about FBA labeling requirements, see the Seller Central Help for your marketplace.
PrepGuidance	String		Item preparation instructions.
PrepInstructionList	String		A list of preparation instructions to help with item sourcing decisions.
PrepInstruction	String		Preparation instructions for shipping an item to Amazon's fulfillment network.
FeePerUnitCurrencyCode	String		The fee currency code for Amazon to prepare 1 unit.
FeePerUnitValue	Decimal		The fee amount for Amazon to prepare 1 unit.
ErrorReason	String		The reason why the SellerSKU/ASIN is invalid.

Returns a list of items in a specified inbound shipment.

Select

The Cloud will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

• MarketplaceId supports the '=' comparison.
• ShipmentId supports the '=' comparison.
• LastUpdatedDate supports the '=', '<', '>', '<=', '>=' comparisons.

For example, the following query is processed server side:

SELECT * FROM InboundShipmentItems  WHERE MarketplaceId = 'ATVPDKIKX0DER'

SELECT * FROM InboundShipmentItems  WHERE ShipmentId = 'FBA8J3K9LZPX'

SELECT * FROM InboundShipmentItems  WHERE LastUpdatedDate > '2020-01-01'

Columns

Name	Type	References	Description
ShipmentId [KEY]	String		The ID of the shipment.
SellerSKU [KEY]	String		The Seller SKU of the item.
QuantityShipped	Int		The item quantity that you are shipping.
QuantityInCase	Int		The item quantity in each case, for case-packed items.
QuantityReceived	Int		The item quantity that has been received at an Amazon fulfillment center.
FulfillmentNetworkSKU	String		Amazon's fulfillment network SKU of the item.
PrepDetailsList	String		A JSON aggregate of preparation instructions and who is responsible for that preparation.
MarketplaceId	String		Marketplace identifier for the report.
ReleaseDate	Date		The date that a pre-order item will be available for sale.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
LastUpdatedDate	Datetime		A date used for selecting inbound shipments that were last updated before/after a specified time.

Returns a list of items in a specified inbound shipment.

Columns

Name	Type	References	Description
MarketplaceId [KEY]	String		Required. A marketplace identifier. Specifies the marketplace the shipment is tied to.
ShipmentId [KEY]	String		Requried. A shipment identifier originally returned by the createInboundShipmentPlan operation.
ShipmentContainsPreorderableItems	Boolean		Indicates whether the shipment contains items that have been enabled for pre-order. For more information about enabling items for pre-order, see the Seller Central Help.
ShipmentConfirmedForPreorder	Boolean		Indicates whether this shipment has been confirmed for pre-order.
NeedByDate	Date		Date that the shipment would need to arrive at an Amazon fulfillment center to avoid delivery promise breaks for pre-ordered items if this shipment is later confirmed for pre-order. In YYYY-MM-DD format.
ConfirmedFulfillableDate	Date		Date in YYYY-MM-DD format that determines which pre-order items in the shipment are eligible for pre-order. If this shipment is confirmed for pre-order with a subsequent call to the confirmPreorder operation, the pre-order Buy Box will appear for any pre-order items in the shipment with a release date on or after this date.

Returns information about the availability of inventory that a seller has in Amazon's fulfillment network and in current inbound shipments. You can check the current availability status for your Fulfillment by Amazon inventory as well as discover when availability status changes.

Select

The Cloud will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the Cloud.

Note: Attributes 'GranularityType' and 'GranularityId' are required to query the view. You must set GranularityId to the MarketplaceId from the API matching your region.

• SellerSKU supports the '=', 'IN' comparisons.
• GranularityType supports the '='comparison.
• GranularityId supports the '=' comparison.
• MarketplaceId supports the '=' comparison.
• StartDateTime supports the '=', '<', '>', '<=', '>=' comparisons.

Following are example queries which are processed server side:

SELECT * FROM InventorySupply WHERE GranularityType = 'Marketplace' AND GranularityId = 'ATVPDKIKX0DER' AND SellerSKU = '123'

SELECT * FROM InventorySupply WHERE GranularityType = 'Marketplace' AND GranularityId = 'ATVPDKIKX0DER' AND StartDateTime > '2020-01-01'

Columns

Name	Type	References	Description
UID [KEY]	String		Auto Generated Primary Key field.
FNSKU	String		The Fulfillment Network SKU (FNSKU) of the item. The FNSKU is a unique identifier for each inventory item stored in an Amazon fulfillment center.
SellerSKU	String		The Seller SKU of the item. Required if the QueryStartDateTime is not specified.
ASIN	String		The Amazon Standard Identification Number (ASIN) of the item.
Condition	String		The condition of the item.
GranularityType	String
GranularityId	String
TotalQuantity	Integer		The total number of units in an inbound shipment or in Amazon fulfillment centers.
ProductName	String		The localized language product title of the item within the specific marketplace.
LastUpdatedTime	String		The date and time that any quantity was last updated.
FulfillableQuantity	Integer		The item quantity that can be picked, packed, and shipped.
InboundWorkingQuantity	Integer		The item quantity that can be picked, packed, and shipped.
InboundShippedQuantity	Integer		The item quantity that can be picked, packed, and shipped.
InboundReceivingQuantity	Integer		The item quantity that can be picked, packed, and shipped.
TotalReservedQuantity	Integer		The total number of units in Amazon's fulfillment network that are currently being picked, packed, and shipped.
PendingCustomerOrderQuantity	Integer		The number of units reserved for customer orders.
PendingTransshipmentQuantity	Integer		The number of units being transferred from one fulfillment center to another.
FcProcessingQuantity	Integer		The number of units that have been sidelined at the fulfillment center for additional processing.
TotalUnfulfillableQuantity	Integer		The total number of units in Amazon's fulfillment network in unsellable condition.
CustomerDamagedQuantity	Integer		The number of units in customer damaged disposition.
WarehouseDamagedQuantity	Integer		The number of units in warehouse damaged disposition.
DistributorDamagedQuantity	Integer		The number of units in distributor damaged disposition.
CarrierDamagedQuantity	Integer		The number of units in carrier damaged disposition.
DefectiveQuantity	Integer		The number of units in defective disposition.
ExpiredQuantity	Integer		The number of units in expired disposition.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
StartDateTime	Datetime		A start date and time in ISO8601 format. If specified, all inventory summaries that have changed since then are returned. You must specify a date and time that is no earlier than 18 months prior to the current date and time.
MarketplaceId	String		The marketplace ID for the marketplace for which to return inventory summaries.