Importing Inventory

Inventory Import Overview

The inventory import feature lets you add items to your Fixmo inventory from an external file. This is useful when migrating from another system, onboarding a new supplier's product list, or adding items in bulk. Fixmo supports 11 fields for inventory import and enforces your plan's item limit. Only users with the Admin role can access data import.

Preparing for Inventory Import

Before importing inventory items, ensure your Fixmo account is set up with the categories your items will use. Fixmo matches category names from your file against existing categories using case-insensitive matching.

1. 1Go to Settings > Inventory and create the categories and sub-categories your items will need.
2. 2Verify that your plan has enough capacity for the items you plan to import. Check your current inventory count in Settings > Billing under Usage Statistics.
3. 3Prepare your file with column headers that closely match the Fixmo field names for the best auto-mapping results.

How to Import Inventory

The inventory import follows the same flow as other imports: upload, map, and execute.

1. 1Navigate to Settings > Data Import from the sidebar.
2. 2Click the 'Import Inventory' option.
3. 3Upload your file by dragging and dropping it into the upload zone, or click to browse and select a file.
4. 4Fixmo parses the file and displays the column mapping interface.
5. 5Review the auto-mapped columns and adjust any incorrect mappings.
6. 6Ensure at least the name field is mapped (required).
7. 7Choose your import mode: Bulk Import or Guided Import.
8. 8Start the import and review the results.

Supported Inventory Fields

Fixmo recognizes 11 fields for inventory import. Only name is required — all other fields are optional and use sensible defaults when not mapped.

• name (required) — the item's display name used across Fixmo
• sku — the Stock Keeping Unit code for internal reference
• costPrice — the purchase cost from your supplier
• sellPrice — the retail price charged to customers
• category — the category name, matched case-insensitively against existing inventory categories
• barcode — the barcode number for scanning
• initialStock — the starting stock quantity for this item
• minStock — the minimum stock alert threshold
• unit — the unit of measurement (defaults to 'pcs' if not specified)
• usageType — how the item is used: REPAIR_PART, PRODUCT, or BOTH (defaults to BOTH)
• description — an optional text description of the item

Plan Limit Enforcement

Fixmo checks your plan's inventory item limit before starting the import. If the total number of items after import would exceed your limit, the import is blocked entirely.

• Free plan — limited inventory item count (check Settings > Billing for your exact limit)
• Pro plan — higher inventory item limit
• Business plan — unlimited inventory items
• The import checks your current item count plus the number of rows in your file against your plan limit
• If the limit would be exceeded, a message appears asking you to upgrade your plan or reduce the number of items in your file

How Category Matching Works

When your file includes a category column, Fixmo tries to match each value against your existing inventory categories using case-insensitive name comparison. For example, 'phone parts', 'Phone Parts', and 'PHONE PARTS' all match the same category. If no match is found, the item is imported without a category assignment.

Default Values for Unmapped Fields

Fields that are not mapped or left empty in your file receive sensible default values so that imported items are immediately usable.

• usageType — defaults to BOTH, making the item available for both repairs and point-of-sale
• unit — defaults to 'pcs' (pieces)
• trackStock — defaults to true (stock tracking enabled)
• branch — items are assigned to your shop's first (oldest) branch
• costPrice, sellPrice — default to 0 if not specified
• initialStock, minStock — default to 0 if not specified