AOV field not exported

Yes. If this is not in usermeta… this plugin cannot imagine where other plugins saves their data out of the standard ones.

Other question: is there a way to export the customer ID ?

The user_id is exported.

I don’t see any user_id in the Meta Keys tab of the plugin, nor in the csv export. What’s the name of the field ?

source_user_id maybe ?

Yes, user_id cannot be used directly because this is different in every installation and can create problems migrating problems with the import tool.

Hi,

In the export your field called ‘_order_count’ is empty.

It’s in the Meta Keys list under the name ‘_order_count’.
So, is there a way to have this field filled in the .csv file ?
Patrick

If this value exists in the usermeta table, it should be filled.

Are you exporting all fields or only a selection? Try to export all fields.

It works well now, even with only selected fields.

Patrick

You have changed anything in your side.

I’ve looked at all my exported lines. All the values of the _order_count column are not filled : some are and some don’t (some that should at least). So it’s very weird.
Patrick

But in the database what appears in the cases where this is empty.

Surely the problem of the plugin who manage this data.

From the back-office, when I search a client from in Woocommerce > Client I see that every customer has his 3 fields filled (number of order, total spent and AOV). In your csv downloaded file, some clients, who should have the ‘number of orders’ filled, have not this field filled.
In the db, I don’t know where to find this information (if you have this information for me, I’ll check the field), but I’m quited sure it’s filled because I can see it in the backend which pulls data form the db.
So, please, could you check why this fies is not exported ?

• This reply was modified 1 year, 9 months ago by antoine69.

I have explained it to you before, but I do it again, I try to do it better:
1) WordPress has two tables to store data related to users users and usermeta.
2) there are plugins that store user data in different tables, in fact although you see it in its tab, it is possible that this data is not even stored but is generated on the fly or in fact, is stored in another different table
3) if you are a developer you can use the hooks that we provide for these cases, we have created them for this type of cases.