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