Sum

The Sum action adds together the total of items in a list and provides the sum value, such as the total price of several different orders.

Note

The Sum action returns a value that includes a decimal point, such as 13.0. To return a value without a decimal point, use the floor funtion when you use the results of the Sum action as a variable. For example, instead of {{ sum }}, use {{ sum | floor}}.

Fields

The Sum action contains the following fields.

Fields used in the Sum action.

Field	Description
List	Required. The list of what is totaled by the Sum action.

Returned data

The Sum action itself doesn't take any direct action in your store. Instead, it calculates data from your store and makes this data available for use in subsequent steps in your workflow.

When you add a Sum action to a workflow, steps that follow this action have a Sum variable available in the variable picker. To use the data extracted by your query in following conditions or actions, select Sum in the Returned data section of the configuration panel. For custom created variables, use the Sum object.

Note

If then Sum action is used multiple times in a single workflow, then a number is added to the variable name. For example, in a workflow that uses the Sum action twice, the first variable for returned data is Sum and the second variable is Sum1.

Variables are named accoring to the action, and can't be customized.

Templates

Move large fulfillment orders to another fulfillment location

Move fulfillment orders that have large fulfillable quantities to another fulfillment location. View template

Send email summary with all unfulfilled orders older than 2 days

Get a daily summary of all of your unfulfilled orders that are older than 2 days, making use of schedules, get order data, count, and sum. View template

Tag and send a daily summary of late fulfillments

Every day, tag and send a daily email summary that counts the total number and dollar value of all orders that miss a 2 day shipping guarantee. View template

Use tags to segment customers based on their orders for last 6 months

When a new order is created, get the customer's order total and order count for the last 6 months, and then add tags to the customer. Makes use of Get order data, Count, Sum. View template