
內容簡介
Sales by State Report for SureCart 外掛提供一個報告,顯示按州、縣或省分分組的淨銷售額和總銷售額,幫助用戶了解特定年份的銷售情況,特別適合用於銷售稅或區域規劃。
【主要功能】
• 顯示每州的淨銷售額和總銷售額
• 支援選擇國家、年份及訂單狀態
• 自動從 SureCart API 匯入訂單數據
• 提供可排序的欄位和分頁結果
• 對於無銷售的州顯示為零
外掛標籤
開發者團隊
② 後台搜尋「Sales by State Report for SureCart」→ 直接安裝(推薦)
原文外掛簡介
Sales by State Report for SureCart adds a report showing net and gross sales grouped by state, county, or province, for a chosen year and a chosen set of order statuses.
It appears under SureCart → Sales by State.
Use it when you need to know how much each state bought in a given year, counting only the order statuses that matter for sales tax or territory planning.
This plugin requires SureCart. There are no settings screens to configure. After you activate the plugin, open the report and choose a country, year, and order statuses.
Documentation: salesbystate.com
How to use
Install and activate SureCart, then install and activate this plugin.
Go to SureCart → Sales by State.
Choose a country, a year, and the order statuses that should count.
The table lists Net Sales and Gross Sales for every state in that country.
If the store already has orders, the plugin imports them from the SureCart API into its report table in the background. A progress bar appears until that finishes. You can leave the page; the import continues on its own.
What the report shows
Net Sales and Gross Sales for every state in the selected country
A summary of both figures across all states
Sortable columns and paginated results
States with no sales, shown as zero rather than hidden
Filters
Country — United States, Canada, and United Kingdom. Defaults to the store’s tax address country when that country has states, otherwise the United States.
Year — a rolling list that starts ten years back and gains a year each January without dropping one. Defaults to the current year.
Order status — a checkbox list of SureCart order statuses. Defaults to Paid.
How the figures are calculated
Gross Sales is the checkout total. Net Sales is the checkout total minus tax and shipping. Both use the values SureCart stores on the checkout (converted from cents).
Refunds are not modelled as separate records. An order that has been fully refunded is controlled by the status filter. A partial refund is not deducted from its order’s total.
Performance
Sales for a whole year are answered by one indexed query that returns one row per state. The response size does not grow with the number of orders.
SureCart keeps orders on its API, not in a local WordPress table. Existing orders are imported from the SureCart API into the report table once. After that import, opening or changing the report filters does not call the API.
Data and privacy
The plugin creates one custom database table holding, per order: the order ID, order status, creation and payment dates, billing and shipping country and state codes, currency, and the order, tax, shipping and net totals. It stores no names, addresses, email addresses or any other personal data.
During the one-off import, and when a checkout is confirmed, the plugin reads order, checkout and address data from the SureCart API. It does not send data to any other service, includes no third-party analytics, and collects no telemetry.
Deleting the plugin removes the table and its options.
