Skip to main content

Organize products on packing slips/pick lists by the order they are located in the warehouse

  • May 6, 2024 1:01 PM UTC
  • 3 replies
  • 2 views

I organized our shop floor by attributing warehouse locations to each area. I did this alphabetically, creating over 20 zones. After this, I uploaded a spreadsheet to our inventory, attributing the appropriate warehouse location to each item in our inventory. We have about 800 items. 

My goal in doing this was not to create extra work for myself but to be able to pick our orders in the exact order that they are arranged on our shop floor. The packing slip is my preferred document to work with when picking orders because it has all the customer and order information on it.

I was under the impression that because there is an option to sort packing slips and pick lists by "warehouse location" that it would sort the products on the order by their location in the warehouse. This should absolutely be a feature for making it easier to pick items on orders. It would make it so much easier for businesses that have large warehouses with tons of product and for smaller businesses like ourselves that have a ton of different products and receive many orders each day. This way, we aren't running back and forth picking items on the list that could be organized by location on the slip.

To be totally honest, I invested a TON of my time making sure that our inventory had appropriate warehouse location attributions, and had to reach out to SS support several times to make sure it would work the way I was hoping it would. I feel like I did all this extra work in vain to accomplish something that could be easily automated, but isn't.

3 replies

  • May 7, 2024 2:39 AM UTC

I did the same thing with our products, originally for the pick list. Our packing slip "Order Items By" option is set to "None" to keep the original order, but I just tested by switching it to "Warehouse Location" and printing a packing slip, and it did rearrange the order to follow the warehouse locations. Make sure your order items are attaching to the shipstation product records, the name should be a clickable link that pops up the product record. Also try setting one of the other "Order Items By" options and see if it changes the sort order of your packing list.


TheVegBox
  • Employee
  • Aug 23, 2024 1:15 PM UTC

Hi Did anyone get any further with this. Seems really silly you can't organise the warehouse in alphabetical order with the product locations.


I experienced the same thing. We added specific warehouse locations (Area, Unit, Shelf, Bin) hoping that when we print a pick list it would tell us where to find the product location (we have 800 SKUs). Instead, the pick list just calls out the warehouse the product is in (we only have one). The fact that the specific location fields exist tells me that this has to be possible. How do people in larger warehouses with more product find what they're looking for? 

Does anyone know how to code/customize the pick list to include this information, or any other hack to figure it out?