Prepare Monthly Report

Table of contents

Prepare Magento orders
Export Order Data
Copy Paste SQL Code from here
Export the Results
Convert .csv file to UTF-8 Format
Format, Filter and sort the order List
Update the Formulas to the new month's order list
Update the Formulas
Troubleshoot the Formulas
Consistency Check
Update the Graphics
Send Report to Management
- Email report
New Procedure starting October 1 2024
Generate order list for Keys.Discount
Fill in Summary Sheet and business expenses

Sorry, but you do not have permission to view this content. Log in

What are your feelings

Still stuck? How can we help?

Updated on July 1, 2025