How to Print Item Labels and Bulk Import/Export Items

Getting stock onto the shelf and keeping it scannable are two chores that shouldn’t eat your afternoon. The Store module handles both: bulk import loads hundreds of items from a spreadsheet in one pass, export hands you a clean CSV of your current inventory, and the built-in label printer turns any item’s SKU into a barcode or QR label you can stick on the bin. This guide walks through all three.

The Store module is gated by permissions. You need stores.read to open the Items page and export or print labels. Bulk Import (and every other stock action) is hidden unless you also have stores.write.

Where These Tools Live

Everything here starts from the Store → Items page (the Items list). The toolbar across the top of that page holds the Export and Import buttons, label printing lives in two places, and the import template is a one-click download inside the Import window.

Bulk Import Items from a Spreadsheet

Bulk import is the fastest way to stand up a new store or add a supplier’s whole catalogue. You upload an Excel or CSV file, Rentablez validates every row and shows you a preview, and only then does it create the items.

Step 1 — Open the Import window

On the Items page, click Import in the toolbar. The Bulk Import Store Items window opens on the upload step.

If you don’t see an Import button, your role is missing stores.write. Ask an administrator to grant store write access.

Step 2 — Download the template (first time)

If you don’t already have a formatted file, click Download the import template inside the window. This saves store-items-template.xlsx with the correct column headers already in place. Fill in your items row by row and save it.

The template uses these columns:

Required columns are marked with an asterisk in the window (for example Name*). A row missing any required value is flagged as an error and skipped — it will not block the rest of the import.

Step 3 — Upload your file

Drag your file onto the drop zone, or click it to browse. Accepted formats are .xlsx and .csv, up to 5 MB. Rentablez parses the file and moves you to the preview step automatically.

Step 4 — Review the preview

The preview bar tells you how many rows are valid and how many have errors (will be skipped), along with the file name. Below it, a table lists the valid rows (Name, Category, UOM, Unit Cost, Selling Price, Reorder Level) and a separate table lists any error rows with the exact reason each one failed.

Two things to check before you commit:

• New categories. If your file references a category that doesn’t exist yet, a yellow banner lists them: “New categories will be created.” They’re added automatically on import — handy, but double-check for typos so you don’t create a duplicate category by accident.
• Duplicates. Use the Duplicates toggle to decide what happens when an imported item matches an existing one:

Step 5 — Import

Click Import N Items (the button shows how many valid rows will be created). When it finishes, a message confirms the result — for example, “Import complete: 40 created, 3 updated, 2 skipped.” Click Done to close the window; your new items appear in the list right away.

Import only creates and updates the item records — names, prices, categories, reorder levels. It does not bring in stock quantities. To put quantities on hand, use Receive Stock afterwards. See How to Manage Store Items and Stock.

Export Your Inventory to CSV

Export gives you a snapshot of your current stock for spreadsheets, audits, or accounting.

Step 1 — Filter to what you want (optional)

Export respects the filters and search currently applied to the Items list. Narrow by category, location, item type, or low-stock first if you only want a slice; leave everything cleared to export the whole store.

Step 2 — Click Export

Click Export in the toolbar. Rentablez downloads a file named store-items-<date>.csv and shows an “Export downloaded” confirmation.

The CSV includes one row per item with these columns:

Export is a one-way snapshot for reading — editing this CSV and re-uploading it through Import won’t work, because the two files use different columns. Use the import template for adding or updating items.

Print Barcode and QR Labels

Rentablez turns any item’s SKU into a scannable barcode (Code 128) or QR code label, sized for a 4” × 1” thermal label roll printed 2-up — two identical labels side by side per strip. You can print a single item from its detail page, or a whole batch from the Items list.

Print Labels for a Batch of Items

Use this when you’re relabelling a shelf or tagging a fresh delivery.

Step 1 — Select the items

On the Items page, tick the checkbox next to each item you want to label. A Print Labels action appears once you have items selected.

Step 2 — Open the label window

Click Print Labels. The window lists every item you selected with its Item name, SKU, and a Copies field.

Step 3 — Choose code type and copies

• At the top, pick Barcode or QR Code — the choice applies to the whole batch.
• Set Copies per item (minimum 1). Set an item to 3, for example, and you get three labels for it.

A summary line shows the total, for example “12 labels · 6 strips (4” × 1” · 2-up).”

Step 4 — Print

Click Print. Rentablez opens your browser’s print dialog with the label sheet ready. Send it to your thermal label printer.

Print a Label for a Single Item

When you only need one item’s label — and want to fine-tune how it looks — use the item detail page.

Step 1 — Open the item and go to Labels

Click an item in the list to open its detail page, then open the Labels tab.

Step 2 — Choose code type

Pick QR Code or Barcode. For barcodes, the panel shows the Code 128 value it will encode.

Step 3 — Adjust the layout (optional)

The label designer shows a live preview of the 2” × 1” label. Drag the elements — code, item name, SKU, UOM — to reposition them until it looks right.

Step 4 — Print or download

• Print opens the print dialog for your thermal printer, using the same 4” × 1” 2-up roll format.
• Download PNG saves the label as an image instead — useful for emailing to a print shop or dropping into another document.

Scan them back later. The QR and barcode you print encode the item’s SKU, so you can look an item up instantly with the Scan Item button on the Items page. See How to Manage Store Items and Stock.

Related Articles

• What Is the Store Module?
• How to Manage Store Items and Stock
• How to Purchase Stock: Requisitions, POs, GRNs and Returns
• How to Run a Physical Stock Audit
• How to Read Store Reports (Valuation, Reorder, P&L, Consumption)