Member Avatar for Ritesh_5

Hi,

i have installed prestashop 1.4.8.2 & i need a report of last order date for each customers, please help me to create mysql query. i need below columns information from database.

id_customer, firstname, lastname, email, last order date.

or is there any way i can export in active customers list (those customers who didn't placed any order for last 3 months.)

thanks,

Ritesh

  • 2 Contributors
  • 2 Replies
  • 448 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by Ritesh_5
Member Avatar for AndrisP 
select * from some_table where `last order date` < date_sub(now(), interval 3 month)
Member Avatar for Ritesh_5

Hi,

   thanks for the reply, but i have no technical knowledge about programming & database, can you create sql query for me compatible to prestashop 1.4.8.2 table structure.

   thank you in advance.

   regards,
   Ritesh
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.