Orders by Number
  • 29 Mar 2023
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Orders by Number

  • Dark
    Light
  • PDF

Article Summary

This report allows you to view your sales within a range of order numbers (Eg: Orders #1000 - #1050)


Running The Report

1. Go to Reports > Sales > Orders by Number. 

2. Enter the order number range you wish to report on [To and From Order Number].

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.

Here are the definitions of what will populate in your default Sales by Order Number report:

WebsiteThe website the purchase originated from.
Order NumberThe number assigned to an order in 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 it was. (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. The format is LAST, FIRST.
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 code 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 Status

Lets you know who this person is: 

  • ClubMember
  • RepeatCustomer
  • 1stTimeCustomer
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.
Sub TotalSubtotal 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.
TipTip amount in the 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 AttributesThe category or method that applies to your order.
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.
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 that the order was picked up.
Picked Up ByThe name of the individual that picked up the order, if available.
Shipment CountThe number of Club Shipments the purchaser has received.
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.
Transaction TypeIf there is a specific transaction type that should be recorded other than a standard purchase. (Ex: Refund)
Last Modified DateThe date of the last time that this order was modified/edited.



Was this article helpful?