Warning: mysqli_connect(): (HY000/2002): No route to host in /home/skybizgl/public_html/ticket/header-uc.php on line 38

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /home/skybizgl/public_html/ticket/header-uc.php on line 39

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/skybizgl/public_html/ticket/header-uc.php on line 40

Import Sales Order from Excel to SkyBiz Distribution
Knowledgebase
SkyBiz Support Ticket > SkyBiz Support Ticket > Knowledgebase

Search help:


Import Sales Order from Excel to SkyBiz Distribution

Solution

 

Below are guideline(s) on How to Import Sales Order from Excel to MySQL

Step 1: Go to Data Excel Conversion Sheet

Go to Local Disk C>>MyERP>>Sample>>Data Conversion Sample

 

Step 2: Key in all data on Excel Conversion under Sales Order

Click "Sales Order" on worksheet tabs at bottom of excel >> key in all the data >> save the document

N/B: Note that RED titles are compulsory field.

 

 

Step 3: Open SkySyn

Go to Local Disk C>>MyERP>>SkySyn

 

 

Step 4: Go to File > Excel to MySQL2

 

 

Step 5: Synchronize Data

Select Database >> Choose File Location of Data Excel Convert >> Click Show Excel Sheet >> Tick Sales Order >> Click SQL Convert

 

 

Step 6: Wait until "Process Convert Completed" message shown then press "OK".

 
Was this article helpful? yes / no
Related articles Import Purchase Order from Excel to SkyBiz Distribution
Import Fixed Asset from Excel to SkyBiz
Import Item Master/Product Master from Excel into SkyBiz System
where to get data excel conversion
Guides on How to Import Text file to Excel format
Article details
Article ID: 29
Category: SkyBiz SkySyn
Date added: 2016-03-16 08:40:33
Views: 260
Rating (Votes): Article rated 3.0/5.0 (2)

 
« Go back

 
Powered by Help Desk Software HESK, brought to you by SysAid