{"id":10560,"date":"2026-05-16T13:30:53","date_gmt":"2026-05-16T05:30:53","guid":{"rendered":"https:\/\/aeosub.com\/gst-report-for-woocommerce\/"},"modified":"2026-05-16T13:30:53","modified_gmt":"2026-05-16T05:30:53","slug":"gst-report-for-woocommerce","status":"publish","type":"post","link":"https:\/\/aeosub.com\/zh\/gst-report-for-woocommerce\/","title":{"rendered":"GST Report for WooCommerce"},"content":{"rendered":"
\"GST<\/div>\n
\n\n\n\n\n\n\n\n
Developer<\/th>\nSetups Works<\/a><\/td>\n<\/tr>\n
Version<\/th>\nv2.1.0<\/td>\n<\/tr>\n
Active Installs<\/th>\n0 +<\/td>\n<\/tr>\n
Requires \/ Tested<\/th>\n5.9 \/ 6.9.4<\/td>\n<\/tr>\n
Last Updated<\/th>\n2026-05-16 4:57am GMT<\/td>\n<\/tr>\n
Official Link<\/th>\nView Details \u2192<\/a><\/td>\n<\/tr>\n<\/table><\/div>\n
A native PHP GST dashboard for WooCommerce \u2014 CGST\/SGST\/IGST breakdown, Excel export, and PDF tax invoices. No JavaScript frameworks, no REST API.<\/div>\n

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 \u2014 all without leaving WordPress admin.<\/p>\n

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>\n

Key Features<\/h4>\n
    \n
  • Setup Wizard<\/strong> \u2014 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>\n
  • GST Report tab<\/strong> \u2014 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>\n
  • Orders tab<\/strong> \u2014 Card-based order view showing customer name, GSTIN, billing state, order status, and a full per-order GST breakdown (CGST, SGST, IGST).<\/li>\n
  • Products tab<\/strong> \u2014 All published products with thumbnail, SKU, HSN code, price, stock quantity, GST rate, and stock status.<\/li>\n
  • Excel export<\/strong> \u2014 Download the filtered report as a properly formatted .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>\n
  • PDF invoice<\/strong> \u2014 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 \u2014 no manual configuration needed.<\/li>\n
  • Flexible HSN lookup<\/strong> \u2014 Reads HSN from product meta (hsn<\/code>, _hsn_code<\/code>), product attributes (any attribute whose name contains “HSN”), or order-item meta \u2014 whichever is present. Checks variation first, then parent product.<\/li>\n
  • HPOS compatible<\/strong> \u2014 Works with both the classic wp_posts<\/code> order table and WooCommerce High-Performance Order Storage (HPOS\/COT). Detects automatically.<\/li>\n
  • Filtering & search<\/strong> \u2014 Filter by start\/end date, sort newest or oldest, search by order ID or billing email. Paginated at 50 orders per page.<\/li>\n
  • Summary stat cards<\/strong> \u2014 Total orders, total products, revenue, total GST collected, and average order value \u2014 calculated via a single SQL aggregation query (no N+1 queries).<\/li>\n<\/ul>\n

    Who Is This For?<\/h4>\n
      \n
    • Indian WooCommerce store owners filing GSTR-1 or GSTR-3B returns<\/li>\n
    • Stores selling to GST-registered buyers (B2B) who need tax invoices with GSTIN<\/li>\n
    • Accountants or store managers who need a quick Excel export of GST data for a given period<\/li>\n
    • Stores in Tamil Nadu (TN) needing CGST + SGST split, or any other state needing IGST<\/li>\n<\/ul>\n

      How GST Calculation Works<\/h4>\n

      The plugin uses WooCommerce’s own tax totals stored against each order line item:<\/p>\n

        \n
      • Intra-state (TN):<\/strong> If billing state is Tamil Nadu, tax is split 50\/50 as CGST + SGST.<\/li>\n
      • Inter-state:<\/strong> All other billing states are treated as IGST.<\/li>\n
      • 5% GST:<\/strong> Products assigned to a tax class whose name contains 5<\/code> (e.g. “GST 5%”) are reported under the 5% columns.<\/li>\n
      • 18% GST:<\/strong> All other taxed products are reported under the 18% columns.<\/li>\n
      • 0% \/ Exempt:<\/strong> Products with no tax are reported under the zero-rated supply column.<\/li>\n<\/ul>\n

        Technical Notes<\/h4>\n
          \n
        • Pure PHP \u2014 no JavaScript frameworks, no React, no REST API.<\/li>\n
        • All data fetched via WC_Order_Query<\/code> and direct SQL with $wpdb->prepare()<\/code>.<\/li>\n
        • All $_GET<\/code> input is sanitised with sanitize_key()<\/code>, sanitize_text_field()<\/code>, absint()<\/code>, and wp_unslash()<\/code>.<\/li>\n
        • All output escaped with esc_html()<\/code>, esc_url()<\/code>, esc_attr()<\/code>, wp_kses_post()<\/code>.<\/li>\n
        • Stats query result cached with wp_cache_get\/set<\/code>.<\/li>\n
        • Nonce-protected on all export actions.<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"

          A native PHP GST dashboard for WooCommerce \u2014 CGST\/SGST\/IGST breakdown, Excel export, and PDF tax invoices. No JavaScript frameworks, no REST API.<\/p>","protected":false},"author":1,"featured_media":9317,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[252],"tags":[908,909,910,911,569,555],"class_list":["post-10560","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-trends","tag-gst","tag-india","tag-invoice","tag-tax","tag-woocommerce","tag-wordpress-plugin"],"_links":{"self":[{"href":"https:\/\/aeosub.com\/zh\/wp-json\/wp\/v2\/posts\/10560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aeosub.com\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aeosub.com\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aeosub.com\/zh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aeosub.com\/zh\/wp-json\/wp\/v2\/comments?post=10560"}],"version-history":[{"count":0,"href":"https:\/\/aeosub.com\/zh\/wp-json\/wp\/v2\/posts\/10560\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aeosub.com\/zh\/wp-json\/wp\/v2\/media\/9317"}],"wp:attachment":[{"href":"https:\/\/aeosub.com\/zh\/wp-json\/wp\/v2\/media?parent=10560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aeosub.com\/zh\/wp-json\/wp\/v2\/categories?post=10560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aeosub.com\/zh\/wp-json\/wp\/v2\/tags?post=10560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}