Importing Modifiers
You can import modifiers into Fuze Store POS to set up or update product and service extras in bulk. Modifiers let you offer options like sizes, toppings, or add-ons.

Step-by-Step Guide
- Open the app drawer.
- Go to Configurations.
- Under Data Management, tap Import.
- Choose the matching data type on the type grid.
- Optionally tap Download template for a CSV starter (your live export).
- Upload a CSV, XLS, or XLSX file, review the preview, then confirm Import.
Field Reference
The import file contains both modifier rows and option rows. Set the modifier_type column to indicate which type each row represents.
| Field | Description | Required | Applies To | Possible Values | Example |
|---|---|---|---|---|---|
| id | UUID identifier for the modifier or option. Leave blank to create new. | Both | 123e4567-e89b-12d3-a456-426614174000 | ||
| code | Unique code for the modifier. Letters, numbers, dashes and underscores only. Saved in lowercase. | MODIFIER | massage-pressure | ||
| modifier_type | Whether this row is a modifier or an option. | Yes | Both | MODIFIER, OPTION | MODIFIER |
| name | Name of the modifier or option. | Yes | Both | Massage Pressure | |
| label | Display label on receipts and POS Register. Falls back to name if empty. | Both | Massage Pressure | ||
| is_active | Whether the modifier is active. Defaults to YES if empty. | MODIFIER | YES, NO | YES | |
| is_required | Whether the modifier is required on an item. Defaults to NO if empty. | MODIFIER | YES, NO | NO | |
| is_visible_on_front | Whether the modifier is visible on the POS front. Defaults to YES if empty. | MODIFIER | YES, NO | YES | |
| is_multiple | Whether the customer can select more than one option. Defaults to NO if empty. | Yes, on MODIFIER rows | MODIFIER | YES, NO | NO |
| min_options | Minimum number of options the customer must select. Cannot be greater than max_options. | Yes, if is_multiple is YES | MODIFIER | 1 | |
| max_options | Maximum number of options the customer can select. | Yes, if is_multiple is YES | MODIFIER | 3 | |
| is_selected | Whether the option is selected by default. Defaults to NO if empty. | OPTION | YES, NO | NO | |
| base_price | Price for the option. | Yes | OPTION | 12.50 | |
| ordering | Display order of the option. Defaults to the row order under its modifier. | OPTION | 1 |
YES/NO and enum values are not case-sensitive, and blank cells fall back to the defaults noted above.
Row Order
Row order is part of the structure of this file, not just presentation:
- Each option row belongs to the modifier row directly above it. A MODIFIER row opens a group, and every OPTION row below it joins that group until the next MODIFIER row.
- The first row must be a MODIFIER row, otherwise the leading options have no group to join.
- Do not sort the file by name or code. Sorting separates options from their modifier and rebuilds the groups incorrectly.
Tips
- Review your data before importing to avoid errors.
- Download a sample export file first if you are unsure about formatting.
- Use clear names so staff can quickly identify each modifier and option.
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 code. 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.
- Row order is structure. Each OPTION row belongs to the MODIFIER row directly above it. The first row must be a MODIFIER row. Do not sort the file by name or code, because sorting separates options from their modifier and rebuilds the groups wrongly.
- A generated code can clash. Import matches modifiers by code, and a code made from a name can match one your store already has after a deletion, so one row can update the wrong modifier. Check codes before importing.
Works with
| Add-on or plan | What changes |
|---|---|
| Basic plan | Import and export are locked. |
| Starter and up | Import is available. |