How to bulk upload items
This guide will walk you through the Bulk Upload functionality for uploading items.
Bulk Upload Items
Rather than create several individual Items, we recommend taking advantage of the Bulk Upload function. This quick guide will demonstrate how to use the New Items Template to create all your items at once in Excel and then upload the file in the Backend Portal.
- Navigate to the NOQ Backend Portal > Products > F&B Products > Master Stock List > Items

- Click the Actions button

- Select Bulk Upload.

- Download the New Items Template CSV file.

- Open the file in Excel or Google Sheets and populate the following fields with your Items:
Key Fields in the Template
- Item Name: The name displayed to customers.
- Item Category: Organize menu Items into categories (e.g., Wines, Spirits).
- Item Tags: Enables tagging of Items to enhance search functionality.
- Item SKU: Stock Keeping Unit ID.
- Item Description: Customer-facing.
- Has Variants?: Y/N. Variants are mandatory customer choices (e.g., size or type). Examples:
- Variant Name 1: Glass (£5)
- Variant Name 2: Bottle (£12)
- Selling Price: Price without variants.
- Cost Price: Cost of raw goods (for profit tracking).
- Block Price: Allows manual price overrides via EPOS.
Note: The system supports up to ten variants during bulk upload. Additional variants can be added after upload.
Save the completed template as a CSV file and upload it to the system via the Bulk Upload page. In the Upload Template menu, select Add New Items and then upload your Items CSV.