merchant info

******NOTE:  Keep in mind this was a raw query but it should at least give a pretty accurate picture.  
****** The numbers are in integers, so the total you see in #1 is $17,740,905

1.
    Paid Orders from '2020-06-01 00:00:00' till '2021-06-01 00:00:00'
  It was 121786 orders 
  
  TOTAL:  17740905
  
  by payment_method:
    "credit_card" : 15429414
    "pay_at_pickup" : 24563
    "paypal" : 13540
    "purchase_order" : 222938
    "paypal_express" : 1327322
    "pay_by_check" : 2704
    "already_paid_externally" : 502377
    "paying_externally" : 47319
    "purchase_by_website_owner" : 120757
    "payment_request_button" : 49965
    "custom" : 0
    "local" : 0
    "" : 0
    nil : 0
  
  
  2.
    Paid Orders from  '2021-05-01 00:00:00' till '2021-06-01 00:00:00'
  It was 8973 orders
  
  TOTAL: 1364055
  
  by payment_method:
    "credit_card" : 1160414
    "pay_at_pickup" : 1814
    "paypal" : 1102
    "purchase_order" : 23739
    "paypal_express" : 90096    
    "pay_by_check" : 419
    "already_paid_externally" : 71248
    "paying_externally" : 4130
    "purchase_by_website_owner" : 6617
    "payment_request_button" : 4470
    "custom" : 0
    "local" : 0
    "" : 0
    nil : 0
    
3.  All Orders, comparing 2019 vs. 2020

2019:
    From '2019-01-01 00:00:00' till '2020-01-01 00:00:00'
  There were 67000 Paid orders
  TOTAL: 10362300
2020:
    From '2020-01-01 00:00:00' till '2021-01-01 00:00:00'
  There were 105297 Paid orders
  TOTAL: 15374616
  
4.  Breakdown of customer order volume on stripe vs. authorize.net vs. paypal

  a.
  from '2020-06-01 00:00:00'  till '2021-06-01 00:00:00' there were 121786 Paid orders
  TOTAL : 17740905
  by merchant_name:
    "authorize_net" : 9024954
    "stripe" : 8715950
    "pay_gate_xml" : 0
     nil : 0
  b.
  from   '2021-05-01 00:00:00' till '2021-06-01 00:00:00' there were 8973 paid orders
  TOTAL : 1364055
by merchant_name:
  "authorize_net" : 746884
  "stripe" : 617170
  "pay_gate_xml" : 0
  nil : 0
2019
  "authorize_net" : 6485393
  "stripe" : 3876907
  "pay_gate_xml" : 0
  nil : 0
2020
  "authorize_net" : 8057671
  "stripe" : 7316945
  "pay_gate_xml" : 0
  nil : 0

# A note on the above - these are orders from customers who either chose Stripe or authorize.net.  
They can also activate Paypal as a 2nd payment option.  It is harder to get the paypal transactions, it can be done,
but hopefully this will work for now.  The important thing is that the vast majority probably 80-90% are running through Stripe or Auth.net.