CatalogModifiers
Query the available catalog modifiers.
Table Specific Information
Select
Retrieve all catalog modifiers:
SELECT * FROM CatalogModifiers
Insert
To create an item, you will need to specify the Name column.
INSERT INTO CatalogModifiers (Name) VALUES ('Cat Created 2') Update
Modify the details of an existing CatalogModifiers by providing the Id of the Modifier:
UPDATE CatalogModifiers SET Name = 'Cat Updated' WHERE ID = '1234'
Delete
Delete a category object by providing the Id of the Categories:
DELETE FROM CatalogModifiers WHERE Id = '32123'
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
The modifier's ID. |
| Name | String | False |
The modifier's name. |
| UpdatedAt | Datetime | False |
Last modification timestamp. |
| IsDeleted | Boolean | False |
If true, the object has been deleted from the database. When deleted, the UpdatedAt field will equal the deletion time. |
| PriceMoneyAmount | Integer | False |
The modifier's price amount. |
| PriceMoneyCurrency | String | False |
The modifier's price currency. |
| PresentAtAllLocations | Boolean | False |
If true, this object is present at all locations (including future locations), except where specified in the AbsentAtLocationIds field. If false, this object is not present at any locations (including future locations), except where specified in the PresentAtLocationIds field. If not specified, defaults to true. |
| PresentAtLocationIds | String | False |
A list of locations where the object is present, even if PresentAtAllLocations is false. |
| AbsentAtLocationIds | String | False |
A list of locations where the object is not present, even if PresentAtAllLocations is true. |
| Version | Int64 | False |
The version of the object. When updating an object, the version supplied must match the version in the database, otherwise the write will be rejected as conflicting. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Type | String |
The catalog object type to be modified. |