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 will send the report to a fulfillment service for processing, so needs to include the following details for all orders that are marked as "pending shipment":
OrderID, Order date, ship company name, ship first name, ship last name, ship address1, ship address2, ship city, ship state, ship postal code, ship country, ship phone number, total shipping cost, product code, product name, quantity, product price, total price, order status (being "pending shipment").
Many thanks in advance.