Knowledgebase:
How To Fulfill Root Chakra Candle Orders
Posted by Oliver Olivas, Last modified by Oliver Olivas on 15 October 2019 12:12 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 RootChakraCandles tab:

  1. Customer Name
  2. Clickbank Order ID
  3. Purchase Date
  4. Product
  5. Order ID from the csv file (Paste it under the COMMENTS column)

9. On a separate excel file, fill in the following columns:

  1. Order Date
  2. Receipt (Clickbank Order ID)
  3. Account
  4. Name
  5. Item
  6. Quantity
  7. Price (price is always 0)
  8. SKU (SKU is clickbnk-rootchkra-candle)
  9. Tags (Tags is always clickbank)
  10. Comments (csv file order number)
  11. Order Details
  12. Complete Address

10. Log in to CosmicCuration's Shopify 

username: donna.dfys@gmail.com

password: Welcome01!

11. Click on the Apps tab. Then Click on EZ Importer by Highview Apps

12. Click on Import Orders. Upload candle order csv file using the following format: RootChakraCandles Month/Date - Month/Date

13. Once you have selected the correct csv file, click on Review Import button.

14. Scroll down. Review data before clicking on the Import buton.

15. Wait for the import process to be complete. Go back to CosmicCuration's Shopify. Input the Receipt number on the search bar on top of the screen and click on the order.

16. Look for the customer's email address in Clickbank Master Account by using the customer's Receipt number in the Receipt Search box. Copy customer's email address.

Username: Ric@thecosmoswithlove.com

Password: COsmic17!!

17. Paste customer's email address in Contact Information section by clicking on the Edit button. Once finished, click on Create Shipping Label button.

18. Click on Buy Shipping Label button. Before you do, make sure that the Package is Candle Box (12x2x2 in), Total Weight is 5oz and Shipping Service is USPS First Class Package.

19. Copy the tracking number

20. Paste the tracking number in the Google Sheets under the Tracking # column.

(0 vote(s))
Helpful
Not helpful

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