Report Pundit
WelcomeStart Free Trial
  • โœจWelcome to Report Pundit Documentation
  • ๐ŸกReport Pundit Website
  • ๐Ÿ’ปReport Pundit App
  • ๐Ÿ›’Shopify Testimonials
  • ๐Ÿ“ŒGetting Started
    • ๐Ÿ‘จโ€๐ŸซWalkthrough
    • โ„น๏ธNavigation Panel
    • ๐Ÿ Home
    • ๐Ÿ“”Library
    • ๐Ÿ’ผMy Reports
    • โฐSchedules
    • โš™๏ธSettings
      • ๐ŸชชAccount
      • ๐Ÿ”Data Sync Options
      • ๐Ÿ› ๏ธReport Formatting
        • ๐Ÿ“…Week Start from Sunday
        • ๐ŸŒ•Include Current Day
        • ๐Ÿ’ฒEnable Currency for Reports
      • ๐Ÿ“€FTP, Google Drive, and Google Sheets
      • ๐ŸŒ€Recent Sync History
      • ๐Ÿ“ฌCustom Email
      • ๐Ÿ‘ฅUser Management
      • ๐Ÿคตโ€โ™‚๏ธShopify staff
    • ๐ŸงฉHow to Create a Custom Report and Auto-Schedule It
  • ๐Ÿง Knowledge Base
    • ๐ŸงพReport Creation
      • Customized Reports
        • Re-arrange columns
      • Filters
        • 'Contains' & 'Not contains'
        • 'Is' & 'Is not'
        • 'Include' & 'Exclude'
        • 'is Blank' & 'is not Blank'
        • 'begins with' & 'ends with'
        • '= Equals' & '!= Not Equals'
        • '> Greater than' & '< Lesser than'
        • '>= Greater than or equal' & '<= Lesser than or equal'
      • Sort
      • ๐Ÿ–Œ๏ธCustom Fields
        • Calculated Columns (Fields)
        • ๐Ÿ›ก๏ธStatic Field
      • Data Comparison
      • Formatting Tools
      • Sharing Report Links
      • Exporting the report
      • Unique Reports
      • Staff Details
      • Other Options
    • ๐Ÿ”—App Integrations
      • Stocky
      • UpPromote
      • Yotpo
      • Sezzle
      • Square
      • PayPal
      • Google Analytics 4
      • Amazon Ads
      • Bing Ads (Microsoft Ads)
      • Facebook
      • Snapchat
      • TikTok
      • Ship Bob
      • Ship Station
      • Ship Hero
      • Bold
      • Printful
      • Printavo
      • Authorize.net
      • Recharge Payments
      • Klarna
      • Shippo
      • Returnly
      • Rich Returns
      • Seal Subscriptions
      • Google Ads
      • Stripe
    • ๐Ÿ“ฅSchedules
      • โŒšHourly
        • "N" Number of Days
        • Week to Date
        • Static Start Date
        • Custom Date Range
      • ๐ŸŒžDaily
        • Custom Time Range
        • Custom Date Range
        • Static Start Date
        • Year to Date
        • Quarter to Date
        • Month to Date
        • Week to Date
        • "N" Number of Days
      • ๐Ÿ“†Weekly
        • Year to Date
        • Quarter to Date
        • Month to date
        • "N" Number of Days
        • Static start date
        • Custom Date Range
      • ๐Ÿ—“๏ธMonthly
        • "N" Number of Days
        • Quarter to Date
        • Year to Date
        • Static Start Date
        • Custom Date Range
      • ๐Ÿ•žSchedule Modification
      • ๐Ÿ”ฝOutput Options
        • Email
        • ๐Ÿ“คFTP
        • ๐Ÿ’ฝGoogle Drive
        • ๐Ÿ—’๏ธGoogle Sheets
        • Power BI
        • BigQuery
    • ๐Ÿ“ƒReport Types
      • ๐ŸคตSales
      • ๐ŸฅกOrders
      • Inventory
      • ๐ŸŽFulfilment
      • Customer
    • ๐Ÿ”„Data Synchronization
      • How to Manage Your Data Mismatch Issue
  • โ“FAQ
    • Reports
    • Schedules
    • Data Sync
    • Billing & Sales
    • Service
  • ๐Ÿ“‹Changelog
Powered by GitBook
On this page
  1. FAQ

Reports

FAQs related to Reports

PreviousHow to Manage Your Data Mismatch IssueNextSchedules

Last updated 10 months ago

Redirecting FAQs

How do I integrate PayPal to generate reports?

  1. How can I change the width of columns in my reports?

A. Column width in reports can be adjusted to a certain extent by dragging column headers. For this, place your mouse pointer on the right border of a column's header. It'll change to indicate the ability to drag that column horizontally.

To view more columns in the report viewer screen, use the Freeze Column option within the column options drop-down menu (click on the arrow pointing downward in the column's header). This fixes the column in its place so that it's easily visible when you scroll across the report viewer screen.

  1. How do Customer Reports work?

A. The data in customer reports comes from the entire history of your store's every customer, including those who've only created an account. By default, these reports capture the full list of your customers.

Note that customer reports don't function based on date ranges/time periods. If you want to view data for a specific duration, do this:

  • Navigate to the Customer Reports section in the reports Library. Click on your desired report to open it.

  • In the report, click on Formatting to open the drop down menu.

  • Toggle the All Time Customer "ON" in the menu.

  • Update the date range as required.

  1. Can I share a link to the report with my staff or partners?

A. Yes, you are enabled to to the reports with others. However, the recipients are permitted to a few

  1. What is Assigned Fulfillment Location and how does it work?

A. Assigned Fulfillment Location is a new feature that makes it easier for customers to manage their orders. With this feature, customers no longer need to manually update the location where their orders will be fulfilled from. Instead, the system can automatically assign the location even before the order is fulfilled. This means customers can save time and effort, and enjoy a more streamlined experience when managing their orders.

How does it work?

A. For existing customers who wish to use the Assigned Fulfillment Location feature, we offer a seamless onboarding process. Follow these steps to get started:

  • Contact our support team at support@reportpundit.com and request access to the Assigned Fulfillment Location feature.

  • Our team will promptly respond and initiate the necessary technical setup to enable the feature for you.

  • Once the setup is complete, log out of your account and log back in to activate the feature.

  • Finally, synchronize your data to see the Assigned Fulfillment Location feature in action.

For new customers, the feature is already integrated and available for use.

  1. Why are my reports not showing draft orders?

A. Report Pundit 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.

  1. Can I see payouts in my Sales report?

A. Report Pundit 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.

  1. Can I reconcile my Paypal Payouts with Report Pundit?

A. Report Pundit can reconcile all the Shopify orders that are paid via Paypal. The information behind each order like Order Number, Order Amount, Discounts, Returns, Net Sales, Shipping, Taxes & Total Sales are reconciled.

Further, the Transaction Fee charged by Paypal, the Net Amount received in PayPal, the Available Balance after each transaction are also recorded.

  1. Will I be able to see the amounts deposited & withdrawn through PayPal?

A. Yes, the deposits & withdrawals made from your bank account through PayPal are recorded with the date.

  1. Which field shows the timeline comment data?

A. 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 Order Event Sync in the Additional Sync Section of the Settings page

  • Once the sync is completed, get in touch with us and we will create a custom field for you

  1. Which language can I use to write functions under Calculated fields?

A. We can perform any arithmetic calculations or case statement inside the calculated field using PostgreSQL.

  1. How do I write a CASE statement?

A. The CASE statement goes through conditions and returns a value when the first condition is met (like a if-then-else statement). 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 ELSE clause. If there is no ELSE part and no conditions are true, it returns NULL.

  • CASE Syntax

CASE
    WHEN condition1 THEN result1
    WHEN condition2 THEN result2
    WHEN conditionN THEN resultN
    ELSE result
END
  • SQL CASE Examples

CASE 
  WHEN [Total Sales] <= 1000 THEN [Total Discounts] * 5
  WHEN [Total Sales] > 100 THEN [Total Discounts] * 10
  ELSE [Total Sales]
END
  1. Can you include additional information about the orders and products like metafields, line_item properties in the report?

  1. Can I view tax collection by county, city & state?

A. Shopify collects various taxes based on the Store delivery Location Zip, or a rule customized & applied for collecting taxes by merchants.

If the store is set to collect the taxes, Report Pundit 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.

  1. How do I know the Best-Selling Products along with their Variant, SKUs, Vendor, and Product type?

A. 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.

If you'd like to see draft orders in your report, kindly and we shall enable the option for you from our end.

A. Yes, we can include additional custom information about the orders and products in the report, associated with apps like . Kindly and we shall set it up for you.

Customized Method: Create a report customized to your requirements. Select the desired fields, sort the fields, and save the report. to learn how to create a customized report.

Have another question not answered in our FAQ? .

โ“
contact us
Infinite Options
contact us
Click here
๐Ÿ™‹
Let us know here
How do I create a customized report?
What are the Pre-Created Reports that you provide?
How do I use filters for the records in the report?
How do I sort the fields in the report?
How do I create custom fields?
How do I create a Static field with fixed inputs?
How do I export a report without scheduling it?
How do I write a CASE statement?
Share Links
How do I select the fields for my report?
How do I edit/rename the fields in the report?
How do I re-arrange the fields?
How do I select the date range for the report?
How do I save a report?
How do I clone/duplicate a report?
How do I delete a report?
How do I add currency symbols to the report values?
How do I add sub-total to my records?
set of features.