ProductMedia is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table.

Table Specific Information

Select

The driver uses the AdobeCommerce API to filter the results by Sku while the rest of the filter is executed client side within the driver.

The Sku column must be specified in the WHERE clause to retrieve results from ProductMedia. Sku can be used only with the equals (=) operator. For example:

SELECT * FROM [ProductMedia] WHERE Sku = 'sjl-8082'

Update

To update a ProductMedia record, you must set Sku and EntryId (refers to the Id column).

UPDATE ProductMedia SET Label = 'lbl new' WHERE EntryId = '1' AND Sku = 'sjl-8082'

Delete

Product media can be deleted by providing Sku and EntryId (refers to the Id column).

DELETE FROM ProductMedia WHERE EntryId = 1 AND Sky = 'sjl-8082'

Columns