Are you exporting all the fields or a list of them?
Hi,
I’ve tried both and in all cases I only have the 2 columns:
_money_spent
wps_wpr_no_of_orders
Whare is AOV column please ?
Thanks
Have you seen this data in usermeta table?
I”ve looked in the db USERMETA table but I didn’t see this field. I”ve found _money_spent and wps_wpr_no_of_orders .
But what should be the name of AOV within your plugin ? I think it’s not there.
Hi again,
I’ve found a record
woocommerce_admin_customers_report_columns
with:
[“date_last_active”,”total_spend”,”avg_order_value”,”country”,”city”,”state”,”postcode”]
Does it help ?
No. This and all plugins that manage used, only check in usermeta column for this kind of data.
If the plugin saves this kind of data in other structures, we should create an addon to manage it.
Well, it’s hard to follow you.
My only question is : why the AOC fiels is not available in .csv export ?
If this is not in the usermeta table -> NO
It could be exported if you, me or anyone make an addon for it.
So it comes from Woocommerce ?
It seems the fields ‘avg_order_value’ is in the table = your first question).
[“date_last_active”,”total_spend”,”avg_order_value”,”country”,”city”,”state”,”postcode”]
No, this is not there. This is a schema.
Anyway WooCommerce is not a table. You should ask the plugin’s author or if you know how to code, you will see it easily in the source code of the other plugin and you can use the hooks we provide to create addons to solve your problem.
Ok so from you side, everything is OK. I see.
But I really don’t understand why you ask me this below, in your first question:
Are you exporting all the fields or a list of them?
Because much people export a list of field and write it badly.
When you export all this problem does not exists beucase the plugin looks for the fields for you.
I’ve tested the all fields (by default) and it’s the same, so it’s normal or not ?