ListingsItems

Returns details about a listing's item for a selling partner.

Table Specific Information

Select

The driver uses the Amazon Marketplace API to process WHERE clause conditions built with the following column or in the connection string. The rest of the filter is executed client-side within the driver.

SellerId: supports the following operator: =.

The following query is processed server-side:

SELECT * FROM ListingsItems WHERE SellerId = 'XXXXXXXXXXXXXX'

Insert

To insert ListingsItems, you must specify the ProductType, Requirements, Attributes, and SellerId. You can execute the insert in one of two ways.

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

You can also use Bulk Insert:

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, SellerId)
VALUES ('product_type', 'LISTING', 'Attributes#TEMP', '12345', 'XXXXXXXXXXXXXX')

Update

Advanced selling partner use cases can support multiple offers or fulfillment channels for individual listings. To update a specific attribute, all distinct records must be set.

UPDATE ListingsItems SET Attributes = '{\"op\":\"add\",\"path\":\"/attributes/fulfillment_availability_quantity\",\"value\":[{\"value\":\"200\"}]}', ProductType = 'LUGGAGE' WHERE SKU = '15700' AND SellerId = 'A1WD8M4EQL9XVH'

Delete

In order to delete ListingsItems, the SellerId needs to be specified.

DELETE FROM ListingsItems WHERE SellerId = 'XXXXXXXXXXXXXX'

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

Columns


Name	Type	ReadOnly	References	Description
SKU [KEY]	String	False		A selling partner provided identifier for an Amazon listing.
FulfillmentAvailability	String	False		Fulfillment availability for the listings item.
Procurements	String	False		The vendor procurement information for the listings item.
ProcurementCostCurrency	String	False		The price (ISO4217 currency code) that you want Amazon to pay you for this product.
ProcurementCostAmount	String	False		The price (numeric value) that you want Amazon to pay you for this product.
Attributes	String	False		This field is required for INSERT statements. Aggregate field containing structured 'AttributeName' and 'AttributeValue' fields.
SellerId [KEY]	String	False		A selling partner identifier, such as a merchant account or vendor code.
Requirements	String	False		This field can be specified for INSERT statements. The allowed values are LISTING, LISTING_PRODUCT_ONLY, LISTING_OFFER_ONLY.
ProductType	String	False		This field is required for INSERT statements.