Getting Started with Inventory

Congratulations! You’ve just taken the first step to organizing your inventory with SystemSIA. Now that you’ve started your trial, you can follow this guide. It will help you get the most value out of SystemSIA in the shortest amount of time. 

Importing your products to SystemSIA 

To start managing your inventory, let’s start by adding a product list to SystemSIA. This can be done by importing a csv file to SystemSIA. 

If you don’t have a spreadsheet with all your products, you can get in touch with your vendors/suppliers to see if they can send one to you. From there you can make a few changes to match the import template we have below. 

1. If you haven’t downloaded the template from SystemSIA directly, then download this csv template to quickly import products to SystemSIA. If you already have a csv file with your products, you can format that file to look like this template for easy importing. 

2. Go to Warehouse, select inventory and click import Excel.

3. Click to find the csv file from your computer or drag and drop your file. Then click Save.

Take a look around

Now that SystemSIA has some products, it’s time to get familiar with viewing your products in SystemSIA

1. On the Homepage, click on Warehouse goto inventory

2. Click on any of your items in this list to see more details.

3.Here you’ll notice all the information from your csv is populated onto the product record. If you think you’ll be interested in being alerted when you’re low in stock, you can edit the item and add a Critical limit and Reorder Quantity.

4.To view the product list in full screen again, click the blue circular symbol at the upper right. 

Next Step

For the manual input of product, visit How to setup a product record.


Was this article helpful ?

[yasr_visitor_votes null size=”–“]

Have more questions ? Submit a request

Create product record(s)

Products can be added in SIA in two ways:

One at a time – Use this approach if you have a limited number of products.

Batch upload – Import your product details all at once by using our Excel template.

On the menu, click Warehouse and select Inventory.

How to setup a product record one at a time

1. On the Action section (left side), click Create New button.

2. Fill up the product details. On the Image field, click the grey square to upload a photo.

3. Input Item Code and Item Name. Note: Item Code and Item Name must be unique.

4. Select category. If the category is not on the list, click Add New Category and type the category you want to add. Note: Group your products into distinct categories. This might help you in organization and analysis.

5. Select a Brand. If the Brand is not on the list, click Add New Brand and type the brand you want to add.

6. Type in the Barcode and Description.

7. Select Supplier and Unit. Note: The unit is what term you use to measure the quantity of your product (Example: Pcs, Kg, Box)

8. Input the Current Quantity, Cost, Price, Reorder Quantity, and Critical Limit. Note: Reorder Quantity is the quantity when your item is needed to be reordered. Critical Limit is the critical level of your item’s quantity. Get notified before you go out of stock.

9. Select Item Type if Product or Service. Note: COGS Account is connected on your income statement. Tax type: If your item is VATable or Non VATable.

10. Select Active in Status to display the item. Note: Inactive status will not display the item for your transactions.

11. If you want to set expiration, tick Enable Expiry. Note: Adding of Expiration Date is upon receiving the item.

12. Tick Enable Group Price, if you have multiple pricing for different customers and input the prices for your item. Note: One group price of an item can be assigned to your customer. This is the amount they have to pay.

13. Click the Save button.

How to upload product records by batch

1. On the Action section (left side), click Import Excel button.

2. Click the Download Template button.

3. Open the Excel template, fill up the fields, and save on your computer.

4. Go back to the system, click Select File and select the Excel file you saved.

5. Wait for the file to upload.

6. Click Save once done.


Was this article helpful?

[yasr_visitor_votes null size=”–“]

Have more questions ? Submit a request