Report to tell how long it took from order to shipping The Next CEO of Stack OverflowCustom sales order report NOT matching Magento's sales order reportPart Shipment Report in MagentoHow can i export this reporthow to add shipping cost magento report?I have multiple employees shipping orders. Is there any way to track which user shipped which order?Magento2 : Free shipping and Flat Rate for specified statesTooltip on custom shipping methodMagento2 - Create A Custom Report Displaying Order ItemsMagento 2: Sales Order report show wrong dataHow to create a admin report grid?
Why does C# sound extremely flat when saxophone is tuned to G?
Why didn't Theresa May consult with Parliament before negotiating a deal with the EU?
MAZDA 3 2006 (UK) - poor acceleration then takes off at 3250 revs
What does this shorthand mean?
Trouble understanding the speech of overseas colleagues
Which organization defines CJK Unified Ideographs?
Should I tutor a student who I know has cheated on their homework?
Can I equip Skullclamp on a creature I am sacrificing?
How to Reset Passwords on Multiple Websites Easily?
How do I go from 300 unfinished/half written blog posts, to published posts?
Why here is plural "We went to the movies last night."
How to be diplomatic in refusing to write code that breaches the privacy of our users
Are there languages with no euphemisms?
How did people program for Consoles with multiple CPUs?
How to write papers efficiently when English isn't my first language?
Go Pregnant or Go Home
Science fiction (dystopian) short story set after WWIII
Text adventure game code
How should I support this large drywall patch?
Anatomically Correct Strange Women In Ponds Distributing Swords
How to count occurrences of text in a file?
How to use tikz in fbox?
Where to find order of arguments for default functions
If the heap is initialized for security, then why is the stack uninitialized?
Report to tell how long it took from order to shipping
The Next CEO of Stack OverflowCustom sales order report NOT matching Magento's sales order reportPart Shipment Report in MagentoHow can i export this reporthow to add shipping cost magento report?I have multiple employees shipping orders. Is there any way to track which user shipped which order?Magento2 : Free shipping and Flat Rate for specified statesTooltip on custom shipping methodMagento2 - Create A Custom Report Displaying Order ItemsMagento 2: Sales Order report show wrong dataHow to create a admin report grid?
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
edited 1 hour ago
Shoaib Munir
2,2991829
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
edited 1 hour ago
Shoaib Munir
2,2991829
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
edited 1 hour ago
Shoaib Munir
2,2991829
asked Aug 17 '17 at 2:12
RachaelRachael
11
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
shipping reports ee-1.14.2.4
edited 1 hour ago
Shoaib Munir
2,2991829
asked Aug 17 '17 at 2:12
RachaelRachael
11
edited 1 hour ago
Shoaib Munir
2,2991829
asked Aug 17 '17 at 2:12
RachaelRachael
11
edited 1 hour ago
Shoaib Munir
2,2991829
edited 1 hour ago
Shoaib Munir
2,2991829
edited 1 hour ago
Shoaib Munir
2,2991829
2,2991829
asked Aug 17 '17 at 2:12
RachaelRachael
11
asked Aug 17 '17 at 2:12
RachaelRachael
11
asked Aug 17 '17 at 2:12
RachaelRachael
11
11
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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
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
);
);
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
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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
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
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
answered Aug 17 '17 at 4:47
philwinklephilwinkle
33.4k582144
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
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
answered Aug 17 '17 at 4:47
philwinklephilwinkle
33.4k582144
33.4k582144
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
