Skip to content

Instantly share code, notes, and snippets.

@Tomasz-Silpion

Tomasz-Silpion/payments.sql

Created July 20, 2016 17:20
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Tomasz-Silpion/01ab5349244941f0c21b97aca5fa0677 to your computer and use it in GitHub Desktop.
Save Tomasz-Silpion/01ab5349244941f0c21b97aca5fa0677 to your computer and use it in GitHub Desktop.
Download ZIP
Get all customers payment methods between range of dates from Magento database
Raw
payments.sql
SELECT
o.grand_total AS 'Order Total',
o.created_at AS 'Payment Day',
p.method AS 'Payment Method',
CONCAT_WS(' ', o.customer_firstname, o.customer_lastname) AS 'Customer Name',
o.increment_id AS 'Order Number'
FROM sales_flat_order o
LEFT JOIN sales_flat_order_payment p ON p.entity_id = o.entity_id
WHERE (o.created_at BETWEEN '2016-01-01' AND '2016-12-31')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment