Hej!
Prova med detta i ett verktyg som phpmyadmin (om du kommer åt den).
SELECT
’Min Mall’ AS Template
, ’1’ AS Quantity
, CONCAT(adr.firstname, ’ ’, adr.lastname) AS Receiver_First_and_last_name
, ” AS Receiver_CO
, ” AS Receiver_Company_name
, ” AS Receiver_Attn
, cus.email AS Receiver_Email
, SUBSTRING(REPLACE(adr.phone_mobile, ’ ’, ”), 2, 2) AS Receiver_Phone_country_code
, SUBSTRING(REPLACE(adr.phone_mobile, ’ ’, ”), 4, 15)AS Receiver_Phone
, adr.address1 AS Receiver_Address_1
, adr.address2 AS Receiver_Address_2
, ” AS Receiver_Door_Code
, adr.postcode AS Receiver_Postal_code
, adr.city AS Receiver_Postal_city
, cou.iso_code AS Receiver_Country_code
, ” AS Shipment_reference
, ” AS Shipment_description
FROM ps_orders AS ord
LEFT JOIN ps_customer AS cus ON ord.id_customer=cus.id_customer
LEFT JOIN ps_address AS adr ON ord.id_address_delivery = adr.id_address
LEFT JOIN ps_country AS cou ON adr.id_country=cou.id_country
WHERE ord.date_add >= ’2023-11-08’
(den väljer information från den 8e november).
Konstig nog så funkar det inte i prestashop database sökning (i admin gränssnittet). Men jag ska se om jag kan klura ut det med.
.
.
