---
title: "Importing Products & Opening Stock in Bulk"
description: Upload hundreds or thousands of products and initial warehouse stock counts in minutes using S2 Pos Excel import tools.
url: "https://guide.s2pos.com/docs/import-products-opening-stock/"
updated: "2026-11-22"
category: "Products & Inventory Setup"
tags:
  - S2 Pos
---

# Importing Products & Opening Stock in Bulk

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

1. Go to **Products → Import Products** and click **Download template file**.
2. Fill in required columns: **Product Name**, **Unit**, **Product Type** (`single` or `variable`), **Manage Stock** (`1` or `0`), **Purchase Price**, and **Selling Price**.
3. Optionally fill in Brand, Category, SKU, Alert Quantity, Opening Stock, and Expiry Date — new categories and brands mentioned in the sheet are created automatically.
4. Upload the completed Excel/CSV file and click **Submit**.

## Updating Opening Stock Separately

1. If products are already created and you want to upload counted shelf quantities, go to **Products → Import Opening Stock**.
2. Download the template, enter each product's **SKU**, **Location**, **Quantity**, **Unit Cost**, and optional **Lot/Expiry Date**.
3. 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](https://wa.me/8801711131326)
- **Website:** [s2pos.com](https://s2pos.com)
- **Video Tutorials:** [YouTube @s2pos](https://www.youtube.com/@s2pos)
- **Facebook:** [facebook.com/s2bd.pos](https://www.facebook.com/s2bd.pos)
