Skip to content
English
Submit a Support Ticket
  • There are no suggestions because the search field is empty.

Bulk Uploading Items & Ingredients

This guide will walk you through the Bulk Upload functionality

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. 

  1. Navigate to the NOQ Backend Portal > Products > F&B Products > Master Stock List > Items

  2. Click the Actions button
  3. Select Bulk Upload.
  4. Download the New Items Template CSV file.
  5. 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 five 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.

Bulk Upload Ingredients

Rather than create several individual ingredients, we recommend taking advantage of the Bulk Upload function. This quick guide will demonstrate how to use the New Ingredients Template.

  1. Navigate to the NOQ Backend Portal > Products > F&B Products > Master Stock List > Ingredients

  2. Click the Actions button


  3. Click Bulk Upload.


  4. Download the New Ingredients Template CSV file.
  5. Open the file in Excel or Google Sheets and populate the following fields with your Ingredients:

Key Fields in the Template

  • Ingredient Name: The name.
  • Ingredient Category: Organize ingredients into categories (e.g., Mixers, Spirits).
  • Ingredient Tags: Enables tagging of ingredients to enhance search functionality.
  • Ingredient SKU: Stock Keeping Unit ID.
  • Purchase Unit Type: Unit type of ingredient (e.g. kegs, cases)
  • Units: Individual unit type (e.g. bottles, cans)
  • Unit Quantity of the case: The amount of units per case.
  • Unit Measurement: The measurement type of each unit (e.g. cl, kg)
  • Cost Per Purchase Unit: Cost of raw goods (for profit tracking).

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 Ingredients and then upload your Items CSV.