CatalogModifiers

Query the available catalog modifiers.

Table Specific Information

Retrieve all catalog modifiers:

SELECT * FROM CatalogModifiers

To create an item, you will need to specify the Name column.

INSERT INTO CatalogModifiers (Name) VALUES ('Cat Created 2')

Modify the details of an existing CatalogModifiers by providing the Id of the Modifier:

UPDATE CatalogModifiers SET Name = 'Cat Updated' WHERE ID = '1234'

Delete a category object by providing the Id of the Categories:

DELETE FROM CatalogModifiers WHERE Id = '32123'


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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Type	String	The catalog object type to be modified.