cancel
Showing results for 
Search instead for 
Did you mean: 
WebDev_TMI
New Contributor
Status: New

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:
UI Suggestion

or through mySql/database language such as:

 

GET "customerName", "customerEmail", "customerPhone", "itemSKU", "itemPrice" FROM "/customers" WHERE lastOrderYear="2021";