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
- 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
Here are the columns in the Products import file:
| Field | Description | Required | Possible Values | Example |
|---|---|---|---|---|
| id | UUID identifier for the product. Leave empty to create a new product. | 123e4567-e89b-12d3-a456-426614174000 | ||
| sku | Stock Keeping Unit. A unique code for each product. An existing SKU updates the matching product. | SKU-12345 | ||
| enable_product | Whether the product is active in the store. Defaults to YES if empty. | YES, NO | YES | |
| is_available | Whether the product is available for sale. Defaults to YES if empty. | YES, NO | YES | |
| name | Name of the product. | Yes | Grilled Chicken | |
| is_bundle | Whether the product is a bundle of other products. Defaults to NO if empty. | YES, NO | NO | |
| bundle_item_ids | Pipe-separated list of product IDs or SKUs in the bundle. | Yes, if is_bundle is YES | SKU-123|SKU-124 | |
| category_ids | Pipe-separated list of category IDs or codes. The categories must already exist. | chickens|best-sellers | ||
| description | Description of the product. | Delicious grilled chicken | ||
| weight | Weight of the product. | 1.5 | ||
| weight_unit | Unit of weight. | Yes, if weight is set | lb, kg, g, mg, mcg, oz, st, ct, t, ton, l | kg |
| manage_inventory | Whether inventory tracking is enabled. Defaults to NO if empty. | YES, NO | NO | |
| quantity | Quantity in stock. | Yes, if manage_inventory is YES | 100 | |
| low_stock_level | Threshold for low stock alerts. | 10 | ||
| stock_status | Current stock status. | Yes, if manage_inventory is YES | IN_STOCK, OUT_OF_STOCK | IN_STOCK |
| modifier_ids | Pipe-separated list of modifier IDs or codes. The modifiers must already exist. | chicken-part|chicken-size | ||
| price | Selling price of the product (tax included). | Yes | 79.99 | |
| cost | Cost price of the product. | 10.00 | ||
| enable_special_price | Whether the special price is enabled. Defaults to NO if empty. | YES, NO | NO | |
| special_price | Special discounted price. | Yes, if enable_special_price is YES | 7.99 | |
| special_price_from | Start date for the special price. A plain date or a full ISO timestamp both work — your export emits the full timestamp. | Yes, if enable_special_price is YES | ISO date or datetime | 2024-06-01 |
| special_price_to | End date for the special price. | ISO date or datetime | 2024-06-30 | |
| tax_class | Tax class name or code. | TAXABLE_GOODS, NONE | NONE | |
| tax_id | Tax UUID associated with the product. Unlike the other reference columns, a tax name is not accepted here — copy the id from your Taxes export. | Yes, if tax_class is TAXABLE_GOODS | UUID only | 123e4567-e89b-12d3-a456-426614173000 |
| preparation_time_minutes | Time needed to prepare the item, in minutes. Defaults to 0 if empty. | 0 to 999999.99 | 15 |
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_idsandmodifier_idscolumns 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_idsonly 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.