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
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
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.