Orders by Ship/Pickup Date

Updated on 29 Mar 2023
4 Minutes to read

Print
Share
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

This report lets you view your sales based on the Order or Ship/Pickup Date. This is an excellent report for reviewing the total value of 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

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.

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 regularly.

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 web services and cannot be manually added to an order.
Status	What is the status of the order is. (Completed/Quarantined/Cancelled/Pending)
Type	What type of order was it? (Website/ClubOrder/AdminPanel)
Submitted Date	The date they ordered. (MM/DD/YY)
Submitted Time	Time the order was placed. (12:00 am/12:00 pm)
Completed Date	The date the order was completed. (MM/DD/YY)
Completed Time	Time the order was completed. (12:00 am/12:00 pm)
Cust #	The number assigned to the customer in the admin panel.
Bill Birth Date	Birthdate of the customer that is being billed. (MM/DD/YY)
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	A 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	An automatic tracking flag attached to customers/contacts gives 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 to whom the order is being shipped. (MM/DD/YY)
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 to whom the order is being shipped.
Ship Address	Address of the customer that the order is being shipped.
Ship Address 2	The second address of the customer that the order is being shipped to.
Ship City	A city that the customer lives in that the order is being shipped to.
Ship State	State that the customer lives 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 to whom the order is being shipped.
Ship Email	Email address of the customer that the order is being shipped.
Subtotal	Subtotal of the order, before taxes and shipping/handling.
Deposit	If there is a bottle deposit on the product(s). *(Canadian customers only)
Shipping	The total amount of shipping.
Handling	The total amount of handling.
Taxes	The 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 has 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/YY)
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/YY)
Tracking No.	A unique number is assigned to each shipment, used for tracking purposes.
Pickup Date	The date the order was picked up.
Picked Up By	Who was the order picked up by?
Shipment Count	A member receives and uses the current number of club shipments for club orders.
Order Notes	Notes made by the customer or admin regarding 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	Several visits as a non-club member and club member if you use Restaurant POS features.
Club Guest Count	Several club member visits if you use Restaurant POS features.
Non-Club Guest Count	The number of visits as a non-club member if you use 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.

Was this article helpful?

What's Next

Orders by Number