ODBC Driver for Amazon Marketplace

Build 23.0.8839

SubmitOverrideFeed

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

Execute

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

For #TEMP tables

You must include in your query:

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

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

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

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

EXEC SubmitOverrideFeed OverrideFeedAggregate = 'OverrideFeedAggregate#TEMP'

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

For XML aggregate

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

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

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

Input

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

Result Set Columns

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839