By default, Magento’s order export only exports a few basic fields, often not enough even basic information required to for anything.
By customer request, we install an extension that extends the order export process; allowing you export all order components plus any number of existing product attributes with your order.
We will set up the required parameters and once you’re happy with the exported grid, you can easily manage it.
Go to Sales > Orders Export Tool > Export Profiles
Once you are in export profiles there are a few things to note:
1. File Format – how the file will be exported. CSV stands for Comma Seperated Values and this file opens up in Microsoft Excel or preferred LibreOffice Calc
2. Last Generated File – gives the url of the last exported file.
3. Starting with Order # – we will alway set the export file in such a way that it will export the next lot of orders. For example, if the last time you exported orders 125 – 180 (say orders in a month) – the next export will be from order #181 on. If you want to export earlier orders, you will have to hit the dropdown menu on the right and hit ‘edit’.
4. Last Update – this shows when the last export file was generated.
5. In the dropdown menu, the only necessary field you’d have to hit would be ‘edit’ – in case you want to add/delete fields or if you wanted to change from where (order #) the order file was exported.
To export your file, simply click on the orange line (2nd one usually) and a ‘save file’ window will appear. Save onto your computer and open it up with either Microsoft Excel or better LibreOffice Calc.
If you want to make an edit to the fields being exported or from what order # the filie is exported from, go to the dropdown menu on the right and hit ‘edit’.
On the first (configuration) tab – the only field you need to be concerned with is highlighted in red. If you want to change from what order the file is exported from, just change it here.
In the template tag, this is where the export fields are set up. You can click on it and see how it is set up but I will not go into how this is managed. If you would like additional fields added, just let me know.
Once you have edited the file, you will have to regenerate the export file by clicking save and then generate.