Before you can start using the purchasable products inventory to track stock and manage inventory in Mews POS, you need to upload and set up the products you purchase from your suppliers. This help article explains how to download, complete, and upload the purchasable product import template in the Mews POS web dashboard. Setting up your products correctly ensures accurate stock tracking and consistent inventory data across your operations.

 

In this article, you can learn about:

• How to complete the product import templates for your purchasable products inventory in Mews POS
  • Step 1: Fill in the purchasable product table
  • Step 2: Upload the purchasable product table

 

How to complete the product import templates for your purchasable products inventory in Mews POS

Step 1: Fill in the purchasable product table

To fill in the purchasable product table, you first need to download the product import table.

 

To do so:

1. Log in to pos.mews.com, then navigate to Inventory > Products.
2. Next, click and select Download template.

3. Open the file in a spreadsheet application, for example, Microsoft Excel.
4. Complete the sheet using the fields below. Note: If a field is not listed, you do not need to complete it.

Product details

• Product name: Enter the inventory product name.
• Product category: Add a product category. It is recommended to distinguish these from your sellable categories by adding a prefix, for example, STOCK | WINE, and using capital letters for consistency.
• Product for purchase: Indicate if the product is purchasable.

Purchase configuration

• Packages purchased: Enter the number of packages purchased, for example, if you have 5 boxes, enter “5”.
• Units purchased: Enter the number of items purchased or the number of items you have in your packages. For example, if you have 100 bottles per box and you have 5 boxes, you have 500 units.
• Unit of measurement: Choose a unit from the drop-down menu, for example, bottle.
• Total price: Enter supplier price excluding VAT. Note: Do not add currency symbols.
• Purchase taxes: Enter applicable tax.

Inventory tracking

• Track this product in the inventory: Enter TRUE to enable tracking.

Counting Unit:

Note: Required if you have set inventory tracking to TRUE.

• Counting unit: Enter how a single product is counted in your operations.
• Unit of measurement: Select the unit of measurement you use to count the product from the drop-down menu.

Classification (optional)

• Purchased product family
• Purchased product subfamily

Unit conversion:

For example: You purchase wine by the bottle, 1 bottle = 0.75 liters, but sell it by the glass, or count it in liters.

• Conversion - Purchased quantity: Enter the quantity you purchase, for example, 1.
• Conversion - Unit of measurement: Select the unit you purchase in from the dropdown menu, for example, bottle.
• Conversion - Selling quantity / Counting quantity: Enter the equivalent quantity used for selling or counting, for example, 0.75.
• Conversion: Select the unit used for selling or counting from the drop-down menu, for example, liter.

5. Save the spreadsheet file.

Step 2: Upload the purchasable product table

To import the Product Import Table:

1. Log in to pos.mews.com, then navigate to Inventory > Products.
2. Click , and select Import Products.
3. You can then either drag and drop your file or click Browse file to upload it.

 

Import results: there are two possible outcomes after the import:

a. Successful import
If the products import correctly, you can see a summary showing the number of rows that are Inserted, Updated, and Ignored.

b. Import with errors
If some products do not import, an error message displays. You can also see details indicating which rows failed and the reason for each error.

To resolve this, review the highlighted issues in your file, make the necessary corrections, and upload the table again. Note: In this case, no products are uploaded until the errors are resolved.