Our online store has been doing really well since we launched in January and our orders are increasing dramatically every week.
The issue is we have been printing the packing slips and using these to manually tally the total number of products across all unfulfilled orders which is taking a LONG time.
I’m hoping either Shopify has a feature that I haven’t discovered yet or there is an app that will allow me to collate our unfulfilled orders by product variants so we know how many of each product type size and quantity to get ready, then organise them into customer orders.
i.e.
Product 1a (10g) x 10
Product 1b (20g) x 5
Product 1c (50g) x 5
Product 2a (10g) x 10
Product 2b (20g) x 10
Product 2c (50g) x 5
Rather than…
Order #1001
Product 1a (10g) x 5
Product 2b (20g) x 10
Product 2c (50g) x 3
Order #1002
Product 1a (10g) x 5
Product 1b (20g) x 3
Product 1c (50g) x 4
Product 2a (10g) x 5
Product 2c (50g) x 2
Order #1003
Product 1b (20g) x 2
Product 1c (50g) x 1
Product 2a (10g) x 5
I have no idea what this process is called so I did a search for ‘inventory management’ ad ‘order fulfilment’ but haven’t come across anything yet.
I’m not sure whether you’re looking for an automated way to create a custom CSV or Excel export of your unfulfilled orders but we have an app, EZ Exporter, that might be able to help with this.
We have a “Grouping and Aggregation” feature where you can group the line item rows by a line item field (such as the line item name, SKU, or Variant ID) and then sum up the fulfillable quantity field. So each row in the CSV/Excel report will be a unique product variant and will have a column for the total quantity that needs to be fulfilled for each unique variant.
Here’s a sample of what this would look like after exporting with our app:
You can also schedule the export to run automatically and have it sent to an email address, Google Sheets, Google Drive, Dropbox, Amazon S3, or an FTP/SFTP server so this could save additional time.
We have a 7-day free trial period in case you’d like to give it a try and feel free to contact us at support@highviewapps.com if you have any questions or need any assistance.
It is possible to achieve your requirements with our Sales by Product or Sales by the Variant report but with the applied filter to include only unfulfilled orders.
The report looks like this, it is sample data from my test store, the screenshot is clickable:
