DiscountsAutomaticBasic

Stores basic automatic discount rules applied at checkout without the use of discount codes.

Table-Specific Information

Select

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

Title supports the '=, !=' comparison operators.
DiscountClass supports the '=, !=' comparison operators.
StartsAt supports the '=, !=, <, >, >=, <=' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM DiscountsAutomaticBasic WHERE Title = 'Val1'
  SELECT * FROM DiscountsAutomaticBasic WHERE DiscountClass = 'Val1'
  SELECT * FROM DiscountsAutomaticBasic WHERE StartsAt = '2023-01-01 11:10:00'

Insert

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

Title, EndsAt, StartsAt, CombinesWithOrderDiscounts, CombinesWithProductDiscounts, CombinesWithShippingDiscounts

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

AppliesOnEachItem, DiscountAmount, ProductsToAdd, ProductsToRemove, MinimumQuantity, MinimumSubtotal

Update

The following columns can be updated:

Title, EndsAt, StartsAt, CombinesWithOrderDiscounts, CombinesWithProductDiscounts, CombinesWithShippingDiscounts

The following pseudo-columns can be used to update a record:

AppliesOnEachItem, DiscountAmount, ProductsToAdd, ProductsToRemove

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 automatic basic discount record.
Title	String	False		The display title of the discount, as shown to merchants or customers.
Status	String	True		The current operational status of the discount, such as active, scheduled, or expired.
Summary	String	True		A detailed description summarizing the terms, conditions, and effects of the discount.
DiscountClass	String	True		Defines how this discount interacts with other discounts when applied together, such as whether it is order-level, product-level, or shipping-level.
EndsAt	Datetime	False		The date and time when the discount expires. Returns 'null' if the discount is open-ended or ongoing.
ShortSummary	String	True		A brief summary of the discount, typically used for display in lists or summaries.
StartsAt	Datetime	False		The date and time when the discount becomes active.
AsyncUsageCount	Int	True		The total number of times this discount has been used, updated asynchronously and potentially differing from the real-time count.
CreatedAt	Datetime	True		The date and time when this automatic basic discount was created.
CombinesWithOrderDiscounts	Bool	False		Indicates whether this discount can be combined with other order-level discounts.
CombinesWithProductDiscounts	Bool	False		Indicates whether this discount can be combined with other product-level discounts.
CombinesWithShippingDiscounts	Bool	False		Indicates whether this discount can be combined with other shipping-related discounts.
DiscountMinimumQuantityGreaterThanOrEqualToQuantity	String	True		Specifies the minimum number of items that must be purchased for the discount to be applied.

Pseudo-Columns

疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。


Name	Type	Description
AppliesOnEachItem	Bool	If true, the discount value is applied individually to each eligible item. If false, the total discount amount is distributed evenly across all eligible items.
DiscountAmount	Decimal	The monetary value or percentage amount of the discount applied to the eligible items or order.
ProductsToAdd	String	A comma-separated list of product IDs to which the discount will be newly applied.
ProductsToRemove	String	A comma-separated list of product IDs from which the discount will be removed.
MinimumQuantity	String	Specifies the minimum number of items required in the cart for the discount to activate.
MinimumSubtotal	String	Specifies the minimum subtotal value required in the order for the discount to be applied.

Code Assist MCP for Shopify