ProductMediaImages
Stores image media records tied to products, including URLs, alt text, and ordering.
Table-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- ProductId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM ProductMediaImages WHERE ProductId = 'Val1'
Insert
The following columns can be used to create a new record:
ProductId, AltText, MediaContentType, Url
Update
The following columns can be updated:
AltText, Url
Delete
You can delete entries by specifying the following columns:
Id, ProductId
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A unique identifier assigned to the media image record within Shopify. | |
| ProductId [KEY] | String | True |
Products.Id |
The globally unique identifier of the product to which this image belongs. |
| AltText | String | False |
A descriptive word or phrase that explains the content or purpose of the image for accessibility and SEO. | |
| MediaContentType | String | True |
Indicates the type of media content represented, such as 'IMAGE' or other supported formats within the product media system. | |
| Height | Int | True |
The original height of the image in pixels. Returns null if the image is not stored or processed by Shopify. | |
| Width | Int | True |
The original width of the image in pixels. Returns null if the image is not stored or processed by Shopify. | |
| Url | String | False |
The direct URL location where the image file is hosted and can be accessed. |