Is a stroke of luck acceptable after a series of unfavorable events?

What do "high sea" and "carry" mean in this sentence?

Robert Sheckley short story about vacation spots being overwhelmed

When Does an Atlas Uniquely Define a Manifold?

Are there languages with no euphemisms?

Why were Madagascar and New Zealand discovered so late?

How do I solve this limit?

Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis

What is the purpose of the Evocation wizard's Potent Cantrip feature?

Does it take more energy to get to Venus or to Mars?

How can I get through very long and very dry, but also very useful technical documents when learning a new tool?

How to Reset Passwords on Multiple Websites Easily?

Why didn't Theresa May consult with Parliament before negotiating a deal with the EU?

Can a single photon have an energy density?

Is it okay to store user locations?

Would this house-rule that treats advantage as a +1 to the roll instead (and disadvantage as -1) and allows them to stack be balanced?

How do I get the green key off the shelf in the Dobby level of Lego Harry Potter 2?

Is it my responsibility to learn a new technology in my own time my employer wants to implement?

How do scammers retract money, while you can’t?

What is the point of a new vote on May's deal when the indicative votes suggest she will not win?

Visit to the USA with ESTA approved before trip to Iran

Where to find order of arguments for default functions

How can I open an app using Terminal?

Natural language into sentence logic

Report to tell how long it took from order to shipping

0

I am trying to find out if there is a report to show how long (how many days) it took for orders to be shipped. For instance, for July the average lapse from order to shipping was 2 days etc.

shipping reports ee-1.14.2.4

share|improve this question

edited 56 mins ago

Shoaib Munir

2,2941829

asked Aug 17 '17 at 2:12

RachaelRachael

11

add a comment | 

0

I am trying to find out if there is a report to show how long (how many days) it took for orders to be shipped. For instance, for July the average lapse from order to shipping was 2 days etc.

shipping reports ee-1.14.2.4

share|improve this question

edited 56 mins ago

Shoaib Munir

2,2941829

asked Aug 17 '17 at 2:12

RachaelRachael

11

add a comment | 

I am trying to find out if there is a report to show how long (how many days) it took for orders to be shipped. For instance, for July the average lapse from order to shipping was 2 days etc.

shipping reports ee-1.14.2.4

share|improve this question

edited 56 mins ago

Shoaib Munir

2,2941829

asked Aug 17 '17 at 2:12

RachaelRachael

11

share|improve this question

edited 56 mins ago

Shoaib Munir

2,2941829

asked Aug 17 '17 at 2:12

RachaelRachael

11

share|improve this question

edited 56 mins ago

Shoaib Munir

2,2941829

asked Aug 17 '17 at 2:12

RachaelRachael

11

edited 56 mins ago

Shoaib Munir

2,2941829

edited 56 mins ago

Shoaib Munir

2,2941829

asked Aug 17 '17 at 2:12

RachaelRachael

11

asked Aug 17 '17 at 2:12

RachaelRachael

11

1 Answer
1

active

oldest

votes

3

This report does not exist out-of-the-box per-se, but you can get this information with an SQL query [insert standard caution about running SQL on your live production database]:

SQL Query

select e.increment_id,e.created_at as order_date, min(sfs.created_at) as first_shipment_date, TIMESTAMPDIFF(hour, e.created_at, sfs.created_at) as time_to_shipment

from sales_flat_order e

left join sales_flat_shipment sfs on (e.entity_id = sfs.order_id)

group by e.created_at having (time_to_shipment is not null)

order by e.created_at desc

Sample output

increment_id    order_date  first_shipment_date time_to_shipment

38660   2017-08-16 17:38:00 2017-08-16 19:43:22 2

38659   2017-08-16 16:51:31 2017-08-16 19:48:56 2

38658   2017-08-16 16:42:34 2017-08-16 17:13:51 0

38657   2017-08-16 14:35:48 2017-08-16 15:23:19 0

38656   2017-08-16 14:10:33 2017-08-16 15:22:16 1

share|improve this answer

answered Aug 17 '17 at 4:47

philwinklephilwinkle

33.4k582144

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%2f189406%2freport-to-tell-how-long-it-took-from-order-to-shipping%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

3

This report does not exist out-of-the-box per-se, but you can get this information with an SQL query [insert standard caution about running SQL on your live production database]:

SQL Query

select e.increment_id,e.created_at as order_date, min(sfs.created_at) as first_shipment_date, TIMESTAMPDIFF(hour, e.created_at, sfs.created_at) as time_to_shipment

from sales_flat_order e

left join sales_flat_shipment sfs on (e.entity_id = sfs.order_id)

group by e.created_at having (time_to_shipment is not null)

order by e.created_at desc

Sample output

increment_id    order_date  first_shipment_date time_to_shipment

38660   2017-08-16 17:38:00 2017-08-16 19:43:22 2

38659   2017-08-16 16:51:31 2017-08-16 19:48:56 2

38658   2017-08-16 16:42:34 2017-08-16 17:13:51 0

38657   2017-08-16 14:35:48 2017-08-16 15:23:19 0

38656   2017-08-16 14:10:33 2017-08-16 15:22:16 1

share|improve this answer

answered Aug 17 '17 at 4:47

philwinklephilwinkle

33.4k582144

add a comment | 

3

This report does not exist out-of-the-box per-se, but you can get this information with an SQL query [insert standard caution about running SQL on your live production database]:

SQL Query

select e.increment_id,e.created_at as order_date, min(sfs.created_at) as first_shipment_date, TIMESTAMPDIFF(hour, e.created_at, sfs.created_at) as time_to_shipment

from sales_flat_order e

left join sales_flat_shipment sfs on (e.entity_id = sfs.order_id)

group by e.created_at having (time_to_shipment is not null)

order by e.created_at desc

Sample output

increment_id    order_date  first_shipment_date time_to_shipment

38660   2017-08-16 17:38:00 2017-08-16 19:43:22 2

38659   2017-08-16 16:51:31 2017-08-16 19:48:56 2

38658   2017-08-16 16:42:34 2017-08-16 17:13:51 0

38657   2017-08-16 14:35:48 2017-08-16 15:23:19 0

38656   2017-08-16 14:10:33 2017-08-16 15:22:16 1

share|improve this answer

answered Aug 17 '17 at 4:47

philwinklephilwinkle

33.4k582144

add a comment | 

This report does not exist out-of-the-box per-se, but you can get this information with an SQL query [insert standard caution about running SQL on your live production database]:

SQL Query

select e.increment_id,e.created_at as order_date, min(sfs.created_at) as first_shipment_date, TIMESTAMPDIFF(hour, e.created_at, sfs.created_at) as time_to_shipment

from sales_flat_order e

left join sales_flat_shipment sfs on (e.entity_id = sfs.order_id)

group by e.created_at having (time_to_shipment is not null)

order by e.created_at desc

Sample output

increment_id    order_date  first_shipment_date time_to_shipment

38660   2017-08-16 17:38:00 2017-08-16 19:43:22 2

38659   2017-08-16 16:51:31 2017-08-16 19:48:56 2

38658   2017-08-16 16:42:34 2017-08-16 17:13:51 0

38657   2017-08-16 14:35:48 2017-08-16 15:23:19 0

38656   2017-08-16 14:10:33 2017-08-16 15:22:16 1

share|improve this answer

answered Aug 17 '17 at 4:47

philwinklephilwinkle

33.4k582144

select e.increment_id,e.created_at as order_date, min(sfs.created_at) as first_shipment_date, TIMESTAMPDIFF(hour, e.created_at, sfs.created_at) as time_to_shipment

from sales_flat_order e

left join sales_flat_shipment sfs on (e.entity_id = sfs.order_id)

group by e.created_at having (time_to_shipment is not null)

order by e.created_at desc

increment_id    order_date  first_shipment_date time_to_shipment

38660   2017-08-16 17:38:00 2017-08-16 19:43:22 2

38659   2017-08-16 16:51:31 2017-08-16 19:48:56 2

38658   2017-08-16 16:42:34 2017-08-16 17:13:51 0

38657   2017-08-16 14:35:48 2017-08-16 15:23:19 0

38656   2017-08-16 14:10:33 2017-08-16 15:22:16 1

share|improve this answer

answered Aug 17 '17 at 4:47

philwinklephilwinkle

33.4k582144

answered Aug 17 '17 at 4:47

philwinklephilwinkle

33.4k582144

answered Aug 17 '17 at 4:47

philwinklephilwinkle

33.4k582144