Workflow Field Definitions
A comprehensive dictionary of product, pricing, and inventory attributes available for automation logic.
1. Event Triggers
Events define the specific change in the system that initiates a workflow.
-
Product [Field] Changed: Triggers when a value (Cost, MAP, MSRP, or Stock) is updated at the Master Product level.
-
Vendor SKU [Field] Changed: Triggers when a value is updated for a specific Vendor-linked SKU, before it is aggregated to the Master Product.
-
Vendor Availability Changed: Triggers when the availability information a vendor reports for a product changes (currently used with Turn 14).
-
Add Product from Catalog: Triggers the moment a new product is imported into your Spark Shipping dashboard from a vendor catalog.
-
Order Imported: Triggers as soon as a new order is received from your integrated storefront. Order workflows require the Premium plan.
2. Product & Identity Fields
These fields identify which items should be affected by the workflow.
-
Product SKU: The unique alphanumeric identifier for the master product.
-
Product Brand: The manufacturer or brand name assigned to the product.
-
Product Type: Defines the structural category of the item:
-
Simple: A standalone product.
-
Bundle: A product comprised of multiple SKUs.
-
Super Bundle: A complex bundle that includes other bundles.
-
-
Product Tags: Custom text labels used to group or categorize products.
-
Product Categories: The categories assigned to the product.
-
Product Weight (lb): The product weight, in pounds.
3. Pricing & Cost Fields
Definitions for the various price points used in calculations.
-
Product Cost: The master cost of the item. This is defined as the "Total Cost" of the lowest-cost, in-stock Vendor SKU. If no linked Vendor SKU is in stock, the lowest Total Cost across all linked Vendor SKUs is used.
-
Lowest Cost Vendor: The name of the vendor whose Vendor SKU currently sets the Product Cost.
-
Product Suggested Price: The calculated price intended for your storefront (often derived from markups).
-
Product MSRP: The master Manufacturer’s Suggested Retail Price. This is defined as the highest available MSRP among the in-stock linked Vendor SKUs (or across all linked Vendor SKUs when none is in stock).
-
Product Lowest MSRP: The lowest available MSRP among the in-stock linked Vendor SKUs (or across all linked Vendor SKUs when none is in stock).
-
Product MAP Cost: The master Minimum Advertised Price. Similar to MSRP, this value is defined as the highest available MAP among the in-stock linked Vendor SKUs (or across all linked Vendor SKUs when none is in stock).
-
Product Bundle Cost: The cumulative cost of all components within a standard bundle.
-
Product Super Bundle Cost: The cumulative cost of all components within a super bundle.
-
Product Bundle MAP / Product Super Bundle MAP and Product Bundle MSRP / Product Super Bundle MSRP: The same totals for MAP and MSRP.
4. Inventory & Custom Data
-
Product Total Stock: The total quantity available across all warehouses and vendors linked to a master SKU.
-
Product User Fields (1-10): Ten customizable data slots used to store unique information not covered by standard fields (e.g., bin locations, special shipping notes, or internal category IDs).
5. Logic Operators
Operators determine how the system evaluates the fields above during a condition check.
| Operator | Definition |
| Equals / Does Not Equal | Matches the exact text or numerical value provided. |
| Contains / Does Not Contain | Identifies if a specific string of text exists within a field (e.g., a specific word in a Tag). |
| Greater Than / Less Than | Compares numerical values, such as identifying products with stock below a certain threshold. |
| Greater Than or Equal / Less Than or Equal | Same as above, but also matches when the values are equal. |
| Is Any Of / Is None Of | Matches when the field equals any (or none) of the values you list, separated by commas. |
| Is Known / Is Blank | Identifies if a field has any data entered or if it is completely empty. |
| Greater Than % Difference / Less Than % Difference | Compares the field with the value or field you choose, as a percentage: (field − value) ÷ value × 100, then checks it against the number you enter. Example: Product MSRP, Greater Than % Difference 40, Product Cost matches when MSRP is more than 40% above Cost. |
| Is a Bundle / Is a Super Bundle / Is Simple | Validates if the product is a Bundle, Super Bundle, or Simple product. |
6. Vendor SKU and Order Fields
-
Vendor SKU events use Vendor SKU fields: Vendor, Vendor SKU Brand, Vendor SKU Category(ies), Vendor SKU Stock, Vendor SKU MSRP, Vendor SKU MAP, Vendor SKU Unit Cost, Vendor SKU Shipping Cost Avg, Vendor SKU Shipping Cost Flat, Vendor SKU User Field 1–5 and Vendor SKU Notes.
-
Order Imported uses order fields such as Order Status, Order Total, Order Vendor Cost, shipping address fields, Customer Email, Order Comment, Internal Notes, Order User Field 1–4, and order item fields marked "(any item)", such as Order Item SKU and Order Item Vendor Name(s).