How to Build a WooCommerce Product Catalog Table in WordPress

Updated July 2026 • 7 min read • By Fahad Murtaza

TableCrafter's WooCommerce Products source lets you display your product catalog as a filterable, searchable, exportable table, sorted by category, filtered by stock status, and exportable to CSV. This is particularly useful for B2B wholesale order sheets, internal inventory snapshots, and product lookup tools that the standard WooCommerce shop grid does not handle well. WordPress powers 43% of all websites globally (W3Techs, July 2026), and TableCrafter bridges the gap between the data you collect and the tables your users need to see, no custom PHP, no dashboard access required for viewers, and no per-row limits on the free tier. The free version on WordPress.org supports CSV, JSON, Google Sheets, and Excel. Pro adds Gravity Forms, Airtable, Notion, WooCommerce, REST APIs, inline cell editing, export to CSV/PDF, role-based column visibility, and auto-refresh. Every table embeds on any page with a [tablecrafter] shortcode or the native Gutenberg block. Notion databases support up to 10,000 rows per database on free plans (Notion documentation, 2025).

When to Use a Product Table Instead of the WooCommerce Shop?

The standard WooCommerce shop page is designed for retail browsing, images, prices, add to cart. A product table is better suited for:

If this step produces unexpected output, check the source data directly in the connected system. TableCrafter passes data through without modification — if a cell displays an unexpected value, the source record contains that value. Use the TableCrafter debug log (Settings > Advanced > Debug Mode) to trace the exact query sent to the source and the raw response received, which narrows the diagnosis to either a source-side or rendering-side issue.

• B2B order sheets: Buyers need to see SKU, unit price, pack size, and stock at a glance across hundreds of SKUs, then place one bulk order. A table with checkboxes or quantity inputs is far faster than navigating a shop grid.
• Internal inventory views: Warehouse staff or buyers need to see stock levels across all products, filtered by category and sorted by stock quantity, to identify what to reorder.
• Price lists: Export a current product catalog with prices to send to wholesale buyers or import into a quoting tool.
• Product lookup: Customer service staff need to quickly look up a product by SKU or name to answer customer queries.

Step 1: How Do I Select the WooCommerce Products Source?

Go to TableCrafter → Tables → Add New. In the Data Source dropdown, select WooCommerce: Products (distinct from WooCommerce: Orders). Name the table Product Catalog.

This setting persists across table rebuilds. If you change the data source later, you may need to revisit this step to remap columns from the new source to the existing table configuration.

The data source connection is checked on each page load. If the source becomes unavailable — for example, if an Airtable API key is revoked or a Google Sheet is unpublished — TableCrafter displays a configurable error message rather than an empty table, so site visitors receive feedback rather than a blank page.

The shortcode accepts all column and filter settings defined in the table builder as defaults, but you can override individual parameters inline. For example, `[tablecrafter id="1" per_page="25"]` overrides the default rows-per-page setting for this specific embed without changing the saved table configuration. This lets you reuse one table definition across multiple pages with different display requirements.

Step 2: How Do I Understand Available Product Fields?

The WooCommerce Products adapter exposes these fields:

Core Product Fields

• product_id, Integer. WooCommerce product ID.
• product_name, String. The product title.
• sku, String. Stock keeping unit. Empty string if not set.
• product_type, Enum: simple, variable, grouped, external.
• status, Enum: publish, draft, pending, private.

Pricing Fields

• regular_price, Decimal. The regular (non-sale) price.
• sale_price, Decimal. The current sale price. Empty if not on sale.
• price, Decimal. The active price (sale price if on sale, otherwise regular price).

Inventory Fields

• manage_stock, Boolean. Whether stock management is enabled for this product.
• stock_quantity, Integer. Current stock count. Null if manage_stock is false.
• stock_status, Enum: instock, outofstock, onbackorder.
• backorders_allowed, Boolean.
• low_stock_threshold, Integer.

Category and Taxonomy Fields

• categories, Array of category names. Rendered as a comma-separated list or badges.
• tags, Array of tag names.

Variation Fields (Variable Products)

For variable products, TableCrafter can either show a single parent row or expand to show one row per variation. Enable Expand variations in the table config to see individual variation SKUs, prices, and stock levels as separate rows.

Step 3: How Do I Configure Columns for a B2B Catalog?

A B2B product table typically needs:

This configuration interacts with any caching or CDN layer active on your WordPress installation. If you use WP Rocket, LiteSpeed Cache, or a CDN such as Cloudflare, flush the page cache after making this change to ensure the updated configuration is reflected in the cached HTML served to visitors. TableCrafter's server-side output is regenerated on the next uncached request.

1. product_name, Label: Product. Make it a link to the product page: /product/{slug}/ or to the WooCommerce admin product edit page if this table is internal-only.
2. sku, Label: SKU. Enable search on this column so buyers can look up by SKU.
3. categories, Label: Category. Display Type: Badges. Set badge colour to a neutral tone.
4. regular_price, Label: List Price. Format: Currency.
5. price, Label: Your Price. Format: Currency. (For a single price-list table, just use regular_price.)
6. stock_quantity, Label: In Stock. Show blank or N/A when manage_stock is false.
7. stock_status, Label: Availability. Display Type: Badge. Map instock to green, outofstock to red, onbackorder to amber.

Step 4: How Do I Add Category and Stock Filters?

Open the Filters tab. Add a category filter:

• Source Field: categories
• Filter Type: Multi-Select
• Label: Category
• Options Source: Auto (reads from product_cat taxonomy)

Add a stock status filter:

TableCrafter validates this configuration on save. If validation fails, the admin panel displays a specific error message identifying which field caused the problem. Correct the field value and save again without needing to restart the setup process.

After completing this step, verify the result by viewing the page as a logged-out visitor in an incognito window. This confirms the table behaves correctly for public visitors rather than reflecting admin-level permissions that may hide configuration issues during initial setup. Check both the rendered output and the browser console for any JavaScript errors.

• Source Field: stock_status
• Filter Type: Dropdown
• Label: Availability
• Default Value: instock (pre-filter to in-stock items; buyers can clear this to see out-of-stock)
• Options: In Stock (instock), Out of Stock (outofstock), On Backorder (onbackorder)

Step 5: How Do I Enable Export?

In the Toolbar tab, enable Export to CSV. For a B2B catalog, this is one of the highest-value features, buyers often want to take the price list into their own purchasing or ERP system. The export respects the current filter state, so a buyer can filter to a specific category and export just that subset.

If you want to include fields in the export that are not visible in the table (for example, the product ID for ERP import), add those fields as Hidden Export Columns in the column settings. They will not appear in the rendered table but will be included in the CSV.

The column mapping you define here is stored as a JSON configuration in the WordPress database. You can export this configuration using the TableCrafter export tool and import it to another table or another site. This is useful when replicating a table layout across multiple pages or when migrating a table to a staging environment for testing before going live.

Step 6: How Do I Configure Access?

Decide who can see the catalog table:

This step is required before the table can render data. Skipping it or entering incorrect values will result in a connection error when the table first loads. Double-check the value by pasting it directly into the field rather than typing it manually to avoid whitespace or encoding issues.

TableCrafter re-fetches this data on each page load by default. If your data source updates infrequently and your site has significant traffic, enable the built-in caching option in the table's Performance tab. This stores the fetched data for a configurable number of minutes and serves it from WordPress transients, reducing API calls to the source and improving page load time for visitors.

• Public catalog: Set Minimum role to view to None (public). Any visitor can see the table. Appropriate for published price lists.
• Logged-in buyers only: Set to Customer or a custom wholesale role.
• Internal staff only: Set to Shop Manager or Administrator.

Step 7: How Do I Place the Shortcode?

[tablecrafter id="6" filter="true" search="true" export="true"]

For a B2B order sheet where buyers need to request quantities, you can embed this table on a page alongside a Gravity Forms order form, using the product name or SKU as a lookup reference. The table gives buyers the product data they need to fill in the order form.

The configuration you set here applies to every visitor who loads a page containing this table, regardless of whether they are logged in. Role-specific overrides for columns and rows are a separate layer and do not replace these global display settings. Apply global settings first, then add role restrictions as needed for tables that serve multiple user types.

How Does Handling Variable Products Work?

Variable products (e.g., a t-shirt available in multiple sizes) have a parent product row and child variation rows. TableCrafter handles these in two modes:

• Collapsed (default): One row per parent product. price shows the price range ($10.00 – $25.00). stock_quantity shows total stock across all variations. Good for a high-level catalog view.
• Expanded: One row per variation. Each variation's SKU, price, and stock is shown separately. Good for an inventory table where you need to track individual variants.

Toggle between modes in the table-level settings under Variable Products → Display Mode.

This step completes the connection between your data source and the TableCrafter table engine. Once saved, the plugin caches the connection credentials in the WordPress options table and uses them on every subsequent page load. If you update the source configuration later — for example, rotating an API key or changing a sheet URL — return to this step, enter the new value, and save again. The table updates immediately on next load without any shortcode changes.

How Does Keeping Data Fresh Work?

TableCrafter queries WooCommerce products in real time on each page load, so the table always reflects current prices and stock levels. If you use a caching plugin (WP Rocket, NitroPack), exclude the page containing the product table from page-level caching to ensure stock data is not served stale. TableCrafter's own response caching (configurable in Settings → Performance) defaults to 60 seconds for product data, which is a reasonable balance between freshness and database load.

If the result does not match expectations after saving, use the TableCrafter debug log (enable via TableCrafter Settings > Advanced > Debug Mode) to trace exactly which configuration value is being applied for the current request.

If this step produces unexpected output, check the source data directly in the connected system. TableCrafter passes data through without modification — if a cell displays an unexpected value, the source record contains that value. Use the TableCrafter debug log (Settings > Advanced > Debug Mode) to trace the exact query sent to the source and the raw response received, which narrows the diagnosis to either a source-side or rendering-side issue.