Returns details about a listings item for a selling partner.

The following filters are required:

• SKU
• SellerId: You can either specify SellerId as a pseudo-column condition in WHERE filters, or in the connection string.

Some example queries:

SELECT * FROM ListingsItems WHERE SKU = '12345' AND SellerId='XXXXXXXXXXXXXX'

INSERT INTO ListingsItems(ProductType, Requirements, Attributes, SKU, SellerId)
VALUES ('product_type', 'LISTING', '{\"AttributeName\": \"test_attribute\", \"AttributeValue\": \"value\"}', '12345', 'XXXXXXXXXXXXXX')

DELETE FROM ListingsItems WHERE SKU = '12345' AND SellerId='XXXXXXXXXXXXXX'

When inserting, you can also use temp tables in order to insert multiple attributes, as shown in the example below:

INSERT INTO Attributes#temp(AttributeName, AttributeValue) VALUES ('attr1','val1')
INSERT INTO Attributes#temp(AttributeName, AttributeValue) VALUES ('attr2','val2')
INSERT INTO Attributes#temp(AttributeName, AttributeValue) VALUES ('attr3','val3')

INSERT INTO ListingsItems(ProductType, Requirements, Attributes, SKU, SellerId)
VALUES ('product_type', 'LISTING', 'Attributes#temp', '12345', 'XXXXXXXXXXXXXX')

Columns

Name	Type	ReadOnly	References	Description
SKU [KEY]	String	True		A selling partner provided identifier for an Amazon listing.
FulfillmentAvailability	String	False		Fulfillment availability for the listings item.
ProcurementCostCurrency	String	True		The price (ISO4217 currency code) that you want Amazon to pay you for this product.
ProcurementCostAmount	String	True		The price (numeric value) that you want Amazon to pay you for this product.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
Attributes	String	This field is required for INSERT statements. Aggregate field containing structured 'AttributeName' and 'AttributeValue' fields.
SellerId	String	A selling partner identifier, such as a merchant account or vendor code.
Requirements	String	This field can be specified for INSERT statements. The allowed values are LISTING, LISTING_PRODUCT_ONLY, LISTING_OFFER_ONLY.
ProductType	String	This field is required for INSERT statements.