Returns a collection of price records

Table Specific Information

Select

The adapter 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 adapter.

• Id supports the '=' comparison.
• DateCreated supports the '=' comparison.
• DateModified supports the '=' comparison.
• Name supports the '=,LIKE' comparison.

For example, the following queries are processed server side:

SELECT * FROM PriceLists

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 new PriceList, you need to specify the following columns: Name and Active

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

Update

To Update the PriceList, you need to specify the following columns: Name and ID

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

Delete

To Delete the PriceList, you need to specify the following columns:ID

DELETE From PriceLists WHERE Id = '4'

Columns