SanBar EXPress Store Manager for WooCommerce

By SanBar

0+ active installationsVersion 1.6

Spreadsheet-style bulk product editor for WooCommerce. Edit titles, prices, SKUs, categories, brands, tags, suppliers and images inline.

Description

SanBar EXPress Store Manager for WooCommerce (formerly “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.

The plugin was renamed to reflect what the product line has become: alongside this free edition, there is now a Plus edition with additional store-management tools (attributes, variations, custom fields, fiscal data, price calculator, change history, full backup/sync, and user accounts with per-person permissions). This listing, slug, and update path stay exactly the same — same plugin, new display name.

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, suppliers, thumbnail, gallery, descriptions, and upsells
  • Product Code Manager — GTIN, UPC, MPN, Supplier Code and ISBN fields, checksum validation (GTIN/UPC/ISBN), one field configurable to mirror the SKU automatically; optionally saves as _global_unique_id for Google Shopping / Meta Catalog
  • Bulk actions — per-cell and per-column, including price increase/reduce by R$ or % with optional rounding, and stock quantity/status in bulk
  • Inline taxonomy creation — create categories, brands, and tags without leaving the plugin
  • Library — central screen for categories, brands, tags and suppliers (Plus-only sections such as attributes, custom fields and fiscal presets are shown, clearly marked, as a preview of the Plus edition)
  • Integrations menu — one 🔌 Integrations button in the top bar groups the buttons of the other SanBar plugins you have installed (XML Import, Fiscal Check, IMG Tuner, Catalog Hub), so the toolbar never wraps to a second line
  • Image search by barcode (Plus Only) — search a product picture by its GTIN/SKU in open catalogs from the image popup; shown locked in this edition
  • Built-in duplicate detection for SKU, GTIN, UPC and ISBN — prevents catalog corruption
  • Configurable columns — drag-and-drop reorder, pin left/right, 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
  • Keyboard shortcuts and full spatial keyboard navigation — Ctrl+S to save, Ctrl+Enter to apply popup, Esc to cancel, arrow-key navigation across the whole interface (not just the grid)
  • On-screen numeric keypad — optional floating keypad for Price, Sale, Length, Width, Height and Weight (including inside variations); turn it on per place in the columns panel
  • 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
  • Built-in error log — diagnostic panel for save/API errors, no external tools needed
  • WooCommerce HPOS compatible
  • Translation-ready — all strings use __() / wp.i18n.__(). Portuguese (Brazil) translation included.

Integration with the SanBar Suite

Works on its own. When the other SanBar plugins are installed, they plug into the 🔌 Integrations menu and the product popups, without depending on each other:

  • SanBar EXPress NF-e XML Import — imports purchase invoices and creates products/drafts; inside the Store Manager its window filters the grid to the products just created
  • SanBar EXPress Fiscal Check-BR — colors the fiscal buttons of the grid and of the variations window (gray, red, yellow, green) and opens its diagnosis in a window; with XML Import, the flow XML Import → Fiscal Check → grid filter of the same products happens inside the Store Manager (requires the Plus edition of the Store Manager)
  • SanBar EXPress IMG Tuner — a ⚙ badge on each image of the image popup opens the image editor; the edited picture shows up in the popup and the grid right away
  • SanBar EXPress Catalog Hub — manage product tables and add the selected products to a table
  • SanBar EXPress NF-e & PDV — uses the same fiscal fields edited here to issue NF-e/NFC-e; the store tax regime is shared

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 Store Manager sits between them: a familiar spreadsheet UI with full validation, designed for shop owners who add or update many products per day.

More from sanbazar

Other plugins and tools by the author are listed at software.sanbazar.com.br.

Permissions

  • Reading the sheet requires the edit_products capability.
  • Editing a specific product requires edit_product for that post.
  • Deleting requires delete_product.
  • Creating tags/brands/suppliers requires the corresponding taxonomy edit_terms capability.
  • Listing categories, brands, tags, and suppliers requires edit_products (prevents data exposure to lower roles).

Shop Managers and Editors with proper WooCommerce roles get appropriate access without elevated privileges.

External services

Licensing and the optional Plus trial are handled by Freemius (https://freemius.com). Nothing is sent until you opt in on the first-run screen (or start a trial / enter a license): then the site URL, WordPress, PHP and plugin versions, your admin name and e-mail are sent to https://api.freemius.com. You can skip the opt-in and use every feature of this edition. Terms: https://freemius.com/terms/ — Privacy: https://freemius.com/privacy/

Installation

  1. Upload the sanbar-express-sheet-for-woocommerce folder to /wp-content/plugins/, or install via Plugins → Add New → Upload.
  2. Activate the plugin.
  3. Make sure WooCommerce is active.
  4. Go to Products → SB EXP Store Manager 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), and pa_marca (the Brazilian convention of a global attribute named “Marca”).

Does this edition support variable products, custom fields, or fiscal data?

Editing variations, attributes, custom fields and fiscal data is part of the Plus edition. This edition shows those sections in the Library, clearly marked, so you know what’s available if you need them.

Where are my preferences saved?

Per user, in user_meta, under the key sbsheetplus_col_prefs. Each user gets their own column layout, font size, color, width, and visibility preferences.

Does the plugin modify my data on uninstall?

Only its own per-user preferences and its stats transient. Products, categories, brands, tags, and suppliers are NEVER touched on uninstall — they belong to WooCommerce.

Screenshots

Changelog

1.6

  • New: featured products in the “Promo/Dest” column — ★ button per product (also on variable products) with Always, Dates or Weekdays schedule; uses the native WooCommerce featured flag, updated hourly for schedules.
  • New: copy the featured setting from one product and paste it on others with a click on their ★.
  • New: bulk popup for the “Promo/Dest” column — sale price (replace, % off regular price, increase, decrease, remove), sale dates (set or clear) and featured (on/off, schedule or same as sale dates).
  • New: Status and Visibility — right-click switches the option of the cell; with several cells selected, “Set…” applies one option to all.
  • Tweak: selected Status, Visibility and variable-product cells are now highlighted.

1.5

  • New: free 3-day trial of the Plus edition, no credit card required — “Try Plus free” button in the toolbar; licensing handled by Freemius (opt-in).
  • New: license card in Settings with account, upgrade, support and contact links.
  • New: on-screen numeric keypad for Price, Sale, Length, Width, Height and Weight (optional, per place in the columns panel).
  • New: 🔌 Integrations menu grouping the buttons of the other SanBar plugins installed.
  • New: MPN/UPC are also written to the generic mpn and ean keys, for compatibility with feed and SEO plugins.
  • Fix: editing the slug together with the title, status or descriptions in the same save no longer reverts the slug.
  • Fix: thumbnail set on a new product is kept after the first save.

1.4

  • Renamed: the plugin is now “SanBar EXPress Store Manager for WooCommerce” (previously “SanBar EXPress Sheet for WooCommerce”). Same plugin, same slug, same update path — only the display name changed.
  • New: Suppliers — dedicated taxonomy with document, internal code, phone, email, site, contact and notes per supplier; manageable from the sheet and the Library.
  • New: Library screen — central management for categories, brands, tags and suppliers, with Plus-only sections shown as a preview.
  • New: built-in error log panel — diagnostic view of save/API errors, with an unread-error indicator on the toolbar.
  • New: bulk actions extended to a full per-cell/per-column menu (price increase/reduce by R$ or %, optional rounding; stock quantity and status in bulk).
  • New: spatial keyboard navigation across the whole interface, not just the main grid.
  • New: description editor gets richer text formatting — text and background/highlight color (same swatch palette used for column colors), plus adjustable font size (6–64px, with +/− controls) for the full description field.

1.3

  • New: Product Code Manager — GTIN, UPC, MPN, Supplier Code and ISBN fields for each product, accessed via a button next to SKU; configure which field mirrors the SKU automatically, from the column settings panel
  • New: checksum validation and duplicate detection extended to UPC and ISBN (previously GTIN only)
  • Improvement: save errors now open a detailed modal listing the exact reason per product (e.g. invalid or duplicate code), instead of a generic “see console” message
  • Fix: sanitization gap on Supplier Code / MPN fields before saving to the database

1.2

  • New: column pin — lock any column to the left or right edge, keeping it visible while scrolling
  • New: smart input expand — active fields grow on focus for comfortable editing; configurable per column
  • New: cross-highlight with customizable colors — organized palette of 8 pastel families, 3 tones each
  • New: column panel shows available Plus features as visual locked cards with diagonal ribbon badge
  • New: new product modal with visual type cards; Simple type available in this edition
  • Improvement: column settings panel redesigned with cleaner card layout and per-column controls
  • Compatibility: tested and declared compatible with WooCommerce 9.5
  • Fix: stable tag updated to match plugin version

Nota: o changelog de versões anteriores a 1.2 não está documentado neste arquivo.