PriceLists

All price lists for a shop.

Table-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.

Id supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM PriceLists
  SELECT * FROM PriceLists WHERE Id = 'Val1'

Insert

The following columns can be used to create a new record:

Currency, Name, ParentAdjustmentType, ParentAdjustmentValue, ParentSettingsCompareAtMode

Update

The following columns can be updated:

Currency, Name, ParentAdjustmentType, ParentAdjustmentValue, ParentSettingsCompareAtMode

Delete

You can delete entries by specifying the following column:

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		A globally-unique ID.
Currency	String	False		The currency for fixed prices associated with this price list.
FixedPricesCount	Int	True		The number of fixed prices on the price list.
Name	String	False		The unique name of the price list, used as a human-readable identifier.
ParentAdjustmentType	String	False		The type of price adjustment, such as percentage increase or decrease.
ParentAdjustmentValue	Double	False		The value of price adjustment, where positive numbers reduce the prices and negative numbers increase them.
ParentSettingsCompareAtMode	String	False		The type of price list adjustment setting for compare at price.