PoPayPOS Reports for WooCommerce

Description

PoPayPOS Reports for WooCommerce is a WordPress plugin for generating detailed reports of orders created via the Omni POS application.

The plugin allows site administrators to view detailed analytics for POS orders, including:
— Comparison between POS orders and regular orders
— Daily detailed reports
— Visual graphs
— Export data to CSV/Excel
— Detailed statistics
— Full compatibility with High-Performance Order Storage (HPOS)

System Requirements

• WordPress 5.0 or higher
• WooCommerce 5.0 or higher
• PHP 7.4 or higher

Compatibility

This plugin is fully compatible with WooCommerce High-Performance Order Storage (HPOS).
It uses the WooCommerce Data Store API instead of direct SQL queries, ensuring compatibility with future database changes.

Supported features:
— HPOS enabled
— HPOS disabled (traditional database)
— Automatic switching between systems
— Support for WooCommerce 5.0+

Usage

= Accessing Reports =
1. Go to the WordPress admin panel
2. Navigate to WooCommerce > POS Reports

Creating a Report

1. Select a start date and end date
2. Click Generate Report
3. View results in summary cards, graphs, and tables

Exporting Data

1. Generate a report
2. Select an export format (CSV or Excel)
3. Click Export Report

Features

= Summary Cards =
— Number of POS orders
— Total POS order amount
— Number of regular orders
— Total regular order amount
— Total revenue
— Percentage of POS orders from all orders

Graphs

• Line chart comparing daily revenue
• Bar chart comparing daily order counts

Detailed Tables

• List of all POS orders with direct links
• Daily breakdown of orders and revenue

Data Export

• Export to CSV
• Export to Excel (basic)

Data Structure

The plugin identifies orders with the meta field:
order_source = pos
Orders without this field or with a different value are considered regular orders.

Technical Architecture

= WooCommerce Data Store API =
Instead of direct SQL queries:
php
$orders = wc_get_orders(array(
'limit' => -1,
'status' => array('completed', 'processing', 'on-hold'),
'meta_query' => array(
array(
'key' => 'order_source',
'value' => 'pos',
'compare' => '='
)
)
));

HPOS Detection

`php

if (class_exists(‘Automattic\WooCommerce\Utilities\OrderUtil’)) {
$hpos_enabled = \Automattic\WooCommerce\Utilities\OrderUtil::custom_orders_table_usage_is_enabled();
}
<h3>Customization</h3>= Adding More Fields =
Edit theget_orders_by_sourcefunction:php
private function get_orders_by_source($source, $start_date, $end_date) {
$args = array(
‘limit’ => -1,
‘status’ => array(‘completed’, ‘processing’, ‘on-hold’),
‘date_created’ => $start_date . ‘…’ . $end_date,
‘orderby’ => ‘date’,
‘order’ => ‘DESC’,
‘meta_query’ => array(
array(
‘key’ => ‘your_custom_field’,
‘value’ => ‘your_value’,
‘compare’ => ‘=’
)
)
);
return wc_get_orders($args);
}
`

Styling

Edit assets/css/admin.css.

Troubleshooting

• Plugin not in menu: Ensure WooCommerce is active and you have manage_woocommerce permissions.
• No data in reports: Make sure orders contain order_source = pos and check the date range.
• JavaScript errors: Verify all assets are loading and check browser console.
• HPOS issues: Ensure WooCommerce is updated.

Performance

• Uses WooCommerce Data Store API for efficiency
• HPOS improves performance
• Optimized queries for the active database
• Loads orders in small batches to save memory

Support

For questions or support, contact the plugin developer.

License

This plugin is licensed under the GPL v2 or later.