I have a situation with a custom client request:
Cust requirements:
700 items in the cart
no prices attached to the products.
payment will only be cash on delivery or manual CC charge

all of those are no real issue
the problem I cannot seem to solve is when the order is placed and my customer recives the order they need to have all the products show up in the order form in a predefined fashion

ex: products need to be sorted by Aisle # and by location on the aisle and need to be listed that way on the order form my customer recieves (think of it as a shopping list they can use to walk the aisles and follow the order form. to simplify I need to sort the order by the product ID or another variable.

is there anyway to accomplish this without exporting the orders to a spreadsheet and manipulating the spreadsheet based on the item number. Which I believe I can do.

This is boggling my mind.. anyone have any ideas.

Thanks