PriceLists

Stores all price lists defined for the shop, including currency, context, and applicable customer groups.

Table-Specific Information

Select

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

Id supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  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 identifier for the price list record.
Currency	String	False		The ISO 4217 currency code that defines the currency used for all fixed prices within this price list.
FixedPricesCount	Int	True		The total number of product variant prices explicitly defined as fixed entries on this price list.
Name	String	False		The descriptive, human-readable name of the price list, often used to distinguish regional or promotional pricing sets.
ParentAdjustmentType	String	False		Specifies the type of relative adjustment applied to base prices, such as a percentage markup or discount.
ParentAdjustmentValue	Double	False		The numerical value of the price adjustment. Positive values indicate a price decrease (discount), while negative values indicate a price increase (markup).
ParentSettingsCompareAtMode	String	False		Defines how the compare-at price is handled in the price list, determining whether it is adjusted, inherited, or left unchanged.