PDA

View Full Version : Third party order export?


ILoveHostasaurus
04-04-06, 02:20 AM
Does anyone have an order export module for MM5? I've had an open bug for the Miva order export module dating back to October of last year and it has still not been fixed. The symptoms are that the order export file will have the tax and shipping columns treated as cumulative so each order adds to the previous value in that column and your data is all wrong.

jason - jmh web services
04-04-06, 08:13 AM
Does anyone have an order export module for MM5? I've had an open bug for the Miva order export module dating back to October of last year and it has still not been fixed. The symptoms are that the order export file will have the tax and shipping columns treated as cumulative so each order adds to the previous value in that column and your data is all wrong.

Don't believe one is available yet. :(

Jason

dotCOM_host
04-04-06, 08:28 AM
About the only way I've been able to do any exporting properly so far was to write my own mySQL queries and reports (assuming the store is using mySQL on the back-end, not mivasql).

ILoveHostasaurus
04-04-06, 04:35 PM
A module developer has graciously built a replacement order export module for me from the limited source kit, he noticed in the code that "I see where they clear out the l.fields_serialized variable. But, I do not see where they clear out the l.order_tax or l.order_shipping variables." which is what causes the values to be cumulative. I've installed it in a customer's store and am waiting for confirmation that it corrects the issue.

ILoveHostasaurus
04-04-06, 05:16 PM
I've confirmed that this has corrected the issue; I'll forward the fix on to Miva.

kevin@stoneedge.com
04-04-06, 08:53 PM
We've got an export module designed to allow you to download your order information at the click of a couple of buttons in the Stone Edge Order Manager. This module does not use a Miva Admin interface but is called externally from the Order Manager (can also be called from a Browser if not using the Order Manager). Data is in XML format and is specific to the Order Manager import specification (available in the Order Manager's Developer's Guide). Call me if you want additional details...

Smile Dave,

Couldn't resist getting us on the forum...

wcw
04-05-06, 05:21 PM
The EZ Batch exports orders to a flat file in addition to running a better batch report. The orders flat file can be retrieved with FTP or you can have the module email it to you. In addition to the usual columns, this orders export file contains columns for "other charges" like coupons, fees, etc. Just recently I added the ability to export the shipping method and order total weight in the other charges column too. Course the orders export is just one feature. The batch report gives you the ability to add store logo, leave out certain pieces of the batch, etc so you can make invoices, packing slips and run your batch with the same module. You can read about the features at
http://www.emporiumplus.com/go/wcw/PROD/1AAM5/1AA00211

jason - jmh web services
04-05-06, 05:39 PM
The EZ Batch exports orders to a flat file in addition to running a better batch report. The orders flat file can be retrieved with FTP or you can have the module email it to you. In addition to the usual columns, this orders export file contains columns for "other charges" like coupons, fees, etc. Just recently I added the ability to export the shipping method and order total weight in the other charges column too. Course the orders export is just one feature. The batch report gives you the ability to add store logo, leave out certain pieces of the batch, etc so you can make invoices, packing slips and run your batch with the same module. You can read about the features at
http://www.emporiumplus.com/go/wcw/PROD/1AAM5/1AA00211

sweet. Can it export payment method, last four digits of cc?

wcw
04-05-06, 05:42 PM
No payment method, just the amounts.