0

I am exporting orders Sales > Orders to CSV.

The problem is, I can't see which fields are actually exported.

If anyone has any insight, I would much appreciate it.

Order CSV Export

3

The dropdown you're using is from a custom or a 3rd party module. There is no way for us to tell you what fields are exported, however, you could just export it and find out.

There is another way:

The button just above that dropdown that says "Export" will also export a CSV for the current rendered view. To find out what fields would be exported for Sales Orders, we take a peek in the grid block for sales order controller in Adminhtml:

public function exportCsvAction()
{
    $fileName   = 'orders.csv';
    $grid       = $this->getLayout()->createBlock('adminhtml/sales_order_grid');
    $this->_prepareDownloadResponse($fileName, $grid->getCsvFile());
}

So it looks like it exports columns based on the adminhtml/sales_order_grid block. The columns defined there happen to be the same as in that current view.

Conclusion:

If you were to use the orange Export button just above the dropdown you will receive a CSV export that is formatted similarly to the actual grid view. Using any other module or 3rd party to export will yield unpredictable (unknowable) results for this forum's audience.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.