How to Export and Analyze Integrity Log Data from WooCommerce Order Integrity Checker

Introduction

WooCommerce Order Integrity Checker maintains a detailed log of all integrity checks performed on your orders. Exporting and analyzing this data can help you identify patterns, improve your store’s data quality, and make informed decisions about order management. This guide will show you how to export log data and analyze it effectively.

Accessing the Integrity Log

To access the integrity log:

1. Navigate to WooCommerce → Order Integrity → Integrity Log in your WordPress admin
2. You’ll see a table listing all integrity check events
3. Each entry shows: date, order ID, severity level, rule code, and message

Exporting Log Data

Method 1: CSV Export via Admin Interface

The easiest way to export log data:

1. Go to WooCommerce → Order Integrity → Integrity Log
2. Use the filter options to narrow down the data you want (optional):
   • Filter by severity (Warning, Critical)
   • Filter by rule code (DUP_EMAIL, HIGH_QTY, etc.)
   • Search by order ID or customer email
3. Click the “Export CSV” button
4. The CSV file will download to your computer

Understanding the CSV Structure

The exported CSV contains the following columns:

• Date: When the check was performed
• Order ID: The WooCommerce order ID
• Severity: Warning or Critical
• Rule Code: The integrity check that triggered (e.g., DUP_EMAIL, HIGH_QTY)
• Message: Description of the issue detected

Analyzing Exported Data in Excel/Google Sheets

Step 1: Open the CSV File

1. Open the exported CSV file in Excel, Google Sheets, or another spreadsheet application
2. Ensure data is properly formatted in columns

Step 2: Create Summary Statistics

Use pivot tables or formulas to analyze patterns:

Count Issues by Type

Create a pivot table to count occurrences of each rule code:

• Rows: Rule Code
• Values: Count of Order ID

This shows which integrity checks trigger most frequently.

Count Issues by Severity

Another pivot table:

• Rows: Severity
• Values: Count of Order ID

This shows how many warnings vs. critical issues you have.

Time-Based Analysis

Group by date to identify trends:

• Rows: Date (grouped by week or month)
• Values: Count of Order ID

This helps identify if issues are increasing or decreasing over time.

Step 3: Identify Problem Patterns

Look for:

• Most Common Issues: Which rule codes appear most frequently
• High-Value Orders: Cross-reference with order totals to see if high-value orders have more issues
• Repeat Customers: Check if the same email/phone appears multiple times
• Time Patterns: Do issues spike at certain times of day or days of the week?

Advanced Analysis Techniques

Combining with Order Data

For deeper insights, combine integrity log data with order data:

1. Export your WooCommerce orders (WooCommerce → Orders → Export)
2. Use VLOOKUP or INDEX/MATCH to join data by Order ID
3. Analyze:
   • Which product categories have more integrity issues
   • Correlation between order value and integrity warnings
   • Geographic patterns (if order data includes location)

Creating Visualizations

Visual representations help identify patterns quickly:

• Bar Chart: Show frequency of each rule code
• Line Chart: Show trends over time
• Pie Chart: Show distribution of severity levels
• Heatmap: Show issues by day of week and hour of day

Interpreting Results

High Frequency of DUP_EMAIL

If duplicate email checks trigger frequently:

• This might indicate repeat legitimate customers (consider allowlisting)
• Could suggest customers sharing accounts
• May indicate potential issues that need investigation

Action: Review individual cases and consider adjusting thresholds or adding to allowlist.

High Frequency of HIGH_QTY

If high quantity warnings are common:

• B2B customers may legitimately order large quantities
• Wholesale orders might need different thresholds
• Could indicate bulk purchases during promotions

Action: Consider product-specific thresholds or customer role-based thresholds.

High Frequency of HIGH_VALUE

If high value warnings are frequent:

• Luxury products naturally have higher order values
• Bulk orders combine to create high totals
• Gift purchases might exceed normal thresholds

Action: Adjust value thresholds based on your product catalog and average order value.

Taking Action Based on Analysis

Adjust Settings

Based on your analysis, you might need to:

• Update thresholds in Settings (duplicate count, quantity, value)
• Add legitimate patterns to the allowlist
• Adjust keyword lists for note-based checks

Improve Store Processes

Analysis might reveal:

• Need for better customer account management
• Opportunities to improve address collection
• Areas where order review processes can be improved

Regular Analysis Schedule

Establish a routine for analyzing integrity log data:

• Weekly: Quick review of recent warnings and critical issues
• Monthly: Comprehensive analysis with full export and statistics
• Quarterly: Deep dive analysis to identify long-term trends and adjust settings

Best Practices

• Export Regularly: Don’t wait until you have a problem to export data
• Keep Historical Data: Archive exports for long-term trend analysis
• Document Findings: Keep notes on patterns you discover and actions taken
• Share Insights: Discuss findings with your team to improve processes
• Review Settings: Regularly review and adjust settings based on data

Privacy and Data Handling

Remember:

• Integrity log data may contain customer information
• Handle exported data securely and in compliance with privacy regulations
• Delete exported files when no longer needed
• Don’t share log data publicly or with unauthorized parties

Conclusion

Exporting and analyzing integrity log data provides valuable insights into your store’s order patterns and data quality. Regular analysis helps you fine-tune settings, identify legitimate patterns for allowlisting, and improve overall order management processes. Use the export feature regularly and make data-driven decisions to optimize your store’s integrity checking system.