How To Fulfil Root Chakra Mala
Posted by Oliver Olivas on 15 October 2019 01:56 AM

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 RootChakra 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-red 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

11. Send to supplier's email:

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).