[Skip to main content](#vessel-content) # Sales report - products from shipped orders ## - **[montemama](/forum/user/43131-montemama "View montemama's Profile")** - [![montemama's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/43131-montemama "View montemama's Profile") Topic Author - [ Offline](/forum/user/43131-montemama) Less More - Posts: 46 - Thank you received: 3 - - 9 years 11 months ago [\#257140](#257140) by [montemama](/forum/user/43131-montemama "View montemama's Profile") *[Sales report - products from shipped orders](/forum/36-reports-statistics/887837-sales-report-products-from-shipped-orders#257140 "-- HikaShop version -- : 2.6.4 Business -- Joomla version -- : 3.6.4 Hi, I need to create report, which contains quantities of products from orders, which were shipped in certain period. When I filter orders with status "shipped" and set date type "created", I get only those orders, which were created AND shipped in this time period (not those orders, which were created earlier). When I filter shipped orders and set date type "last modified", I get also orders, which were shipped earlier, but were modified during the selected period (sometimes there is added information about payment date or some note later on). Is it possibe to create report of products from orders SHIPPED in certain period - doesn´t matter if and where they were created or modified?")* was created by *[montemama](/forum/user/43131-montemama "View montemama's Profile")* -- HikaShop version -- : 2.6.4 Business -- Joomla version -- : 3.6.4 Hi, I need to create report, which contains quantities of products from orders, which were shipped in certain period. When I filter orders with status "shipped" and set date type "created", I get only those orders, which were created AND shipped in this time period (not those orders, which were created earlier). When I filter shipped orders and set date type "last modified", I get also orders, which were shipped earlier, but were modified during the selected period (sometimes there is added information about payment date or some note later on). Is it possibe to create report of products from orders SHIPPED in certain period - doesn´t matter if and where they were created or modified? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODc4Mzctc2FsZXMtcmVwb3J0LXByb2R1Y3RzLWZyb20tc2hpcHBlZC1vcmRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 9 years 11 months ago [\#257144](#257144) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Sales report - products from shipped orders](/forum/36-reports-statistics/887837-sales-report-products-from-shipped-orders#257144 "-- HikaShop version -- : 2.6.4 Business -- Joomla version -- : 3.6.4 Hi, I need to create report, which contains quantities of products from orders, which were shipped in certain period. When I filter orders with status "shipped" and set date type "created", I get only those orders, which were created AND shipped in this time period (not those orders, which were created earlier). When I filter shipped orders and set date type "last modified", I get also orders, which were shipped earlier, but were modified during the selected period (sometimes there is added information about payment date or some note later on). Is it possibe to create report of products from orders SHIPPED in certain period - doesn´t matter if and where they were created or modified?")* Hi, The information of when an order was shipped is not stored with the order but with the corresponding entry of the order in the history table. So it's not adapted to be used as a filter for a orders report. There is no other option in the reports system than order created or order modified. If you jsut want an export of the orders and that you're ok to get the ones that are "shipped" and that were confirmed (paid) during the period you want, then you can use a mass action with a filter on the order_status column, two filters on the order_invoice_created comparing it to the unix timestamp of the dates you want, and one action CSV export. You can do that via the menu System>Mass actions. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODc4Mzctc2FsZXMtcmVwb3J0LXByb2R1Y3RzLWZyb20tc2hpcHBlZC1vcmRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[montemama](/forum/user/43131-montemama "View montemama's Profile")** - [![montemama's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/43131-montemama "View montemama's Profile") Topic Author - [ Offline](/forum/user/43131-montemama) Less More - Posts: 46 - Thank you received: 3 - - 9 years 11 months ago [\#257293](#257293) by [montemama](/forum/user/43131-montemama "View montemama's Profile") Replied by *[montemama](/forum/user/43131-montemama "View montemama's Profile")* on topic *[Sales report - products from shipped orders](/forum/36-reports-statistics/887837-sales-report-products-from-shipped-orders#257293 "-- HikaShop version -- : 2.6.4 Business -- Joomla version -- : 3.6.4 Hi, I need to create report, which contains quantities of products from orders, which were shipped in certain period. When I filter orders with status "shipped" and set date type "created", I get only those orders, which were created AND shipped in this time period (not those orders, which were created earlier). When I filter shipped orders and set date type "last modified", I get also orders, which were shipped earlier, but were modified during the selected period (sometimes there is added information about payment date or some note later on). Is it possibe to create report of products from orders SHIPPED in certain period - doesn´t matter if and where they were created or modified?")* Thank you, Nicolas. Mass actions are great, I know this possibility, but I need a sum of products - one product name and one number (total ordered during certain period) per row. Is is possible to somehow add the filter from order history table to order reports? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODc4Mzctc2FsZXMtcmVwb3J0LXByb2R1Y3RzLWZyb20tc2hpcHBlZC1vcmRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 9 years 11 months ago [\#257315](#257315) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Sales report - products from shipped orders](/forum/36-reports-statistics/887837-sales-report-products-from-shipped-orders#257315 "-- HikaShop version -- : 2.6.4 Business -- Joomla version -- : 3.6.4 Hi, I need to create report, which contains quantities of products from orders, which were shipped in certain period. When I filter orders with status "shipped" and set date type "created", I get only those orders, which were created AND shipped in this time period (not those orders, which were created earlier). When I filter shipped orders and set date type "last modified", I get also orders, which were shipped earlier, but were modified during the selected period (sometimes there is added information about payment date or some note later on). Is it possibe to create report of products from orders SHIPPED in certain period - doesn´t matter if and where they were created or modified?")* Hi, It sure is possible. You can develop a hikashop plugin and implement the necessary triggers in it to add the filter you want. You can use the system hikashopmassaction plugin and the hikashop massactionorder plugin as examples of how to do it. If you're a skilled developer, it sure is possible. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODc4Mzctc2FsZXMtcmVwb3J0LXByb2R1Y3RzLWZyb20tc2hpcHBlZC1vcmRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[montemama](/forum/user/43131-montemama "View montemama's Profile")** - [![montemama's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/43131-montemama "View montemama's Profile") Topic Author - [ Offline](/forum/user/43131-montemama) Less More - Posts: 46 - Thank you received: 3 - - 9 years 11 months ago - 9 years 11 months ago [\#257716](#257716) by [montemama](/forum/user/43131-montemama "View montemama's Profile") Replied by *[montemama](/forum/user/43131-montemama "View montemama's Profile")* on topic *[Sales report - products from shipped orders](/forum/36-reports-statistics/887837-sales-report-products-from-shipped-orders#257716 "-- HikaShop version -- : 2.6.4 Business -- Joomla version -- : 3.6.4 Hi, I need to create report, which contains quantities of products from orders, which were shipped in certain period. When I filter orders with status "shipped" and set date type "created", I get only those orders, which were created AND shipped in this time period (not those orders, which were created earlier). When I filter shipped orders and set date type "last modified", I get also orders, which were shipped earlier, but were modified during the selected period (sometimes there is added information about payment date or some note later on). Is it possibe to create report of products from orders SHIPPED in certain period - doesn´t matter if and where they were created or modified?")* Hi Nicolas, and what about this solution: Mass action, Data - Order, used filters order_status and order_invoice_created. Export CSV with columns order_product_id and order_product_quantity. Now I need to get sum of quantities per each product. I can use Excel like this [ www.extendoffice.com/documents/excel/163...-another-column.html](https://www.extendoffice.com/documents/excel/1630-excel-sum-based-on-another-column.html) But CSV which I get has dynamic columns. Any ideas how to do that? Thank you! EDIT: I have just noticed, that order_product_id and product_id are not the same. So it´s not a good solution. But anyway, is it possible to use SUMIF formula to count sum of dynamic columns? Last edit: 9 years 11 months ago by [montemama](/forum/user/43131-montemama "View montemama's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODc4Mzctc2FsZXMtcmVwb3J0LXByb2R1Y3RzLWZyb20tc2hpcHBlZC1vcmRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 9 years 10 months ago [\#257718](#257718) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Sales report - products from shipped orders](/forum/36-reports-statistics/887837-sales-report-products-from-shipped-orders#257718 "-- HikaShop version -- : 2.6.4 Business -- Joomla version -- : 3.6.4 Hi, I need to create report, which contains quantities of products from orders, which were shipped in certain period. When I filter orders with status "shipped" and set date type "created", I get only those orders, which were created AND shipped in this time period (not those orders, which were created earlier). When I filter shipped orders and set date type "last modified", I get also orders, which were shipped earlier, but were modified during the selected period (sometimes there is added information about payment date or some note later on). Is it possibe to create report of products from orders SHIPPED in certain period - doesn´t matter if and where they were created or modified?")* Hi, Well, possible but again, it would require the development of a mass action plugin. Here is an alternative solution without coding. You can use the standard export button of the orders listing and install and activate that plugin: [ www.hikashop.com/component/updateme/ctrl...uickbooksexport.html](http://www.hikashop.com/component/updateme/ctrl-download/plugin-quickbooksexport.html) That will give you a CSV with one row per order per product. And thanks to the filters at the top of the orders listing you can restrict the orders used for the CSV to a date range, an order status, etc. So once you get the CSV, you can edit it with Excel and sum the data like you explained in your message. The following user(s) said Thank You: [montemama](/forum/user/43131-montemama "View montemama's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODc4Mzctc2FsZXMtcmVwb3J0LXByb2R1Y3RzLWZyb20tc2hpcHBlZC1vcmRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[montemama](/forum/user/43131-montemama "View montemama's Profile")** - [![montemama's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/43131-montemama "View montemama's Profile") Topic Author - [ Offline](/forum/user/43131-montemama) Less More - Posts: 46 - Thank you received: 3 - - 9 years 10 months ago [\#257788](#257788) by [montemama](/forum/user/43131-montemama "View montemama's Profile") Replied by *[montemama](/forum/user/43131-montemama "View montemama's Profile")* on topic *[Sales report - products from shipped orders](/forum/36-reports-statistics/887837-sales-report-products-from-shipped-orders#257788 "-- HikaShop version -- : 2.6.4 Business -- Joomla version -- : 3.6.4 Hi, I need to create report, which contains quantities of products from orders, which were shipped in certain period. When I filter orders with status "shipped" and set date type "created", I get only those orders, which were created AND shipped in this time period (not those orders, which were created earlier). When I filter shipped orders and set date type "last modified", I get also orders, which were shipped earlier, but were modified during the selected period (sometimes there is added information about payment date or some note later on). Is it possibe to create report of products from orders SHIPPED in certain period - doesn´t matter if and where they were created or modified?")* Thank you very very much, Nicolas! This is what I need. There is just one small step to perfection missing. I have customised export.php (attached) to view only selected columns in desired array and when I apply this plugin, some columns are empty (order_created, order_product_code, order_product_quantity, order_product_name, order_product_price, order_payment_price, order_shipping_id, custom filed fa with custom invoice number, comment). I have tried to use original export.php, but it didin´t work at all - I get syntax error, unexpected ',' when I try to export orders. Could you, please, give me a hint what and where do I need to correct? Is there some conflict between this plugin and customised export.php or there is something missing in the code? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODc4Mzctc2FsZXMtcmVwb3J0LXByb2R1Y3RzLWZyb20tc2hpcHBlZC1vcmRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 9 years 10 months ago [\#257792](#257792) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Sales report - products from shipped orders](/forum/36-reports-statistics/887837-sales-report-products-from-shipped-orders#257792 "-- HikaShop version -- : 2.6.4 Business -- Joomla version -- : 3.6.4 Hi, I need to create report, which contains quantities of products from orders, which were shipped in certain period. When I filter orders with status "shipped" and set date type "created", I get only those orders, which were created AND shipped in this time period (not those orders, which were created earlier). When I filter shipped orders and set date type "last modified", I get also orders, which were shipped earlier, but were modified during the selected period (sometimes there is added information about payment date or some note later on). Is it possibe to create report of products from orders SHIPPED in certain period - doesn´t matter if and where they were created or modified?")* Hi, The plugin works fine with the standard HikaShop export file. So if you get an error, it means that you messed up something. Download the install package on our website and get the content of the file back/views/order/tmpl/export.php and paste it to your order/export view file so that it will have the correct code that is in HikaShop by default. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84ODc4Mzctc2FsZXMtcmVwb3J0LXByb2R1Y3RzLWZyb20tc2hpcHBlZC1vcmRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.075 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)