Add or Remove Columns in Reports

Shopify Reports sometimes provide too much information or lack the data that you want to see for specific cases. In these cases, you can edit the report yourself on Shopify so that it can display the exact data you wish to view.

In this post, let’s discover how to add or remove columns in your Shopify report to customize the reports as the way you want. 

How to add or remove columns in your reports on Shopify

Step 1: Open a Report

• In your Shopify admin overview dashboard, go to Analytics > Reports
• Choose the report you want to customize.

Step 2: Access the Column Editor

• Once the report is open, locate the “Edit columns” button. It is usually situated above the report table, often on the right side.

Step 3: Add or Remove Columns

Clicking “Edit columns” will open a dropdown list of available columns for that report.

• To Add: Select the checkboxes next to the columns you wish to add to your report.
• To Remove: Deselect the checkboxes next to the columns you want to remove.

Step 4: Apply Changes

• Once you’ve made your selections, click “Apply” to update the report view.

Troubleshooting options

If you happen to encounter one of the following problems while adding or removing columns in your Shopify reports, feel free to view our troubleshooting guide below: 

“Edit Columns” Button Not Visible:

• Report Type: Some default Shopify reports may have fixed column layouts and not offer customization. Try a different report or create a custom report for more flexibility.
• Browser/App Issue: Try clearing your browser cache, using a different browser, or accessing Shopify from a different device/network.
• Account Permissions: Ensure your staff account has the necessary permissions to edit reports.

Certain Columns Not Available:

• Report Type: The available columns vary depending on the specific report you’re viewing. Some reports might not include all possible data points.
• Data Limitations: Certain data might not be available if you haven’t enabled specific features (e.g., tracking specific customer information).
• App Integrations: If you’re looking for data from a third-party app, ensure it’s integrated with Shopify’s reporting system or consider using the app’s own reporting features.

Changes Not Saving or Reflecting:

• Browser Cache: Clear your browser cache and refresh the page.
• Save as New Report: If you’re making extensive changes, consider saving the report with a new name to avoid overwriting the default.

FAQs

Can I customize the columns in all of Shopify’s built-in reports?

Most built-in reports offer customization options for adding or removing columns, but some reports might have fixed layouts. For maximum flexibility, consider creating custom reports.

Is there a limit to the number of columns I can add to a Shopify report?

While there’s no strict limit, adding too many columns can make your report cluttered and difficult to read. Focus on the most relevant data for your analysis.

Can I save my custom column configurations for future use?

Yes, Shopify allows you to save customized reports with your preferred column selections, making it easy to access the same data view later.

I’ve added a new custom field to my products. Can I include that field as a column in my reports?

Yes, once you’ve created a custom field, you can typically include it as a column in your reports, allowing you to analyze and filter data based on that specific attribute.

Are there any third-party apps that can help me create more advanced or customized reports with additional column options?

Absolutely! The Shopify App Store offers various reporting and analytics apps that provide enhanced customization options, including the ability to add custom columns, create complex filters, and generate visual reports.

In conclusion

Our guide has shown you how to easily customize Shopify reports by adding or removing columns, empowering you to focus on the data that truly matters for your business growth. Have any questions about specific report customizations or tips for data-driven decision-making? Share your insights and let’s learn from each other in the comments!