# WooCommerce Bulk Order Tools – Status, Tracking & CSV Export

## Overview

Woo Bulk Order Tools is a lightweight, reliable admin utility that speeds up the
everyday order work most WooCommerce stores do by hand: changing statuses in bulk,
adding the same note to many orders, importing tracking numbers from a CSV, and
exporting selected orders to CSV.

It is built to be **stable and trustworthy first**: no external APIs, no telemetry, no
license checks, no upsells in the admin UI, and full compatibility with WooCommerce
High-Performance Order Storage (HPOS).

## Key Features

- **Bulk Status Update** – paste order IDs, pick a status, optionally attach a private
  note. Invalid IDs are skipped and reported.
- **Bulk Order Notes** – add the same note to many orders at once. Private note by
  default; customer notes only when you explicitly choose them.
- **Tracking CSV Import** – import tracking numbers, carriers, tracking URLs, an optional
  status, and a note. Stored locally on each order; no carrier API is contacted.
- **CSV Export** – export selected orders with the columns you choose, with built-in
  protection against spreadsheet formula injection.
- **Built-in Help** tab documenting formats, capability, and limitations.
- **Security-first** – capability checks and nonces on every action, full input
  sanitization and output escaping.
- **HPOS compatible** – uses only the WooCommerce CRUD API.

## Use Cases

- Marking a batch of shipped orders as Completed after a fulfillment run.
- Importing a courier's tracking export into the matching orders.
- Adding an internal note ("checked by warehouse") to a set of orders.
- Pulling a quick CSV of specific orders for accounting or a spreadsheet review.

## CSV Tracking Import

Provide a CSV with a header row.

- **Required columns:** `order_id` (or a numeric `order_number`), `tracking_number`
- **Optional columns:** `carrier`, `tracking_url`, `status`, `note`

```
order_id,tracking_number,carrier,tracking_url,status,note
1234,1Z999AA10123456784,UPS,https://example.com/track/1Z99... number imported.
```

For each valid row the plugin stores tracking meta on the order, adds a private note,
and—if you supply a valid `status`—updates the status. Up to 500 rows are processed per
import by default. Invalid rows are skipped and listed by row number; a malformed header
stops the import safely before any order is touched.

## CSV Export

Pick the orders and the columns. Available columns include order ID, order number,
status, date, billing name, billing email, total, currency, payment method, shipping
method, and the tracking fields. Values that could be interpreted as formulas are
neutralized automatically.

## Requirements

- WordPress 6.0+
- WooCommerce 7.0+ (installed and active)
- PHP 7.4+ (PHP 8.x supported)
- A user with the `manage_woocommerce` capability
- A modern browser
- **No external API required**

## Installation

1. Upload `woo-bulk-order-tools.zip` via **Plugins → Add New → Upload Plugin**.
2. Activate the plugin (WooCommerce must be active).
3. Open **WooCommerce → Bulk Order Tools**.

## Documentation

The download includes a full documentation set: Install guide, User guide, FAQ, Security
overview, Support policy, and a Changelog. A built-in **Help** tab is also available
inside the plugin.

## Support Policy

Support is available through the contact form at https://sggroup.jp/contact/.

It covers installation issues, reproducible bugs, and the documented features. It does not
cover custom development, third-party plugin conflicts beyond basic guidance, server
misconfiguration, or carrier API integrations. Security vulnerabilities can be reported
through the same contact form. See `SUPPORT-POLICY.md` for details.

## Security Notes

- Capability (`manage_woocommerce`) and nonce verification on every action.
- All input sanitized; all output escaped.
- Conservative CSV upload validation (extension, MIME, size, row cap, header check).
- CSV formula-injection protection on export.
- No external network calls, no telemetry, no credentials.

## Limitations

- No automatic carrier tracking, label printing, or rate calculation.
- No live tracking-number validation against carriers.
- No scheduled/automated imports (imports are run manually).
- `order_number` is matched only when numeric; fuzzy matching is not attempted.
- WooCommerce is required; the plugin does nothing without it.

> Screenshots use demo data from a test store.

## Changelog

**1.0.0**
- Initial release: bulk status update, bulk notes, tracking CSV import, CSV export, HPOS
  compatibility, WooCommerce dependency notice.

- Bulk update WooCommerce order statuses from one admin screen.
- Bulk add private or customer order notes to selected orders.
- Import tracking numbers from CSV with optional carrier, tracking URL, status, and note fields.
- Export selected WooCommerce orders to CSV with configurable columns.
- Stores tracking data using WooCommerce order meta through WooCommerce CRUD methods.
- Includes CSV validation, row-level error handling, and a safe 500-row import limit.
- Protects CSV exports against spreadsheet formula injection.
- Includes nonce checks, manage_woocommerce capability checks, sanitization, and escaping.
- Declares WooCommerce HPOS compatibility.
- Shows a safe admin notice when WooCommerce is inactive.
- No external API, no telemetry, no license server, and no remote tracking dependency.
- Includes English documentation, sample CSV files, screenshots, and a support policy.

WordPress 6.0+
WooCommerce 7.0+
PHP 7.4+
Admin user with manage_woocommerce capability
Modern browser
No external API required

Installation Instructions

1. Download the main package from Codester.
2. Unzip the main package on your computer.
3. Inside the package, locate the installable WordPress plugin ZIP:
   woo-bulk-order-tools.zip
4. In WordPress admin, go to Plugins > Add New > Upload Plugin.
5. Upload woo-bulk-order-tools.zip.
6. Activate the plugin.
7. Make sure WooCommerce is installed and active.
8. Go to WooCommerce > Bulk Order Tools.

Basic Usage

Bulk Status Update:
- Open the Bulk Status Update tab.
- Enter WooCommerce order IDs separated by commas, spaces, or new lines.
- Choose the target order status.
- Optionally add a private order note.
- Submit the form and review the result summary.

Bulk Order Notes:
- Open the Bulk Order Notes tab.
- Enter order IDs.
- Enter the note text.
- Choose Private note or Customer note.
- Customer notes are only added when explicitly selected.

Tracking CSV Import:
- Open the Tracking CSV Import tab.
- Upload a CSV file with the required columns:
  order_id, tracking_number
- Optional columns:
  carrier, tracking_url, status, note
- Use the included sample CSV as a starting point.
- The plugin validates the CSV and shows row-level results.

CSV Export:
- Open the CSV Export tab.
- Enter selected order IDs.
- Choose the columns to export.
- Download the generated CSV file.

Requirements

- WordPress 6.0 or newer
- WooCommerce 7.0 or newer
- PHP 7.4 or newer
- An admin user with the manage_woocommerce capability
- No external API is required

Support

Support covers installation issues, reproducible plugin bugs, and documented features.
Support does not include custom development, server configuration, third-party plugin conflicts beyond basic guidance, or carrier API integrations.

Support and security contact:
https://sggroup.jp/contact/