Is there a way to list products for all outstanding/unshipped orders?

[mactac]

I need a way to list out all the products and quantities of products for all outstanding orders.

For example, if I have 100 unshipped orders, I would like to know the total amounts of product A, Product B, etc.

I need this because I prep items before fulfillment and I need to know how many to prep before I start working on the orders themselves.

I cannot see a way to do this, but it seems like a fairly basic function.

Is there a way to do this in Shopify?

[tobebuilds]

Hey Mactac, this is Tobe, a Shopify app developer.

To list out all the products and quantities of products for all outstanding orders in Shopify using Google Sheets, you can follow these steps:

1. Log in to your Shopify admin panel.

2. From the Shopify admin dashboard, click on “Orders” located in the left-hand navigation menu.

3. By default, the “Open” tab will be selected, which displays all your outstanding orders.

4. Shopify provides several filtering and sorting options to help you manage your orders efficiently. You can use these options to narrow down the list or organize it based on your preferences. You should selected “Unfilled,” as shown in this image:
   

   

5. Once you have the desired set of orders displayed, you can export the order details to a CSV file for further analysis.

   • To export all orders, click on the “Export” button at the top right corner of the orders list page.
   • Choose the export format as “CSV for Excel, Numbers, or other spreadsheet programs.”
   • Click on “Export Orders” to generate the CSV file. You should receive it in your email.

6. Open Google Sheets in your browser and create a new blank spreadsheet.

7. In Google Sheets, go to “File” and select “Import.”

8. Choose the “Upload” tab and click on “Select a file from your device.”

9. Locate the exported CSV file from your computer and upload it to Google Sheets.

10. Google Sheets will open the uploaded CSV file in a new sheet.

11. In the sheet, you will find columns named “Lineitem name” and “Lineitem quantity” containing information about the ordered products, including the product names and quantities.
    

    

12. Use the sorting and filtering capabilities of Google Sheets to organize the data as per your requirements.

13. Sum up the quantities for each product to get the total amounts of each product.

    1. I recommend deleting unused columns, so it’s easier to move around the sheet.
    2. I added a new “TOTALS” row, and set the cell values to the sums. See the image for reference. Of course, replace “Demo product 1” with the name of your product.
       
       

(Wow, that’s pretty tedious, isn’t it? It would be awesome if there were an app that could automate this process for you, making it quicker and more convenient.)

I did find the app PiknPak, could be worth a try.