Catalog
Export This Page or the Full Filtered Item Catalog
The export menu has two scopes. This page exports only displayed rows; Everything matching the filter exports the full branch-scoped result behind the active search and filters.
- Menu path
- Inventory -> Items -> Export CSV
- Verified from
- Posnic demo and current POS source reviewed on 2026-09-08
Technical source evidence
frontend/modules/items.html export menu, frontend/static/script/js/core/PosnicPro.js select-all-matching export payload and CSV download, api/src/controllers/items.controller.js exportItems permissions filters and branch context, api/src/repositories/item.repository.js _buildExportFilter projection and HSN normalization, demo.posnic.io Inventory -> Items export menu reviewed on 2026-09-05
Choose the Correct Scope
| Menu choice | Included rows | Best use |
|---|---|---|
| This page (what is shown) | Only item rows currently displayed on this list page. | A quick handoff or spot check where the visible page is intentionally the complete sample. |
| Everything matching the filter | Every item matching the active item-list filters in the current branch and license. | Category, supplier, stock, pricing or full-catalog audits that extend beyond pagination. |
| Everything matching the filter with no filter | All accessible items for the active branch. | A complete catalog snapshot before controlled bulk maintenance. |
Export a Filtered Catalog
- Open Inventory -> Items.
- Select Filter and apply the category, supplier, stock or search conditions required for the audit.
- Confirm the list contains the intended result and note the total number of matching items.
- Open Export CSV and choose Everything matching the filter.
- Wait for the CSV download, then open it in a spreadsheet editor.
- Confirm its row count and inspect products from the beginning, middle and end of the result.
Fields Included in Item Export
The CSV carries the operational fields supported by item re-import: name, itemid, barcode_id, category_name, supplier_name, discount_amount, discount_percentage, hsncode, hsndescription, tax_name, tax, tax_type, mrp_price, company_price, selling_price, available_quantity, unit and sort_order.
- Photos, descriptions, alternate barcodes, ecommerce settings, negative-stock settings and other item behavior switches are not exported.
- For a real HSN item, HSN code and description are exported and tax_name is intentionally blank.
- Rows without a real HSN export blank HSN cells rather than placeholder zero values.
- The file is a catalog audit and re-import surface, not a complete application backup.
Use the Export Safely
| Task | Safe method | Risk to avoid |
|---|---|---|
| Price review | Compare MRP, cost and selling price; approve edits in a separate working copy. | Uploading unapproved formulas or rounded values. |
| Stock review | Treat available_quantity as a snapshot and compare it with a physical count. | Re-importing an old export after sales or purchases have changed stock. |
| Tax audit | Review HSN, tax name, rate and inclusive/exclusive method together. | Changing one tax column without understanding the others. |
| Catalog migration | Retain the original CSV and test a small batch in the destination branch. | Assuming images and non-CSV item settings are contained in the export. |
| Recovery | Use Posnic's proper backup and restore process. | Treating an item-only CSV as a complete recovery file. |
Acceptance Check
- The exported row count matches the intended page or complete filtered result.
- The CSV contains the expected 18 headers and opens without shifted comma-containing fields.
- Sampled prices, quantities, categories, suppliers, tax methods, SKUs and barcodes match the live item details.
- The file name, date, branch, active filter and approver are recorded outside the CSV.
- Any edited copy is treated as a new import proposal, reviewed before selection in the import dialog.