Supports HTML.

Supports HTML.

Defaults to yes.

You can use positive or negative numbers, like 4 or -3. The number you enter will be added to or subtracted from the current quantity.

You can use positive or negative numbers, like 4 or -3. The quantity will be set to the number you enter.

The customer to update.

Setting any tags here will replace all existing tags for this customer.

If "Yes", taxes won't be applied at checkout for this customer.

E.g. "KY" or "MI"

Country is required if the other address fields are filled.

Defaults to "no".

If "Yes", taxes won't be applied at checkout for this customer.

Product to add this variant to.

What should Shopify do when inventory is exhausted: deny sales or continue selling?

In order to trigger when emails are opened, this must be paired with a separate Zap using the Send Outbound Email action, with the Enable Read Receipts? field set to True.

To test with a live email, send an email to yourself using your Send Outbound Email action (with read receipts enabled) and open it, then test this trigger immediately for samples. If you don't need to test with live data, click Skip Test to use static test data.

Query results must have a unique id field so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.

Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows

Usually something auto-incremented like id. Must be unique. Column names that contain a space must be enclosed within brackets [ ].

Usually something like date_updated or last_modified. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.

Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.

You should include desired ordering and limiting (usually to 1 record) in the query.

This query must run in less than ~30 seconds.

E.g. "KY" or "MI"

Country is required if the other address fields are filled.

Defaults to "no".

If "Yes", taxes won't be applied at checkout for this customer.

An email for your customer.

Only used if you select a product variant below.

Requires a Product chosen above. If you choose a variant, you can still fill in the Product Title and the Product Price to override the regular values.

To use this, please also enter a value in the "Discount - Amount" field.

The "Discount - Type" field determines how this value is used. For a fixed amount, enter 5.00 to discount $5.00. For a percentage, enter .25 to discount 25%.

Defaults to "Custom discount". For the discount to be applied, you must also enter values for Discount Type and Amount.

Extra metadata about the order, defined as key/value pairs. For example, Favorite color: Blue.

Should an order confirmation be sent to the customer?

Should a fulfillment confirmation be sent to the customer?

How do you want your inventory to update with this order? Default is "Bypass".

Where the order originated.

Can use html elements.

Comma Separated list of tags. Will replace existing.

Creates a single product variation in Shopify and assigns the price to this variation.

URL of one or more images to use for this product.

Defaults to yes.

Defaults to yes.

Product to choose the variant for.

Can use html elements.

Comma Separated list of tags.

The date and time when the product was published. This must be a date in the past. Defaults to the current date if left blank.

Creates a single product variation in Shopify and assigns the price to this variation.

What should Shopify do when inventory is exhausted: deny sales or continue selling?

URL of an image to use for this new product.

Defaults to yes.

Defaults to yes.

Customize the private email address associated with your mailbox. Be sure to use lowercase and numbers only. Just forward emails to this address to trigger this Zap. Want to receive to your own email address? Try Mailgun, IMAP, Mandrill, or Gmail instead.

Can be a comma separated list of emails. Limited to 5.

You can place HTML in here and we will send it as is. If this is plain text, we will try to convert it to some very basic HTML for greater client compatibility.

A file object to be attached to the email. Plain text content will converted into a txt file and attached. Please note, if the file is over ~10mb or so, you should explore using other email sending techniques (like Gmail or SMTP).

This will be your "display name" when sending. Want to send from your own email address? Try Mailgun, IMAP, Mandrill or Gmail apps instead.

Specify a reply address other than your own.

Can be a comma separated list of emails. Limited to 5.

Can be a comma separated list of emails. Limited to 5.

Set this to "yes" if your emails are received without line breaks or spacing.

Want to be notified when this email is opened? Set this to to True and set up a Zap using the New Read Receipt trigger.

We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.

Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like date_created or your autoincrement id. Column names that contain a space must be enclosed within brackets [ ].

We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.