Ich benötige eine Aufstellung aller offenen Bestellungen (Status “Exported) die eine oder beide der folgenden Artikelnummern enthält:
GOE-38473241
GOE-38473231
In der Aufstellung soll enthalten sein: (Order ID) / Artikelnummer (SKU) /Purchase Date/Payment Method/ E-Mail Adresse des Kunden / Name / Vorname (bill to name)
Select mag2_sales_order.increment_id as 'Order ID',
mag2_sales_order_item.sku,
mag2_sales_order.created_at as 'Datum',
mag2_sales_order.customer_email as 'Email',
mag2_sales_order_address.firstname as 'Vorname',
mag2_sales_order_address.lastname as 'Name',
mag2_sales_order_payment.method as 'Payment'
FROM mag2_sales_order
LEFT JOIN mag2_sales_order_item
ON mag2_sales_order_item.order_id = mag2_sales_order.entity_id
LEFT JOIN mag2_sales_order_address
ON mag2_sales_order_address.parent_id = mag2_sales_order.entity_id
LEFT JOIN mag2_sales_order_payment
ON mag2_sales_order_payment.parent_id = mag2_sales_order.entity_id
WHERE
mag2_sales_order.status ='exported'
and mag2_sales_order_item.sku in ( "GOE-38473241",
"GOE-38473231")
and mag2_sales_order_address.address_type = 'billing'