Hjdcti

Is it legal to have the "// (c) 2019 John Smith" header in all files when there are hundreds of contributors?

How to make payment on the internet without leaving a money trail?

Extreme, but not acceptable situation and I can't start the work tomorrow morning

Can I find out the caloric content of bread by dehydrating it?

Why do we use polarized capacitors?

Shall I use personal or official e-mail account when registering to external websites for work purpose?

Need help identifying/translating a plaque in Tangier, Morocco

What to wear for invited talk in Canada

Why do UK politicians seemingly ignore opinion polls on Brexit?

Ideas for 3rd eye abilities

Manga about a female worker who got dragged into another world together with this high school girl and she was just told she's not needed anymore

Landlord wants to switch my lease to a "Land contract" to "get back at the city"

If a centaur druid Wild Shapes into a Giant Elk, do their Charge features stack?

Domain expired, GoDaddy holds it and is asking more money

What is the command to reset a PC without deleting any files

Is "plugging out" electronic devices an American expression?

Is this food a bread or a loaf?

How can I add custom success page

Are objects structures and/or vice versa?

Is window.confirm() accessible?

Symmetry in quantum mechanics

What causes the sudden spool-up sound from an F-16 when enabling afterburner?

Denied boarding due to overcrowding, Sparpreis ticket. What are my rights?

Prime joint compound before latex paint?

How to generate/export a custom format of CSV file?

Customer CSV export fails with blank pageMagento csv export and then to MySQL databaseUpload csv file with products. not workingMagento 2 : get csv file download in frontend based on click of buttonMost efficient way to generate Products CSVCreate custom order CSV per order with header record and detail recordMagento 2 sales order grid custom column export csv issueHow to Add export type as TXT in export like Csv and Xml from Magento 2Can't Upload products via CSV fileRun native csv import product magento 2, no way to set csv file in custom module

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

2

I hope some one can help me.

Now, I want to generate a csv file of my sales order, but I think existing magento 2 csv format is not fulfill my expectation.
Could anyone can help me how to generate the below CSV file format through magento 2 admin export function.

Thanks!

The below image is my expect CSV data format result:

magento2 csv magento-2.1.1

share|improve this question

edited May 31 '18 at 10:36

hweb87

5972724

asked Oct 19 '16 at 9:15

Felix91627Felix91627

536

bumped to the homepage by Community♦ 2 hours ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

2

I hope some one can help me.

Now, I want to generate a csv file of my sales order, but I think existing magento 2 csv format is not fulfill my expectation.
Could anyone can help me how to generate the below CSV file format through magento 2 admin export function.

Thanks!

The below image is my expect CSV data format result:

magento2 csv magento-2.1.1

share|improve this question

edited May 31 '18 at 10:36

hweb87

5972724

asked Oct 19 '16 at 9:15

Felix91627Felix91627

536

bumped to the homepage by Community♦ 2 hours ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

I hope some one can help me.

Now, I want to generate a csv file of my sales order, but I think existing magento 2 csv format is not fulfill my expectation.
Could anyone can help me how to generate the below CSV file format through magento 2 admin export function.

Thanks!

The below image is my expect CSV data format result:

magento2 csv magento-2.1.1

share|improve this question

edited May 31 '18 at 10:36

hweb87

5972724

asked Oct 19 '16 at 9:15

Felix91627Felix91627

536

share|improve this question

edited May 31 '18 at 10:36

hweb87

5972724

asked Oct 19 '16 at 9:15

Felix91627Felix91627

536

share|improve this question

edited May 31 '18 at 10:36

hweb87

5972724

asked Oct 19 '16 at 9:15

Felix91627Felix91627

536

edited May 31 '18 at 10:36

hweb87

5972724

edited May 31 '18 at 10:36

hweb87

5972724

asked Oct 19 '16 at 9:15

Felix91627Felix91627

536

asked Oct 19 '16 at 9:15

Felix91627Felix91627

536

1 Answer
1

active

oldest

votes

0

Actually in Magento 2 you can export sales info that correspond to columns of order grid:

As you see, there are only some of columns included in your template, namely (order ID, customer e-mail, shipping method). So there is no out of the box way to do it, unless you use coding if you have skills or third-party tool.

share|improve this answer

answered Oct 21 '16 at 15:11

MarcoMarco

1

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f141568%2fhow-to-generate-export-a-custom-format-of-csv-file%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Actually in Magento 2 you can export sales info that correspond to columns of order grid:

As you see, there are only some of columns included in your template, namely (order ID, customer e-mail, shipping method). So there is no out of the box way to do it, unless you use coding if you have skills or third-party tool.

share|improve this answer

answered Oct 21 '16 at 15:11

MarcoMarco

1

add a comment | 

0

Actually in Magento 2 you can export sales info that correspond to columns of order grid:

As you see, there are only some of columns included in your template, namely (order ID, customer e-mail, shipping method). So there is no out of the box way to do it, unless you use coding if you have skills or third-party tool.

share|improve this answer

answered Oct 21 '16 at 15:11

MarcoMarco

1

add a comment | 

Actually in Magento 2 you can export sales info that correspond to columns of order grid:

As you see, there are only some of columns included in your template, namely (order ID, customer e-mail, shipping method). So there is no out of the box way to do it, unless you use coding if you have skills or third-party tool.

share|improve this answer

answered Oct 21 '16 at 15:11

MarcoMarco

1

share|improve this answer

answered Oct 21 '16 at 15:11

MarcoMarco

1

answered Oct 21 '16 at 15:11

MarcoMarco

1

answered Oct 21 '16 at 15:11

MarcoMarco

1