Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Best way to run a custom report or export order details? 
 
Brady
Guru
 
Avatar
Total Posts:  330
Joined:  2007-09-10
Orange County, CA
 

The problem we’ve always had is getting our sales data out of Magento and into our accounting system (MAS 90). Previously we’ve had a custom reports extension created, but it is not compatible with Magento CE 1.4 or newer.

Basically we need a way to see:
- Sales inside / outside California (for taxes)
- Sales inside / outside Canada (for taxes)
- Total sales (with individual order details like order number, name, subtotal, shipping, discount, return amount, etc)
- Sales by SKU (with individual order details like order number, name, subtotal, shipping, discount, return amount, etc)
- Returns to be shown in reports when the return was processed, not when the original purchase was made

Solutions we’ve (briefly) explored:
- Custom extension (pricey)
- Pre-built extension (doesn’t usually meet the needs listed above)
- Dataflow (confusing)

Thanks in advance for the help and advice!

 
Magento Community Magento Community
Magento Community
Magento Community
 
AITOC
Guru
 
Avatar
Total Posts:  618
Joined:  2009-02-19
US
 

Hello Brady,

I think the problem can be solved with Order Import-Export extension by Aitoc (http://www.aitoc.com/en/magentomods_orders_export_and_import.html?utm_source=Magento+Forum&utm;_medium=How+do+I?+Questions&utm;_campaign=Ya). The extension can export raw data in XML format and transform it into necessary format with XSL. In your case you’ll need additional XSL files.
Additional details:

- Sales inside / outside California (for taxes)
Both values can be summed by criteria (state value)

- Sales inside / outside Canada (for taxes)
Both values can be summed by criteria (country_id value)

- Total sales (with individual order details like order number, name, subtotal, shipping, discount, return amount, etc)

The extension exports all orders information without any transformations

- Sales by SKU (with individual order details like order number, name, subtotal, shipping, discount, return amount, etc)

Could you please specify data format? One SKU can be used with a lot of orders. The information should be displayed properly.
How to split shipping cost between products in order?

- Returns to be shown in reports when the return was processed, not when the original purchase was made

That information can be filtered by order status or special notes.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top