All the FAQs regarding reports.
- 1.Why are my reports not showing draft orders?
- Data Export is designed to show only actual orders which are either marked as pending or paid.
- This is to prevent the report from showing incorrect sales, which happens when the draft orders get mixed up with actual order data.
- 2.Can I see payouts in my Sales report?
- Data Export features a separate report type called "Payout" and "Payout Line items" to obtain detailed and accurate information about your payout data.
- A Sales report does not contain fields related to Payouts.
- 3.Which field shows the timeline comment data?
- The timeline comments data will be stored under the Order Events section. Hence, we have to create a field for you from our end.
- Enable Event Sync in the Additional Sync Section of the Account page.
- Once the sync is completed, get in touch with us and we will create a custom field for you.
- 4.Which language can I use to write functions under Calculated fields?
- We can perform any arithmetic calculations or case statement inside the calculated field using PostgreSQL.
- 5.How do I write a
CASEstatement goes through conditions and returns a value when the first condition is met (like an
if-then-elsestatement). So, once a condition is true, it will stop reading and return the result. If no conditions are true, it returns the value in the
ELSEclause. If there is no
ELSEpart and no conditions are true, it returns NULL.
WHEN condition1 THEN result1
WHEN condition2 THEN result2
WHEN conditionN THEN resultN
- SQL CASE Examples
WHEN [Total Sales] <= 1000 THEN [Total Discounts] * 5
WHEN [Total Sales] > 100 THEN [Total Discounts] * 10
ELSE [Total Sales]
- 6.Can you include additional information about the orders and products like,
line_itemproperties in the report?
- 7.Can I view tax collection by county, city & state?
- Shopify collects various taxes based on the Store delivery Location Zip, or rules customized & applied for collecting taxes by merchants.
- If the store is set to collect taxes, Data Export will pull the tax information to deliver the tax report. Hence, in order to view the taxes by county, city & state the rule must be applied in your Shopify store to collect these taxes.
- 8.How do I know the Best-Selling Products along with their Variant, SKUs, Vendors, and Product types?
- The above report can be viewed using 3 methods :
- Easy Method: Use the pre-created report template 'Best Selling Products' which you can find under the 'Product & Variant Reports' section. Manually, select the extra fields which you need and save the report.
- Easiest Method: Ask our Live Human Support, and we'll be more than happy to get it done for you.