Hey @Marco_Langer,
The Level 2 PII requirement applies to all shopifyqlQuery calls, even when your query doesn’t touch customer data.
For troubleshooting the problematic queries, I’d recommend checking the ShopifyQL syntax reference and segment query language reference to verify available columns and query patterns.
As for the zero sales on your dev store, test orders are excluded from analytics by design. The sales reports documentation confirms that test orders placed with Shopify Payments in test mode don’t appear in reports. To see real data, you’d need orders placed with live payment methods.