Organizing a messy store catalog or launching a new seasonal inventory usually means opening dozens of individual products, scrolling down to the taxonomy checkboxes, ticking the right taxonomies, and waiting for the page to update, a slow, click-heavy process that gets old fast.
By pulling your store’s taxonomy structures into a unified grid layout, SheetsPilot Pro completely changes your workflow. You get the speed of spreadsheet editing while keeping absolute control over how your items are classified.
Open Your Field Visibility Panel
To get started, ensure your inventory is loaded by choosing Products from the top dashboard menu. Next, click the Columns icon in the top-right header area. This instantly toggles the Field Visibility & Order sidebar panel, where you can customize which columns show up on your active screen.
View WooCommerce Product Categories Meta Fields in a Table
Inside the sidebar panel, navigate to your store's taxonomy options. Toggle the switch to active so you can edit in a table and manage store hierarchies dynamically:
- Product categories
Once turned on, you can successfully view WooCommerce product categories' meta fields in a table right next to your product names, descriptions, images, and pricing fields.
Fast Table Editing & AI-Driven Scaling
With your store's catalog structure laid out in a clean row-and-column layout, you gain true spreadsheet efficiency. You can catch unassigned items ("Uncategorized") instantly, change groupings manually via the inline cell picker, or leverage the AI Cockpit sidebar to bulk edit WooCommerce product categories' meta fields simultaneously:
- Highlight the specific rows or empty taxonomy cells you want to modify.
- Enter your specialized classification prompt or use template commands like @post_content in the AI Cockpit text field to analyze item data and auto-assign groups.
- Click Apply Prompt.
The system updates your selection immediately, sorting products into accurate store taxonomies so your shop stays cleanly structured and user-friendly.
SheetsPilot Pro bridges the gap between complex e-commerce relational databases and high-speed spreadsheet automation. It gives you the operational capacity of an enterprise merchandising team right inside your dashboard, allowing you to scale your site layout without sacrificing data integrity.
If you are ready to configure your visible fields or need help fine-tuning your automated AI prompts for the best e-commerce organization, our support team is standing by to walk you through it.