Gridsmith — Bulk Edit Products & Orders for WooCommerce

Description

Gridsmith lets you bulk edit WooCommerce products in one place. Instead of opening products one by one, you get a spreadsheet grid of your catalogue: click a cell (or move with the arrow keys), type the new value, and save the whole batch with one button. Changed cells are highlighted until they are saved, and problems — a sale price above the regular price, a duplicate SKU — are shown right on the cell.

Watch the demo: video walkthrough of every feature.

The grid loads one page at a time from the server (filtering, sorting and pagination all happen server-side), so it stays fast on catalogues with thousands of products. Every change goes through the WooCommerce product API, so caches, lookup tables and the shop’s price filters stay correct.

Free features

  • Spreadsheet grid for products with image, name, SKU, type, regular price, sale price, stock, stock status and status
  • Inline editing with the keyboard: arrow keys to move, Enter to edit, Esc to cancel, Tab to go right, Ctrl+S to save
  • Dirty-cell highlighting and per-cell validation errors (sale price must be lower than the regular price, SKUs must be unique)
  • Filters: search by name or SKU, category, stock status, product type and status; sortable columns; 20–200 rows per page
  • Bulk price change for the selected rows or for everything matching the filter: increase or decrease by % or a fixed amount, set a price, set the sale price to “regular minus %”, or remove the sale price — with a live example before you apply
  • “Set for selected”: put one value (for example “Out of stock” or “Draft”) into many rows at once
  • Undo the last change — one click restores the previous values (values someone else changed in the meantime are kept)
  • Show/hide columns

Pro features

  • Variation rows in the grid — edit every variation’s price, sale price, SKU and stock; bulk price changes can include variations
  • Orders grid: change the status of many orders at once (filter by status or customer email; HPOS compatible)
  • Coupons grid: code, discount type, amount, expiry date, usage limit and free shipping
  • Category, tag, attribute and custom field columns
  • Find & replace in product titles, short descriptions and descriptions
  • Saved views: name a combination of filters, sorting and columns and reload it in one click
  • Scheduled bulk price changes that run in the background (Action Scheduler or WP-Cron)
  • Change history with one-click rollback of any batch

Get Pro at coodecraft.com.

External services

The free version does not connect to any external service.

The Pro version contacts the Code Craft licence server (coodecraft.com) only when you activate or deactivate a licence key, and once a day to check the licence is still valid. It sends the licence key, the product id and your site URL. Terms: https://coodecraft.com/terms — Privacy policy: https://coodecraft.com/privacy

Screenshots

Installation

  1. Make sure WooCommerce is installed and active.
  2. Upload the gridsmith folder to /wp-content/plugins/ or install the zip from Plugins Add New Upload Plugin.
  3. Activate Gridsmith.
  4. Open Gridsmith Bulk Edit in the admin menu. Your products are listed straight away.

FAQ

Will it slow down my store with thousands of products?

No. The grid only loads the page you are looking at (20–200 rows) and filtering, sorting and searching run on the server. Bulk price changes are processed in small chunks, with a progress bar, so they never time out.

Do changes go through WooCommerce properly?

Yes. Every value is saved with the WooCommerce product, order and coupon objects ($product->set_…()->save()), so product lookup tables, price caches, stock status and hooks used by other plugins all run as normal.

Can I undo a mistake?

Yes. The Undo button restores the previous values of your last save or bulk action. If someone changed one of those values again in the meantime, Gridsmith keeps the newer value and tells you how many were skipped. Pro keeps a full history where any batch can be rolled back.

Why can’t I edit the price of a variable product?

A variable product’s price comes from its variations. In Gridsmith Pro, tick “Show variations” to see and edit each variation in the grid. In the free version, bulk price changes skip variable products and tell you so.

Why is a stock status cell greyed out?

When “Manage stock” is on for a product, WooCommerce works out the stock status from the quantity. Edit the stock number instead — or clear the stock cell to stop tracking stock and choose the status yourself.

Who can use the grid?

Users with the manage_woocommerce capability (Administrators and Shop Managers). All requests use the WordPress REST API with a nonce.

Does it work with HPOS (High-Performance Order Storage)?

Yes. Gridsmith declares HPOS compatibility, and the Pro orders grid reads and saves orders through wc_get_orders() and the order object.

What happens to my data if I delete the plugin?

Nothing, unless you tick “Delete all plugin data when the plugin is deleted” in Gridsmith Settings. Your products are never deleted either way.

Reviews

There are no reviews for this plugin.

Contributors & Developers

“Gridsmith — Bulk Edit Products & Orders for WooCommerce” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

1.0.0

  • Initial release.