A quick MySQL snippet to count how many times a value appears in a single field—much easier to grok than multiple
COUNT(CASE WHEN meta_value = 'value1' THEN 1 END) AS value1,
COUNT(CASE WHEN meta_value = 'value2' THEN 1 END) AS value2
| value1 | value2 |
| 75 | 56 |
A helper utility to copy Infusionsoft contacts and their order history to Shopify, ignoring Infusionsoft contacts who do not have orders associated with their contact ID.
It also optionally pulls info from a WooCommerce installation.
Get the code from the GitHub repository. Continue reading “Infusionsoft to Shopify Customer History Migration”