- Old Reports
- Sales
- Sales By Date
Sales by Date
This page documents an older/sunset version of our reporting tools - for documentation on the latest version click here.
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 Sales by Date report does not include SKU information for orders, see the Sales Detail/Sales Detail X reports for customer and SKU information.
Running The Report: Learn where to find the report and how to run it. Learn More >
Customizing Sales Reports: Learn how to create a custom filter set to optimize your report. Learn More >
Sales By Date CSV: Learn what columns are included in the Sales By Date Report. Learn More >
Running The Report
1. Go to Reports > Sales > Sales By Date.
2. Enter the date range you wish to report on [To & From Date]. Dates should be MM/DD/YYYY in North America and DD/MM/YYYY in Australia.
3. Adjust any additional Date Type parameters, such as:
- Submitted Date
- Completed Date
- Ship/Pickup Date
- Modified Date
4. Additional filter customizations can be made using the Memorize option. Learn More >
5. Click Export as CSV to download your report.
Sales By Date CSV
Below are the columns that are in the default Sales By Date 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. |