How do I import Shopify products with grouped variants?

Create a searchable table directly from selected Shopify products. You can use one row for each variant or one expandable row for each product.

Reviewed August 12, 2026. This guide describes the current Table Master Shopify product import.

What does a Table Master Shopify product import create?

Table Master can create a searchable storefront table directly from selected Shopify products. The import can include product images, titles, prices, SKUs, variants, product type, vendor, Shopify IDs, and Add to Cart values. Choose Variants when each variant must have its own main table row. Choose Products with grouped variants when one product row must expand to show its variants. A grouped row supports a product with up to 20 variants and uses one plan row. Products with more variants require variant rows. Each variant has a separate cart control; grouped rows do not have one Add all action. The first import is a snapshot, so Shopify product data does not refresh automatically. Open the database and use Sync products to refresh Shopify-managed columns. Table Master keeps custom values for existing rows during this manual refresh. Public self-service plans include up to 20,000 rows. Higher row limits are available by arrangement.

Should I use variant rows or grouped product rows?

Use Variants when each variant needs its own main table row. Each variant uses one plan row and keeps its own direct cart control.

Use Products with grouped variants when you want one main row for each product. The customer can expand the row to see variants. Each grouped product uses one plan row, but a grouped row supports only products with up to 20 variants. Use the variant-row format for larger products.

Grouped rows give each variant a separate cart control. They do not provide one Add all button for all selected variants.

Row format	Main table row	Variant access	Plan-row use
Variants	One row for each variant	Directly in the table	Each variant uses one row
Grouped products	One row for each product	Expand the product row	Each product uses one row

How do I import Shopify products?

1. In Table Master, create a new database.
2. Choose Shopify products as the import source.
3. If requested, select Grant product access and approve access in Shopify.
4. Enter a database name.
5. Under Display type, select Variants or Products with grouped variants.
6. Search for the products that you want to import.
7. Select the products and review the estimated plan-row use.
8. Optional: Open Custom data and select metafields or metaobject child fields. See How do I sync metafields and metaobjects?
9. Save the import.

The product table can include product images, product titles, variant names, SKUs, prices, product type, vendor, product handle, product ID, variant ID, and Add to Cart values.

How do I set up variant cart controls?

After the database is ready, create or edit its embedded table. Open Column type and configure the Add to Cart column. For grouped product rows, the customer first expands a product and then uses the separate cart control for the required variant.

Check the desktop and mobile previews before you add the table to a live theme. Confirm that unavailable variants, quantity controls, button labels, and minimum quantities have the required behavior.

How do I refresh imported Shopify product data?

The initial Shopify product import is a snapshot. Table Master does not refresh it automatically.

1. Open the Shopify product database.
2. Select Sync products.
3. Confirm the sync.
4. Wait for the sync to finish and check the latest values.

Sync products refreshes Shopify-managed columns. These include images, titles, variants, SKUs, prices, product type, vendor, handles, IDs, and Add to Cart values. Custom columns are kept for existing rows.

Deleted, unpublished, and inactive products stay in the database but remain hidden. Variants that Shopify reports as unavailable can be hidden or shown with a More info button. A product or variant that you manually remove from the database is not added again by Sync products.

What limits apply to grouped variants and cart actions?

• A grouped product row supports up to 20 variants.
• A product with more than 20 variants requires the variant-row format.
• Each grouped product uses one plan row. In variant mode, each variant uses one plan row.
• Each variant has a separate cart control. There is no one-click Add all action.
• Shopify product sync is manual through Sync products. It is not automatic.
• The total imported rows must fit the store's active limit. Public self-service plans include up to 20,000 rows. Higher row limits are available by arrangement through Activory support.