Product System

Add your products/services here

In this section, let's us dive deeper in how to insert the data correctly in Excel sheet / CSV file. Here is the list of field which you are required to fill in once you have downloaded our Excel template from our software

Important Note: All fields are mandatory if you are using bulk upload or Excel sheet. If you want to leave the field blank, you need to insert at least something in the field. Please go through the guide below.

• Name: Insert your product/service name.

• SKU: Insert unique SKU number so that it is easier for you to track your product/service.

• Sale Price: Insert your original price.

• Purchase Price: Insert your sale/discounted price. Or else you can just insert the same price as original price if there is no promotion.

• Quantity: Insert the quantity of your product. If you like to ignore this, please insert "-" sign.

• Tax: Insert the tax ID which you have created in Accounting System > Accounting Setup > Taxes. This is how you retrieve your ID. The 1st entry is always 1. The 2nd entry is 2 and so on. If you like to ignore this, please insert "0" sign.

  • 
• Category: Insert the tax ID which you have created in Accounting System > Accounting Setup > Category. This is how you retrieve your ID. The 1st entry is always 1. The 2nd entry is 2 and so on. If you like to ignore this, please insert "0" sign (Please refer to above image for example)

• Unit: Insert the unit ID which you have created in Accounting System > Accounting Setup > Unit. This is how you retrieve your ID. The 1st entry is always 1. The 2nd entry is 2 and so on. If you like to ignore this, please insert "0" sign (Please refer to above image for example)

• Type: Insert the type of product/service you are selling. Choose either one.

  • Product

  • Service

• Description: Insert your product/service description. If you like to ignore this, please insert "-" sign.