Xin Cube Home > Articles > Xin Invoice 3.0 User Guide > Inventory Database > Import Inventory
Getting Started
Company Information
Definition
Add New Company
Open Company
Update Company
Delete Company
Add Company Logo
Remove Company Logo
Set System Data
Default Document Setting
Payment Terms
Inventory Category
Tax
Reference Code
Email Format
Setup Email Server
Personal Preference

Inventory Database
Definition
Add new Inventory
Update Inventory
Delete Inventory
Add Inventory Photo
Remove Inventory Photo
Import Inventory
Export Inventory

Customer Database
Definition
Add new Customer
Update Customer
Delete Customer
Add Customer Photo
Remove Customer Photo
Import Customer
Export Customer

Sales Person Database
Definition
Add new Sales Person
Update Sales Person
Delete Sales Person
Add Sales Person Photo
Remove Sales Person Photo
Add Sales Person Signature
Remove Sales Person Signature
Import Sales Person
Export Sales Person

Quotation
Definition
Draft Quotation
Generate Quotation
Update Quotation
Delete Quotation
Duplicate Quotation
Customize Template

Invoice
Definition
Draft Invoice
Generate Invoice
Update Invoice
Delete Invoice
Duplicate Invoice
Import From Quotation
Generate Delivery Note
Receive Payment
Recurring Invoice
Customize Template

Credit Note
Definition
Draft Credit Note
Generate Credit Note
Update Credit Note
Delete Credit Note
Duplicate Credit Note
Import From Invoice
Customize Template

Security
Set Password
Data Backup




 

Import Inventory

If you have too many Inventory record and it is too time consuming to create one by one into the system, you may import a list of Inventory into the database from Excel file.

To be able to import the Inventory data correctly, you will need to use our Template to do the import.

1. Click on button "Import" on the top menu in Inventory Master page,.
Import Inventory from Excel

2. On the popup screen, click on "Click here to download our Excel template".
Select an Inventory to edit

3. There are 6 columns in the Excel template:

a) Inventory Name - Name or description of the inventory
b) Code - Unique reference of the inventory
c) Category - The Category value must be same as the Category Name set in Setting > Inventory Category. If the system could not match the data, a new Inventory Category will be created
d) Unit - Unit of Measurement of the inventory
e) Unit Price - Unit selling price of the inventory
f) Cost - Purchase cost of the inventory

Inventory Template

4. Create 2 Inventory item in the Excel template, save the template file.

Enter inventory information to Inventory Template

5. On the Import Inventory page, click button "Browse" and select your Excel file to be imported.

Choose your excel file

6. Then click on button "Import Now".

Import Inventory Now

7. Once the inventory imported successfully, you will be notified.

Inventory imported successfully

8. The imported inventory will be list on the Inventory Master.

Inventory List



Next : Click here to learn how to export Inventory List >>
 
     
 
Contact Us For all Support issues, please use our online ticketing system.   Email Us E-mail us anytime at and we'll help.
Please give us a few business days to respond! Thanks!