Magento WizardNo joke, this website relaunches on 1st April. New look, new features!

Contact the site  Make Money

Export List of Magento Orders in CSV Format

 Add to Favourites  
(6 rating, 10 votes)
Loading ... Loading ...

It’s just over eight months since Magento came on the scene, and although it has improved in leaps and bounds, the Reporting which is available through Admin is still deemed to be pretty shoddy. Indeed, similarly trying to integrate anything into third party software is very difficult.

Like our company, we use a delivery service who have a Consignment system. This system can be fed information in numerous formats, which then can spit out labels ad hoc – however, until now, it hasn’t looked as though Magento is going to be any good for this.

A plugin now though has been created whereby you can export any Magento orders into CSV format with the click of a button. An absolute Godsend if you are looking to process a huge bundle of orders from your Magento site before your courier cut-off time elaspes!

This plugin simply needs to be unzipped and uploaded to your server in a secure location – it allows you to output a valid CSV file containing all the “unprocessed” orders which have yet to be shipped. The report creates a breakdown of individual products to be shipped to customers and where they should be sent, including SKU codes.

Once uploaded, just use your FTP client to update the database connection string, and then access the script via surfing to the location on your browser. It will grab the data from your database and prompt you to download in CSV format.

It must be noted that this script should be ran BEFORE you ship your items – it only READS the information in your database, it doesnt update or change anything.

Download the Script and Export Your Orders Today!

  • Digg
  • del.icio.us
  • Facebook
  • Google
  • LinkedIn
  • Live
  • Reddit
  • StumbleUpon
  • Technorati
  • TwitThis

about the author

    This article was written by Sam Davis on January 7, 2009.
    Computing over a glass of Grenache Shiraz... again!
    Sam is the Editor of Blasted Thing. Contact Us

related articles

 Product Tags on Product Page - Video Guide
 Template Path Hints - Video Guide
 Disable Cache while developing your site - Video Guide
 Import/Export Data with Profiles - Video Guide
 Google Base Integration - Video Guide

comments

7 Responses to “Export List of Magento Orders in CSV Format”

  1. Hanen on January 7th, 2009

    salut
    je veux exporter mes produit déjà créé dans une site magento pour les importer dans une autre base de nouveau site Magento
    SVP aidez moi pour exporter et importer correctement mes produits (si c possible avec des imprimer ecran)
    Car j’ai exporté mes produits sous forme d’un fichier CSV et je les ai importés après Mais j’ai pas trouvé mes produits installés dans le nouveau site

  2. Baker Comoy on February 16th, 2009

    Absolutely outstanding!

  3. Chaz on March 31st, 2009

    I can’t get this to output any orders.

    What is this line supposed to represent?
    $sitename = “mysite”; // update this to customise your filename

    If it’s the Magento directory, I installed Magento in the domain root… do I leave it blank?

    I am running multiple stores, so is it the Website Name, Store Name, or Store View Name?

  4. @domainpubber on April 11th, 2009

    Thanks for this code Sam!!!

    I am having a problem with product names that contain commas; as the script is written currently this causes them to be seen as delimiters. Can you offer thoughts on how to solve this please?

  5. Adam on June 5th, 2009

    Fantastic

  6. Mel on January 21st, 2010

    Hi,

    This is a outstanding script, my compliments!!

    However, i want to exclude 2 categories from the export, is this possible?
    Also i am having a problem with the quantity….it is not in the export??

    Thanks in advance for you’re reply…………….

  7. Nacho on January 26th, 2010

    Hi!, nice code, but why is still working for old orders like 3months ago?

    It doesn’t retrieve anything.

    Thanks!

Leave a Reply




Spam protection by WP Captcha-Free


Magento Admin System – Video Guide

  • Sponsored Ads

  • Magento Themes
    • vtiger: great article, thank you....
  • Recent Tweets

    RT @atafoto: RT @NicolasPittet: Embedded ERP : Gestion des stocks et des approvisionnements sous #Magento : http://bit.ly/cV6l6e #ecommerce

    Dificuldades com templates do #magento http://ow.ly/1oOcV #cursodeseo

    Magento Expert - oDesk: Hello I have 2 bugs on my magento theme and I need magento expert to fix it. 1. Create my ... http://bit.ly/b1bm7v

    Magento Ecommerce Development http://tinyurl.com/ybbjw45 #bu266

    Magento Expert - oDesk: Hello I have 2 bugs on my magento theme and I need magento expert to fix it. 1. Create my ... http://bit.ly/b1bm7v