We're looking for someone with volusion experience.
We need to create a saved sql query for orders pending shipment in our volusion store.
We need a report to print out all orders from the previous night on one sheet with just the items and the quantities that need to be picked from our warehouse to be shipped. If possible, we would like the list to be categorized in regards to the warehouse location in alphabetical and numeric order (i.e. - A1; A2; B1: B2, etc.).
In other words: if we had 100 orders and within those orders there was a part ordered 20 times out of the 100 orders, this report will list the item once with a quantity of 20 and the location. We want to avoid picking the same item multiple times from different invoices.
Many thanks in advance.