manage customer transactions weirdness

[jomo5280]

Store is up and running fine –

found a weird issue –

when a customer orders multiple products,

when i look in my admin -under manage customers –

i get multiple instances of customer name, breaking out his individual cart purchases, on multiple lines, with different Custom ID numbers issued, but with same transaction ID. – super confusing

is there a better way to streamline this? – it looks like the customer did multiple transactions, but in reality just did one –

ideally it would just have customer name with ID – and then have all of the products purchased in that table.

[gamehermit]

I just noticed the same thing. I’m cool with the products being laid out one per line but was a little concerned to see that each line incremented the customer ID. I had a customer buy 20 products today. In the management system the Transaction ID was the same for each of the twenty items…that’s cool. But when I looked in the “Customer ID” column, she started with customer ID 12 and ended with Customer ID 32.

So basically One customer has 20 Customer IDs in the database….for one transaction.

That being said, I just launched the site last night and we had two orders today….I contacted the lady who purchased the 20 items and she told me that the buying experience was super easy….she said she’d be back next year

Jack

[amin007]

The manage customer menu does not show one row for each customer (It doesn’t actually care about the customer in that sense). It creates a row for each purchased item which has many advantages. It also helps the admin manage each item individually if needed (for example: ship each item and then add a note that the item that was shipped or whatever). As far as you are concerned, if you need to find out what a particular customer purchased simply use the search field to search and it will list all the items a customer used. Alternatively, if you need a list of customers that purchased a particular item there is also an option to find that.

[jomo5280]

understood. I guess we are confused by the multiple (different) customer ID’s for the same transaction.

It would be nice if we could somehow visually flag that group of products as being from the same transaction – as opposed to matching up the transactions numbers. Maybe alternate different transactions ID’s from Bold to normal somehow? So if the transaction has the same ID they would all be Bold, then the next transaction would be Normal, and so on… Any thoughts?

thanks!

[pianosteve]

I actually came here searching for info about this very thing because my first customer bought four products, and I noticed this behavior when I went to see how the information would be useful to me. The main problem that I see with doing it this way is in the area of exporting email addresses. If I do an email address export, this particular customer’s email address shows up four times. Maybe the email export can at least be configured to do a SELECT DISTINCT query so duplicates would be filtered out.

[admin]

This post will help you get the customer list however you want it directly from the database:

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

[Author]

Posts