WORDPRESS + WOOCOMMERCE / CUSTOM PHP PLUGIN
Update prices
and stock.Confirm every import.
A CSV update should be easy to inspect before it changes the catalogue. This plugin validates the complete file, shows the differences and waits for an administrator’s confirmation.
Independent concept by Ki33 Fictional products · Working local build
with unique SKUs
by the sample CSV
repeated on a clean install
These numbers describe the demo dataset and verification, not commercial results.
01 / THE WORKING APPLICATION
Watch the real import.
Recorded in the running WordPress admin.
57 seconds · Russian captions · 1080p / 30 fps
The WordPress/WooCommerce application runs locally on PHP and MariaDB. Netlify hosts this case study, the recording and downloadable files.
02 / ADMINISTRATOR WORKFLOW
A deliberate update.
One file, one review, one confirmation.
- 01
Upload
The administrator selects a UTF-8 CSV with
sku, price, stock. - 02
Validate
PHP checks every record. Any error blocks the whole file.
- 03
Preview
Compare the old and new prices and quantities before anything is saved.
- 04
Confirm
Apply through the WooCommerce API, then read the saved values back.
03 / EVIDENCE FROM THE APPLICATION
Four states. One working plugin.
Original captures: 1440 × 900.
Select an image to inspect it at full size.
04 / IMPLEMENTATION
The checks happen
on the server.
Custom PHP inside WordPress, using WooCommerce’s product API for the actual updates.
- Permissions & request verification
- Checks
manage_woocommerce,edit_products, each product’s edit permission and separate nonces for validation and application. - A server-side import plan
- The preview belongs to the current user, expires after 15 minutes and uses a single-use confirmation token. Hidden form values cannot override the planned prices.
- Validate the whole file first
- Required fields, exact columns, duplicate and unknown SKUs, price format and integer stock are checked in PHP. An invalid file cannot be applied.
- Recheck before writing
- Permissions and original product values are checked again. A stale preview is rejected when the catalogue has changed.
- WooCommerce CRUD & a transaction
- Product setters and
save()update prices, quantities and availability. InnoDB transactions and locks protect the batch; a save failure rolls back the database changes. - Repeat without duplicates
- Only existing products are updated. Re-uploading matching values reports no new changes, with no second application required.
05 / VERIFICATION
Tested beyond the happy path.
38 integration checks + 24 HTTP checks.
The same checks passed in a separate clean installation.
| Scenario | Verified behaviour |
|---|---|
| Upload and preview | Product values stay unchanged until confirmation. |
| Invalid CSV | All five sample errors are shown; no products change. |
| Correct CSV | Exactly four existing products update; the other eight stay unchanged. |
| Repeat import | No new changes and no duplicate products. |
| Unauthorised request | Anonymous users, subscribers and invalid nonces cannot import. |
| Stale or modified request | Changed products, replayed tokens and tampered client prices cannot overwrite the approved plan. |
| Save failure | An injected failure on the second save rolls back the first product too. |
| Reproduction | New database, generated configuration, 12 seeded products; repeated start and graceful stop verified. |
06 / INSPECT THE WORK
Code, samples and evidence.
Free official components and original code.
Independent concept by Ki33.
Ki33 Catalog CSV ↗
PHP source, admin styles, plugin README and GPL licence.
ZIP / v1.0.0 / 18 KB SOURCE & VERIFICATIONProject sources ↗
Plugin, theme, seed data, setup scripts, automated tests, recording source and documentation.
ZIP / 10.2 MB ACTUAL APPLICATION CAPTURESFour screenshots ↗
Before, validation errors, preview and the saved result.
4 PNG / 1440 × 900Try the plugin in WordPress
Install free WooCommerce, then upload the plugin ZIP through Plugins → Add Plugin → Upload Plugin. Open WooCommerce → CatalogOps · CSV. The examples use the 12 SKUs provided in the project’s seed data.
Scope of this concept
Existing simple products with stock management enabled and no sale price. CSV files up to 1 MB and 1,000 records. Variations, payments, CRM/ERP integrations and production hosting are outside this demonstration. Third-party hook side effects need separate compatibility checks.



