CData BizTalk Adapter for Amazon Marketplace 2019 - Online Help
Questions / Feedback?

SubmitPriceFeed

CData BizTalk Adapter for Amazon Marketplace 2019 - Build 19.0.7354

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

Execute

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

You must include in your query :

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

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

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

Exec SubmitPriceFeed PriceFeedAggregate = 'PriceFeedAggregate#TEMP'

Input

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

Result Set Columns

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

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0