How to find the domain where Shopify has got max order.

0 Shares
0
0
0
0
0
0
0

Client request to give me the report of how many customers have ordered from a certain domain name from Shopify order exports

I am able to do it within 30 mins. 🙂

I have followed the following steps

  1. Downloaded the Order CSV from Shopify Admin
  2. Saved as in Excel Format
  3. Add New Column Next to the Email ID
  4. Using this mixed Mid and Search function, you can quickly get the domain names from the list
    =MID(B2,SEARCH(“@”,B2)+1,255) (Image 1)
  5. Created Private Table. its done 🙂 (Image 2)
Search Domain from Email ID using Formula of Mid and Search
Image 1) – Search Domain from Email ID using Formula of Mid and Search
Shopify Order report via Pivot Table
Image 2) Shopify Order report via Pivot Table

Or You will able to do another method also. TEXT TO COLUMN

  • After Email id add 2 Column
  • Select Email Column
  • Goto Data -> Text to Column -> Delimited -> Next ->
  • Select Other put @ in input -> Finish
  • Follow the same step and create Pivot Table
Search Domain from Email ID via Text to Column
Search Domain from Email ID via Text to Column