Description
SanBar EXPress Sheet for WooCommerce brings a fast, keyboard-friendly, spreadsheet-style editor for your WooCommerce catalog. No more clicking into one product at a time — see and edit dozens of products on a single screen.
Features
- Inline editing for title, slug, status, price, SKU, weight, dimensions, and visibility
- Popups for categories (hierarchical), brands (auto-detects WC Brands, Perfect Brands, YITH Brands), tags, thumbnail, gallery, descriptions, and upsells
- GTIN/EAN-13 validation with checksum verification — optionally save SKU as
_global_unique_idfor Google Shopping / Meta Catalog - Built-in duplicate detection for SKU and GTIN — prevents catalog corruption
- Configurable columns — drag-and-drop reorder, hide unused columns, font size, border color, width per column — preferences saved per user
- Concurrency-safe — detects when another user is editing the same product and warns before overwriting
- Batch saving — saves multiple products in optimized batches of 5 concurrent requests
- Visual edit indicators — edited rows highlighted with orange left border, edited cells marked with asterisk (*) and orange borders on inputs/selects
- Variable products are recognized — variable products in your catalog are listed and visually flagged (lilac left border); basic fields (title, slug, categories, etc.) remain editable, while variation-driven fields (price, SKU, stock, weight, dimensions) link out to the native WP/WC editor
- Keyboard shortcuts — Ctrl+S to save, Ctrl+Enter to apply popup, Esc to cancel, Tab trap inside popups
- Search by title, SKU, category or tag — automatic detection of code-like search terms, case-insensitive
- Quick stats — total, published, drafts, and out-of-stock counts at a glance
- WooCommerce HPOS compatible
- Translation-ready — all strings use
__()/wp.i18n.__(). Portuguese (Brazil) translation included.
What’s NOT in this edition
This is the free edition. Editing of product attributes, variations and creation of variable/digital products is reserved for the Plus edition — see software.sanbazar.com.br. Existing variable products in your catalog are still listed and partially editable; only the variation-specific operations require the Plus edition.
Why use this plugin?
The native WooCommerce product list is great for browsing but slow for bulk editing. The Quick Edit and Bulk Edit features cover only a few fields. CSV imports are powerful but error-prone. SanBar EXPress Sheet sits between them: a familiar spreadsheet UI with full validation, designed for shop owners who add or update many products per day.
More from SanBar
Other plugins and tools by the author are listed at software.sanbazar.com.br.
Permissions
- Reading the sheet requires the
edit_productscapability. - Editing a specific product requires
edit_productfor that post. - Deleting requires
delete_product. - Creating tags/brands requires the corresponding taxonomy
edit_termscapability. - Listing categories, brands, and tags requires
edit_products(prevents data exposure to lower roles).
Shop Managers and Editors with proper WooCommerce roles get appropriate access without elevated privileges.
Screenshots





Installation
- Upload the
sanbar-express-sheet-for-woocommercefolder to/wp-content/plugins/, or install via Plugins Add New Upload. - Activate the plugin.
- Make sure WooCommerce is active.
- Go to Products SB EXP Sheet to open the editor.
FAQ
-
Does it work with WooCommerce HPOS (custom order tables)?
-
Yes. The plugin declares full HPOS compatibility.
-
What brand taxonomies are supported?
-
Auto-detected, in priority order: WooCommerce’s native
product_brand(WC 9.4+),yith_product_brand(YITH WooCommerce Brands),brand(Perfect Brands for WooCommerce), andpa_marca(the Brazilian convention of a global attribute named “Marca”). -
Does it support variable products?
-
It recognizes variable products — they appear in the grid with a lilac left border so you can tell them apart at a glance. Basic fields (title, slug, status, categories, brands, tags, description, image, visibility) remain editable inline. Variation-driven fields (price, SKU, stock, weight, dimensions) become links to the native WP/WC editor, where you can still manage them normally.
Full inline editing of variations and attributes — including bulk variation generation, per-variation price/stock/SKU/dimensions, and inline attribute term creation — is available in the Plus edition at software.sanbazar.com.br.
-
Can I create new products?
-
Yes. The “+ New product” button opens a chooser with three product types. “Simples” (simple) is fully functional. “Digital” and “Variável” (variable) are reserved for the Plus edition and shown with a “PLUS” badge.
-
Where are my preferences saved?
-
Per user, in
user_meta, under the keysbsheetplus_col_prefs. Each user gets their own column layout, font size, color, width, and visibility preferences. The same key is used by the Plus edition, so upgrading preserves all of your settings. -
Does the plugin modify my data on uninstall?
-
Only its own per-user preferences and its stats transient. Products, variations, taxonomies, and attributes are NEVER touched on uninstall — they belong to WooCommerce.
Reviews
There are no reviews for this plugin.
Contributors & Developers
“SanBar EXPress Sheet for WooCommerce” is open source software. The following people have contributed to this plugin.
ContributorsTranslate “SanBar EXPress Sheet for WooCommerce” into your language.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
Changelog
1.0.0
- Initial release.
