Brands
Gets the collection of brands.
Table Specific Information
Select
The connector uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=, >, <, >=, <=' comparison.
- Name supports the '=' comparison.
The rest of the filter is executed client-side within the connector.
For example, the following queries are processed server-side:
SELECT * FROM Brands WHERE Id = 1 SELECT * FROM Brands WHERE Id >= 1 AND Id <= 5
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The id of the brand. | |
| Name | String | False |
The name of the brand. Must be unique. | |
| PageTitle | String | False |
The title shown in the browser while viewing the brand. | |
| MetaKeywords | String | False |
Comma-separated list of meta keywords to include in the HTML. | |
| MetaDescription | String | False |
A meta description to include. | |
| ImageFile | String | False |
A valid image. | |
| SearchKeywords | String | False |
A comma-separated list of keywords that can be used to locate this brand. |