PowerEPOS Stock - Ingredients / Product Import

This guide explains each field in the PowerEPOS Stock Import Template to help you correctly prepare your stock data for onboarding. Completing this template accurately ensures that your products, ingredients, purchase units, stocktake units, and recipe components are set up correctly within PowerEPOS from day one.

Whether you're importing packaged goods, fresh ingredients, beverages, or complex recipe items, this document clarifies what each column means and how it affects stock management, reporting, ordering, costing, and POS integration.

Use this guide as a reference while completing the Ingredient & Product Import sheet to ensure your data is consistent, structured, and ready for a smooth import into PowerEPOS. If you have any questions, our support team is available at support@triniteq.com

PLU

PLU Number assigned to stock item. In the case that an item is directly sold and purchased in the same unit (i.e. beers or wines) this should match the existing POS PLU number. For items that are purchased in a different unit i.e. spirit bottles or food ingredients allocate a new PLU number or Leave blank and Triniteq will allocate one for you when processing the file.

STOCK GROUP

Used for reporting & analytics where possible match to existing groups configured in POS to avoid duplication or enter a new group name to have it generated as part of the import.

DESCRIPTION

Stock item description/name will be used on stock reports, purchase orders, stocktakes etc. It is advised to NOT include any descriptors in the name relating to sizes or units of the item as these are managed separately i.e. Use Peroni not Peroni Keg.

HOW I GET THIS STOCK

Choose the correct stock method for this item from 1 to 3.

1 - I purchase this item

2 - I produce this item as I sell it, never storing it

3 - I pre-produce this item

STOCKTAKE SIZE & UNIT

When counting this item and viewing stocktake reports what unit of measure do you want to see the item in? Also consider how you might use it in a recipe also. eg. Packaged Beers will often just be 1 x Unit as you will count & report per can or bottle. Tap Beers/Kegs you would be 1 x Litre so that you can enter a count per LT and view discrepancies in a standardised unit. Wines & Spirit bottles 750 x ml based on the bottle size (we use ml for wines and spirits not unit as when these are sold in POS you sell (x)ml in a shot or a glass)

PURCHASE SIZE, UNIT & DESCRIPTOR

How do you buy these in. Think of it as a multiple of the stocktake size and unit. i.e. Tap beers are purchased as a KEG (Descriptor) which is 50 (Size) lt (unit). Note that Units must be of the same type as the stocktake unit eg if you stocktake in LT your purchase units need to be of type volume also eg. lt or ml.

SUPPLIER SKU

What is the supplier product code for the item that is displayed on supplier invoices.

SUPPLIER NAME

Who is the supplier you use for this product (for now just consider your main supplier other suppliers can be added later from within POS).

COST PRICE

Provide the current cost price (per stocktake size & unit)

INITIAL STOCK COUNT

What is the starting stock count that should be used when setting up stock. Counts need to be per stocktake unit & size and please also note the date & time the count is valid from.