TOP

Orders by Ship/Pickup Date

This report allows you to view your sales based on the Order or Ship/Pickup Date. This is a great report for reviewing total value for orders. The Orders by Ship/Pickup Date report does not include SKU information for orders, see the Order Detail reports for customer and SKU information.

Running The Report: Learn where to find the report and how to run it. Learn More >

Sales By Date CSV: Learn what columns are included in the Order or Ship/Pickup Date report. Learn More >


Running The Report

1. Go to Reports > Sales > Orders by Ship/Pickup Date.

2. Enter the date range you wish to report on.

3. Adjust the dates, or click Manage Filters and Manage Reports Columns to customize your report. Learn More > 

4. Click Export to queue your report for download. It will be emailed to you when ready. You can also Save As or click Actions > Schedule to schedule your report to generate on a recurring basis (Plus only). Learn More > 

Page Top


Orders by Ship/Pickup Date CSV

Below are the columns that are in the default report. 

Website The website the purchase originated from.
Order Number The number assigned to an order by the admin panel.
Alt Order Number The order number for an order passed into Vin65 from another system (RMS, Amazon, Etc). This will only populate for orders passed to Vin65 through webservices and cannot be manually added to an order.
Status What the status of the order is. (Completed/Quarantined/Cancelled/Pending)
Type What type of order it was. (Website/ClubOrder/AdminPanel)
Submitted Date The date they ordered. (MM/DD/YYYY)
Submitted Time Time the order was placed. (12:00am/12:00pm)
Completed Date The date the order was completed. (MM/DD/YYYY)
Completed Time Time the order was completed. (12:00am/12:00pm)
Cust # The number assigned to the customer in the admin panel.
Bill Birth Date Birthdate of the customer that is being billed. (MM/DD/YYYY)
Bill Name Full name of the customer that is being billed.
Bill First Name First name of the customer that is being billed.
Bill Last Name Last name of the customer that is being billed.
Bill Company Company name of the customer that is being billed.
Bill Address Address of the customer that is being billed.
Bill Address 2 The second address of the customer that is being billed.
Bill City City that the customer being billed lives in.
Bill State State that the customer being billed lives in. (XX) Ex: California - CA
Bill Zip Zip code/Postal of the customer that is being billed.
Bill Phone Phone number of the customer that is being billed.
Bill Email Email address of the customer that is being billed.
Contact Status Automatic tracking flag that is attached to customers/contacts to give you a better idea of what sort of customer the person is.
Pickup Is the order for pickup? (YES/NO)
Pickup Location The address of the Pickup Location.
Pickup Location Code The internal code you set for the Pickup Location.
Ship Birth Date Birthdate of the customer that the order is being shipped to. (MM/DD/YYYY)
Ship First Name First name of the customer that the order is being shipped to.
Ship Last Name Last name of the customer that the order is being shipped to.
Ship Company Company name of the customer that the order is being shipped to.
Ship Address Address of the customer that the order is being shipped to.
Ship Address 2 The second address of the customer that the order is being shipped to.
Ship City City that the customer lives in that the order is being shipped to.
Ship State State that the customer lives in where the order is being shipped to. (XX) Ex: California - CA
Ship Zip Zip code/Postal of the customer that the order is being shipped to.
Ship Phone Phone number of the customer that the order is being shipped to.
Ship Email Email address of the customer that the order is being shipped to.
Subtotal Subtotal of the order, before taxes and shipping/handling.
Deposit If there is a bottle deposit on product(s). *(Canadian customers only)
Shipping Total amount of shipping.
Handling Total amount of handling.
Taxes Total amount of tax.
Total Total of sale including tax, shipping/handling.
Tip The Tips amount for that transaction.
Total After Tips The total amount after tips have been included in the total.
Sales Associate If there is a sales associate assigned to the order.
Sales Attributes A Sales Attribute is one of the ways to track, organize and sort your orders coming into the system. This function is mainly intended for iPad POS orders and Admin Panel orders.
Source If you are using source codes to tag orders.
Shipping Hold Until The date customer would like the order to be held and shipped. (MM/DD/YYYY)
Shipping Hold Reason The reason the customer would like the order held.
Requested Delivery On The date the delivery was requested on.
Sent To Fulfillment Date The date the order was sent to Fulfillment
Ship Date The date the order is physically shipped. (MM/DD/YYYY)
Tracking No. A unique number assigned to each shipment, used for tracking purposes.
Pickup Date The date the order was picked up.
Picked Up By Who the order was picked up by.
Shipment Count The current number of club shipments received by a club member. Used for club orders.
Order Notes Notes made by the customer or admin in regards to the order (ex. Special instructions).
Is Non-Taxable Is the order Non-taxable (Yes/No)
Wholesale # The Wholesale number of the customer.
Club The Club the customer belongs to.
Club Shipment If there is a Club Shipment name for this purchase.
Corporate Batch # The corporate batch number for this purchase.
Guest Count Number of visits as a non-club member and club member if you are using Restaurant POS features.
Club Guest Count Number of visits as a club member if you are using Restaurant POS features.
Non Club Guest Count Number of visits as a non-club member if you are using Restaurant POS features.
Transaction Type If there is a specific transaction type that should be recorded other than a standard purchase.
Last Modified Date The dates of the last time changes were made to a particular order.

Page Top