JDBC Driver for Amazon Marketplace

Build 22.0.8538

SubmitProductFeed

The Product feed contains descriptive information about the products in your catalog. This information allows Amazon to build a record and assign a unique identifier known as an ASIN (Amazon Standard Item Number) to each product.

Execute

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

SubmitProductFeed Has Two main aggregates that need to be entered.

  • ProductDescriptionDataAggregate
  • ProductDataAggregate

You must include in your query :

ProductDescriptionDataAggregate information needs to be entered using ProductDescriptionDataAggregate#TEMP temp table.

INSERT INTO ProductDescriptionDataAggregate#TEMP (Title,Brand,Description,BulletPoint,Manufacturer) VALUES ('test Title','test Brand','test Description','test BulletPoint','test Manufacturer')

ProductDataAggregate info varies by the Category used. The List of all XSD provided by amazon can be found here https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_1_9/Product.xsd

This example will be using the Sports category https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_1_9/Sports.xsd

To add a valid ProductData Sports.xsd must be followed thoroughly and the xml aggregate must be created correctly. This example has the following product Data

  • ProductType = SportingGoods
  • Parentage = Parent
  • VariationTheme = Size (Based on the ProductType selected some of the VariationTheme will be invalid. In these example the Design variation is invalid.)
  • Size = S
  • MaterialComposition = Metal

By following the order of Sports.xsd XSD file the aggregate is :

<Sports>
	<ProductType>SportingGoods</ProductType>
	<VariationData>
		<Parentage>parent</Parentage>
		<VariationTheme>Size</VariationTheme>
		<Size>S</Size>
	</VariationData>
	<MaterialComposition>Metal</MaterialComposition>
</Sports>

This Aggregate is the value of ProductDataAggregate.

INSERT INTO ProductFeedAggregate#TEMP(SKU,ProductDescriptionDataAggregate,ProductDataAggregate) VALUES ('test SKU','ProductDescriptionDataAggregate#TEMP','<Sports>
	<ProductType>SportingGoods</ProductType>
	<VariationData>
		<Parentage>parent</Parentage>
		<VariationTheme>Size</VariationTheme>
		<Size>S</Size>
	</VariationData>
	<MaterialComposition>Metal</MaterialComposition>
</Sports>')

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

EXEC SubmitProductFeed ProductFeedAggregate = 'ProductFeedAggregate#TEMP'

Input

Name Type Required Description
SKU String True Required. Used to identify an individual product. Each product must have a SKU, and each SKU must be unique.
OperationType String True Required. Used to specify the type of operation (Update, Delete or PartialUpdate) to be performed on the data.
StandardProductID String False A standard, unique identifier for a product, consisting of a type (ISBN, UPC, or EAN) and a value that conforms to the appropriate format for the type specified. This is a required field if Type is provided for StandardProductID in the base XSD.
ProductTaxCode String False Amazon's standard code to identify the tax properties for a product.
LaunchDate Datetime False Controls when the product appears from searches and browsing on the Amazon website.
DiscontinueDate Datetime False Controls when the product disappears from searches and browsing on the Amazon website.
ReleaseDate Datetime False The date a product is released for sale.
Condition String False The condition of the item.
Rebate String False The rebate of the product.
ItemPackageQuantity Integer False Number of the same product contained within one package. For example, if you are selling a case of 10 packages of socks, ItemPackageQuantity would be 10.
NumberOfItems Integer False Number of discrete items included in the product you are offering for sale, such that each item is not packaged for individual sale. For example, if you are selling a case of 10 packages of socks, and each package contains 3 pairs of socks, NumberOfItems would be 30.
Title String True Required. Short description of the product.
Brand String False Brand of the product.
Designer String False Designer of the product.
Description String False Long Description of the product.
BulletPoint String False Brief descriptions of the product's features.
PackageDimensionsLength String False Calculated dimensions of the package.
PackageDimensionsWidth String False Calculated dimensions of the package.
PackageDimensionsHeight String False Calculated dimensions of the package.
PackageDimensionsWeight String False Calculated dimensions of the package.
ItemDimensionsLength String False Calculated dimensions of the item.
ItemDimensionsWidth String False Calculated dimensions of the item.
ItemDimensionsHeight String False Calculated dimensions of the item.
ItemDimensionsWeight String False Calculated dimensions of the item.
PackageWeight String False Weight of the package
ShippingWeight String False Weight of the product when packaged to ship.
MerchantCatalogNumber String False Seller's catalog number for the product, if different from the SKU.
MSRP Double False Manufacturer's suggested retail price.
MaxOrderQuantity Integer False Maximum quantity of the product that a customer can order.
SerialNumberRequired Boolean False Indicates whether the product must have a serial number.
Prop65 Boolean False Used if the product is subject to prop 65 regulations in California. US only.
LegalDisclaimer String False Any legal disclaimer needed for the product.
Manufacturer String False Maker of the product.
MfrPartNumber String False Part number provided by the original manufacturer.
SearchTerms String False Terms you submit that give product search results.
PlatinumKeywords String False Values used to map products to nodes in a custom browse structure.
RecommendedBrowseNode String False Value used to classify an item.
Memorabilia Boolean False Used if the product is a memorabilia item.
Autographed Boolean False Used if the product is an autographed item.
UsedFor String False What the product is used for (affects the product's placement in the Amazon browse structure).
ItemType String False Pre-defined value that specifies where the product should appear within the Amazon browse structure.
OtherItemAttributes String False Used to further classify the product within the Amazon browse structure.
TargetAudience String False Used to further classify the product within the Amazon browse structure.
SubjectContent String False Used to relate the product to a specific idea or concept for merchandising.
IsGiftWrapAvailable Boolean False Indicates whether gift wrapping is available for the product.
IsGiftMessageAvailable Boolean False Indicates whether gift messaging is available for the product.
IsDiscontinuedByManufacturer Boolean False Indicates that the manufacturer has stopped making the item.
MaxAggregateShipQuantity Integer False The maximum number of the same item that can be shipped in the same package.
ProductDescriptionDataAggregate String False Section containing category-specific information such as variations. Can be in the form of XML or a #TEMP table.
ProductDataAggregate String False Section containing category-specific information such as variations. Can be in the form of XML or a #TEMP table.
ProductFeedAggregate String False An aggregate representing the feed. Can be in the form of XML, JSON 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8538