SubmitInventoryFeed

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

Execute

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

For #TEMP tables

You must include in your query:

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

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

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

EXEC SubmitInventoryFeed InventoryFeedAggregate = 'InventoryFeed#TEMP'

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

For XML aggregate

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

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

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

Input


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

Result Set Columns