Skip to main content
Sign in with your store to see only the help that applies to you.

CSV Export

Admin Manager

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​

  1. Go to Products.
  2. To export everything, clear any search or filters first. (A filtered list exports only the products shown.)
  3. Click More Actions (the ⋮ button).
  4. Under Export, click Product Catalog (CSV). The file downloads straight away.
  5. 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 and leading zeros

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.

Products List

Exporting Your Catalog​

  1. Go to Products in the top navigation bar.
  2. Click More Actions (the ⋮ button).
  3. Under Export, click Product Catalog (CSV).

The file downloads straight away — there's no options window and no column picker.

Other exports in the same menu
  • 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​

PropertyDetails
File nameproducts-<date>.csv, e.g. products-2026-09-15.csv
EncodingUTF-8
DelimiterComma (,)
Header rowThe first row holds the column names
QuotingEvery value is wrapped in double quotes
RowsOne row per product, and one per variation under its parent

Columns Always Included​

In this order:

ColumnDescription
skuSKU
nameProduct name
brandBrand name
descriptionProduct description
pricePre-tax selling price
costCost
unit_typeHow the product is measured
product_typeProduct structure (for example simple or variable)
category_namesCategories with their full path (e.g., "Cigarettes > Cigars > test"), separated by | if there are several (a category name can have a comma in it)
barcodeBarcode
current_stockQuantity on hand
track_inventoryWhether the product's stock is counted: true or false
reorder_pointLow stock level: at or below this, it needs ordering
reorder_quantityHow many to order
reorder_levels_set_byhand if a person set the levels, sales if they're kept up to date from sales, blank otherwise
activetrue or false
parent_skuParent product SKU (blank for main products)
variation_nameVariation name
box_quantityBox/case quantity
primary_image_urlLink to the main product photo (an uploaded photo too)
gallery_image_urlsLinks to the other photos, separated by vertical bars
is_freebie_onlyWhether the product is freebie-only
auto_print_label_on_saleAuto-print label setting
sale_discount_typeSale discount type
sale_discount_valueSale discount value
sale_starts_atSale start (date and time)
sale_ends_atSale end (date and time)
sale_reasonSale reason text

Columns That Depend on Your Features​

These are added after the columns above, in this order, only when the feature is on:

WhenColumns
Cannabis features onis_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 onuse_weight_presets, weight_display_unit, price_unit, weight_value, weight_preset_barcodes, weights_sold
Quality tiers onquality_tier, weight_prices
Alwaysmulti_buy, multi_buy_applies, multi_buy_shelf
Your store is a distributor, or distributor ordering is onwholesale_price and retail_price (next to cost), wholesale_enabled, minimum_order_quantity, volume_pricing
An SLGA site ID is set, or compliance reporting is onlot_number, expiry_date, lab_tested, equivalent_grams, pst_exempt
Multi-location inventory onwarehouse_location_name, stock_by_location
Modifiers onmodifier_list_names (separated by vertical bars)
Units of measure onuom_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:

ColumnExampleWhat it means
weight_prices1g 10.00 | 3.5g 30.00 | 7g 55.00The product's own price for each weight. Blank on a tier product means it takes its tier's prices.
weights_sold1g | 3.5g 28.00 | 28g hiddenThe weights it sells at. A price is only shown where that weight has its own; hidden means not offered.
multi_buy2 for 40.00 | 5 for 90.00Multi-buy deals: the total for that many.
multi_buy_appliesevery unit or full packsEvery unit gets the deal price, or only complete packs do.
multi_buy_shelfVape ShelfThe multi-buy shelf it's on. It takes that shelf's deal.
additional_barcodes0777000111222 (Supplier UPC) | 6595861Extra barcodes, with their label in brackets.
supplier_codessku AB-12 (Westcan)The codes a supplier uses for it, so their invoices match.
bundle_contentsPAPER x2 | Pick a lighter [1]: LIGHTER-A x1What's in a bundle, by SKU. A name and [1] in front is a choice: pick 1 of those items.
stock_by_locationSales Floor: 12 | Storage: 30Stock 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.
Excel and leading zeros

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​

  1. Export your catalog.
  2. Open it in a spreadsheet application.
  3. Make your changes (update prices, change categories, add new products).
  4. Save as CSV (UTF-8, comma-delimited).
  5. 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 CaseHow to Do It
Catalog backupExport and save the file somewhere safe.
Price reviewExport, review and adjust the price column in a spreadsheet, then re-import.
Supplier reorder listExport Inventory Report (CSV) and filter its Low Stock? column to "Yes" in your spreadsheet.
Migration to another systemExport, then reformat the columns to match the other system's import format.
Seasonal auditExport, filter the spreadsheet to a category, and review for items to deactivate.
Share with your accountantUse Inventory Report (CSV) for stock value.

Troubleshooting​

IssueSolution
Characters look garbledThe file was opened without UTF-8 encoding. Re-open it and choose UTF-8.
SKUs lost leading zerosSet the SKU column to Text when opening the file (see the Excel tip above).
A column I expected isn't thereSome columns only appear when the matching feature is on, or once a product uses them. See the table above.

What's Next?​