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.

YoOhw Studio

<p>YoOhw Tax Invoice Requests for WooCommerce adds a simple, customer-friendly tax invoice request workflow to your WooCommerce store.</p>
<p>Instead of handling invoice requests manually through support tickets or back-and-forth emails, customers can request a tax invoice directly from their order details page. The plugin collects the required invoice details, generates a PDF tax invoice, stores it securely, attaches it to a customer email, and makes it available for download from the customer account.</p>
<p>The plugin is designed for stores that need a lightweight, practical way to collect VAT, GST, ABN, TRN, tax ID, or other regional tax registration details after checkout.</p>
<h4>Key features</h4>
<ul>
<li>Allow customers to request a tax invoice from My Account > Orders.</li>
<li>Show a tax invoice request form on the order details page.</li>
<li>Support guest customers through the order received page when a valid order key is available.</li>
<li>Automatically prefill invoice fields from billing details and previously saved customer invoice details.</li>
<li>Collect company/customer name, tax ID label, tax ID number, country/region, billing address, invoice email, and invoice note.</li>
<li>Generate a PDF tax invoice automatically after a valid request is submitted.</li>
<li>Send the generated tax invoice PDF to the customer by email.</li>
<li>Add a downloadable tax invoice action to the My Account orders list after generation.</li>
<li>Display invoice request details in the WooCommerce order admin screen.</li>
<li>Configure allowed order statuses for tax invoice requests.</li>
<li>Configure seller legal name, seller tax ID, seller address, and seller email.</li>
<li>Configure invoice number prefix and next invoice number.</li>
<li>Show or hide the tax summary by rate in the generated PDF.</li>
<li>Show or hide the tax rate column for order items.</li>
<li>Add a custom footer/legal note to the PDF invoice.</li>
<li>Optionally add a tax invoice request link to WooCommerce customer order emails.</li>
<li>Compatible with WooCommerce High-Performance Order Storage (HPOS) order screens.</li>
</ul>
<h4>Customer workflow</h4>
<ol>
<li>The customer opens an eligible order from My Account > Orders, or opens the order received page with a valid order key.</li>
<li>The customer clicks Request tax invoice.</li>
<li>A modal form opens with prefilled invoice details when possible.</li>
<li>The customer submits the invoice details.</li>
<li>The plugin validates the request, saves the invoice details to the order, and stores reusable invoice details for logged-in customers.</li>
<li>A PDF tax invoice is generated automatically.</li>
<li>The customer receives a WooCommerce-styled email with the PDF attached.</li>
<li>The customer can download the PDF again from the order list or the tax invoice section on the order details page.</li>
</ol>
<h4>Store manager workflow</h4>
<p>Store managers can view the tax invoice request from the WooCommerce order edit screen. The order metabox shows the invoice status, invoice number, company/customer name, tax ID, country/region, invoice email, billing address, invoice note, and a download button when the PDF is available.</p>
<h4>PDF invoice details</h4>
<p>Generated PDF invoices include:</p>
<ul>
<li>Invoice title.</li>
<li>Invoice number and invoice date.</li>
<li>WooCommerce order number and order date.</li>
<li>Currency and payment method.</li>
<li>Seller details.</li>
<li>Customer invoice details.</li>
<li>Order items, quantities, subtotals, tax amounts, and totals.</li>
<li>Optional tax rate column.</li>
<li>Optional tax summary grouped by tax rate.</li>
<li>Optional invoice note from the customer.</li>
<li>Optional footer/legal note configured by the store.</li>
</ul>
<h4>Email behavior</h4>
<p>When a tax invoice PDF is generated, the plugin sends a dedicated customer email with the PDF attached. The email can use WooCommerce email templates and includes the order number and invoice number when available.</p>
<p>You can also enable a request link in customer order emails. When enabled, supported customer emails can include a Request tax invoice button that sends customers to the order page and opens the invoice request form.</p>
<h4>Invoice numbering</h4>
<p>New invoices use the configured invoice number prefix and the next invoice number setting. The default format is:</p>
<pre><code>PREFIX-YEAR-000001
</code></pre>
<p>For example:</p>
<pre><code>TAX-2026-000001
</code></pre>
<p>Existing invoice numbers are preserved and are not regenerated when settings change.</p>
<h4>Security and access control</h4>
<p>The plugin validates invoice requests with WordPress nonces and WooCommerce order permissions. Downloads are protected and only available to authorized users, store managers, or guests with a valid order key. PDF files are generated inside a dedicated uploads folder and served through a permission-checked download handler.</p>
<h4>Where to configure</h4>
<p>Go to:</p>
<p>WooCommerce > Settings > Tax > Tax invoice</p>
<p>Settings are grouped into:</p>
<ul>
<li>General</li>
<li>Seller details</li>
<li>Invoice numbering</li>
<li>PDF display</li>
<li>Customer emails</li>
</ul>


Tax Invoice Requests for WooCommerce

Let customers request tax invoices from WooCommerce order pages, generate PDF invoices automatically, and send them by email.

GST Report for WooCommerce vs Tax Invoice Requests for WooCommerce