After connecting your SQL account, you'll still need to map the SKUs, stores and warehouses and fees to create a sales invoice and deduct inventory in the SQL.

1. Mapping SKU with SQL item code   

1. Go to Mapping SKU

2. Select SKUs and hit Mapping or locate SKU and hit Single Mapping

Note: It’s required to start the BigSeller data plugin to map SKU. If the SKU name and the item code are the same, they’ll be mapped together. If the SKU name does not exist in the SQL system, it will create a new item code with the name and map them.


2. Mapping Stores with SQL Customer Code

1. Go to Store Mapping

2. Click Add Mapping

3. Choose your store and fill in the customer code

4. Click Submit

The customer code can be found here:

Note: Only shops form Shopee, Lazada and Tiktok Shop can be selected. 1 shop can be mapped with 1 customer code. But 1 customer code can be mapped with multiple shops.

3. Mapping BigSeller Warehouse with SQL Warehouse

1. Go to Warehouse Mapping

2. Click Add Mapping

3. Click Add

4. Choose your warehouse and fill in the warehouse code

5. Click Submit

Note:  A warehouse code can be mapped with multiple BigSeller warehouses, while 1 BigSeller warehouse can be mapped with 1 warehouse code only. If you don't have warehouse in the SQL, you can ignore the mapping.

The steps to find the warehouse code are shown below:

4. Mapping Fees

You can map the fees in BigSeller and SQL items to make fees more clear

1. Go to Warehouse Mapping

2. Fill out the items

3. Click Save

  Description of the fees:
Name Description
Shipping Fees Including buyer and seller shipping fees
Transaction Fees Including commission, transaction fees, service fees, etc
Discount Including seller and platform discount
Coupon Including seller and platform voucher
Refund Fees Including platform refund and adjustment fees
Default Fees If there are unmapped fees in invoice, BigSeller will automatically use the default fees.

5. Create Sales Invoice

After finish mapping, you can create the sales invoice for the completed orders from Shopee, Lazada and Tiktok Shop.

 1. In the Create Sales Invoice page,
 2. Select the orders and hit Create Sales Invoice

Orders will be moved to Create Successfully list when being created successfully. If you accidentially click Move to [Create Successfully] without creating invoices, the invoice cannot be generate from BigSeller anymore, please go to SQL system to do so.

Note: Please enable BigSeller Data Plugin before creating invoices.