Using the Arigato Database to Select Items for Processing

Arigato now supports using its internal database to select specific items for processing in Bulk Operations and Scheduled Workflows. This gives you more control over exactly which Products, Customers, or Orders are included, based on custom data you've imported or generated.

When to Use the Arigato Database Source

If you’ve imported or stored custom data in the Arigato Database—like tags, scoring data, or external flags—you can now use that data to filter the items you want to process.

Instead of relying on Shopify’s filtering or tags, you can filter by any key-value data stored in the Arigato Database and combine multiple filters using AND logic.

This is especially useful when:

• You want to run a Workflow on only items you've marked in your import.
• You need to filter on complex or external values not stored in Shopify.
• You want to avoid overloading Shopify queries.

Accessing the Arigato Database Source

When creating or editing a Bulk Operation or Schedule, you’ll now see a “Source” selector near the top of the configuration:

• Choose Arigato Database to use your custom database records instead of live Shopify data.

Note: This option only appears for supported resource types:

• Products
• Customers
• Orders
• Draft Orders
• Variants
• Collections

Building a Database Filter

Once Arigato Database is selected, advanced filters become available by default.

Each filter includes:

• Database Key (e.g., import_flag, segment, score)
• Value Type: String or Number
• Comparison Operator: depends on value type
• Input Field: the value or expression to match

You can add multiple filters by clicking + Add Filter. Filters use AND logic, so only records matching all filters will be selected.

Example Filters

Preview and Run

After setting your filters, click Search. The Preview Table shows the items matching your criteria. From there, you can continue exactly as you would with a Shopify-sourced Workflow.

Jobs using the Arigato Database source complete normally—object selection, preview, confirmation, and Actions behave the same.

File Import: Preparing the Arigato Database

To get value from this feature, your database must first contain meaningful values. You can do this through the Database Storage > Import section.

Import Format Requirements

• CSV format only
• Max size: 20MB
• Max rows: under 1 million
• Required Columns:
  • ID — Shopify GID or legacy ID (must be present and valid on all rows)
  • One or more database.key_name columns

Import Rules

• Keys must start with database.
• Keys: under 128 characters
• Values: under 64KB
• Empty cells are skipped
• Enter DELETE to remove a value
• Non-database. columns are ignored
• File upload is disabled while an import is in progress

The app shows a progress banner updating every 5 seconds while importing. The page refreshes automatically when the import is complete.

Exporting From the Database

You can also export existing database records using the Export tab:

• Select a resource type (e.g., Products)
• The exported file is downloaded immediately
• If there are more than 1000 rows, the file is zipped
• A warning appears if no records are found
• "Shop" is not available as an export option

Notes and Limitations

• Filters support Twig, which will be rendered when entered in a filter input.
• Shopify and Arigato Database sources are not combinable—you must choose one per operation.
• Filters apply only to supported object types listed above.
• Imported values should be as specific and concise as possible to ensure clean matching.