1. Log in to Clickbank API

username: oliver

password: oliverolivas

2. Click on the Orders tab on the left side.

3. Click on CHECK FOR NEW ORDERS button.

5. Click on DOWNLOAD NEW ORDERS button.

6. Open the downloaded csv (excel file). Include check for special characters (#^*@) in the file and correct entries from:

1. Customer's name
2. Address line 1&2
3. Zip Code
4. Country

Below is an example of an error that we are looking for (orders bound for EU countries usually have these error/s):

7. Check each address using the Zip Code to verify if the customer has provided a correct address. Copy customer's Zip Code and Country and input them in the Zip Code Checker

8. Transfer the following data from the downloaded csv file to Google Sheets under the SpiritTree tab:

1. Customer name
2. Clickbank order ID
3. Purchase date
4. Order ID (copy the order ID to the AliExpress Order ID column)

9. On a separate csv file, copy the information from the downloaded csv file and add a column after the Country column and name it SKU and put 23199977-lift-tree to every entry on the sheet.

10. Once verifying that all entries are correct, save the csv file with the following format: CB_LiftTree_Month_Date-Month_Date (Example given ranges from September 28-September 30)

11. Send to supplier's email: 563515679@qq.com