More data from Ecommerce Orders

Hello,
New to AC and loving it so far. I spent the weekend configuring, building automations and migrating from hubspot (free).

I am using woocommerce for my store, have the AC integration plugin installed and all is working fine. New orders show up in the ecommerce list in the contact. It has the product name, ID, etc.

I want to get the product URL (most importantly) and maybe a few other fields moved into the most recent Deal. There seems to be no way of doing that today. Also the product URL is not even included in the order data that comes over (this seems like a pretty crucial piece of data to me).

The only way I can imagine doing this is to:

  • use a webhook to POST the contact to my own service
  • in that service, use the woocommerce API to grab the latest order object for the customer
  • call the A/C API to store the URL (and maybe other properties) in a transient field(s) in the contact
  • Have another automation copy that to the deal when it sees them change (hopefully those triggers work when set by API and not just UI)

This seems like a very rube goldberg solution to what should be pretty simple and obvious. Is there an easier way?

Thanks!

1 Like

Hi there! Welcome to the AC Forum and thanks for posting your question here.

You are correct, the Product URL does not come over in the integration as it is set up now, but this might be possible with custom coding using the API (or maybe with Zapier), but it may need an AC consultant or a web developer to write that code. - Unfortunately, our Support team cannot troubleshoot custom code.
We hope this helps. :slight_smile:

Yes use custom fields in the Contact and a copy routine to the Deal table. Mr. Goldberg was involved in that decision in 2004 :slight_smile: