1. Home
  2. Apps : Accounting
  3. How to Sync with SQL Accounting

How to Sync with SQL Accounting

With SQL Accounting Sync, you are able to sync your online order details from your SiteGiant store into SQL Accounting Software easily with just a few clicks. Let’s go through the video guides below.

Step 1: Creating New Profile in SQL Account Sync

For this episode, we will be covering how to create a new profile in SQL Account Sync:
1. Creating a new company profile
2. Setting up your SQL Account Sync Settings

Step 2: Setting Up Your SQL Account Sync Setting

For this episode, we will be covering how to set up SQL Account Sync settings in SiteGiant Lite:
1. Setting your SQL Account Sync settings in SiteGiant Lite
2. Creating a new customer code in SQL Accounting Software
3. Creating a new product code in SQL Accounting Software
4. Selecting auto-generate invoice number channel
5. Creating preset for coupon in SiteGiant Lite

Step 3: Matching Your Customers in SQL Account Sync

For this episode, we will be covering how to do customer matching in SQL Account Sync:
1. Matching your customer in SiteGiant Lite
2. Adding new store & matching your customers in SiteGiant Lite

Step 4: Making Customer Payment in SQL Account Sync

For this episode, we will be covering how to make customer payment from SiteGiant Lite to SQL Account Sync:
1. Downloading payment file from Lazada Seller Centre
2. Importing payment file to SiteGiant Lite.
3. Making customer payment in SQL Account Sync

Step 5: Matching Your products in SQL Account Sync

For this episode, we will be covering how to match your products in SiteGiant Lite:
1. Viewing your list of items in product matching tab
2. Selecting and inputting product ID & product UOM into SQL Account Sync
3. Importing & exporting product matching excel file

Step 6: Syncing Your Orders into SQL Accounting

For this episode, we will be covering how to sync your orders from SiteGiant Lite into SQL Accounting:
1. Filtering & Checking Orders that haven’t synced into SQL Accounting
2. Syncing your orders from SiteGiant Lite into SQL Accounting

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support