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:


Column	Supported Operators
Id	`=`, `>`, `<`, `>=`, `<=`, `IN`, `NOT IN`
Name	`=`
PageTitle	`=`

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;

SELECT * FROM Brands WHERE Id in (51,54);

SELECT * FROM Brands WHERE Id not in (51,54);

SELECT * FROM Brands WHERE PageTitle = 'modern';

SELECT * FROM Brands WHERE Name = 'Test';

Insert

To insert a brand, specify at least the Name column.

INSERT INTO Brands (Name, PageTitle, SearchKeywords) VALUES ('TestBrand', 'Test Brand Page', 'test, brand');

Update

To update a brand, specify the column to update and use the Id to identify the brand.

UPDATE Brands SET PageTitle = 'Updated Page Title' WHERE Id = 1

Delete

To delete a brand, specify its Id.

DELETE FROM Brands WHERE Id = 1

Columns


Name	Type	ReadOnly	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	An array of meta keywords to include in the HTML.
MetaDescription	String	False	A meta description to include.
ImageURL	String	False	Image URL used for this category on the storefront.
SearchKeywords	String	False	A comma-separated list of keywords that can be used to locate this brand.
ItemURL	String	False	The custom URL for the product on the storefront.
ItemURLIsCustomized	Boolean	False	Returns true if the URL has been changed from the default URL assigned by BigCommerce.