Returns a collection of price records.

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.
• DateCreated supports the =, >, <, >=, and <= comparisons.
• DateModified supports the =, >, <, >=, and <= comparisons.
• Name supports the = and LIKE comparisons.

The rest of the filter is executed client-side within the connector. For example, the following queries are processed server-side:

SELECT * FROM PriceLists WHERE Id = 1 

SELECT * FROM PriceLists WHERE DateCreated = '2021-05-26'

SELECT * FROM PriceLists WHERE DateModified = '2021-05-26'

SELECT * FROM PriceLists WHERE Name LIKE 'Wholesale group1'

Insert

To insert a price list, specify the following columns: Name and Active.

INSERT INTO PriceLists (Name, Active) VALUES ('Wholesalegroup', false)

Update

To update a price list, specify the following columns: Name and Id.

UPDATE PriceLists SET Name = 'Wholesalegroup' WHERE Id = '4'

Delete

To delete a price list, specify the Id column.

DELETE From PriceLists WHERE Id = '4'

Columns