Øyvind

Found it out myself: SELECT CONCAT(ps_address.firstname, ' ', ps_address.lastname) as firstlast, ps_address.postcode, ps_address.address1, ps_address.phone_mobile, ps_customer.email FROM ps_address INNER JOIN ps_customer ON ps_customer.id_customer=ps_address.id_customer INNER JOIN ps_orders ON ps_orders.id_address_delivery=ps_address.id_address WHERE current_state = 2

My shipping company requires me to upload an Excel sheet with addresses when I order shipping for a batch of orders. The format they require is: Firstname Lastname | Postcode | Address 1 | Mobile phone | Email I use this MySQL query to get firstname lastname, postcode, address 1 and mobile phone: SELECT CONCAT(firstname, ' ', lastname) as firstlast, postcode, address1, phone_mobile FROM `ps_address` INNER JOIN ps_orders ON ps_orders.id_address_delivery=ps_address.id_address WHERE current_state = 2 The only problem is that email is missing. I assume I have to include the "email" from ps_customer, but how do I make it into one query?

No, unfortunately not. I have to respond to all incoming messages via email.

That got me a little bit further, but now this pop-up appear after a while:

Does anyone make the Customer service feedback system in Prestashop version 1.6.0.9 work with Gmail? Customers can send me messages, but when I reply via the back office they don't get my replies. While it works when I answer the feedback via email, it would have been great to have all the communication in the back office. IMAP is enabled for my Gmail address in Gmail's Settings >> Forwarding and POP/IMAP >> IMAP Access I'm using the following settings in Customers >> Customer service: IMAP URL: mail.gmail.com IMAP port: 993 IMAP user: My Gmail address IMAP password: My Gmail address password All settings below this are set to NO, except for IMAP options (/ssl). When I click the Run sync button I get this error message: 'Cannot connect to the mailbox:."No such host as mail.gmail.com"' I'm using the default-bootstrap theme and under Advanced parameters >> E-mail I have selected 'Use PHP's mail() function (recommended; works in most cases)' Is that what's causing the error? Any tips would be greatly appreciated!

Found the solution here: http://www.prestashop.com/forums/topic/355921-order-total-is-not-including-tax/ I downloaded the order-payment.tpl raw file from Github and replaced it with the one in (your-theme)/order-payment.tpl. Seems to work fine.

In my installation of Prestashop v. 1.6.0.9 with the default-bootstrap skin the total sum that calculates total shipping and purchased products incl. tax shows the total without tax. This is misleading for the customers as they are prompted to pay the sum with tax in the payment window. Have I messed up a setting, or is it a bug?