Dtjytyk

Add an angle to a sphere

Where to refill my bottle in India?

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

What is the offset in a seaplane's hull?

Information to fellow intern about hiring?

Is domain driven design an anti-SQL pattern?

Does it makes sense to buy a new cycle to learn riding?

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

When blogging recipes, how can I support both readers who want the narrative/journey and ones who want the printer-friendly recipe?

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

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

Unbreakable Formation vs. Cry of the Carnarium

Doomsday-clock for my fantasy planet

What do the Banks children have against barley water?

Ideas for 3rd eye abilities

What do you call something that goes against the spirit of the law, but is legal when interpreting the law to the letter?

Email Account under attack (really) - anything I can do?

Does the average primeness of natural numbers tend to zero?

"My colleague's body is amazing"

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

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

I see my dog run

Copycat chess is back

Typesetting a double Over Dot on top of a symbol

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♦ 19 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♦ 19 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