--- title: Exporting items id: inventory.export description: "Download your items, their variants or your stock at each location as a CSV from the Actions menu." lastUpdated: 2026-10-24 order: 90 --- Who can do this: team leaders, administrators and owners. ## What it does Use Export, in the Actions menu beside Create Item, to download your items as a CSV file. To change items in bulk, export them, edit the spreadsheet and import it again with the [item import](/docs/inventory/import.md). The window has three choices. | Choice | What it picks | | --- | --- | | Records | The items. Selected takes the items you ticked. All Matching takes every item your search and filters match. Everything takes every item. Each choice shows how many items it covers. | | Shape | The file, and the window shows what one row of each file is | | Columns | The columns in the file. The window opens on All Columns. Columns in This View takes the columns the list shows. Choose Columns lets you tick them one by one. Each column has the name the item import gives it. | | Shape | One row per | | --- | --- | | Items | Item or variant, with the item's columns on each variant's row | | Stock by Location | Item or variant at each location where it has a stock figure, even a zero. Each of its rows holds On Hand, Committed, Available and Incoming. | | Notes | Note on those items, oldest first within each item, with its author and its text. Lucrii skips an item with no notes. | Only the Items file imports back. Lucrii doesn't import a Stock by Location or Notes file. Choose Columns keeps the columns the import needs ticked, and you can't untick them. In an Items file, they are ID, Title, SKU, Handle, Variant ID and Variant SKU. They also include Option 1 Name to Option 3 Name and Option 1 Value to Option 3 Value. - Some columns in an Items file hold figures Lucrii works out, such as Average Cost Price and Incoming Stock. These columns are for reading. [Importing and exporting contacts](/docs/contacts/import-export.md) explains them and the headings in the file. - Items adds up to four stock columns for each active location. - In Stock by Location, Available is On Hand less what unfulfilled sales orders have committed. Incoming is what purchase orders have still to deliver. - Stock by Location also has Item ID, Variant ID and Unit. Choose Columns starts them unticked, and All Columns includes them. - [Exporting orders](/docs/orders/import-export.md) lists the Notes file's columns. Columns in This View writes its default columns. - Selected and Everything export in the list's sort. All Matching exports in the list's default order. The export runs in the background. A message says it has started. When the file is ready, a message offers Download and View Job, and Lucrii emails you a link to the export in Bulk Activity. The file name gives your Shape, your choice of records and the day you exported. Excel opens an exported file with accented names as you typed them. You can also ask Hermes to export your items. ## Before you start - Exporting is for a team leader or above. Below that, Export is not in the Actions menu. - A file can have at most 1,024 columns. Lucrii refuses a wider export before it starts. - You can have three jobs in progress at once, counting bulk actions and exports together. [Quotes, sales orders and purchase orders](/docs/orders/overview.md) says how the limit works. You can start up to 120 jobs an hour. ## How to use it 1. Open the Items list. 2. To export only some items, tick them first. 3. Select Actions, then Export. 4. Under Records, Shape and Columns, choose what you want, then select Export. 5. When the message says the file is ready, select Download, or open the export from Bulk Activity. ## Troubleshooting Lucrii says you already have jobs running. Wait for one of them to finish, or cancel one in Bulk Activity. Then start the export again. Lucrii says the export has too many columns. The message reads like "This export is over 1,024 columns. Leave out at least 6 columns." Choose Columns and untick at least as many as the message says. Then export again. Lucrii says you have started too many jobs in the last hour. Wait a few minutes, then start the export again. A location's stock columns are missing from an Items file. Items leaves out a stock column whose name passes 128 characters. Only a location with a very long name makes one. An item is missing from Stock by Location. The file has no row for an item with no stock record anywhere. It has none for an item that does not track inventory either. No email came when an export was ready. Lucrii does not send the email in a demo organisation. ## Related - [Importing items from a spreadsheet](/docs/inventory/import.md): Create or update many items at once from a CSV or TSV spreadsheet. - [Bulk actions on items and locations](/docs/inventory/bulk-actions.md): Edit, tag, restock or delete many items at once, or archive, restore or delete locations. - [Items and locations](/docs/inventory/overview.md): Browse the items you buy and sell, and the locations you keep them in. - [Creating an item](/docs/inventory/items-create.md): Create an item with its name, prices, stock tracking and the vendor you buy from. - [Bulk Activity](/docs/settings/bulk-activity.md): Follow the imports, exports and bulk changes your organisation runs, and see what happened to each record. ## Changes - [Bulk actions with Hermes](/changelog/2026-10-16#2026-10-16-bulk-actions-with-hermes) - 2026-10-16 - [Export file names and sort order](/changelog/2026-10-16#2026-10-16-export-file-names-and-sort-order) - 2026-10-16 - [Exporting items](/changelog/2026-10-16#2026-10-16-exporting-items) - 2026-10-16 - [Exports that import back](/changelog/2026-10-16#2026-10-16-exports-that-import-back) - 2026-10-16 - [Notes, payments and fulfilments in exports](/changelog/2026-10-16#2026-10-16-notes-payments-and-fulfilments-in-exports) - 2026-10-16 - [Average cost and available stock](/changelog/2026-09-30#2026-09-30-average-cost-and-available-stock) - 2026-09-30 - [Help pages for every feature](/changelog/2026-09-30#2026-09-30-help-pages-for-every-feature) - 2026-09-30