Updating WooCommerce Guest Orders

I am pretty sure this works…YMMV – It’s a little brutish, sorry. Create View posts2update AS SELECT p.id, m1.meta_value AS email from ayq_posts p, ayq_postmeta m1, ayq_postmeta m2 WHERE p.ID = m1.post_id and p.ID = m2.post_id AND m1.meta_key = ‘_billing_email’ AND m1.meta_value IS NOT NULL AND m2.meta_key = ‘_customer_user’ AND m2.meta_value = 0 Create View…

Manually Applying Zerobounce Statuses to Groundhogg

There are no date or other filter inputs on the Zerobounce scan form… So, you may find yourself doing the Groundhogg Zerobounce Data Dance…which goes kinda like this: Set a filter for something like Unconfirmed newish, or imported, or other records you consider suspect. Export the records, at least ID and email. Go to Zerobounce,…

Groundhogg Contact Tagging by Variations (Optionally, with Content Restriction)

The Groundhogg WooCommerce integration by default will tag the Contact with a tag for the base product, but tagging variations is not possible in the existing extension. We have solved this issue…updating variation tags on Contacts for past orders, and tagging on new orders as well. We also have some ancillary code to generate the…

Why (and Why Not) Groundhogg? And Why FluentCRM

Aside from the funny name, Groundhogg is certainly a good value. Some companies charge thousands of dollars for a few hours of onboarding training. Almost all CRM and automation companies charge based on the number of contacts in the database, also known as the “success tax”. You will find neither of these (anti-)features in Groundhogg….