Adding a Connection to Amazon Marketplace

To add a connection to Amazon Marketplace:

1. In the application console, navigate to the Connections page.
2. At the Add Connections panel, select the icon for the connection you want to add.
3. If the Amazon Marketplace icon is not available, click the Add More icon to download and install the Amazon Marketplace connector from the CData site.

For required properties, see the Settings tab.

For connection properties that are not typically required, see the Advanced tab.

Connecting to Amazon Marketplace

The following properties are required:

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

Authenticate to Amazon 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.

This section details a selection of advanced features of the Amazon Marketplace Sync App.

User Defined Views

The Sync App supports the use of user defined views, virtual tables whose contents are decided by a pre-configured user defined query. These views are useful when you cannot directly control queries being issued to the drivers. For an overview of creating and configuring custom views, see User Defined Views .

SSL Configuration

Use SSL Configuration to adjust how Sync App handles TLS/SSL certificate negotiations. You can choose from various certificate formats;. For further information, see the SSLServerCert property under "Connection String Options" .

Firewall and Proxy

Configure the Sync App for compliance with Firewall and Proxy, including Windows proxies and HTTP proxies. You can also set up tunnel connections.

Query Processing

The Sync App offloads as much of the SELECT statement processing as possible to Amazon Marketplace and then processes the rest of the query in memory (client-side).

For further information, see Query Processing.

Logging

For an overview of configuration settings that can be used to refine CData logging, see Logging. Only two connection properties are required for basic logging, but there are numerous features that support more refined logging, which enables you to use the LogModules connection property to specify subsets of information to be logged.

Customizing the SSL Configuration

By default, the Sync App attempts to negotiate TLS with the server. The server certificate is validated against the default system trusted certificate store. You can override how the certificate gets validated using the SSLServerCert connection property.

To specify another certificate, see the SSLServerCert connection property.

Connecting Through a Firewall or Proxy

HTTP Proxies

To authenticate to an HTTP proxy, set the following:

• ProxyServer: the hostname or IP address of the proxy server that you want to route HTTP traffic through.
• ProxyPort: the TCP port that the proxy server is running on.
• ProxyAuthScheme: the authentication method the Sync App uses when authenticating to the proxy server.
• ProxyUser: the username of a user account registered with the proxy server.
• ProxyPassword: the password associated with the ProxyUser.

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 Sync App 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 SellerCentral API

See Seller Central Data Model for the available entities in the Seller Central API.

Using VendorCentral API

See Vendor Central Data Model for the available entities in the Vendor Central API.

The CData Sync App models the Seller Central API as relational views, and stored procedures.

To use Amazon Seller Central Data Model, simply set Schema to SellerCentral.

Views

Views are tables that cannot be modified, such as Orders, OrderItems. 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 Sync App models the data in Amazon Marketplace as a list of tables in a relational database that can be queried using standard SQL statements.

Amazon Marketplace Connector for CData Sync Tables

Name	Description
Destinations	Returns information about all destinations.
InboundDeliveryWindowOptions	Retrieves all delivery window options for a shipment.
InboundItemComplianceDetails	List the inbound compliance details for MSKUs in a given marketplace.
InboundPackingOptions	Retrieves a list of all packing options for an inbound plan.
InboundPlacementOptions	Provides a list of all placement options for an inbound plan.
InboundPlan	Provides a list of inbound plans with minimal information.
InboundSelfShipAppointmentSlots	Retrieves a list of available self-ship appointment slots used to drop off a shipment at a warehouse.
InboundShipmentContentUpdatePreview	Retrieve a paginated list of shipment content update previews for a given shipment.
ListingsItems	Returns details about a listings item for a selling partner.
ListingsItemsAttributes	Returns details about a listings item attributes for a selling partner.
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.

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

Retrieves all delivery window options for a shipment.

Columns

Name	Type	ReadOnly	References	Description
InboundPlanId [KEY]	String	False		Identifier of an inbound plan.
ShipmentId [KEY]	String	False		The shipment to generate delivery window options for.
DeliveryWindowOptionId [KEY]	String	False		Identifier of a delivery window option. A delivery window option represent one option for when a shipment is expected to be delivered.
StartDate	Datetime	False		The timestamp at which this delivery window option starts. This is based in ISO 8601 datetime with pattern `yyyy-MM-ddTHH:mm:ss.sssZ`.
EndDate	Datetime	False		The timestamp at which this delivery window option ends. This is based in ISO 8601 datetime with pattern `yyyy-MM-ddTHH:mm:ss.sssZ`.
ValidUntil	Datetime	False		The timestamp at which this window delivery option becomes no longer valid. This is based in ISO 8601 datetime with pattern `yyyy-MM-ddTHH:mm:ss.sssZ`.
AvailabilityType	String	False		Identifies type of Delivery Window Availability. Values: `AVAILABLE`, `CONGESTED`

List the inbound compliance details for MSKUs in a given marketplace.

Columns

Name	Type	ReadOnly	References	Description
Msku [KEY]	String	False		The merchant SKU, a merchant-supplied identifier for a specific SKU.
HsnCode	String	False		Harmonized System of Nomenclature code.
Amount	Decimal	False		Decimal value of the currency.
Code	String	False		ISO 4217 standard of a currency code.
Asin	String	False		The Amazon Standard Identification Number, which identifies the detail page identifier.
MarketplaceId	String	False		The Marketplace ID. Refer to [Marketplace IDs](https://developer-docs.amazon.com/sp-api/docs/marketplace-ids) for a list of possible values.
Fnsku	String	False		The Fulfillment Network SKU, which identifies a real fulfillable item with catalog data and condition.
TaxRate	String	False		Contains the type and rate of tax.

Retrieves a list of all packing options for an inbound plan.

Columns

Name	Type	ReadOnly	References	Description
PackingOptionId [KEY]	String	False		Identifier of a packing option.
InboundPlanId [KEY]	String	False		Identifier of an inbound plan.
Discounts	String	False		Discount for the offered option.
Fees	String	False		Fee for the offered option.
Expiration	Datetime	False		The timestamp at which this packing option becomes no longer valid. This is based in ISO 8601 datetime with pattern `yyyy-MM-ddTHH:mm:ss.sssZ`.
Status	String	False		The status of the packing option. Can be: `OFFERED`, `ACCEPTED`, or `EXPIRED`.
ShippingConfiguration	String	False		List of supported shipping modes.
PackingGroups	String	False		Packing group IDs.

Provides a list of all placement options for an inbound plan.

Columns

Name	Type	ReadOnly	References	Description
PlacementOptionId [KEY]	String	False		The identifier of a placement option. A placement option represents the shipment splits and destinations of SKUs.
InboundPlanId [KEY]	String	False		Identifier of an inbound plan.
Discounts	String	False		Contains details about cost related modifications to the placement cost.
Fees	String	False		Contains details about cost related modifications to the placement cost.
Expiration	Datetime	False		The timestamp at which this packing option becomes no longer valid. This is based in ISO 8601 datetime with pattern `yyyy-MM-ddTHH:mm:ss.sssZ`.
Status	String	False		The status of a placement option. Can be: `OFFERED`, `ACCEPTED`, or `EXPIRED`.
ShipmentIds	String	False		Shipment ids.
CustomPlacementInput	String	False		Provide units going to the warehouse.

Provides a list of inbound plans with minimal information.

Columns

Name	Type	ReadOnly	References	Description
InboundPlanId [KEY]	String	False		Identifier of an inbound plan.
Name	String	False		Human-readable name of the inbound plan.
MarketplaceIds	String	False		A list of marketplace IDs.
CreatedAt	Datetime	False		The ISO 8601 datetime with pattern `yyyy-MM-ddTHH:mm:ss.sssZ`.
LastUpdatedAt	Datetime	False		The ISO 8601 datetime with pattern `yyyy-MM-ddTHH:mm:ss.sssZ`.
Status	String	False		Current status of the inbound plan. Can be: `ACTIVE`, `VOIDED`, `SHIPPED`, 'ERRORED'.
ShipmentSummary	String	False		Summary information about a shipment.
PlacementOptionSummary	String	False		Summary information about a placement option.
PackingOptionSummary	String	False		Summary information about a packing option.
StateOrProvinceCode	String	False		The state or province code.
PhoneNumber	String	False		The phone number.
City	String	False		The city.
Email	String	False		The email address.
CompanyName	String	False		The name of the business.
PostalCode	String	False		The postal code.
AddressLine2	String	False		Additional street address information.
AddressLine1	String	False		Street address information.
CountryCode	String	False		The country code in two-character ISO 3166-1 alpha-2 format.
AddressName	String	False		The name of the customer in the specified address.
InboundPlanAggregate	String	False		Parameter used for creating new inbound plans by passing the JSON aggregate.
InboundPlanItems	String	False		Inbound plan item's input parameters. Used for creating an inbound plan.

Retrieves a list of available self-ship appointment slots used to drop off a shipment at a warehouse.

Columns

Name	Type	ReadOnly	References	Description
ShipmentId [KEY]	String	False		Identifier of a shipment. A shipment contains the boxes and units being inbounded.
InboundPlanId [KEY]	String	False		Identifier of an inbound plan.
SlotId [KEY]	String	False		An identifier to a self-ship appointment slot.
StartTime	Datetime	False		The start timestamp of the appointment in UTC.
EndTime	Datetime	False		The end timestamp of the appointment in UTC.
ExpiresAt	Datetime	False		The time at which the self ship appointment slot expires. In ISO 8601 datetime format.

Retrieve a paginated list of shipment content update previews for a given shipment.

Columns

Name	Type	ReadOnly	References	Description
ShipmentId	String	False		Identifier of a shipment. A shipment contains the boxes and units being inbounded.
ContentUpdatePreviewId	String	False		Identifier of a content update preview.
InboundPlanId	String	False		Identifier of an inbound plan.
Expiration	Datetime	False		The date in ISO 8601 format for when the content update expires.
BoxUpdateInput	String	False		Input information for updating a box
ItemInput	String	False		Defines an item's input parameters.
VoidableUntil	Datetime	False		Voidable until timestamp.
Name	String	False		The name of the carrier.
EndTime	Datetime	False		The end timestamp of the appointment in UTC.
ShippingMode	String	False		Mode of shipment transportation that this option will provide. Can be: `GROUND_SMALL_PARCEL`, `FREIGHT_LTL`, `FREIGHT_FTL_PALLET`, `FREIGHT_FTL_NONPALLET`, `OCEAN_LCL`, `OCEAN_FCL`, `AIR_SMALL_PARCEL`, `AIR_SMALL_PARCEL_EXPRESS`.
QuoteExpiration	Datetime	False		The time at which this transportation option quote expires.
TransportationOptionId	String	False		Identifier of a transportation option. A transportation option represent one option for how to send a shipment.
StartTime	Datetime	False		The start timestamp of the appointment in UTC.
AlphaCode	String	False		The carrier code. For example, USPS or DHLEX.
Amount	Decimal	False		Decimal value of the currency.
Code	String	False		ISO 4217 standard of a currency code.
ShippingSolution	String	False		Shipping program for the option. Can be: `AMAZON_PARTNERED_CARRIER`, `USE_YOUR_OWN_CARRIER`.

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	False		A selling partner provided identifier for an Amazon listing.
FulfillmentAvailability	String	False		Fulfillment availability for the listings item.
Procurements	String	False		The vendor procurement information for the listings item.
ProcurementCostCurrency	String	False		The price (ISO4217 currency code) that you want Amazon to pay you for this product.
ProcurementCostAmount	String	False		The price (numeric value) that you want Amazon to pay you for this product.
Attributes	String	False		This field is required for INSERT statements. Aggregate field containing structured 'AttributeName' and 'AttributeValue' fields.
SellerId [KEY]	String	False		A selling partner identifier, such as a merchant account or vendor code.
Requirements	String	False		This field can be specified for INSERT statements. The allowed values are LISTING, LISTING_PRODUCT_ONLY, LISTING_OFFER_ONLY.
ProductType	String	False		This field is required for INSERT statements.

Returns details about a listings item attributes 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 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.
ProductType	String	False		The Amazon product type of the listings item. Required for Updating an attribute.
SellerId [KEY]	String	True		A selling partner identifier, such as a merchant account or vendor code.
AttributePath	String	True		The attribute path for the listings item.
AttributeGroup	String	True		The attribute group for the listings item.

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.
PaymentInformation	String	False		A JSON object of various payment attributes related to this fulfillment order. Required for India but is optional for all other marketplaces.

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.

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.

Amazon Marketplace Connector for CData Sync Views

Name	Description
CatalogItems	The Catalog Items table helps you retrieve item details for items in the catalog.
CatalogItemsClassifications	The Catalog Items Classifications table helps you retrieve classification 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.
InboundDeliveryChallanDocument	Provide delivery challan document for PCP transportation in India marketplace.
InboundOperationStatus	Gets the status of the processing of an asynchronous API call.
InboundPackingGroupBoxes	Retrieves a page of boxes from a given packing group.
InboundPackingGroupItems	Retrieves a page of items in a given packing group.
InboundPlanBoxes	Provides a paginated list of box packages in an inbound plan.
InboundPlanItems	Provides a paginated list of item packages in an inbound plan.
InboundPlanPallets	Provides a paginated list of pallet packages in an inbound plan.
InboundShipmentBoxes	Provides a paginated list of box packages in a shipment.
InboundShipmentItems	Returns a list of items in a specified inbound shipment.
InboundShipmentPallets	Provides a paginated list of pallet packages in a shipment.
InboundShipments	Returns a list of inbound shipments based on criteria that you specify.
InboundTransportationOptions	Retrieves all transportation options for a 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	Returns details about a listings item issues for a selling partner.
ListingsItemsOffers	Returns details about a listings item offers for a selling partner.
ListingsItemsSummaries	Returns details about a listings item summaries for a selling partner.
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.
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.
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.

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.
Classifications	String		A JSON array of classifications (browse nodes) associated with the item in the Amazon catalog by Amazon marketplace.
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.

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

Columns

Name	Type	References	Description
ClassificationId [KEY]	String		Identifier of the classification (browse node identifier).
MarketplaceASIN [KEY]	String		Amazon Standard Identification Number that identifies a product.
DisplayName	String		Display name for the classification (browse node).
ParentClassificationId	String		Parent classification (browse node) ID of the current classification.
MarketplaceId	String		Specifies the marketplace for which items are returned.
ShowParentClassifications	Boolean		Specifies whether to list all browse nodes for the item(s) or just the top-level browse node. By default, only the top-level browse nodes are listed.
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.
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.
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.
ItemClassifications	String		A comma-separated list of classification IDs for filtering keyword searches. The results may vary, as the classification could refer to either the item's classification or its parent classification. 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.

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.
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.
SalesRankings	String		A JSON aggregate containing the list of sales rank information for the item, by category.
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 Sync App 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 Sync App.

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.

Provide delivery challan document for PCP transportation in India marketplace.

Columns

Name	Type	References	Description
InboundPlanId [KEY]	String		Identifier of an inbound plan.
ShipmentId [KEY]	String		Identifier of a shipment. A shipment contains the boxes and units being inbounded.
Uri	String		Uniform resource identifier to identify where the document is located.
Expiration	Datetime		The timestamp of expiration of the URI. This is in ISO 8601 datetime format with pattern `yyyy-MM-ddTHH:mm:ss.sssZ`.
DownloadType	String		The type of download. Can be `URL`.

Gets the status of the processing of an asynchronous API call.

Columns

Name	Type	References	Description
OperationId [KEY]	String		The operation ID returned by the asynchronous API call.
OperationProblem	String		A problem with additional properties persisted to an operation.
Operation	String		The name of the operation in the asynchronous API call.
OperationStatus	String		The status of an operation.

Retrieves a page of boxes from a given packing group.

Columns

Name	Type	References	Description
PackageId [KEY]	String		Primary key to uniquely identify a Package (Box or Pallet).
InboundPlanId [KEY]	String		Identifier of an inbound plan.
ContentInformationSource	String		Indication of how box content is meant to be provided.
Item	String		Information associated with a single SKU in the seller's catalog.
BoxId	String		The ID provided by Amazon that identifies a given box. This ID is comprised of the external shipment ID (which is generated after transportation has been confirmed) and the index of the box.
CountryCode	String		ISO 3166 standard alpha-2 country code.
State	String		State.
WarehouseId	String		An identifier for a warehouse, such as a FC, IXD, upstream storage.
Value	Decimal		Value of a weight.
UnitOfWeight	String		Unit of the weight being measured.
TemplateName	String		Template name of the box.
Width	Decimal		The width of a package.
Height	Decimal		The height of a package.
UnitOfMeasurement	String		Unit of linear measure.
Length	Decimal		The length of a package.
Quantity	Int		The number of containers where all other properties like weight or dimensions are identical.
PackingGroupId [KEY]	String		Identifier of a packing group.

Retrieves a page of items in a given packing group.

Columns

Name	Type	References	Description
PackingGroupId [KEY]	String		Identifier of a packing group.
InboundPlanId [KEY]	String		Identifier of an inbound plan.
Msku	String		The merchant defined SKU ID.
ManufacturingLotCode	String		The manufacturing lot code.
Fnsku	String		A unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center.
Expiration	String		The expiration date of the MSKU in ISO 8601 format. The same MSKU with different expiration dates cannot go into the same box.
Code	String		ISO 4217 standard of a currency code.
Amount	Decimal		Decimal value of the currency.
Quantity	Int		The number of the specified MSKU.
PrepOwner	String		In some situations, special preparations are required for items and this field reflects the owner of the preparations. Options include `AMAZON`, `SELLER` or `NONE`.
PrepType	String		Type of preparation that should be done. Can be: `ITEM_LABELING`, `ITEM_BUBBLEWRAP`, `ITEM_POLYBAGGING`, `ITEM_TAPING`, `ITEM_BLACK_SHRINKWRAP`, `ITEM_HANG_GARMENT`, `ITEM_BOXING`, `ITEM_SETCREAT`, `ITEM_RMOVHANG`, `ITEM_SUFFOSTK`, `ITEM_CAP_SEALING`, `ITEM_DEBUNDLE`, `ITEM_SETSTK`, `ITEM_SIOC`, `ITEM_NO_PREP`, `ADULT`, `BABY`, `TEXTILE`, `HANGER`, `FRAGILE`, `LIQUID`, `SHARP`, `SMALL`, `PERFORATED`, `GRANULAR`, `SET`, `FC_PROVIDED`, `UNKNOWN`, `NONE`.
LabelOwner	String		Specifies who will label the items. Options include `AMAZON`, `SELLER`, and `NONE`.
Asin	String		The Amazon Standard Identification Number (ASIN) of the item.

Provides a paginated list of box packages in an inbound plan.

Columns

Name	Type	References	Description
BoxId [KEY]	String		The ID provided by Amazon that identifies a given box. This ID is comprised of the external shipment ID (which is generated after transportation has been confirmed) and the index of the box.
InboundPlanId [KEY]	String		Identifier of an inbound plan.
LabelOwner	String		Specifies who will label the items. Options include `AMAZON`, `SELLER`, and `NONE`.
Msku	String		The merchant defined SKU ID.
UnitOfMeasurement	String		Unit of linear measure.
PackageId	String		Primary key to uniquely identify a Package (Box or Pallet).
ContentInformationSource	String		Indication of how box content is meant to be provided.
Value	Decimal		Value of a weight.
Fnsku	String		A unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center.
Height	Decimal		The height of a package.
PrepInstruction	String		Information pertaining to the preparation of inbound goods.
CountryCode	String		ISO 3166 standard alpha-2 country code.
State	String		State.
Width	Decimal		The width of a package.
WarehouseId	String		An identifier for a warehouse, such as a FC, IXD, upstream storage.
UnitOfWeight	String		Unit of the weight being measured.
TemplateName	String		Template name of the box.
Expiration	String		The expiration date of the MSKU in ISO 8601 format. The same MSKU with different expiration dates cannot go into the same box.
Length	Decimal		The length of a package.
ManufacturingLotCode	String		The manufacturing lot code.
Quantity	Int		The number of containers where all other properties like weight or dimensions are identical.
Asin	String		The Amazon Standard Identification Number (ASIN) of the item.

Provides a paginated list of item packages in an inbound plan.

Columns

Name	Type	References	Description
InboundPlanId [KEY]	String		Identifier of an inbound plan.
Msku	String		The merchant defined SKU ID.
ManufacturingLotCode	String		The manufacturing lot code.
Fnsku	String		A unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center.
Expiration	String		The expiration date of the MSKU in ISO 8601 format. The same MSKU with different expiration dates cannot go into the same box.
Quantity	Int		The number of the specified MSKU.
LabelOwner	String		Specifies who will label the items. Options include `AMAZON`, `SELLER`, and `NONE`.
Asin	String		The Amazon Standard Identification Number (ASIN) of the item.
PrepInstructions	String		Decimal value of the currency.

Provides a paginated list of pallet packages in an inbound plan.

Columns

Name	Type	References	Description
PackageId [KEY]	String		Primary key to uniquely identify a Package (Box or Pallet).
InboundPlanId [KEY]	String		Identifier of an inbound plan.
Quantity	Int		The number of containers where all other properties like weight or dimensions are identical.
UnitOfMeasurement	String		Unit of linear measure.
Length	Decimal		The length of a package.
Width	Decimal		The width of a package.
Height	Decimal		The height of a package.
Value	Decimal		Value of a weight.
UnitOfWeight	String		Unit of the weight being measured.
Stackability	String		Indicates whether pallets will be stacked when carrier arrives for pick-up.

Provides a paginated list of box packages in a shipment.

Columns

Name	Type	References	Description
InboundPlanId [KEY]	String		Identifier of an inbound plan.
ShipmentId [KEY]	String		Identifier of a shipment. A shipment contains the boxes and units being inbounded.
PackageId [KEY]	String		Primary key to uniquely identify a Package (Box or Pallet).
LabelOwner	String		Specifies who will label the items. Options include `AMAZON`, `SELLER`, and `NONE`.
Msku	String		The merchant defined SKU ID.
UnitOfMeasurement	String		Unit of linear measure.
ContentInformationSource	String		Indication of how box content is meant to be provided.
Region	String		Representation of a location used within the inbounding experience.
Value	Decimal		Value of a weight.
Fnsku	String		A unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center.
Height	Decimal		The height of a package.
Unit	String		Unit of the weight being measured.
PrepInstruction	String		Information pertaining to the preparation of inbound goods.
BoxId	String		The ID provided by Amazon that identifies a given box. This ID is comprised of the external shipment ID (which is generated after transportation has been confirmed) and the index of the box.
CountryCode	String		ISO 3166 standard alpha-2 country code.
State	String		State.
Width	Decimal		The width of a package.
WarehouseId	String		An identifier for a warehouse, such as a FC, IXD, upstream storage.
TemplateName	String		Template name of the box.
Expiration	String		The expiration date of the MSKU in ISO 8601 format. The same MSKU with different expiration dates cannot go into the same box.
Length	Decimal		The length of a package.
ManufacturingLotCode	String		The manufacturing lot code.
Quantity	Int		The number of containers where all other properties like weight or dimensions are identical.
Asin	String		The Amazon Standard Identification Number (ASIN) of the item.

Returns a list of items in a specified inbound shipment.

Select

The Sync App 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 Sync App.

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

Provides a paginated list of pallet packages in a shipment.

Columns

Name	Type	References	Description
InboundPlanId [KEY]	String		Identifier of an inbound plan.
ShipmentId [KEY]	String		Identifier of a shipment. A shipment contains the boxes and units being inbounded.
PackageId [KEY]	String		Primary key to uniquely identify a Package (Box or Pallet).
UnitOfMeasurement	String		Unit of linear measure.
Length	Decimal		The length of a package.
Quantity	Int		The number of containers where all other properties like weight or dimensions are identical.
Height	Decimal		The height of a package.
UnitOfWeight	String		Unit of the weight being measured.
Stackability	String		Indicates whether pallets will be stacked when carrier arrives for pick-up.
Width	Decimal		The width of a package.
Value	Decimal		Value of a weight.

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

Select

The Sync App 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 Sync App.

• 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	References	Description
ShipmentId [KEY]	String		The ID of the shipment.
ShipmentStatus	String		The status of your inbound shipment.
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.
ShipFromDistrictOrCounty	String		The district or county of the return address.
ShipFromStateOrProvinceCode	String		The State Or Province Code of the return address.
ShipFromAddressLine1	String		The street address information of the return address.
ShipFromAddressLine2	String		Additional street address information 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.
MarketplaceId	String		Marketplace identifier for the report.
BoxContentsSource	String		Where the seller provided box contents information for a shipment.
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		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.

Retrieves all transportation options for a shipment.

Columns

Name	Type	References	Description
InboundPlanId [KEY]	String		Identifier of an inbound plan.
TransportationOptionId [KEY]	String		Identifier of a transportation option. A transportation option represent one option for how to send a shipment.
ShipmentId [KEY]	String		Identifier of a shipment. A shipment contains the boxes and units being inbounded.
VoidableUntil	Datetime		Voidable until timestamp.
Amount	Decimal		Decimal value of the currency.
Expiration	Datetime		The timestamp at which this transportation option quote becomes no longer valid. This is based in ISO 8601 datetime with pattern `yyyy-MM-ddTHH:mm:ss.sssZ`.
Code	String		ISO 4217 standard of a currency code.
Name	String		The contact's name.
EndTime	Datetime		The end timestamp of the appointment in UTC.
ShippingMode	String		Mode of shipment transportation that this option will provide. Can be: `GROUND_SMALL_PARCEL`, `FREIGHT_LTL`, `FREIGHT_FTL_PALLET`, `FREIGHT_FTL_NONPALLET`, `OCEAN_LCL`, `OCEAN_FCL`, `AIR_SMALL_PARCEL`, `AIR_SMALL_PARCEL_EXPRESS`.
StartTime	Datetime		The start timestamp of the appointment in UTC.
AlphaCode	String		The carrier code. For example, USPS or DHLEX.
ShippingSolution	String		Shipping program for the option. Can be: `AMAZON_PARTNERED_CARRIER`, `USE_YOUR_OWN_CARRIER`.
PlacementOptionId	String		The placement option to generate transportation options for.

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 Sync App 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 Sync App.

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		The granularity type for the inventory aggregation level. Acceptable value(s) are: 'Marketplace'.
GranularityId	String		The granularity ID for the inventory aggregation level.
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.
Stores	String		A list of seller-enrolled stores that apply to this seller SKU.

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.

Returns the lowest priced offers for a single item based on ASIN.

Columns

Name	Type	References	Description
ASIN	String		Required. The Amazon Standard Identification Number (ASIN) of the item.
MarketplaceId	String		A marketplace identifier. Specifies the marketplace for which prices are returned.
ItemCondition	String		The condition of the lowest priced product listed. The allowed values are New, Used, Collectible, Refurbished, Club.
OffersListingPriceAmount	Decimal		The listing price amount of the offered price.
OffersListingPriceCurrencyCode	String		The listing price currency code of the offered price.
OffersShippingAmount	Decimal		The shipping amount of the offered price.
OffersShippingCurrencyCode	String		The shipping currency code of the offered price.
FeedbackCount	Integer		The feedback count.
SellerPositiveFeedbackRating	Double		The positive feedback rating of the seller.
SellerId [KEY]	String		The seller Id.
ShippingTimeAvailabilityType	String		The shipping time availability type.
ShippingTimeMaximumHours	Integer		The maximum hours of shipping time.
ShippingTimeMinimumHours	Integer		The minimum hours of shipping time.
ShippingTimeAvailableDate	String		The date when the item will be available for shipping. Only displayed for items that are not currently available for shipping.
QuantityDiscountPrices	String		Contains pricing information that includes special pricing when buying in bulk.
PointsNumber	Integer		The number of points.
PointsMonetaryValueCurrencyCode	String		The currency code in ISO 4217 format.
PointsMonetaryValueAmount	String		The monetary value.
IsBuyBoxWinner	Boolean		When true, the offer is currently in the Buy Box. There can be up to two Buy Box winners at any time per ASIN, one that is eligible for Prime and one that is not eligible for Prime.
IsPrime	Boolean		Indicates whether the offer is an Amazon Prime offer.
IsNationalPrime	Boolean		Indicates whether the offer is an Amazon Prime offer throughout the entire marketplace where it is listed.
ShipsFromCountry	String		The country from where the product is shipped.
ShipsFromState	String		The state from where the product is shipped.
IsFeaturedMerchant	Boolean		The boolean value of the merchant being featured.
IsFulfilledByAmazon	Boolean		The boolean value of the merchant being fulfilled by Amazon.
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.
MyOffer	Boolean		When true, this is the seller's offer.
OfferType	String		Indicates the type of customer that the offer is valid for.
SubCondition	String		The subcondition of the item. Subcondition values: New, Mint, Very Good, Good, Acceptable, Poor, Club, OEM, Warranty, Refurbished Warranty, Refurbished, Open Box, or Other.
ConditionNotes	String		Information about the condition of the item.

Generated schema file.

Columns

Name	Type	References	Description
SellerSKU [KEY]	String		Identifies an item in the given marketplace.
MarketplaceId	String		A marketplace identifier. Specifies the marketplace for which prices are returned.
ItemCondition	String		The condition of the lowest priced product listed. The allowed values are New, Used, Collectible, Refurbished, Club.
OffersListingPriceAmount	Decimal		The listing price amount of the offered price.
OffersListingPriceCurrencyCode	String		The listing price currency code of the offered price.
OffersShippingAmount	Decimal		The shipping amount of the offered price.
OffersShippingCurrencyCode	String		The shipping currency code of the offered price.
FeedbackCount	Integer		The feedback count.
SellerPositiveFeedbackRating	Double		The positive feedback rating of the seller.
SellerId	String		The seller Id.
ShippingTimeAvailabilityType	String		The shipping time availability type.
ShippingTimeMaximumHours	Integer		The maximum hours of shipping time.
ShippingTimeMinimumHours	Integer		The minimum hours of shipping time.
ShippingTimeAvailableDate	String		The date when the item will be available for shipping. Only displayed for items that are not currently available for shipping.
QuantityDiscountPrices	String		Contains pricing information that includes special pricing when buying in bulk.
PointsNumber	Integer		The number of points.
PointsMonetaryValueCurrencyCode	String		The currency code in ISO 4217 format.
PointsMonetaryValueAmount	String		The monetary value.
IsBuyBoxWinner	Boolean		When true, the offer is currently in the Buy Box. There can be up to two Buy Box winners at any time per ASIN, one that is eligible for Prime and one that is not eligible for Prime.
IsPrime	Boolean		Indicates whether the offer is an Amazon Prime offer.
IsNationalPrime	Boolean		Indicates whether the offer is an Amazon Prime offer throughout the entire marketplace where it is listed.
ShipsFromCountry	String		The country from where the product is shipped.
ShipsFromState	String		The state from where the product is shipped.
IsFeaturedMerchant	Boolean		The boolean value of the merchant being featured.
IsFulfilledByAmazon	Boolean		The boolean value of the merchant being fulfilled by Amazon.
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.
MyOffer	Boolean		When true, this is the seller's offer.
OfferType	String		Indicates the type of customer that the offer is valid for.
SubCondition	String		The subcondition of the item. Subcondition values: New, Mint, Very Good, Good, Acceptable, Poor, Club, OEM, Warranty, Refurbished Warranty, Refurbished, Open Box, or Other.
ConditionNotes	String		Information about the condition of the item.

Returns details about a listings item issues 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 ListingsItemsIssues WHERE SKU = '12345' AND SellerId = 'XXXXXXXXXXXXXX'

Columns

Name	Type	References	Description
SKU	String		A selling partner provided identifier for an Amazon listing.
Code	String		An issue code that identifies the type of issue.
Message	String		A message that describes the issue.
Severity	String		The severity of the issue. The allowed values are INFO, WARNING, ERROR.

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
SellerId	String		A selling partner identifier, such as a merchant account or vendor code.

Returns details about a listings item offers 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 ListingsItemsOffers WHERE SKU = '12345' AND SellerId = 'XXXXXXXXXXXXXX'

Columns

Name	Type	References	Description
SKU	String		A selling partner provided identifier for an Amazon listing
MarketplaceId	String		A marketplace identifier. Identifies the Amazon marketplace for the listings item.
OfferType	String		Type of offer for the listings item. The allowed values are B2B, B2C.
PriceAmount	String		Purchase price amount of the listings item.
PriceCurrency	String		Purchase price currency of the listings item.
Points	String		The number of Amazon Points offered with the purchase of an item, and their monetary value. Note that the Points element is only returned in Japan (JP).

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
SellerId	String		A selling partner identifier, such as a merchant account or vendor code.

Returns details about a listings item summaries 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 ListingsItemsSummaries WHERE SKU = '12345' AND SellerId = 'XXXXXXXXXXXXXX'

Columns

Name	Type	References	Description
SKU	String		A selling partner provided identifier for an Amazon listing.
Asin	String		Amazon Standard Identification Number (ASIN) of the listings item.
ConditionType	String		Identifies the condition of the listings item. The allowed values are new_new, new_open_box, new_oem, refurbished_refurbished, used_like_new, used_very_good, used_good, used_acceptable, collectible_like_new, collectible_very_good, collectible_good, collectible_acceptable, club_club.
CreatedDate	Datetime		Date the listings item was created, in ISO 8601 format.
ItemName	String		Name, or title, associated with an Amazon catalog item.
LastUpdatedDate	Datetime		Date the listings item was last updated, in ISO 8601 format.
MainImageLink	String		Link, or URL, for the main image.
MainImageHeight	Integer		Height of the main image in pixels.
MainImageWidth	Integer		Width of the main image in pixels.
MarketplaceId	String		A marketplace identifier. Identifies the Amazon marketplace for the listings item.
ProductType	String		The Amazon product type of the listings item.
Status	String		Statuses that apply to 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
SellerId	String		A selling partner identifier, such as a merchant account or vendor code.

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

Select

The Sync App 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 Sync App. OrderItems table supports server side filtering with = and IN operators for AmazonOrderId field.

• AmazonOrderId supports the '=' comparison.

For example, the following query is processed server side:

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

Columns

Name	Type	References	Description
OrderItemId [KEY]	String		An Amazon-defined order item identifier.
AmazonOrderId	String	Orders.AmazonOrderId	The Amazon ID of the order.
ASIN	String		The Amazon Standard Identification Number (ASIN) of the item.
SellerSKU	String		The seller stock keeping unit (SKU) of the item.
BuyerCustomizedInfoCustomizedURL	String		The Buyer CustomizedURL.
Title	String		The name of the item.
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 total number of items that are included in the ASIN.
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.
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.
ShippingDiscountAmount	String		The Shipping Discount Amount.
ShippingDiscountCurrencyCode	String		The Shipping Discount Currency Code.
ShippingDiscountTaxAmount	String		The Shipping Discount Tax Amount.
ShippingDiscountTaxCurrencyCode	String		The Shipping Discount Tax Currency Code.
PromotionDiscountAmount	Decimal		The Promotion Discount Amount.
PromotionDiscountCurrencyCode	String		The Promotion Discount Currency Code.
PromotionDiscountTaxAmount	Decimal		The Promotion Discount Tax Amount.
PromotionDiscountTaxCurrencyCode	String		The Promotion Discount Tax 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.
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.
TaxCollectionModel	String		The tax collection model applied to the item.
TaxCollectionResponsibleParty	String		The party responsible for withholding the taxes and remitting them to the taxing authority.
SerialNumberRequired	Boolean		When true, the product type for this item has a serial number. Returned only for Amazon Easy Ship orders.
IsTransparency	Boolean		When true, transparency codes are required.
IossNumber	String		The IOSS number for the marketplace.
StoreChainStoreId	String		The store chain store identifier. Linked to a specific store in a store chain.
DeemedResellerCategory	String		Applies to selling partners that are not based in the EU and is used to help them meet the VAT Deemed Reseller tax laws in the EU and UK.
IsBuyerRequestedCancel	Boolean		When true, the buyer has requested cancellation.
BuyerCancelReason	String		The reason that the buyer requested cancellation.
BuyerCustomizedInfoURL	String		The location of a zip file containing Amazon Custom data.
GiftWrapPriceAmount	String		The Gift Wrap Price Amount.
GiftWrapPriceCurrencyCode	String		The Gift Wrap Price Currency Code.
GiftWrapTaxAmount	String		The Gift Wrap Tax Amount.
GiftWrapTaxCurrencyCode	String		The Gift Wrap Tax Currency Code.
GiftMessageText	String		A gift message provided by the buyer.
GiftWrapLevel	String		The gift wrap level specified by the buyer.
AssociatedItems	String		A list of associated items that a customer has purchased with a product. For example, a tire installation service purchased with tires.

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 aggregated order metrics for a given interval, broken down by granularity, for a given buyer type.

Columns

Name	Type	References	Description
IntervalTime	String		A time interval used for selecting order metrics. This takes the form of two dates separated by two hyphens (first date is inclusive; second date is exclusive). Dates are in ISO8601 format and must represent absolute time (either Z notation or offset notation). Example: 2018-09-01T00:00:00-07:00--2018-09-04T00:00:00-07:00 requests order metrics for Sept 1st, 2nd and 3rd in the -07:00 zone.
BreakdownStartTime	Datetime		The starting date-time of the interval used for selecting order metrics. Dates are in ISO8601 format and must represent absolute time (either Z notation or offset notation).
BreakdownEndTime	Datetime		The ending date-time of the interval used for selecting order metrics. Dates are in ISO8601 format and must represent absolute time (either Z notation or offset notation).
UnitCount	Integer		The number of units in orders based on the specified filters.
OrderItemCount	Integer		The number of order items based on the specified filters.
OrderCount	Integer		The number of orders based on the specified filters.
AverageUnitPriceCurrencyCode	String		Three-digit currency code. In ISO 4217 format.
AverageUnitPriceAmount	Double		The currency amount.
TotalSalesCurrencyCode	String		Three-digit currency code. In ISO 4217 format.
TotalSalesAmount	Double		The currency amount.

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
GranularityTimeZone	String		An IANA-compatible time zone for determining the day boundary. Required when specifying a granularity value greater than Hour. The granularityTimeZone value must align with the offset of the specified interval value.
Granularity	String		The granularity of the grouping of order metrics, based on a unit of time. Specifying granularity=Hour results in a successful request only if the interval specified is less than or equal to 30 days from now. For all other granularities, the interval specified must be less or equal to 2 years from now.
MarketplaceId	String		A marketplace identifier. This specifies the marketplace in which the order was placed. Only one marketplace can be specified.
BuyerType	String		Filters the results by the buyer type that you specify, B2B (business to business) or B2C (business to customer). Example: B2B, if you want the response to include order metrics for only B2B buyers.
FulfillmentNetwork	String		Filters the results by the fulfillment network that you specify, MFN (merchant fulfillment network) or AFN (Amazon fulfillment network). Do not include this filter if you want the response to include order metrics for all fulfillment networks.
FirstDayOfWeek	String		Specifies the day that the week starts on when granularity=Week, either Monday or Sunday. Default: Monday.
Asin	String		Filters the results by the ASIN that you specify. Specifying both ASIN and SKU returns an error. Do not include this filter if you want the response to include order metrics for all ASINs.
Sku	String		Filters the results by the SKU that you specify. Specifying both ASIN and SKU returns an error. Do not include this filter if you want the response to include order metrics for all SKUs.

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

Note: If you're retrieving personally identifiable information (PII), you must set IncludeRestrictedData to true. When retreiving PII, the OAuth application that you use to authenticate must be granted the Direct-to-consumer-shipping role to query this view. If you authenticated with the embedded OAuth application, you will need to create your own OAuth application with the Direct-to-consumer-shipping role enabled. See Creating a Custom OAuth App for more information about creating an OAuth application.

Select

The Sync App 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 Sync App.

• AmazonOrderId supports the '=' comparison.
• SellerOrderId supports the '=' comparison.
• PurchaseDate supports the '=', '<', '>', '<=', '>=' comparison.
• LastUpdateDate supports the '=', '<', '>', '<=', '>=' comparison.
• OrderStatus supports the '=', 'IN' comparison.
• FulfillmentChannel supports the '=', 'IN' comparison.
• PaymentMethod supports the '=', 'IN' comparison.
• MarketplaceId supports the '=' comparison.
• BuyerEmail supports the '=' comparison.
• IsISPU supports the '=' comparison.

For example, the following query is processed server side:

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

SELECT * FROM Orders WHERE SellerOrderId = '249-7638334' AND purchasedate > '2010-01-01'

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

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

SELECT * FROM Orders WHERE MarketplaceId = 'ATVPDKIKX0DER'

SELECT * FROM Orders WHERE BuyerEmail = '[email protected]'

SELECT * FROM Orders WHERE IsISPU = false

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.
ShippingAddressCounty	String		The Shipping Address County.
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.
ShippingAddressMunicipality	String		The Shipping Municipality.
ShippingAddress_AddressType	String		The Shipping Address Type.
DefaultShipAddressName	String		The Shipping Address Name.
DefaultShipAddressLine1	String		Default Ship From Location Address AddressLine.
DefaultShipAddressLine2	String		Default Ship From Location Address AddressLine.
DefaultShipAddressLine3	String		Default Ship From Location Address AddressLine.
DefaultShipCity	String		Default Ship From Location Address City.
DefaultShipCounty	String		Default Ship From Location Address County.
DefaultShipDistrict	String		Default Ship From Location Address District.
DefaultShipStateOrRegion	String		Default Ship From Location Address State Or Region.
DefaultShipPostalCode	String		Default Ship From Location Address Postal Code.
DefaultShipCountryCode	String		Default Ship From Location Address Country Code.
DefaultShipPhone	String		Default Ship From Location Address Phone.
DefaultShipMunicipality	String		The Default Ship Municipality.
DefaultShip_AddressType	String		Default Ship From Location 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.
PaymentMethodDetails	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.
BuyerInvoicePreference	String		Can be individual or business.
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.
HasAutomatedShippingSettings	Boolean		If true, this order has automated shipping settings generated by Amazon. This order could be identified as an SSA order.
AutomatedCarrier	String		Auto-generated carrier for SSA orders
AutomatedShipMethod	String		Auto-generated ship method for SSA orders.
EarliestShipDate	Datetime		The Earliest Ship Date.
EasyShipShipmentStatus	String		The status of the Amazon Easy Ship order. This property is included only for Amazon Easy Ship orders.
HasRegulatedItems	Boolean		Whether the order contains regulated items which may require additional approval steps before being fulfilled.
PromiseResponseDueDate	Datetime		Indicates the date by which the seller must respond to the buyer with an estimated ship date. Returned only for Sourcing on Demand orders.
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.
IsEstimatedShipDateSet	Boolean		When true, the estimated ship date is set for the order. Returned only for Sourcing on Demand orders.
IsSoldByAB	Boolean		When true, the item within this order was bought and re-sold by Amazon Business EU SARL (ABEU).
IsIBA	Boolean		When true, the item within this order was bought and re-sold by Amazon Business EU SARL (ABEU).
IsISPU	Boolean		When true, this order is marked to be picked up from a store rather than delivered.
IsGlobalExpressEnabled	Boolean		When true, the order is a GlobalExpress order.
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.
CompanyName	String		The company name of the recipient.
ExtendedFields	String		The container for address extended fields. For example, street name or street number. Only available for Brazil shipping addresses.
AmazonPrograms	String		A list of the programs that are associated with the specified order item.

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.

Columns

Name	Type	References	Description
MarketplaceId [KEY]	String		Required. The marketplace identifier.
FeatureName	String		The feature name.
FeatureDescription	String		The feature description.
SellerEligible	Boolean		Indicates whether the seller is eligible to use the feature.
SellerSku	String		Used to identify an item in the given marketplace. SellerSKU is qualified by the seller's SellerId, which is included with every operation that you submit.
FnSku	String		The unique SKU used by Amazon's fulfillment network.
Asin	String		The Amazon Standard Identification Number (ASIN) of the item.
SkuCount	String		The number of SKUs available for this service.
OverlappingSkus	String		Other seller SKUs that are shared across the same inventory.
IneligibleReasons	String		A list of one or more reasons that the seller SKU is ineligible for the feature.
QueryStartDate	Datetime		A date that you can use to select inventory that has been updated since a specified date.

Returns the fulfillment order items indicated by the specified order identifier.

Columns

Name	Type	References	Description
SellerFulfillmentOrderId [KEY]	String		The fulfillment order identifier
SellerFulfillmentOrderItemId [KEY]	String		A fulfillment order item identifier submitted with a call to the createFulfillmentOrder operation.
SellerSku	String		The seller SKU of the item.
CancelledQuantity	Integer		The item quantity that was cancelled by the seller.
EstimatedArrivalDate	Datetime		The estimated arrival date and time of the item quantity. Note that this value can change over time. If the shipment that contains the item quantity has been cancelled, estimatedArrivalDate is not returned.
EstimatedShipDate	Datetime		The estimated date and time that the item quantity is scheduled to ship from the fulfillment center. Note that this value can change over time. If the shipment that contains the item quantity has been cancelled, estimatedShipDate is not returned.
FulfillmentNetworkSku	String		Amazon's fulfillment network SKU of the item.
OrderItemDisposition	String		Indicates whether the item is sellable or unsellable.
Quantity	Integer		The item quantity.
UnfulfillableQuantity	Integer		The item quantity that is unfulfillable.
GiftMessage	String		A message to the gift recipient, if applicable.
DisplayableComment	String		Item-specific text that displays in recipient-facing materials such as the outbound shipment packing slip.
PerUnitDeclaredValue	Decimal		The monetary value assigned by the seller to this item.
PerUnitDeclaredCurrencyCode	String		The currency code of the monetary value assigned by the seller to this item.
PerUnitTaxValue	Decimal		The tax on the amount to be collected from the recipient for this item in a COD (Cash On Delivery) order.
PerUnitTaxCurrencyCode	String		The currency code of the tax on the amount to be collected from the recipient for this item in a COD (Cash On Delivery) order.
PerUnitPriceValue	Decimal		The amount to be collected from the recipient for this item in a COD (Cash On Delivery) order.
PerUnitPriceCurrencyCode	String		The currency code of the amount to be collected from the recipient for this item in a COD (Cash On Delivery) order.

Returns a list of fulfillment order previews based on shipping criteria that you specify.

Columns

Name	Type	References	Description
SellerFulfillmentOrderItemId [KEY]	String		A fulfillment order item identifier that the seller created with a call to the createFulfillmentOrder operation.
EarliestArrivalDate	Datetime		The earliest date that the shipment is expected to arrive at its destination.
EarliestShipDate	Datetime		The earliest date that the shipment is expected to be sent from the fulfillment center, in ISO 8601 date time format.
EstimatedShippingWeightUnit	String		The estimated shipping unit weight of the item quantity for a single item, as identified by sellerSku, in a shipment.
EstimatedShippingWeightValue	String		The estimated shipping weight value of the item quantity for a single item, as identified by sellerSku, in a shipment.
IsCodCapable	Boolean		Indicates whether this fulfillment order preview is for COD (Cash On Delivery).
IsFulfillable	Boolean		Indicates whether this fulfillment order preview is fulfillable.
LatestArrivalDate	Datetime		The latest date that the shipment is expected to arrive at its destination, in ISO 8601 date time format.
LatestShipDate	Datetime		The latest date that the shipment is expected to be sent from the fulfillment center, in ISO 8601 date time format.
MarketplaceId	String		The marketplace the fulfillment order is placed against.
Quantity	Integer		The item quantity.
SellerSku	String		The seller SKU of the item.
ShippingSpeedCategory	String		The shipping method used for the fulfillment order. When this value is ScheduledDelivery, choose Ship for the fulfillmentAction. Hold is not a valid fulfillmentAction value when the shippingSpeedCategory value is ScheduledDelivery.
ScheduledDeliveryInfo	String		Provides additional insight into the shipment timeline when exact delivery dates are not able to be precomputed.
ShippingWeightCalculationMethod	String		The method used to calculate the estimated shipping weight.
UnfulfilledItemSellerSku	String		The seller SKU of the unfulfillable item.
UnfulfilledItemQuantity	Integer		The item quantity of the unfulfillable item.
UnfulfilledItemSellerFulfillmentOrderItemId	String		The fulfillment order item identifier of the unfulfillable item.
UnfulfilledItemUnfulfillableReasons	String		Error codes associated with the fulfillment order preview that indicate why the item is unfulfillable.
AddressLine1	String		The first line of the address.
AddressLine2	String		Additional address information.
AddressLine3	String		Additional address information.
City	String		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		The two digit country code. In ISO 3166-1 alpha-2 format.
DistrictOrCounty	String		The district or county where the person, business, or institution is located.
AddressName	String		The name of the person, business or institution at the address.
PostalCode	String		The postal code of the address.
StateOrRegion	String		The state or region where the person, business or institution is located.
Phone	String		The phone number of the person, business, or institution located at the address.
IncludeCODFulfillmentPreview	Boolean		When true, returns all fulfillment order previews both for COD and not for COD. Otherwise, returns only fulfillment order previews that are not for COD.
IncludeDeliveryWindows	Boolean		When true, returns the ScheduledDeliveryInfo response object, which contains the available delivery windows for a Scheduled Delivery. The ScheduledDeliveryInfo response object can only be returned for fulfillment order previews with ShippingSpeedCategories = ScheduledDelivery.

Returns delivery tracking information for a package in an outbound shipment for a Multi-Channel Fulfillment order.

Columns

Name	Type	References	Description
PackageNumber [KEY]	Integer		Required.The package identifier.
AdditionalLocationInfo	String		Additional location information.
CarrierCode	String		The name of the carrier.
CarrierPhoneNumber	String		The phone number of the carrier.
CarrierURL	String		The URL of the carrier's website.
CustomerTrackingLink	String		Link on swiship.com that allows customers to track the package.
CurrentStatus	String		The current delivery status of the package.
CurrentStatusDescription	String		Description corresponding to the CurrentStatus value.
EstimatedArrivalDate	Datetime		The estimated arrival date.
ShipDate	Datetime		The shipping date for the package.
ShipToAddressCity	String		The destination city address information for tracking the package.
ShipToAddressCountry	String		The destination state address information for tracking the package.
ShipToAddressState	String		The destination country address information for tracking the package.
SignedForBy	String		The name of the person who signed for the package.
EventAddressCity	String		The city address information where the delivery event took place.
EventAddressCountry	String		The country address information where the delivery event took place.
EventAddressState	String		The state address information where the delivery event took place.
EventCode [KEY]	String		The event code where the delivery event took place.
EventDate	Datetime		The date and time that the delivery event took place, in ISO 8601 date time format.
EventDescription	String		A description for the corresponding event code.
TrackingNumber	String		The tracking number for the package.

An array of items that Amazon accepted for return. Returns empty if no items were accepted for return.

Columns

Name	Type	References	Description
SellerFulfillmentOrderId [KEY]	String		The fulfillment order identifier.
SellerReturnItemId	String		An identifier assigned by the seller to the return item.
RmaPageURL	String		A URL for a web page that contains the return authorization barcode and the mailing label. This does not include pre-paid shipping.
ReturnAuthorizationId	String		An identifier for the return authorization. This identifier associates return items with the return authorization used to return them.
SellerFulfillmentOrderItemId	String		The identifier assigned to the item by the seller when the fulfillment order was created.
AmazonReturnReasonCode	String		The return reason code that the Amazon fulfillment center assigned to the return item.
AmazonShipmentId	String		The identifier for the shipment that is associated with the return item.
ReturnComment	String		An optional comment about the return item.
Status	String		Indicates if the return item has been processed by an Amazon fulfillment center.
StatusChangedDate	Datetime		Indicates when the status last changed.
SellerReturnReasonCode	String		The return reason code assigned to the return item by the seller.
ReturnReceivedCondition	String		The condition of the return item when received by an Amazon fulfillment center.
AmazonRmaId	String		The return merchandise authorization (RMA) that Amazon needs to process the return.
FulfillmentCenterId	String		An identifier for the Amazon fulfillment center that the return items should be sent to.
ReturnToAddressAddressLine1	String		The first line of the address.
ReturnToAddressAddressLine2	String		Additional address information.
ReturnToAddressAddressLine3	String		Additional address information.
ReturnToAddressCity	String		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.
ReturnToAddressCountryCode	String		The two digit country code. In ISO 3166-1 alpha-2 format.
ReturnToAddressDistrictOrCounty	String		The district or county where the person, business, or institution is located.
ReturnToAddressName	String		The name of the person, business or institution at the address.
ReturnToAddressPostalCode	String		The postal code of the address.
ReturnToAddressStateOrRegion	String		The state or region where the person, business or institution is located.

Returns a list of return reason codes for a seller SKU in a given marketplace.

Columns

Name	Type	References	Description
ReturnReasonCode [KEY]	String		A code that indicates a valid return reason.
Description	String		A human readable description of the return reason code.
TranslatedDescription	String		A translation of the description. The translation is in the language specified in the Language request parameter.
SellerSku	String		Required. The seller SKU for which return reason codes are required.
MarketplaceId	String		The marketplace for which the seller wants return reason codes.
Language	String		The language that the TranslatedDescription property of the ReasonCodeDetails response object should be translated into.
SellerFulfillmentOrderId	String		Required. The fulfillment order identifier.

Generated schema file.

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.
LandedPriceAmount	Decimal		The landed price amount of the buying price.
LandedPriceCurrencyCode	String		The landed price currency code of the buying price.
ListingPriceAmount	Decimal		The listing price amount of the buying price.
ListingPriceCurrencyCode	String		The listing price currency code of the buying price.
ShippingAmount	Decimal		The shipping amount of the buying price.
ShippingCurrencyCode	String		The shipping currency code of the buying price.
FulfillmentChannel	String		The fulfillment channel for the product listed.
ItemCondition	String		The condition of the product listed.
ItemSubCondition	String		The sub-condition of the product listed.
RegularPriceAmount	Decimal		The regular price amount of the product.
RegularPriceCurrencyCode	String		The regular price currecny code for 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.
OfferType	String		Indicates whether to request pricing information for the seller's B2C (business-to-consumer) or B2B (business-to-business) offers. Default is B2C. The allowed values are B2C, B2B.

Returns report details for the reports that match the filters that you specify.

Select

The Sync App 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 Sync App.

Note: 'ReportType' attribute is required to query the view. You can view available values for 'ReportType' in Amazon Selling-Partner API Documentation, or you can query the 'ReportTypes' view.

• ReportId supports the '=' comparison.
• ReportType supports the '=', 'IN' comparisons.
• MarketplaceIds supports the '=', 'IN' comparisons.
• ProcessingStatus supports the '=', 'IN' comparisons.
• CreatedTime supports the '=', '<', '>', '<=', '>=' comparisons.

Following are example queries that are processed server side:

SELECT * FROM ReportList WHERE ReportId = '51013018828'

SELECT * FROM ReportList WHERE ReportType = 'GET_FLAT_FILE_OPEN_LISTINGS_DATA'

SELECT * FROM ReportList WHERE ReportType = 'GET_FLAT_FILE_OPEN_LISTINGS_DATA' AND CreatedTime > '2021-06-12' AND CreatedTime < '2021-08-01 12:00:00'

SELECT * FROM ReportList WHERE ReportType = 'GET_FLAT_FILE_OPEN_LISTINGS_DATA' AND MarketplaceIds = 'A1VC38T7YXB528'

SELECT * FROM ReportList WHERE ReportType = 'GET_FLAT_FILE_OPEN_LISTINGS_DATA' AND ProcessingStatus = 'DONE'

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

Columns

Name	Type	References	Description
ReportId [KEY]	String		Report Id.
ReportType	String		The type of the Report. ReportType is not required when UseSandbox=True.
ReportDocumentId	String		The identifier for the report document.
CreatedTime	Datetime		The date and time when the report was created. While filtering, CreatedTime value is only accepted till 90 days old.
DataStartTime	Datetime		The start of a date and time range used for selecting the data to report.
DataEndTime	Datetime		The end of a date and time range used for selecting the data to report.
MarketplaceIds	String		A list of marketplace identifiers for the report.
ProcessingStartTime	Datetime		The date and time when the report processing started.
ProcessingEndTime	Datetime		The date and time when the report processing completed.
ProcessingStatus	String		The processing status of the report.

Returns report details for the reports that match the filters that you specify.

Select

This view lists all the available Report Types of Seller Central API and their respective format (JSON, XML, CSV, TSV, PDF, XLSX).

SELECT * FROM ReportTypes

Columns

Name	Type	References	Description
ReportTypeId [KEY]	String		Sequential id of the report type.
ReportTypeValue	String		Enumeration value of the report type.
ReportFormat	String		The download format of the report type The allowed values are JSON, XML, CSV, TSV, PDF, XLSX.
Category	String		Report format category.
Description	String		Report format description.
URL	String		Amazon Selling-Partner API Documentation link of the report type.

Returns the shipping documents associated with a package in a shipment.

Columns

Name	Type	References	Description
ShipmentId [KEY]	String		Required. The unique shipment identifier provided by a shipping service.
PackageClientReferenceId	String		Required. A client provided unique identifier for a package being shipped. This value should be saved by the client to pass as a parameter to the getShipmentDocuments operation.
PackageDocumentType	String		The type of shipping document.
PackageDocumentFormat	String		The file format of the document.
PackageDocumentContents	String		A Base64 encoded string of the file contents.
PackageDocumentDPI	Long		The resolution of the document (for example, 300 means 300 dots per inch).
TrackingId	String		The carrier generated identifier for a package in a purchased shipment.
ShippingBusinessId	String		Amazon shipping business to assume for this request. The default is AmazonShipping_UK. Refer X-amzn-shipping-business-id for other marketplaces.

Returns the available shipping service offerings.

Columns

Name	Type	References	Description
ServiceId [KEY]	String		An identifier for the shipping service.
IsEligible	Boolean		A boolean value that indicates whether the shipping service offering is eligible.
RequestToken	String		A unique token generated to identify a getRates operation.
AvailableValueAddedServiceGroups	String		A JSON format of value-added services available for a shipping service offering.
BilledWeightUnit	String		The weight unit.
BilledWeightValue	Decimal		The weight value.
CarrierId	String		The carrier identifier for the offering, provided by the carrier.
CarrierName	String		The carrier name for the offering.
DeliveryWindowStartTime	Datetime		The promised start time of delivery.
DeliveryWindowEndTime	Datetime		The promised end time of delivery.
PickupWindowStartTime	Datetime		The promised start time of pickup.
PickupWindowEndTime	Datetime		The promised end time of pickup.
RequiresAdditionalInputs	Boolean		When true, indicates that additional inputs are required to purchase this shipment service.
RateId	String		An identifier for the rate (shipment offering) provided by a shipping service provider.
ServiceName	String		The name of the shipping service.
SupportedDocumentSpecifications	String		A JSON format of the document specifications supported for a shipment service offering.
TotalChargeUnit	String		The currency code of the total charge.
TotalChargeValue	Decimal		The monetary value of the total charge.
IneligibilityReasons	String		A JSON aggregate of reasons why a shipping service offering is ineligible.
ShipTo	String		Required. The ship to address.
ShipFrom	String		The ship from address.
ReturnTo	String		The return to address.
ShipDate	Datetime		The ship date and time (the requested pickup). This defaults to the current date and time.
Packages	String		A list of packages to be shipped through a shipping service offering.
ValueAddedServicesValue	Decimal		A collection's monetary value of supported value-added services.
ValueAddedServicesUnit	String		A collection's currency code of supported value-added services.
TaxDetailsType	String		Indicates the type of tax.
TaxDetailsRegistrationNumber	String		The shipper's tax registration number associated with the shipment for customs compliance purposes in certain regions.
ChannelType	String		The shipment source channel type. The allowed values are AMAZON, EXTERNAL. The default value is AMAZON.
AmazonOrderDetails	String		The Amazon order ID associated with the Amazon order fulfilled by this shipment.. This is required if the shipment source channel is Amazon.
AmazonShipmentDetails	String		The encrypted shipment ID. This attribute is required only for a Direct Fulfillment shipment.
ShippingBusinessId	String		Amazon shipping business to assume for this request. The default is AmazonShipping_UK. Refer X-amzn-shipping-business-id for other marketplaces.