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