Create Shopify Order Pick lists with warehouse inventory locations (bins/aisles/shelves)

Get your picking done quicker with optimized picklists for your Shopify store

This sheet was created using the Sheet Master App on Shopify by Comstack https://apps.shopify.com/sheet-master
https://www.comstack.co/solutions/she...
For custom requests, please email us on [email protected]

Transcript:
_________________________________________________-
This Sheet Master template helps you create a Pick list based on orders received in your store
The pick list can be setup to contain the warehouse locations of products, including bins, shelves, aisles or any custom location
To get started, look up the Pick list with Locations template
Click create sheet
Once the sheet is created, click open sheet
As the first step, update the Locations sheet with a few locations mapped to a product SKU from your store
Do this by entering your product SKU code in the Key column and the matching location in the Location column
You can either use the Aisle, Shelf and Bin template provided or modify the location column to suit your needs.
To export the latest data from Shopify, select the date range during which the orders were created, and select Export from Shopify
Once the data is updated the pick list can be created
To create the pick list, Select Create Pick list
This pick list can be sorted by any column and in any order
This pick list can be printed in any format, and can be resized just like a sheet
If you would like to customize the columns in this pick list, head over to the settings sheet
Let's say we want to include the vendor name in the pick list
Check the vendor checkbox
Now export data from Shopify
And then, create the pick list
The vendor name is now included in the pick list
If instead of listing items by order number, you would like a summarized pick list with summed up line item quantities form all orders, this can be set up in the settings sheet
Change type of pick list to Summary Pick list
Now export data from Shopify
And then create the pick list
This pick list contains total values of order line items across orders, and no longer shows the order-wise data
Pick list and location formats are completely customizable to suit your exact needs
If you have any questions, or if you need a custom sheet, please send us an email at support at Comstack.co