Importing Products

You can import products into Fuze Store POS to quickly set up or update your inventory. This works for migrating from another system or adding many items at once.

Step-by-Step Guide

1. Open the app drawer.
2. Go to Configurations.
3. Under Data Management, tap Import.
4. Choose the matching data type on the type grid.
5. Optionally tap Download template for a CSV starter (your live export).
6. Upload a CSV, XLS, or XLSX file, review the preview, then confirm Import.

Before you import

• Item limit. New rows count toward your plan's item limit, the same as adding items one by one. Products and services share the one limit. If the file would go over it, nothing is imported, and the message says how many more your plan allows.
• Updates take no room. Rows that match an item you already have only update it, so you can always re-import your own export.

Field Reference

Here are the columns in the Products import file:

YES/NO and enum values are not case-sensitive, and blank cells fall back to the defaults noted above.

Tips

• Import categories and modifiers first. The category_ids and modifier_ids columns match against records that already exist, so codes with no match are skipped without an error and the product imports uncategorized.
• Import bundle members before the bundles that contain them, for the same reason — bundle_item_ids only matches products that already exist.
• Review your data before importing to avoid errors.
• Download a sample export file first if you are unsure about formatting.
• Keep product names and SKUs consistent across your inventory.
• Update your product data regularly to reflect current prices and stock levels.

Edge cases

• All or nothing. Every row is checked before anything is saved. One bad row stops the whole import and nothing is saved. The app lists each problem as Row 2: … and names the column.
• How a row is matched. A row matches an existing record by its id first, then by its SKU (letter case does not matter, and a file cannot list the same SKU twice). A row that matches is updated, and every other row is added. A row with none of these is always added, so running a hand-made file twice makes duplicates. Export first and edit that file to update safely.
• Spreadsheet formats. You can upload .csv, .xls, or .xlsx. The file is read by what it really is, so a damaged or unreadable spreadsheet is refused as a bad format. A CSV with a single column has no separators and is refused as not being a spreadsheet, so add a second column or save it as .xlsx.
• Headers matter, not order. Extra columns are ignored. YES/NO and other fixed values accept any letter case, and blank cells fall back to the default for that column.
• Starter and up. Import is not on the free Basic plan. It needs Store Settings · Import, and Download template also needs Store Settings · Export.
• The item limit. New rows count toward your plan's item limit, the same as adding items one by one. Products and services share one limit (Basic 150, Starter 500, Lite 1,000, Standard 3,000, Premium none). If the file would go over it, nothing is imported and the message says how many more your plan allows. Rows that match an existing item only update it.
• Import categories and modifiers first. Codes in category_ids and modifier_ids with no match are skipped without an error, and the product imports uncategorized. The same holds for bundle_item_ids, so import bundle members before their bundles.
• Tax. tax_id must be a tax UUID, not a name. Copy it from your Taxes export.
• Where it sells. A row with both sell_on_register and sell_online set to NO is refused. Blank leaves an existing product unchanged.
• Stock. A row with manage_inventory YES needs quantity and stock_status. Opening stock rides on product rows, with no Advanced Inventory add-on.

Works with

Related guides

• Import Overview
• Importing Services
• Product Overview