Gsyfuy

Typesetting a double Over Dot on top of a symbol

Is ipsum/ipsa/ipse a third person pronoun, or can it serve other functions?

Could Giant Ground Sloths have been a good pack animal for the ancient Mayans?

How can I plot a Farey diagram?

Is this food a bread or a loaf?

"listening to me about as much as you're listening to this pole here"

Pristine Bit Checking

Are cabin dividers used to "hide" the flex of the airplane?

How is it possible for user's password to be changed after storage was encrypted? (on OS X, Android)

Is there a way to make member function NOT callable from constructor?

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

Add an angle to a sphere

Lied on resume at previous job

Landing in very high winds

How to deal with fear of taking dependencies

Can a planet have a different gravitational pull depending on its location in orbit around its sun?

How to move the player while also allowing forces to affect it

Is Social Media Science Fiction?

Finding files for which a command fails

Is it wise to hold on to stock that has plummeted and then stabilized?

What is the meaning of "of trouble" in the following sentence?

Could a US political party gain complete control over the government by removing checks & balances?

How could a lack of term limits lead to a "dictatorship?"

Why is the design of haulage companies so “special”?

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♦ 12 mins 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♦ 12 mins 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