PriceLists

Lists price lists configured for the shop (for example, business-to-business (B2B) tiers, or markets).

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 Id.
Currency	String	False		The currency used for fixed prices associated with this price list.
FixedPricesCount	Int	True		The total 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 a percentage increase or decrease.
ParentAdjustmentValue	Double	False		The numeric value of the price adjustment, where positive numbers reduce prices and negative numbers increase them.
ParentSettingsCompareAtMode	String	False		The adjustment setting type applied to compare-at prices on the price list.