How to automatically update ActiveCampaign records with Zapier Tables when product prices change

Question

Our website (code based) offers 1k products. We plan to use ActiveCampaign for our email marketing. We are wondering how to make a dynamic catalogue offers to our contacts that ensures the pricing and other information are the latest.

So, if a contact purchase Product A

Next week we want to recommend related products based on their recent purchase. However product price can change from time to time. So we want to ensure that before we send the campaign the custom fields in ActiveCampaign are already updated.

We are looking to Zapier Tables as a possible solution to handle the product list, however how do we make sure that whenever there is a price change, all affected contact records in ActiveCampaign will be updated based on the new price.

Also, is there an easier way to have product information from the website to sync into Tables and ActiveCampaign seamlessly?

pranayshinde · Answer

You’ll have to Create a custom field in ActiveCampaign for each product (e.g., Product A Price).

Use a Zapier Webhook to send product data from your website to ActiveCampaign whenever prices change

Zap Trigger: "Webhook by Zapier" (when your website sends a price change event for a product).
Zap Action:
- ActiveCampaign: Update Contact
  - Search for: Contacts with a custom field like "Purchased Products" containing the product ID.
  - Update: The relevant product price field (e.g., Product A Price) with the new value.
In ActiveCampaign, create an email that pulls the latest price from the updated custom field (e.g., %Product A Price%).
Use automation rules to trigger emails based on purchase history.

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded