# Shopify Products Imported With Wrong Taxable Status

> Shopify defaults all imported products to taxable when the supplier CSV has no Variant Taxable column. Fix it at import time or in bulk with a re-import.

- Published: 2026-09-17
- Author: Importier Team
- Category: Import Guides / File Imports
- Canonical: https://www.importier.app/blog/shopify-import-taxable-status-wrong

---

A children's clothing merchant in the UK imports 150 products from a supplier spreadsheet. Children's clothing and footwear sized for under-14s is zero-rated for VAT in the UK; customers should pay no tax on it. The supplier's CSV has columns for product code, description, price, and sizes. There is no column for taxable status. After the import completes, every product in Shopify shows "Charge tax on this product" ticked. The merchant runs the store for six weeks before a customer emails asking why they were charged 20% VAT on a baby vest.

This is the Shopify import taxable status problem. When a CSV file does not include a Variant Taxable column, Shopify applies its default setting to every imported product. The default is taxable. For merchants selling categories that are legally tax-exempt in their jurisdiction, a silent default creates a compliance risk that is invisible until a customer or an auditor flags it.

## Why Shopify Defaults All Imported Products to Taxable

[Shopify's CSV format for product imports](https://help.shopify.com/en/manual/products/import-export/using-csv) includes a "Variant Taxable" column that controls the "Charge tax on this product" setting per variant. When this column is present and set to FALSE, Shopify imports the variant as tax-exempt. When the column is absent or blank, Shopify uses the store's default tax setting, which for most stores is taxable.

Supplier CSV exports are not built around Shopify's data model. A supplier's price list typically includes cost, RRP, description, and variant attributes. It does not include Shopify-specific fields like Variant Taxable, Variant Requires Shipping, or Variant Fulfillment Service. Shopify fills in its own defaults for every missing field on import.

The result is predictable: every product in the import gets the default taxable setting regardless of the merchant's tax obligations. For a general retailer selling only taxable goods, this is harmless. For a merchant selling a mix of taxable and exempt categories, half the catalogue may be incorrectly taxed.

<Callout label="Per-variant, not per-product">
Shopify's taxable flag applies to each variant individually, not to the product as a whole. A product with 5 size variants requires the correct taxable setting on all 5 variant rows. In a supplier CSV where 4 variant rows are silent on taxable status, all 4 import as taxable even if a 5th row happens to include Taxable=FALSE. There is no per-product taxable setting that cascades to variants.
</Callout>

![Supply chain analyst examining a large printed supplier product catalogue spread flat on an office table showing ordered rows of product codes with a highlighted annotation marking an absent column header](/blog/shopify-import-taxable-status-wrong/01.jpg)

## Which Product Categories Are Commonly Tax-Exempt

Tax exemptions vary by jurisdiction and category. Merchants selling across multiple markets often carry a mix of taxable and exempt products in the same catalogue. Common exempt categories by region:

**United Kingdom:** Children's clothing and footwear (sized for under-14), most food and drink, books and newspapers, prescription medicines. The [UK HMRC guidance on VAT rates by goods and services](https://www.gov.uk/guidance/rates-of-vat-on-different-goods-and-services) sets out zero-rated and exempt categories in detail.

**Australia:** Fresh food, most beverages (excluding alcohol and soft drinks), educational course materials, prescription and OTC medicines.

**United States:** Varies by state. Pennsylvania exempts most clothing and footwear. Groceries are exempt in most states. New Jersey exempts baby products. Prescription drugs are exempt nationwide.

**Canada:** Basic groceries (unprocessed food), prescription drugs, medical and assistive devices.

The distinction between zero-rated (taxed at 0%) and exempt is important in VAT jurisdictions: zero-rated lets the business claim input tax credits; exempt does not. For Shopify's taxable flag, the practical outcome is the same: the customer pays no tax on the item.

A catalogue that mixes taxable garments (adult clothing, taxable accessories) with zero-rated items (children's clothing) needs different taxable settings per product category. Importing the entire catalogue from one supplier CSV without setting taxable status correctly taxes both categories identically.

![Boutique children's clothing store interior with neat rows of colourful garments hanging on wooden wall-mounted rails and folded stacks of baby clothing arranged on display tables](/blog/shopify-import-taxable-status-wrong/02.jpg)

## How to Identify Incorrectly Taxed Products After Import

Shopify admin does not filter the product list by taxable status. To find affected products after an import, the most reliable method is exporting the catalogue and reading the Variant Taxable column.

The Importier export flow includes a Full Shopify CSV preset that outputs every product and variant field in Shopify's standard CSV format, including Variant Taxable. After running the export, open the CSV and filter the Variant Taxable column. Products that should be exempt but show TRUE are incorrectly configured. For a catalogue of 150 products with 3-5 variants each, this audit takes a few minutes in a spreadsheet.

Alternatively, open each product individually in Shopify admin and check the Pricing section; the "Charge tax on this product" checkbox is visible per variant under Shipping. At scale, the spreadsheet audit is faster.

<Divider label="Setting taxable status at import time" />

## Mapping Taxable Status in the Importier Import Wizard

The correct fix is setting taxable status at import time rather than correcting it afterwards. Importier's import wizard handles this in the column mapping step.

<Steps items="Add the supplier CSV in Importier. If the CSV includes a taxable indicator column (labelled 'Taxable', 'VAT Exempt', 'Tax Exempt', or similar), the auto-mapper may recognise it. If not, locate it manually in the column list | In the column mapping step, map the supplier's taxable indicator to Shopify's Variant Taxable field. The expected values Shopify accepts are TRUE and FALSE. If the supplier uses different values (1/0, Yes/No, Exempt/Standard), use the value transformation options to normalise them before mapping | If the supplier CSV has no taxable column at all, set a batch default. For a catalogue of entirely exempt products, set Variant Taxable to FALSE for the entire batch. For a mixed catalogue, import in two passes: first the exempt category with Taxable=FALSE as the batch default, then the taxable category with Taxable=TRUE | Save each configuration as a named import profile. A children's clothing import profile with Taxable=FALSE and an adult clothing profile with Taxable=TRUE avoids needing to reconfigure on every import cycle" />

The two-pass approach is useful when a single supplier CSV contains both taxable and exempt products and the taxable status must be set differently per row. Split the CSV by category, run two imports with different profiles, and both sets of products get the correct taxable setting without manual post-import correction.

![Financial auditor at a large wooden desk examining a printed data correction worksheet with rows of product records and two columns of amended values highlighted in green and red correction marks](/blog/shopify-import-taxable-status-wrong/03.jpg)

## Fixing Taxable Status on Existing Products Without Overwriting Other Data

For the merchant who discovered the error six weeks after import, the fix requires correcting 150 products without overwriting the descriptions, images, and tags added in the meantime.

Export the catalogue using Importier's Full Shopify CSV preset. The export includes every field Shopify holds for each variant: title, description, images, SKU, price, taxable status, inventory, and all metafields. Open the CSV and change the Variant Taxable column from TRUE to FALSE for every variant row that should be exempt. Leave all other columns unchanged.

Re-import the edited CSV using Importier's update-existing mode. The import matches each product by SKU, then updates only the fields present in the CSV. Because the file includes Variant Taxable with the corrected values and all other fields are unchanged, the re-import corrects the taxable status without touching descriptions, images, tags, or inventory levels. 150 products corrected in one import pass, not 150 individual admin edits.

<PullQuote>The re-import corrects taxable status without touching descriptions, images, tags, or inventory. One CSV edit and one import pass replaces 150 individual product edits in Shopify admin.</PullQuote>

This same pattern applies to any field that was incorrectly set during the original import. Update the relevant column in the exported CSV, re-import with update-existing, and only that field changes. The approach is covered in more detail in the [Importier import profiles guide](/blog/shopify-import-profiles) for setting up recurring profile-based imports.

![Compliance officer at a standing desk with multiple printed jurisdiction reference sheets spread across the surface showing comparison table columns in an organised layout with labelled section dividers](/blog/shopify-import-taxable-status-wrong/04.jpg)

## What Tax-Related Data Goes Where in Shopify

Taxable status (Variant Taxable) is the most common tax setting merchants need at import time, but it is not the only one. Two other tax-related fields appear in the product CSV:

**Variant Requires Shipping:** controls whether Shopify calculates shipping for the variant. Digital products set this to FALSE. Services set it to FALSE. Physical goods set it to TRUE. Like Variant Taxable, this defaults to TRUE on import when the column is absent.

**HS Code (Harmonized System Code):** used for customs and duty calculation on international orders. Shopify stores this per variant. Importier's data enrichment can fill HS codes automatically for products where the barcode or product description provides enough information to identify the commodity code. The [Importier export presets guide](/blog/shopify-export-presets) covers exporting HS codes for customs review alongside taxable status in a combined audit export.

Both fields should be verified alongside Variant Taxable after any large import, particularly for catalogues that include products across multiple tax categories or cross-border shipments.

<Compare withoutTitle="Post-import manual correction" withTitle="Taxable status set at import time" withoutItems="Discover incorrectly taxed products only when a customer or auditor flags the error, potentially weeks after import | Correct each product individually in Shopify admin: open product, find each variant, uncheck tax setting, save: 150 products = 150+ edits | Risk of missing some variants: manual per-product editing on a large catalogue leaves room for inconsistent settings" withItems="Map the Variant Taxable field in the Importier column mapping step during import: all products get the correct setting before going live | Save the taxable configuration as a named import profile: the same supplier's future imports use the same settings without reconfiguration | Batch default for catalogues with no taxable column: set FALSE for exempt categories, TRUE for taxable, import in two passes if mixed" />

<TipBox />

## Key Takeaways

- **Shopify defaults all imported products to taxable when the supplier CSV omits the Variant Taxable column.** This is a silent default; no error is reported. The incorrectly taxed products go live immediately.
- **Taxable status applies per variant, not per product.** Every variant row in a multi-variant product must have the correct taxable setting. A product with 5 variants requires Taxable=FALSE on all 5 rows to be fully exempt.
- **Check taxable status after every large import.** Export using Importier's Full CSV preset and filter the Variant Taxable column. Fix any incorrectly taxed products before they reach customers.
- **Set taxable status at import time using the column mapping step.** Map a supplier taxable column if one exists, or set a batch default (FALSE for all exempt products). Save the configuration as a named import profile for recurring imports from the same supplier.
- **Correct bulk taxable status with update-existing mode.** Export the catalogue, edit the Variant Taxable column, re-import with update-existing. Only the taxable field updates; descriptions, images, tags, and inventory are unchanged.

Import your product catalogue and configure taxable status correctly from the first import at [importier.app](https://importier.app).