Sales report, quantity ordered vs shipped, prepared and unprepared quantity

[ari_mandel]

HI,

I need a Sales report that calculates for each product; quantity ordered, quantity shipped, prepared quantity; unprepared quantity.

The quantity of our inventory is always unknown and we can get refills from the suppliers when we need. So, we need a report of all items which are still missing and should be ordered from the suppliers.

The same report could also show what was actually shipped if the data can be filtered by Order status.

It should also be able to filter by product manufacturer, and to group by year/month/day/order.

[Amasty]

Hi!

Please, take a look at the Advanced Reports extension. It comes with 9 types of reports, including those, you need.

Have a nice day!

[Vicent_Nguyen]

Hi!

Magento 2 Advanced Reports extension comes with two new reports which are not supported by Magento default: Sale by location report and Repeat customer rate report. These reports play essential roles in understanding stores’ customers and managing regional sales. Moreover, figures can be reported in selected time, be compared with the previous period and be displayed as line charts. This makes data processing much easier and quicker.

You will probably need custom reports for the store, you can take Free Advanced Reports extension - Mageplaza. With main features:

• 2 new informative advanced reports
• Customizable report period
• Report comparison
• Highly informative line-chart reports
• 16 report cards

You can look more extension must have for your store here.

[extait_inc]

Hi @ari_mandel
Consider this extension which should satisfy your needs.

Admin Emai Notifier M2

If you can't find all the needed options.

We can customize the extension for your needs.

[AnyQuestion]

@ari_mandel 

This M2 extension covers almost all requested features and displays a sales report directly on the product edit screen in admin:

Product Purchases

And it's free!

> It should also be able to filter by product manufacturer, and to group by year/month/day/order.

This is not provided by the extension out-of-the-box but be custom developed as an addon.