Launching a supermarket, pharmacy, or hardware shop with 1,000+ SKUs? Use the bulk Excel importer to load your entire catalog and opening stock cleanly.
Importing Your Product Catalog #
- Go to Products → Import Products and click Download template file.
- Fill in required columns: Product Name, Unit, Product Type (
singleorvariable), Manage Stock (1or0), Purchase Price, and Selling Price. - Optionally fill in Brand, Category, SKU, Alert Quantity, Opening Stock, and Expiry Date — new categories and brands mentioned in the sheet are created automatically.
- Upload the completed Excel/CSV file and click Submit.
Updating Opening Stock Separately #
- If products are already created and you want to upload counted shelf quantities, go to Products → Import Opening Stock.
- Download the template, enter each product’s SKU, Location, Quantity, Unit Cost, and optional Lot/Expiry Date.
- Upload and click Submit to populate initial inventory across every branch.
Pro Tip: Always keep a backup copy of your Excel sheet. If any row has a formatting issue, S2 Pos shows the exact row number so you can fix and re-upload cleanly.
Need help with S2 Pos?
Our support team (by s2bd.com) can assist with setup, printer configuration, or a free live demo:
- WhatsApp / Phone: 01711131326
- Website: s2pos.com
- Video Tutorials: YouTube @s2pos
- Facebook: facebook.com/s2bd.pos
