Setups Works

<p><strong>GST Report for WooCommerce</strong> is a lightweight, fast admin dashboard built entirely with native PHP and direct database queries. It generates GST-compliant reports for Indian WooCommerce stores, handles both intra-state (CGST + SGST) and inter-state (IGST) tax calculations across 18% and 5% GST rates, and lets you export to Excel or open a PDF tax invoice in one click — all without leaving WordPress admin.</p>
<p>Designed for Indian store owners who need to file GSTR-1, GSTR-3B, or provide tax invoices to B2B buyers, without the overhead of a full accounting plugin.</p>
<h4>Key Features</h4>
<ul>
<li><strong>Setup Wizard</strong> — On first activation, a guided wizard checks your HSN codes, GST tax rates, and PDF Invoices plugin configuration so your dashboard is accurate from day one.</li>
<li><strong>GST Report tab</strong> — Line-item breakdown per order with CGST/SGST (intra-state) and IGST (inter-state) at 18%, 5%, and 0% rates, with separate columns for each. Cancelled and refunded orders appear as negative entries.</li>
<li><strong>Orders tab</strong> — Card-based order view showing customer name, GSTIN, billing state, order status, and a full per-order GST breakdown (CGST, SGST, IGST).</li>
<li><strong>Products tab</strong> — All published products with thumbnail, SKU, HSN code, price, stock quantity, GST rate, and stock status.</li>
<li><strong>Excel export</strong> — Download the filtered report as a properly formatted <code>.xlsx</code> file using a zero-dependency PHP XLSX writer. Includes date, invoice number, DC number, customer, GSTIN, state, HSN, quantity, subtotal, and all GST columns.</li>
<li><strong>PDF invoice</strong> — Opens the WooCommerce PDF Invoices & Packing Slips invoice for any order in a new tab with one click. Access key is read automatically from the order — no manual configuration needed.</li>
<li><strong>Flexible HSN lookup</strong> — Reads HSN from product meta (<code>hsn</code>, <code>_hsn_code</code>), product attributes (any attribute whose name contains “HSN”), or order-item meta — whichever is present. Checks variation first, then parent product.</li>
<li><strong>HPOS compatible</strong> — Works with both the classic <code>wp_posts</code> order table and WooCommerce High-Performance Order Storage (HPOS/COT). Detects automatically.</li>
<li><strong>Filtering & search</strong> — Filter by start/end date, sort newest or oldest, search by order ID or billing email. Paginated at 50 orders per page.</li>
<li><strong>Summary stat cards</strong> — Total orders, total products, revenue, total GST collected, and average order value — calculated via a single SQL aggregation query (no N+1 queries).</li>
</ul>
<h4>Who Is This For?</h4>
<ul>
<li>Indian WooCommerce store owners filing GSTR-1 or GSTR-3B returns</li>
<li>Stores selling to GST-registered buyers (B2B) who need tax invoices with GSTIN</li>
<li>Accountants or store managers who need a quick Excel export of GST data for a given period</li>
<li>Stores in Tamil Nadu (TN) needing CGST + SGST split, or any other state needing IGST</li>
</ul>
<h4>How GST Calculation Works</h4>
<p>The plugin uses WooCommerce’s own tax totals stored against each order line item:</p>
<ul>
<li><strong>Intra-state (TN):</strong> If billing state is Tamil Nadu, tax is split 50/50 as CGST + SGST.</li>
<li><strong>Inter-state:</strong> All other billing states are treated as IGST.</li>
<li><strong>5% GST:</strong> Products assigned to a tax class whose name contains <code>5</code> (e.g. “GST 5%”) are reported under the 5% columns.</li>
<li><strong>18% GST:</strong> All other taxed products are reported under the 18% columns.</li>
<li><strong>0% / Exempt:</strong> Products with no tax are reported under the zero-rated supply column.</li>
</ul>
<h4>Technical Notes</h4>
<ul>
<li>Pure PHP — no JavaScript frameworks, no React, no REST API.</li>
<li>All data fetched via <code>WC_Order_Query</code> and direct SQL with <code>$wpdb->prepare()</code>.</li>
<li>All <code>$_GET</code> input is sanitised with <code>sanitize_key()</code>, <code>sanitize_text_field()</code>, <code>absint()</code>, and <code>wp_unslash()</code>.</li>
<li>All output escaped with <code>esc_html()</code>, <code>esc_url()</code>, <code>esc_attr()</code>, <code>wp_kses_post()</code>.</li>
<li>Stats query result cached with <code>wp_cache_get/set</code>.</li>
<li>Nonce-protected on all export actions.</li>
</ul>


GST Report for WooCommerce

A native PHP GST dashboard for WooCommerce — CGST/SGST/IGST breakdown, Excel export, and PDF tax invoices. No JavaScript frameworks, no REST API.

GST Report for WooCommerce vs WooCommerce Tax (formerly WooCommerce Shipping & Tax)