How to separate orders and include SKU for Online Store sales report.

Is there a way to have the Online Store sales report to separate the orders coming from the same customer? Currently it appears that we are only able to generate an Online Store sales report where multiple/different items coming from the same person are bundled under Order Description.
 
Also, is it possible to have the SKU number show up on Online Store sales report?
 
Having orders separated will help us speed up inventory management, and having SKU numbers will help us sort/prepare orders faster.
 
Able to generate the following format Online Store sales report now: 
Name:  XYZ
Order Description:  item A - 2 X item B
 
Looking for how to generate the following format:
Name:  XYZ
Qty: 1,  Order Description: item A, SKU:A1A
Qty: 2,  Order Description: item B, SKU: B1B
 
4,647 Views
Message 1 of 4
Report
3 REPLIES 3
Square Community Moderator

Hi @French-Baker

 

Which report were you looking at currently? Was this through the Sales Summary section using custom reporting filters? Or were you referring to the order descriptions from the Online Store section that gets broken down by "completed" and "open" status? 

 

There's not currently a way to customize reports to reflect those specific details the way that you're describing from the reporting tools themselves, but there might be some workarounds that we can try. 

4,637 Views
Message 2 of 4
Report

Hello @EJ_

 

Thank you for your reply. 

 

I'm looking at the Online Sales report, the one that is generated through the following steps:

 

From the main dashboard,

select Online Store,

select the location,

select Custom date range under Export Order Details

select download CSV.

 
Any workaround that you would like to suggest to get the details for the online sales report, would be greatly appreciated. 
 
 
 
4,632 Views
Message 3 of 4
Report
Square Community Moderator

Thanks for clarifying @French-Baker

 

Unfortunately there's not currently a way to customize the exportable sales reports at this time, and the best workaround that other sellers have mentioned using is to download other reports and combine them together to get the information you need.

 

Any changes to those style reports need to be done manually after downloading the preset report. 

 

I can see how that would be helpful with your orders, so I'll let our Reporting team know it's something that you'd like to see or at least like to easily customize and build on your side. 

4,624 Views
Message 4 of 4
Report