CSV Export
Use this page to download your product catalog as a spreadsheet file — for a backup, a price review, or to edit and import back.
Quick steps
- Go to Products.
- To export everything, clear any search or filters first. (A filtered list exports only the products shown.)
- Click More Actions (the ⋮ button).
- Under Export, click Product Catalog (CSV). The file downloads straight away.
- Open it in Google Sheets, Excel or another spreadsheet program.
To edit and bring the changes back in, save the file as CSV and use CSV Import. Products are matched by SKU.
The file holds everything about your products: prices, deals, tiers, photos, extra barcodes, suppliers, bundles and stock in each location. Importing it into a store with no products puts them all back as they were.
Excel can turn a SKU like 007 into 7. Set the SKU and barcode columns to Text when you open the file.
Common questions
What's the difference between Product Catalog (CSV) and Inventory Report (CSV)? Product Catalog (CSV) is your full product list, ready to edit and re-import. Inventory Report (CSV) is a stock-value report (stock, cost, value) for checking or sending to an accountant — it isn't meant to be re-imported.
Are inactive products included? Yes, unless you've filtered the list to Active only.
How do I print a stock list for counting? Use More Actions > Inventory List (Print). It opens a printable list grouped by category. See Printing a stock list.
A column I expected isn't there.
Some columns only appear when the matching feature is switched on for your store, for example cannabis details or weight presets. Others appear once one of your products uses them, for example preferred_supplier or bundle_contents.
How do I read the price columns? They're written the way the product page shows them. See Prices, deals and lists in one cell.
More detail: the export options and which products are included
CSV export downloads your product catalog as a spreadsheet file. Use it for backups, offline price reviews, bulk editing (re-import after changes), or sharing product data with suppliers and partners.

Exporting Your Catalog
- Go to Products in the top navigation bar.
- Click More Actions (the ⋮ button).
- Under Export, click Product Catalog (CSV).
The file downloads straight away — there's no options window and no column picker.
- Inventory Report (CSV) is a stock-on-hand valuation report: SKU, name, category, current stock, low stock level, unit cost, retail price and stock value. It isn't meant to be re-imported. Use Product Catalog (CSV) when you want to edit and re-import.
- Inventory List (Print) opens the same stock list in a new tab, laid out for paper. See Printing a stock list.
Which Products Are Included
Product Catalog (CSV) downloads the products the list is showing. With no search or filter, that is every product in your store, both active and inactive. With a search or filter on — a category, a brand, a stock status, Active only — the file holds just those products.
To export the whole catalog, clear the search and filters first.
Each product with variations is followed by its variations, one row each (for example the 1g, 3.5g and 7g options), with their own SKU, stock, price and cost. A variation's row has its parent's SKU in parent_sku and its own variation_name, so a re-import puts it back under the right product.
More detail: file format and every column
File Format
| Property | Details |
|---|---|
| File name | products-<date>.csv, e.g. products-2026-09-15.csv |
| Encoding | UTF-8 |
| Delimiter | Comma (,) |
| Header row | The first row holds the column names |
| Quoting | Every value is wrapped in double quotes |
| Rows | One row per product, and one per variation under its parent |
Columns Always Included
In this order:
| Column | Description |
|---|---|
sku | SKU |
name | Product name |
brand | Brand name |
description | Product description |
price | Pre-tax selling price |
cost | Cost |
unit_type | How the product is measured |
product_type | Product structure (for example simple or variable) |
category_names | Categories with their full path (e.g., "Cigarettes > Cigars > test"), separated by | if there are several (a category name can have a comma in it) |
barcode | Barcode |
current_stock | Quantity on hand |
track_inventory | Whether the product's stock is counted: true or false |
reorder_point | Low stock level: at or below this, it needs ordering |
reorder_quantity | How many to order |
reorder_levels_set_by | hand if a person set the levels, sales if they're kept up to date from sales, blank otherwise |
active | true or false |
parent_sku | Parent product SKU (blank for main products) |
variation_name | Variation name |
box_quantity | Box/case quantity |
primary_image_url | Link to the main product photo (an uploaded photo too) |
gallery_image_urls | Links to the other photos, separated by vertical bars |
is_freebie_only | Whether the product is freebie-only |
auto_print_label_on_sale | Auto-print label setting |
sale_discount_type | Sale discount type |
sale_discount_value | Sale discount value |
sale_starts_at | Sale start (date and time) |
sale_ends_at | Sale end (date and time) |
sale_reason | Sale reason text |
Columns That Depend on Your Features
These are added after the columns above, in this order, only when the feature is on:
| When | Columns |
|---|---|
| Cannabis features on | is_cannabis_product, product_format, strain_type, package_size, thc_content, cbd_content, thc_unit, cbd_unit, thc_min, thc_max, cbd_min, cbd_max, dominant_terpene, effects_data, medical_benefits_data |
| Weight presets on | use_weight_presets, weight_display_unit, price_unit, weight_value, weight_preset_barcodes, weights_sold |
| Quality tiers on | quality_tier, weight_prices |
| Always | multi_buy, multi_buy_applies, multi_buy_shelf |
| Your store is a distributor, or distributor ordering is on | wholesale_price and retail_price (next to cost), wholesale_enabled, minimum_order_quantity, volume_pricing |
| An SLGA site ID is set, or compliance reporting is on | lot_number, expiry_date, lab_tested, equivalent_grams, pst_exempt |
| Multi-location inventory on | warehouse_location_name, stock_by_location |
| Modifiers on | modifier_list_names (separated by vertical bars) |
| Units of measure on | uom_template, uom_levels — see CSV Import for the format |
After these come any other product details one of your products uses, for example preferred_supplier, additional_barcodes, supplier_codes, bundle_contents, exclude_from_promotions, staff_pick or menu_display_name.
Prices, deals and lists in one cell
Some cells hold a list. Items are separated by |, and each is written the way the product page shows it:
| Column | Example | What it means |
|---|---|---|
weight_prices | 1g 10.00 | 3.5g 30.00 | 7g 55.00 | The product's own price for each weight. Blank on a tier product means it takes its tier's prices. |
weights_sold | 1g | 3.5g 28.00 | 28g hidden | The weights it sells at. A price is only shown where that weight has its own; hidden means not offered. |
multi_buy | 2 for 40.00 | 5 for 90.00 | Multi-buy deals: the total for that many. |
multi_buy_applies | every unit or full packs | Every unit gets the deal price, or only complete packs do. |
multi_buy_shelf | Vape Shelf | The multi-buy shelf it's on. It takes that shelf's deal. |
additional_barcodes | 0777000111222 (Supplier UPC) | 6595861 | Extra barcodes, with their label in brackets. |
supplier_codes | sku AB-12 (Westcan) | The codes a supplier uses for it, so their invoices match. |
bundle_contents | PAPER x2 | Pick a lighter [1]: LIGHTER-A x1 | What's in a bundle, by SKU. A name and [1] in front is a choice: pick 1 of those items. |
stock_by_location | Sales Floor: 12 | Storage: 30 | Stock in each location. |
Write none in weight_prices or multi_buy to take that pricing off. An empty cell leaves it as it is.
Example (first few columns only):
"sku","name","brand","description","price","cost"
"BD-001","Blue Dream","Green Farms","Sativa-dominant hybrid","12.99","8.00"
"GUM-010","Mango Gummies","Sweet Leaf","10 pack","6.50","3.25"
More detail: printing a stock list
Printing a Stock List
Products → More Actions → Inventory List (Print) opens a printable stock list in a new tab, with a Print button at the top. Your product list filters don't carry over to it. It has its own filters at the top instead. Pick what you want and click Apply (Clear resets them):
-
Show: Switched on (the default), Switched off or Both.
-
Location: if your store has more than one location, pick one to list only that room with that room's stock, for example a count sheet for the vault.
-
Only products with stock: leaves out anything with nothing on hand.
-
Categories: tick the categories to list. A category brings its subcategories with it. Tick none to list them all.
-
Products are grouped by category, so the sheet can be read shelf by shelf.
-
Each row shows SKU, Product, In stock and Price, and a Counted box to write what you count. A ▼ marks a product at or below its low stock level. The sheet ends with lines for who counted and the date.
-
Cost and value are left off, so the sheet can go to whoever does the count. To print them, click Show cost & value at the top: each row then also shows Cost and Value, each category ends with a Subtotal, and the last line is the Total value at cost. Only people whose role can see cost (View Financial Data) get that button.
-
Blind count at the top takes In stock (and the low stock marks) off the sheet, so counters write what they actually count rather than copying the expected number. Show stock on hand puts it back.
To type the counts in instead of writing them, click Count on screen — see Stock Counts.
The printout and Inventory Report (CSV) are built from the same figures, so they always agree. Value is stock × the product's average cost (or its typed cost when nothing has been received at a price). Bundles and products with variations are listed but valued at nothing — their components and variations are valued on their own rows — and stock below zero isn't valued.
More detail: working with the file, use cases and troubleshooting
Working with the Exported File
Opening in a Spreadsheet Application
- Google Sheets — File > Import > Upload > select the CSV file. Choose "Comma" as the separator.
- Microsoft Excel — File > Open > select the CSV file. If the Text Import Wizard appears, choose "Comma" delimited.
- LibreOffice Calc — File > Open > select the CSV file. Confirm UTF-8 encoding and a comma separator.
Microsoft Excel may strip leading zeros from SKUs and barcodes (e.g., changing 007 to 7). To prevent this, import through Data > From Text and set those columns to Text.
Editing and Re-Importing
- Export your catalog.
- Open it in a spreadsheet application.
- Make your changes (update prices, change categories, add new products).
- Save as CSV (UTF-8, comma-delimited).
- Import the updated CSV.
The importer matches rows to existing products by SKU, so existing products are updated and new SKUs create new products.
Use Cases
| Use Case | How to Do It |
|---|---|
| Catalog backup | Export and save the file somewhere safe. |
| Price review | Export, review and adjust the price column in a spreadsheet, then re-import. |
| Supplier reorder list | Export Inventory Report (CSV) and filter its Low Stock? column to "Yes" in your spreadsheet. |
| Migration to another system | Export, then reformat the columns to match the other system's import format. |
| Seasonal audit | Export, filter the spreadsheet to a category, and review for items to deactivate. |
| Share with your accountant | Use Inventory Report (CSV) for stock value. |
Troubleshooting
| Issue | Solution |
|---|---|
| Characters look garbled | The file was opened without UTF-8 encoding. Re-open it and choose UTF-8. |
| SKUs lost leading zeros | Set the SKU column to Text when opening the file (see the Excel tip above). |
| A column I expected isn't there | Some columns only appear when the matching feature is on, or once a product uses them. See the table above. |
What's Next?
- CSV Import — Re-import your edited CSV to apply changes.
- Managing Products — Browse your catalog in the admin panel.
- Bulk Operations — Make bulk changes without exporting and re-importing.