Export merge product quantity from selected orders

Shopify Apps

Topic summary

A user seeks a way to export aggregated product quantities from multiple selected Shopify orders to streamline warehouse picking and packing. Instead of viewing each order separately, they want a consolidated list showing total quantities per product across all selected orders.

Solutions offered include:

  • Third-party apps: EZ Exporter and Data Export Reports can generate product summary exports automatically.
  • Manual method: Export orders as CSV from Shopify Admin, then use Excel/Google Sheets pivot tables to group by product name and sum quantities.
  • Shopify Order Printer: The original poster found this free app sufficient for their basic needs (product name + quantity).
  • Automation tools: Shopify Flow with Google Sheets connector can automate row additions; Mechanic app offers advanced automation for PDFs, emails, and pick lists.

The discussion reached a resolution with the user identifying a workable free solution, though multiple alternatives remain available depending on complexity and automation requirements.

Summarized with AI on October 27. AI used: claude-sonnet-4-5-20250929.
1

Is it possible to set up an export through some application, where we only get products and their quantity?

Example:
I select 10 orders.
Export:
Product 1 / 200 pcs
Product 2 / 20 pcs
Product 3 / 50 pcs
etc…

Then we can bring all the necessary quantity from the warehouse for packaging, which will then be sorted into shipments.

Does anyone have any recommendations? Thank you.

2

Yes, absolutely! What you’re describing is a Product Summary Eport based on selected Shopify orders where instead of exporting each order line-by-line, you get a combined total Quatity per product like a pick list for the warehouse. This is a commonly used for warehouse prep and fulfillment.

Here are the three ways you can do this:

Use a Shopify app no code required.

Use Shopify Admin + Excel (Manual Method).

If you do this only occasionally, this method works without apps.

  • Go to Orders in your Shopify Admin.
  • Select the 10 products manually selected.
  • Click Export >> Export as CSV.
  • Open in excel or google sheet.
  • Use Pivot Table to group by lineitem name and sum the lineitem quantity.

By following one of the method you can ensure to fulfill your requirements.

If this was helpful mark as Solution and like it.

1 Like
3

Thank you! I also find a simple solution Shopify Order Printer - Just for Product name and quantity is enough and free :slightly_smiling_face:

4

I am happy that it could help. If this was helpful please don’t forget to Buy me a Coffee.

It encourage me to help other merchants.

5

Hi @PetrK this is possible using shopifys free app shopify-flow with the googlesheets connector to add rows to a sheet.

https://help.shopify.com/en/manual/shopify-flow/reference/connectors/add-row-to-spreadsheet

If you also need this info emailed, or turned into PDFS attaching to emails or printing into picklists etc etc etc

There’s more advanced automation tools like mechanic.

examples https://tasks.mechanic.dev/?q=export&tags=CSV , https://tasks.mechanic.dev/?q=pdf

If you need this type of automation setup then contact me for services.
Contact info in forum signature below :down_arrow: :down_arrow: :down_arrow:.
ALWAYS please provide context, examples: store url, theme name, post url(s) , or any further detail in ALL correspondence.