Orders by Ship/Pickup Date
  • 29 Mar 2023
  • 4 Minutes to read
  • Dark
    Light
  • PDF

Orders by Ship/Pickup Date

  • Dark
    Light
  • PDF

Article Summary

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. 

WebsiteThe website the purchase originated from.
Order NumberThe number assigned to an order by the admin panel.
Alt Order NumberThe 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.
StatusWhat is the status of the order is. (Completed/Quarantined/Cancelled/Pending)
TypeWhat type of order was it? (Website/ClubOrder/AdminPanel)
Submitted DateThe date they ordered. (MM/DD/YY)
Submitted TimeTime the order was placed. (12:00 am/12:00 pm)
Completed DateThe date the order was completed. (MM/DD/YY)
Completed TimeTime the order was completed. (12:00 am/12:00 pm)
Cust #The number assigned to the customer in the admin panel.
Bill Birth DateBirthdate of the customer that is being billed. (MM/DD/YY)
Bill NameFull name of the customer that is being billed.
Bill First NameFirst name of the customer that is being billed.
Bill Last NameLast name of the customer that is being billed.
Bill CompanyCompany name of the customer that is being billed.
Bill AddressAddress of the customer that is being billed.
Bill Address 2The second address of the customer that is being billed.
Bill CityA city that the customer being billed lives in.
Bill StateState that the customer being billed lives in. (XX) Ex: California - CA
Bill ZipZip code/Postal of the customer that is being billed.
Bill PhonePhone number of the customer that is being billed.
Bill EmailEmail address of the customer that is being billed.
Contact StatusAn automatic tracking flag attached to customers/contacts gives you a better idea of what sort of customer the person is.
PickupIs the order for pickup? (YES/NO)
Pickup LocationThe address of the Pickup Location.
Pickup Location CodeThe internal code you set for the Pickup Location.
Ship Birth DateBirthdate of the customer to whom the order is being shipped. (MM/DD/YY)
Ship First NameFirst name of the customer that the order is being shipped to.
Ship Last NameLast name of the customer that the order is being shipped to.
Ship CompanyCompany name of the customer to whom the order is being shipped.
Ship AddressAddress of the customer that the order is being shipped.
Ship Address 2The second address of the customer that the order is being shipped to.
Ship CityA city that the customer lives in that the order is being shipped to.
Ship StateState that the customer lives where the order is being shipped to. (XX) Ex: California - CA
Ship ZipZip code/Postal of the customer that the order is being shipped to.
Ship PhonePhone number of the customer to whom the order is being shipped.
Ship EmailEmail address of the customer that the order is being shipped.
SubtotalSubtotal of the order, before taxes and shipping/handling.
DepositIf there is a bottle deposit on the product(s). *(Canadian customers only)
ShippingThe total amount of shipping.
HandlingThe total amount of handling.
TaxesThe total amount of tax.
TotalTotal of sale including tax, shipping/handling.
TipThe Tips amount for that transaction.
Total After TipsThe total amount after tips has been included in the total.
Sales AssociateIf there is a sales associate assigned to the order.
Sales AttributesA 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.
SourceIf you are using source codes to tag orders.
Shipping Hold UntilThe date customer would like the order to be held and shipped. (MM/DD/YY)
Shipping Hold ReasonThe reason the customer would like the order held.
Requested Delivery OnThe date the delivery was requested on.
Sent To Fulfillment DateThe date the order was sent to Fulfillment
Ship DateThe date the order is physically shipped. (MM/DD/YY)
Tracking No.A unique number is assigned to each shipment, used for tracking purposes.
Pickup DateThe date the order was picked up.
Picked Up ByWho was the order picked up by?
Shipment CountA member receives and uses the current number of club shipments for club orders.
Order NotesNotes made by the customer or admin regarding the order (ex., Special instructions).
Is Non-TaxableIs the order Non-taxable (Yes/No)
Wholesale #The Wholesale number of the customer.
ClubThe Club, the customer, belongs to.
Club ShipmentIf there is a Club Shipment name for this purchase.
Corporate Batch #The corporate batch number for this purchase.
Guest CountSeveral visits as a non-club member and club member if you use Restaurant POS features.
Club Guest CountSeveral club member visits if you use Restaurant POS features.
Non-Club Guest CountThe number of visits as a non-club member if you use Restaurant POS features.
Transaction TypeIf there is a specific transaction type that should be recorded other than a standard purchase.
Last Modified DateThe dates of the last time changes were made to a particular order.



Was this article helpful?