purchase | ADHOC Odoo purchase addons | Portal library

Assuming what I mentioned in my comment on your question, the fix is just to simplify your FieldWithConfidence type significantly. Right now it is trying to add a number of additional levels of structure beyond what you seem to want. Here is a version of that type that works as I think you intend:

We can do something like this:

Prompts because copy1, copy2, copy3 are not fields in data source. They are calculated in query. Fields copy1, copy2, copy3 don't actually exist for purposes of filtering. SQL is okay with doing calculations with calculated fields (your gtotal calc) but WHERE clause expressions must use actual fields from data source. Options:

1. repeat the calculation for each in the WHERE clause: calc1here + calc2here + calc3here > 0

2. build another query that uses working query as data source

3. build a report using working query as RecordSource and apply gtotal filter to report when opening

You need to pair down the customers first so there is only one record per customer:

This is not a dumb question at all. However, GTM by itself does not persist anything, unless you create a tag that writes the utm parameters to cookies or local storage. But then this is probably not relevant for your case, because with the proper configuration, Google Analytics does persist the values by itself (in a manner of speaking).

GA calculates sessions on the GA server by connecting requests with the same client id (or user if, if set). It can look at the first pageview in the session and inspect the url for campaign information such as utm parameters. That way, it does not require that utm parameters are persisted in the browser, the only thing that needs to be stored (by default in a cookie) is the client id.

There is one caveat, that GA starts a new session when the campaign info changes. When you visitor is rerouted via an external domain for payment, a new session will start with the external domain as referrer and the marketing channel set to referrer. To avoid that, you need to add the payment gateway domain to the referral exclusion list (if you use Universal Analytics, there is a similar mechanism for Google Analytics 4), so GA ignores the external domain when the session and channel attribution is calculated. But that's a setting in the Google Analytics interface, you do not need to make changes to GTM for that.

You can use a database like firestore to store all the purchase information. Ex: Users/Auth-id

then retrieve it whenever needed. you can also get the previous purchases with the API

Ex:

I am guessing you want to change the default email template when a user creates a new account.

This email template can be found at : woocommerce/templates/emails/customer-new-account.php and the line you wish to change is L25 here.

If you go through the documentation Template structure & Overriding templates via a theme you will see.

Edit files in an upgrade-safe way using overrides. Copy the template into a directory within your theme named /woocommerce keeping the same file structure but removing the /templates/ subdirectory.

Example: To override the admin order notification, copy: wp-content/plugins/woocommerce/templates/emails/admin-new-order.php to wp-content/themes/yourtheme/woocommerce/emails/admin-new-order.php

What you have to do is to copy the contents of customer-new-account.php and inside your theme ( preferably child theme because of this ) create a file here wp-content/themes/yourtheme/woocommerce/emails/customer-new-account.php and update the line 25 as such.

I would suggest a sub query where you take the union of both, and dedicate a column to the paid amount and another to the due amount. Then apply the aggregation on that sub query:

Here is the query in Postgresql, using mode() to determine the biggest spender, alias the most frequent value for each date in your purchase table