How many orders customer made?

[nisarek]

Hello,

 

Sometime I receive gifts from manufacturers and I want give them to my customers but I don't have time to check every new order to check if this is first, second or maybe third order made by my customer.

 

It will be great if someone can help me to find solution how make this in invoice.

It could also give how many products he ordered:

Orders: 3 / Products: 5

 

Best Regards.

[Daemonj]

Navigate to Admin > Orders > Customers, select the customer record, and click Orders. You will be shown all of the orders that customer has made.

 

If you want a count to appear for that customer you will have to create that modification.

[nisarek]

Navigate to Admin > Orders > Customers, select the customer record, and click Orders.  You will be shown all of the orders that customer has made.

 

If you want a count to appear for that customer you will have to create that modification.

<{POST_SNAPBACK}>

 

 

I know that I can look to customers history order but if I send 100 parcels every week it is imposible check everythig.

 

My question is: "It is easy way to receive this information/count from db without create new entrys in db?"

[Daemonj]

Yep, just issue a few selects to count the number of records in the orders table for that particular customer_id for the total order count.

 

For the total product count do a select to capture the records in the orders_products table for that particular customer_id. Then walk through and add up the quantity purchased.