How to complete the product import templates for inventory upload in Mews POS

Before you can start using Mews POS, you need to create your products in the Mews POS inventory. You can add products with the product import template. These are two excel sheets that your Mews onboarding manager provides which you can use to fill in your product inventory details.

You can also include allergen and dietary restriction information in your product data, helping staff identify suitable options for guests and supporting menu creation later on.

 

Once you complete the sheets, send them to your onboarding manager to upload. After a successful upload, you can combine purchasable products into sellable products as composite products.

 

There are two product import tables for Mews POS:

  • Sellable products
  • Purchasable products

You can learn more about sellable and purchaseable product types.

 

In this article, you can learn about:

 

How to complete the product import templates for inventory upload in Mews POS

Step 1: Fill in the Sellable product table 

To fill in the sellable product table:

  1. Open the file using a spreadsheet editing application such as Microsoft Excel.
  2. Complete the product table Excel sheet using the fields below. Note: If a field is not listed in this article, Mews POS does not require it for product creation, and you do not need to complete it.

Product details

  • Product name: Enter the name of the product with as much information as possible. 
  • Product Category: Click to select the product category. This makes it possible for the system to classify products in the reports.  
  • Kitchen name: Enter the name of the product as it appears on the printed kitchen ticket.
  • Regal Code: Enter the ASTORE code, if applicable.
  • SKU: Enter the Stock keeping unit of the product, if applicable.
  • Barcode: Enter the product barcode, if applicable.

Guest-facing information

  • Description: Enter a description of the product as it appears in your menu for Order & pay. Note: Include allergens and warnings.

Dietary information

  • Allergens: Enter applicable allergens using the supported values, for example, gluten, dairy.
  • Dietary restrictions: Enter applicable tags, for example, vegetarian, vegan.

Adding this information allows:

  • Staff to quickly identify suitable options in the POS
  • Easier menu creation using dietary filters

Selling options

  • Make available for sale: A sellable product is visible from the invoicing module on your smartphone or tablet and within the Order & pay menu. They can be bought by guests and staff. Enter TRUE or FALSE into the field to indicate if the product is available for sale.
  • Price: Enter the price of the product without the currency symbol.
  • Promotion price: Enter the promotion price of the product if it is on sale.
  • Sales tax: Click to select the sales tax that applies to this product.

Variants (optional)

  • Variant - Option name: Enter the type of variant, for example, Size, Flavor.
  • Variant - Option values: Enter the variant values followed by their prices, separated by a hyphen. Use a comma to separate each variant, for example, Small-7.90, Medium-10.90, Large-12.90.

 

 

  1. Save the spreadsheet file.

 

Step 2: Fill in the Purchasable product table 

To fill in the purchase product table:

  1. Open the file using a spreadsheet editing application such as Microsoft Excel.
  2. Complete the product table excel sheet using the fields below. Note: If a field is not listed in this article, Mews POS does not require it for product creation, and you do not need to complete it.

Product details

  • Product name: Enter the inventory product name and description.
  • Product category: Select the category, this is so the system can classify products in reports.
  • Product for purchase: Indicate if the product is purchasable.

Purchase configuration

  • Packages purchased: Enter number of packages. For example, if you buy 5 boxes, enter 5.
  • Units purchased: Enter total units. For example, if you have 100 bottles per box and you have 5 boxes, enter 500 for 500 bottles.
  • Unit of measurement: Enter unit, for example, bottle.
  • Total price: Enter supplier price. Note: Do not add currency symbols.
  • Purchase taxes: Enter applicable tax for the product.

Inventory tracking

  • Track this product in the inventory: Enter TRUE to enable inventory tracking and processing of product transfers and adjustments. 

Unit conversion (optional)

If your products require unit conversion, fill in the following fields:

  • Counting unit: Enter how you count a single product, for example, bottle, bag.
  • Unit of measurement: Click to select the unit of measurement you want to use to count the product.
  • Conversion - Purchased quantity: Enter the number of products you purchase.
  • Conversion - Unit of measurement: Click to select the unit of measurement for the purchasable product.
  • Conversion - Selling quantity: Click to select the unit of measurement for the sellable product.
  • Conversion - Unit of measurement: Click to select the unit of measurement for the sellable product.

Classification (optional)

  • Purchased product family: Assign the inventory family and the product classification that the system applies when editing the inventory. Note: This field may not be visible in your region.
  • Purchased product subfamily: Assign an inventory subcategory and classify a product to sort the inventory reports. Note: This field may not be visible in your region.
  1. Save the spreadsheet file.

This completes the product import tables. You can now send these to your onboarding manager.


Was this article helpful?
00



Feedback