While RAW Data Reports offer good details about Customers/Orders, while I am trying to write a yearly report, some of the options have either missing data or way too much data to sort through, highlighted below:
Raw Data Exports
Customers
A list of customers that were acquired during a specified date range. The data is provided in a raw format which you can export to PDF or Excel.
→ MISSING: Last order SKU
Orders
Need to run a report of all your shipped orders from the past month? Or maybe see from where your orders were placed. Find them here!
→ TOO MUCH DATA
Shipped Orders
A list of shipped orders in a raw format which you can export to PDF or Excel.
→ MISSING: Order SKU
Shipped Items
A list of items shipped during a specified date range summarized by SKU.
→ MISSING: Shipped address, city, state; Customer name, email, phone
• Developer Section
I understand there is a developer section and API requests, etc. Maybe add something similar to reports, where we can build our own request using a simple UI:
or through mySql/database language such as:
GET "customerName", "customerEmail", "customerPhone", "itemSKU", "itemPrice" FROM "/customers" WHERE lastOrderYear="2021";