How to find and upload your Shopify report

IMPORTANT NOTE:

1. Your Shopify products must have a unique SKU so you can assign it to its respective book in AHS. If a product doesn't have a SKU, it will not register in the income reporting. Here's a step-by-step rundown.

2. In order to see your Shopify income in AHS you must manually create the book in AHS first. While doing so, you can assign it the Shopify SKU you defined on their site. If you didn't assign the SKU during the book's set-up on AHS, you can add it by going to your book's Details tab on the BOOKS Page. 

Once you follow these steps you can move on to the setup steps below.

Step 1: Head to Shopify's reports page.

Step 2:

Step 3:

Step 4:

Step 5:

Shopify's system allows customers to create their own report. Don't be intimidated by this step. Just copy and paste this AHS code:

FROM sales
SHOW net_items_sold, net_sales, total_sales, billing_country, order_id, day, product_variant_sku
WHERE line_type = 'product'
GROUP BY product_title, billing_country, order_id, day, product_variant_sku
SINCE this_month
UNTIL this_month
ORDER BY day ASC
LIMIT 100000

Step 6:

Step 7:

Step 8:

Step 9:

INITIAL SETUP IS COMPLETE!

Now that the initial setup is complete, you can do the following going forward.

Step 1:

Step 2:

Step 3:

IMPORTANT: You can only select one month at a time.

Step 4:

Step 5:

Step 6:

Save it to a location on your computer you can find easily.

Step 7:

Step 8:

Once you've dowloaded the file, you can upload it by clicking on the 'Upload income report' button on the AHS homepage. Be sure to choose the Shopify option from the drop-down menu.

Click 'Choose File' and select the downloaded report to send it to AHS.

• Related Articles

• Creating SKU's in Shopify

  From your Shopify admin, go to Products. Click the product that you want to edit. For products with multiple variants, in the Variants section, add your SKU numbers: For products without variants, in the Inventory section, add your SKU number: Click ...

• How do I manually upload a KDP report?

  1. Head to KDP on Amazon at kdp.amazon.com (in the US) 2. Click on ‘Reports’ at the top of the page. 3. Select ‘Royalties Estimator’ 4. In the date drop-down, choose ‘Last 90 Days’ 5. Click ‘Download’ 6. Download the file to a place on your computer ...

• My report file will not upload to AHS. What can I do?

  There is a common issue with spreadsheet apps, especially Excel. When the report file is either opened or renamed before uploading to AHS, the app can change the ISBNs to scientific notation. Here's a screenshot of an opened file: Notice the "+12" in ...

• How do I download the 90 day report from KDP?

  1. Head to KDP on Amazon at kdp.amazon.com (in the US) 2. Click on ‘Reports’ at the top of the page. 3. Select ‘Royalties Estimator’ 4. In the date drop-down, choose ‘Last 90 Days’ 5. Click ‘Download’ 6. Download the file to a place on your computer ...

• How do I upload Amazon Ads to AHS?

  In order to get your ads reports for Amazon on The Author Helper Suite, please follow these steps. STEP 1 – Make sure you’re on the main campaigns page and select the date you want to download. NOTE: Amazon often updates the data multiple days later, ...