We run a commissioned based hair salon where commissioned employees are paid based on an individual sales numbers. Giving an employee visibility into their individual sales numbers helps us hold them accountable and provides transparency in an industry that's often opaque (to the determent of the employee). I saw a previous thread in here that outlined something similar that was added to feature requests but nothing has showed up in the product yet.
As a workaround we are manually adding item sales from the item sales report by exporting a detailed css from item level sales report and pasting the latest rows to a google sheet that then feeds a custom lookerstudio report permissions to the individual employee (see attached screenshot). This is works well because we can create a report for the individual and permission it to them individually via google.
2 Questions:
1) Is there anything in the product roadmap to enable individual level reporting in square and if so what's the timeline?
2) Is there any way to connect/ automate exports of the item level sales report to a google sheet with all the column level detail (Columns in the report include the following)
| Date | Time | Time Zone | Category | Item | Qty | Price Point Name | SKU | Modifiers Applied | Gross Sales | Discounts | Net Sales | Tax | Transaction ID | Payment ID | Device Name | Notes | Details | Event Type | Location | Dining Option | Customer ID | Customer Name | Customer Reference ID | Unit | Count | Itemization Type | Commission | Employee | Fulfillment Note | Channel | Token | Card Brand | PAN Suffix |
