I started developing an order export module some days ago.
The module currently has those features discussed in here, and I think I will send out the first beta in like a week.
I am looking for beta-testers. If you are interested, contact me through private messaging.
Please contact me with some details. Tell me which features you want, and in which format you need the export, just what you want to tell me how your order export module would have to look like.
Best would be if you for example send me a xml-template how your order would have to look like.
In my order export module, you can modify how your xml output should look really easily through the backend.
I am using XSL “templates”, so you can build your own XML, and being able to access ALL order data.
<!-- Put tags in here, which should wrap around each order --> <orders>
<!-- Process order XML --> <xsl:for-each select="orders/order"> <!-- Ex: Wrap <order> around each order --> <order> <!-- Ex: Then access values from export xml and put them into your own tags --> <id><xsl:value-of select="ID"/></id> <created><xsl:value-of select="created_at"/></created> <email><xsl:value-of select="customer_email"/></email> <!-- Ex: Now go to the billing section --> <!-- Ex: Wrap <billing> around billing section --> <billing> <xsl:for-each select="billing"> <!-- Ex: get values and wrap them into your own tags from billing section --> <prefix><xsl:value-of select="prefix"/></prefix> <name><xsl:value-of select="lastname"/></name> </xsl:for-each> <!-- Ex: Wrap </billing> around billing section --> </billing> <!-- Ex: Wrap </order> around each order --> </order> </xsl:for-each>
<!-- Put end tags in here, which should wrap around each order --> </orders>
Integrated into backend.
Order Export Manager: Grid where all exported orders are being stored.
Set default filename format for export: For example: export_ÚTE%_&#xTI;ME%
Export to what ever format you want, with XSL templates you can build any output you want (Templates I built: XML, CSV)
Templates can be defined in backend.
In the XSL Template every variable of the order can be used. (general, shipping, billing, payment, items)
Intelligent Export - saves last exported order, and on a new export last exported order is set as “start export from” id.
Date Range export - select a date range to export.
Download each order seperately
Mass Download of exported orders in a zip file selected in grid
Automatically export order after new order has been submitted (checkout)
FTP-Upload: You can upload the export to a ftp server, if upload fails this will be shown in the export manager.
Automatically export order and upload to a ftp server after a new order has been submitted (checkout)
More ideas please?
Only requirement: libxslt has to be installed on the server.
Isn’t order export a feature of the latest dataflow? We’re just now starting to look at it to export order data. Does anyone have it working or does it still require customization?
No, you currently can’t export orders - except using webservices.
If you like you can contact me and tell me which features you would like to have concerning the order export, and I’ll maybe integrate them.
I have a customer who receives about 500 orders per day (he sells cheap things), and now think how long that takes using webservices..
I have also coded a export script using webservices, and for the customer that took to long.. this is why I started coding my export module.
Also, integrating into magento has the advantage of using events (new order) etc..
I have a customer who receives about 500 orders per day (he sells cheap things), and now think how long that takes using webservices..
I have also coded a export script using webservices, and for the customer that took to long.. this is why I started coding my export module.
Also, integrating into magento has the advantage of using events (new order) etc..
Webservices can easy handle 500 orders in a day.
How do you handle invoicing, payment capturing, and shipment processing of 500 orders per day with just a export module without webservices? Do you manually update every single invoice, capture the payments, and marked items shipped for all 500 orders? How do you update the orders in Magento with just a export module?
I certainly won’t manually process 500 orders per day without webservices. Without webservices, I have a problem handling 50 orders a day.
By the way, my experience is coming from implementing e-commerce solutions and fulfillment systems for a company processing 5000 orders a day.
Who says that webservices are bad? Webservices are just fine for talking TO magento. But in my case for the order export only out of magento this is the best way.
By the way, the export module is mainly thaught for connecting an ERP—not handling invoicing etc. in magento.
So...if i understand well, there is now a export module but only for people who paid 
...
Sales: Call 877.832.5289 (N America)|310.295.4144 (International)
