ChatGPT JSON to Markdown
Convert a local ChatGPT export into readable Markdown. Preview a conversation or download a ZIP of notes for Obsidian.
Open tool →Download a working template for simple, variable, grouped, external or downloadable products. Then check your file for the mistakes that import without an error.
The same file can import differently on two stores, so the template and the check both use these. Find them under WooCommerce → Settings, on the General and Products tabs.
Each file has the columns WooCommerce's importer recognises and working example rows. Replace the rows, or delete the columns you don't need. Every product is set to draft, so nothing goes live by accident.
Find rows that will fail, and values that import without an error but end up wrong. The file is read in this page and never uploaded.
Rules read from the WooCommerce 11.2.1 importer source code and checked by importing test files through it. This tool can't see your store, so it can't tell whether a SKU or parent already exists there.
The importer's success screen only tells you which rows failed. These are the ones that succeed and leave the wrong data behind. Each comes from how the importer's code reads a cell.
WooCommerce keeps only your store's decimal separator and strips other punctuation. On a store that uses a dot, 19,99 imports as 1999, and 1.299,00 imports as 1.299. Weights and dimensions are read the same way. This is common when a file comes from a spreadsheet in a European locale.
The column understands 1, 0 and backorder. Any other text counts as true, so no, false and outofstock all mark the product as in stock. An empty cell does the opposite: with no stock quantity, it marks the product as out of stock.
When a row has a quantity, WooCommerce turns on stock management and works out the status itself. A row with In stock? = 1 and Stock = 0 ends up out of stock.
The importer converts this cell to a number. Words become 0, and 0 means private. Use 1 for published, 0 for private, -1 for draft and 2 for pending. An empty cell means draft.
Only 1, 0 and notify are understood. Everything else becomes "do not allow".
PHP reads slashes as month/day/year, so 01/02/2026 is January 2, and 31/12/2026 is not a date at all, so it's dropped. A plain number is treated as a Unix timestamp, so a spreadsheet's date serial number lands in January 1970. Use 2026-12-31.
If a variation names an attribute its parent doesn't have, WooCommerce drops it, and the row becomes an "any" variation that matches every combination. If the attribute exists but the value isn't in the parent's list, the variation is created but shoppers can never select it.
Excel can turn 4006381333931 into 4.00638E+12 and remove the leading zero from a UPC. Once the file is saved as CSV like that, the digits are gone. Format those columns as Text before you paste, and re-export from your source if it has already happened.
Column names aren't case-sensitive. The importer also accepts Title or Product Title for Name, Price for Regular price, Quantity for Stock, and Parent SKU for Parent.
| Column | What to enter |
|---|---|
| ID | Leave empty for new products. To update, use an existing product's ID. |
| Type | simple, variable, variation, grouped or external. Add virtual or downloadable after a comma. Empty means simple for new rows. |
| SKU | Unique across all products and variations. |
| GTIN, UPC, EAN, or ISBN | The barcode number. In 11.2.1 this column isn't matched automatically, so choose it on the mapping screen. |
| Name | Product name. Leave empty on variations. |
| Published | 1 published, 0 private, -1 draft, 2 pending. |
| Is featured? | 1 or 0. |
| Visibility in catalog | visible, catalog, search or hidden. If the column exists, an empty cell fails the row. |
| Short description, Description | Text or HTML. Wrap the cell in double quotes if it contains commas or line breaks. |
| Date sale price starts, ends | YYYY-MM-DD. |
| Tax status | taxable, shipping or none. |
| Tax class | The slug of a tax class. Empty means standard. |
| In stock? | 1, 0 or backorder. Ignored when Stock is filled. |
| Stock | A whole number. Empty turns off stock management for that product. |
| Low stock amount | A whole number. |
| Backorders allowed? | 1, 0 or notify. |
| Sold individually? | 1 or 0. |
| Weight (kg), Length (cm), Width (cm), Height (cm) | Numbers in your store's unit. The unit in the name must match your store's setting for the column to map automatically. Values aren't converted. |
| Allow customer reviews? | 1 or 0. |
| Purchase note | Text shown after purchase. |
| Sale price, Regular price | Numbers with your store's decimal separator and no thousands separator. The sale price must be lower for a sale to run. |
| Categories | Commas separate categories and > nests them: Clothing > Shirts, Sale. Missing categories are created. Write \, for a comma inside a name. |
| Tags | Separated by commas. |
| Shipping class | The class name. |
| Images | Full URLs or media library file names, separated by commas. The first is the main image. |
| Download limit, Download expiry days | Whole numbers. Used by downloadable products. |
| Parent | For a variation: the parent's SKU, or id:123. |
| Grouped products, Upsells, Cross-sells | SKUs or id:123 values, separated by commas. |
| External URL, Button text | For external products. |
| Position | Menu order, as a number. |
| Attribute 1 name | For example, Colour. Use 2, 3 and so on for more attributes. |
| Attribute 1 value(s) | On a parent, all values separated by commas: Red, Blue. On a variation, one value, or empty to mean "any". |
| Attribute 1 visible | 1 shows it on the product page. |
| Attribute 1 global | 1 uses a global attribute, 0 a custom one for this product only. |
| Attribute 1 default | On a variable parent, the value selected by default. |
| Download 1 name, Download 1 URL | The file's label and location. |
| Meta: your_key | A custom field. The part after Meta: is the meta key. |
Building many variations by hand? The variation CSV generator makes every combination for you.
A comma-separated file saved as UTF-8, with a header row and one product per row. Variations each get their own row, with the parent's SKU in the Parent column. Only the columns you want to set are needed.
WooCommerce includes one at wp-content/plugins/woocommerce/sample-data/sample_products.csv. It's built around a demo catalogue, so the templates here are smaller and easier to adapt.
The most common cause is a decimal comma on a store that uses a dot. WooCommerce strips the comma, so 19,99 becomes 1999. Check your file above, or set the store's decimal separator before importing.
Usually the parent row isn't type variable, or the attribute name or value on the variation doesn't match the parent's. The checker tests each variation against its parent when both are in the same file.
That SKU is already in your store, or appears earlier in the file. To change existing products, tick 'Update existing products' on the import screen. To create new ones, give them new SKUs.
No. The check runs in your browser using JavaScript, and the file doesn't leave your computer.
The rules were read from the WooCommerce 11.2.1 importer source code, then checked by importing test files through that importer. The core columns have been stable for a long time, but always try a small test import on your own version first.
Quick Variable Products lets you pick attributes, generate every variation in one click, then set price, SKU and stock per row, right inside WooCommerce.
Explore Free and Pro →Read the step-by-step guideConvert a local ChatGPT export into readable Markdown. Preview a conversation or download a ZIP of notes for Obsidian.
Open tool →Open a WooCommerce stock CSV, count products in a browser worksheet, or download a printable inventory count sheet PDF. Review differences and export your count record.
Open tool →Turn daily demand, supplier lead time and safety stock into a reorder point and stock-position check.
Open tool →Generate up to 500 variations and a draft product CSV, or review an existing variation CSV for parent links, SKUs, prices and local attributes.
Open tool →Work out buffer stock from demand and lead-time variation at the service level you choose, with a reorder point.
Open tool →Find the cheapest order size, rounded to your pack size and supplier minimum, and compare it with what you order now.
Open tool →See how often you sell through your stock, how long it sits, and the cash a higher turnover would free.
Open tool →See how much of your stock has sold, how long the rest will last and when you'll reach your target.
Open tool →Check a whole list of GTIN, UPC or EAN codes, add check digits, and find lost zeros, spreadsheet damage and duplicates.
Open tool →Turn product names and attributes into readable, unique SKUs, with a list or a WooCommerce import file to download.
Open tool →Sort products into A, B and C classes by value, straight from a WooCommerce export or a pasted list.
Open tool →Work out your shrinkage rate on stock, cost of goods sold and sales, and see which lines lost the most.
Open tool →See how much gross margin each unit of money in stock earns, and the cash a target would free.
Open tool →