Export Daily Sales to Google Sheet or CSV
Hey Everyone (and AWS friends),
Would it be possible to get an easy to use daily automation that exports your new sales data (sku, qty sold, fees paid, and sale price) to a google sheet? It would be great to be able to export this into a single source of truth for all of my commerce channels and compare against ad spend on the day to understand my full picture. This would be much appreciated!
Export Daily Sales to Google Sheet or CSV
Hey Everyone (and AWS friends),
Would it be possible to get an easy to use daily automation that exports your new sales data (sku, qty sold, fees paid, and sale price) to a google sheet? It would be great to be able to export this into a single source of truth for all of my commerce channels and compare against ad spend on the day to understand my full picture. This would be much appreciated!
0 replies
Steve_Amazon
Hi @Seller_4o7Wv4mjVruWt,
Steve from Amazon here, thank you for reaching out. For this I recommend that you view and download the Transaction View report. The View Transactions Page displays a summary view of the transactions that have occurred in the account since the last settlement date up until closing on the previous day. A transaction can be a charge or credit that is initiated by Amazon, an order, a refund or an adjustment.
For your automation question, there are third party apps in Seller Central that may be a good option for you. Please visit this resource for more information there.
Please let me know if there are any questions.
Thanks,
Steve