Importing Supplies from CSV

If you have an existing list of supplies — packaging materials, cleaning products, raw ingredients — you can bring them into Iraca all at once using a CSV file instead of adding them one by one.

---

Before you start

You'll need a CSV file with at least two columns: sku and name. Everything else is optional. If you don't have a file ready, download Iraca's template first (see below).

Only workspace owners and admins can import supplies.

---

Downloading the template

The easiest way to get started is with the Iraca template, which includes all supported columns with an example row already filled in.

1. Go to Purchasing → Supplies
2. Click Import CSV
3. In the dialog, click Template to download supplies-import-template.csv
4. Open it in Excel, Google Sheets, or any spreadsheet app and fill in your data

---

Supported columns

Column	Required	Description
sku	Yes	A unique code for the supply item
name	Yes	The name of the supply
brand	No	The brand or manufacturer, if it matters which one you buy
barcode	No	UPC or barcode number
unit_of_measure	No	How the item is measured — e.g. box, roll, unit. Defaults to unit
unit_cost	No	Cost per unit in your workspace currency
notes	No	Any internal notes
preferred_supplier_name	No	The name of the supplier contact you usually buy this from. Must match a contact you already have — see below
is_active	No	1 or true to mark active, 0 or false to mark inactive. Defaults to active
low_stock_notifications_enabled	No	1 or true to enable low stock alerts. Defaults to off

Tips:

• Column names must match exactly (lowercase, underscores)
• Extra columns in your file are ignored
• Maximum file size is 5 MB

---

Linking a supplier

preferred_supplier_name records who you usually buy an item from. It travels as a name, not an ID, so a file exported from one workspace still means something in another.

The name has to match a contact you already have. Iraca will not create a contact from a name in a spreadsheet — a contact is used for purchase orders, quote requests, vendor bills and payment reminders, so a typo would put a phantom supplier into all of them.

When a name can't be matched, the row still imports — only the supplier link is dropped, and the name is listed in the import summary so you can fix it. Two cases produce that:

• No contact by that name. Create the contact and re-import, or set the supplier on the item afterwards.
• More than one contact by that name. Iraca picks the one filed as a supplier if exactly one of them is; if you have two suppliers with identical names it won't guess between them.

Capitalisation and surrounding spaces don't matter — acme supply co matches Acme Supply Co.

Leaving the column blank on an update leaves the existing supplier alone. To remove a supplier link, clear the field on the item itself.

---

Running the import

1. Go to Purchasing → Supplies
2. Click Import CSV
3. Drag your file into the upload area, or click to browse for it
4. Click Import

Iraca processes your file and shows a summary when it's done — how many supplies were created, how many were updated, and any rows that had problems.

---

How Iraca handles existing supplies

Iraca matches rows by SKU within your workspace:

• New SKU — a new supply is created
• Existing SKU — the supply is updated with the new values from your file
• Previously deleted SKU — the supply is restored and updated

This means you can safely re-import an updated version of your file without creating duplicates.

---

Fixing errors

If any rows couldn't be imported, Iraca lists them with a row number, SKU, and a description of the problem. Common issues:

• Missing required columns — your file is missing sku or name
• Column count mismatch — a row has more or fewer columns than the header
• Invalid value — for example, unit_cost contains text instead of a number

Fix the affected rows in your file and import again. Rows that already imported successfully won't be duplicated.

---

Plan limits

Your plan includes a maximum number of product and supply records combined. If an import would exceed that limit, Iraca stops at that row and notes it as an error. Existing records are not affected.

To increase your limit, upgrade your plan under Billing.

---

Exporting your supplies

To download a CSV of all your current supplies — for backup or to edit in bulk — click Export CSV on the Supplies page. The file uses the same column format as the import template.