ChannelListings
Returns a list of all Channel Listings for a specific channel
Table Specific Information
Select
The driver will use the BigCommerce API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.
- Listingid supports the '='.
- ChannelId supports the '='.
- Datecreated supports the '='.
- Datemodified supports the '='.
ChannelId or (ChannelId and ListingId) are required for select.
For example, the following queries are processed server side:
select * FROM ChannelListings WHERE ChannelId=667159 AND ListingId=882998595
Insert
To insert a new ChannelListings, you need to specify at least the following columns: Productid,State,Variants,ChannelId and Name with valid combinations
INSERT INTO ChannelListings (Productid,State,Variants,ChannelId) values(12345,'active','test',667159)
Update
UPDATE ChannelListings SET name ='Test' WHERE ChannelId=667159
Columns
| Name | Type | ReadOnly | Description |
| Listingid [KEY] | Long | True |
The ID of the channel listing that has been created, returned, or updated |
| ChannelId | Integer | True |
The ID of the channel associated with this channel listing |
| Datecreated | Datetime | True |
Date on which the channel listing was first created |
| Datemodified | Datetime | True |
Date on which the channel listing was most recently changed |
| Name | String | False |
Name of the product for this channel listing specifically This is an optional field that can be used to override the product name in the catalog |
| Description | String | True |
Description of the product for this channel listing specifically This is an optional field that can be used to override the product description in the catalog |
| Productid | Integer | False |
The ID of the product associated with this channel listing |
| State | String | False |
The state of the product assignment or channel listing |
| Variants | String | False |
Varriatns |