ProductImages
Returns images registered for products.
Table Specific Information
Select
SELECT * FROM ProductImages
There are two alternatives to inserting new product images for BigCommerce, ImageFile and ImageUrl.
Insert using ImageFile
To insert a product image using ImageFile, you only need the ProductId and the local path of your ImageFile, which is written as a string using forward slashes as directory separators. BigCommerce does not allow for additional parameters when inserting an image using ImageFile. Therefore, including extra parameters returns an error.
INSERT INTO ProductImages (ProductId, ImageFile) VALUES (963, 'C:/dev/tests/v19/ProviderBigCommerce/DDHU.jpg');
Insert using ImageUrl
In addition to using ImageFiles, you can add product images by specifying image URLs of images on the web. When inserting image URLs, you can add additional fields to your query, such as Description, SortOrder, and IsThumbnail.
INSERT INTO ProductImages (ProductId, ImageUrl) VALUES (955, 'http://oi50.tinypic.com/kexbfq.jpg');
Update
UPDATE ProductImages SET Description = 'Testing123' WHERE Id = 265
Delete
DELETE FROM ProductImages WHERE Id = 3
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | False |
The Id of the image. | |
| ProductId [KEY] | Integer | False |
Products.Id |
The Id of the corresponding product. |
| ImageFile | String | False |
The local path to the original image file uploaded to BigCommerce. | |
| StandardUrl | String | False |
Standard Image URL for the product. | |
| ThumbnailUrl | String | False |
The thumbnail URL for this image. By default, this is the image size used on the category page and in side panels. | |
| IsThumbnail | Boolean | False |
Flag for identifying whether the image is used as the product's thumbnail. | |
| SortOrder | Integer | False |
The order in which the image will be displayed on the product page. | |
| Description | String | False |
The description for the image. | |
| DateModified | Datetime | True |
The last modification date of the image. | |
| TinyUrl | String | False |
Tiny URL for the product. | |
| ZoomUrl | String | False |
Zoom URL for the product. |
Pseudo-Columns
Pseudo column fields are used to enable the user to INSERT Fields that are non-readable but required during creation of new records.
| Name | Type | Description |
| ImageUrl | String |
The local path to the original image file to be uploaded to BigCommerce. |