What is a Smart SKU?

The Smart SKU is a tool that generates an SKU for your inventory items based on the attributes and rules decided by you. Smart SKU is free, open source and works on Web, Windows, Linux, Android, iOS and macOS!

What is SKU (Stock Keeping Unit)

A SKU, or Stock Keeping Unit, is a unique number used to internally track a business' inventory. Retailers use SKUs to track their inventory and sales, which can provide analytical data that are beneficial to have in order to develop relationships with your vendors and customers.

Why is SKU important?

SKU numbers are important because they ensure your inventory is accurately tracked, and help you pinpoint when exactly to order new products so your merchandise never goes out of stock.

Why Smart SKU is used?

To uniquely identify and track individual products within a company's inventory system.
To manage their inventory more efficiently.
To track the movement of each product from the time it enters the inventory until it is sold.
To pinpoint when to order new products, so your merchandise never goes out of stock.

How to Run the Project :

Open the project using Visual Studio
Right click on the Solution 'SmartSkus' -> Properties -> Multiple startup projects -> Select(Start) - SmarSkus.Api and SmartSkus.Wasm -> OK
Note: The database will automatically created upon run of the project, as InMemory Db is used in this project.

Features

Inventory Management - Dashboard will display all items in Inventory with Sku, Description and quantity:

User can add new item in inventory by providing SKU, Description and Quantity.
If user adds unknown SKU, it will create new item in inventory.
If user adds known SKU, it will add the quantity to existing item in inventory.
If user adds negetive quantity with known SKU, it will substract the quantity to existing item in inventory.

Dashboard :

Inventory Management Form (User can add new item in inventory by providing SKU, Description and Quantity):

Result :

SKU Management - Dashboard displays all unique Sku's in inventory and their variations:

User can manually add new Item by specifying one or more attributes, whose Sku will be generated automatically.
User can add bulk items by specifying item name and selecting preconfigured options, whose Skus will be generated automatically.

Add Single Item in Inventory and SKU will be generated automatically along with QR-Code.

Result :

Add Bulk Items in Inventory and SKUs will be generated automatically along with QR-Codes.

Result :

Available Items in the Inventory Can be Viewed All or Seperately using following buttons in left panel :

Admin Panel - After Login user can manage Master Data:

Admin User can manage(perform CRUD operations) items in Inventory.
Admin User can divide the items in inventory by adding different Categories.(e.g - Apperals, Electronics etc.)
For Each defined category different sub-options, can be added.(e.g - T-Shirt(Item Name), Apperal(Category), Size(Option Key), Small,Medium,Large(Option Values).
Admin User can manage(perform CRUD operations) all categories and sub options.