Skip to main content
Question

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

  • January 24, 2025
  • 2 replies
  • 12 views

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?

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Forum|alt.badge.img+5

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.


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2532 replies
  • January 27, 2025

Hi ​@semari,


We just wanted to see how everything is going with your Zap. If you need any assistance, feel free to reach out. 

We're happy to address any concerns and assist you.