WSN Sales Report
WSN (Wine Shipping Network) or commonly known as a 205 Report is a fulfillment report. The Wine Shipping Network report is in a format that most fulfillment companies are able to use.
Running The Report: Learn where to find the report and how to run it. Learn More >
WSN Report Export: Learn what columns are included in the WSN Report when exported. Learn More >
1. Go to Reports > Shipping > WSN Report.
2. Enter the date range you wish to report on.
3. Adjust any additional Date Type parameters, such as:
4. Adjust any Status options. Typically you should only run the report for Submitted and Completed orders as these are orders that have an authorization or have collected payment.
4. *If the orders are for an allocation you can filter by the specific allocation.
5. Adjust the Shipping status to Not Shipped to find all the orders that have not shipped and do not have tracking information. Additional status are available for additional reporting. You may have other orders that you wish to include, however the most comon is Not Shipped.
6. Click View Report to run your report. You can also click Export to have your downloaded report emailed to you.
Below are the columns that are in the default WSN report.
Format Version | |
---|---|
Client Code | |
Order Number | The number assigned to an order by the admin panel. |
Invoice Number | |
Onsite | If the sale is onsite or offsite. |
License to License | |
Do not reconfigure | |
Force 3-tier | |
Order Type | The type of the order. (Example: POS/Admin Panel/Club Order, etc.) |
Sub-Club | |
Order Date | Date of the order. |
Courier / Ship Method | The shipping method of the order. |
Courier Tracking No | The tracking number of the courier. |
Fulfiller | |
Requested Ship Date | The date that the order was requested to be delivered on. |
Compliance ID | |
Age Verification ID | |
Recipient ID | |
Recipient First Name | Ship to customer's first name. |
Recipient Last Name | Ship to customer's last name. |
Recipient Company | Ship to customer's company. |
Recipient Address 1 | Ship to customer's address. |
Recipient Address 2 | Ship to customer's address second field. |
Recipient City | Ship to customer's city. |
Recipient State | Ship to customer's state. |
Recipient Postal Code | Ship to customer's postal code. |
Recipient Country | Ship to customer's country. |
Recipient Work Phone | Ship to customer's work phone. |
Recipient Home Phone | Ship to customer's home phone. |
Recipient Email | Ship to customer's email. |
Recipient DOB | Ship to customer's date of birth. |
Customer ID | The customer number. |
Customer First Name | First name of the customer. |
Customer Last Name | Last name of the customer. |
Customer Company | The company of the customer. |
Customer Address 1 | Address of the customer. |
Customer Address 2 | Address of the customer second field. |
Customer City | City of the customer. |
Customer State | State of the customer. |
Customer Postal Code | Postal Code of the customer. |
Customer Country | Customer's country. |
Customer Work Phone | The work phone number of the customer. |
Customer Home Phone | The home phone number of the customer. |
Customer Mobile Phone | The cell phone number of the customer. |
Customer Email | The customer's email address. |
Customer DOB | The customer's date of birth. |
Credit Card Number | Credit card number used for the order. |
Credit Card Exp Date | Credit card expiration date. |
Payment Authorization Code | Authorization code from payment gateway. |
Special Instructions | Any special delivery/handling instructions. |
Gift? | Is the order a gift. |
Gift Message | A message from the giftor. |
Shipping Total | The total amount for shipping. |
Handling Fees | The handing fee amount. |
Discount Amount | The amount of discount used in the order. |
Insurance (if more than Carrier Std.) | |
Retail Amt (Products Only) | |
Product 1 Supplier | The supplier of the product. |
Prod 1 SKU | The product's SKU. |
Prod 1 Name | The name of the product. |
Prod 1 Tax | The tax of the product. |
Prod 1 Price | The product's price. |
Prod 1 Alchol % | The alcohol % of the product. |
Prod 1 Weight | The weight of the product. |
Prod 1 Inventory Location | The inventory location of the product. |
Product 2 Supplier | The supplier of the product. |
Prod 2 SKU | The product's SKU. |
Prod 2 Name | The name of the product. |
Prod 2 Tax | The tax of the product. |
Prod 2 Price | The product's price. |
Prod 2 Alchol % | The alcohol % of the product. |
Prod 2 Weight | The weight of the product. |
Prod 2 Inventory Location | The inventory location of the product. |
Product 3 Supplier | The supplier of the product. |
Prod 3 SKU | The product's SKU. |
Prod 3 Name | The name of the product. |
Prod 3 Tax | The tax of the product. |
Prod 3 Price | The product's price. |
Prod 3 Alchol % | The alcohol % of the product. |
Prod 3 Weight | The weight of the product. |
Prod 3 Inventory Location | The inventory location of the product. |
Product 4 Supplier | The supplier of the product. |
Prod 4 SKU | The product's SKU. |
Prod 4 Name | The name of the product. |
Prod 4 Tax | The tax of the product. |
Prod 4 Price | The product's price. |
Prod 4 Alchol % | The alcohol % of the product. |
Prod 4 Weight | The weight of the product. |
Prod 4 Inventory Location | The inventory location of the product. |
Product 5 Supplier | The supplier of the product. |
Prod 5 SKU | The product's SKU. |
Prod 5 Name | The name of the product. |
Prod 5 Tax | The tax of the product. |
Prod 5 Price | The product's price. |
Prod 5 Alchol % | The alcohol % of the product. |
Prod 5 Weight | The weight of the product. |
Prod 5 Inventory Location | The inventory location of the product. |
Product 6 Supplier | The supplier of the product. |
Prod 6 SKU | The product's SKU. |
Prod 6 Name | The name of the product. |
Prod 6 Tax | The tax of the product. |
Prod 6 Price | The product's price. |
Prod 6 Alchol % | The alcohol % of the product. |
Prod 6 Weight | The weight of the product. |
Prod 6 Inventory Location | The inventory location of the product. |
Product 7 Supplier | The supplier of the product. |
Prod 7 SKU | The product's SKU. |
Prod 7 Name | The name of the product. |
Prod 7 Tax | The tax of the product. |
Prod 7 Price | The product's price. |
Prod 7 Alchol % | The alcohol % of the product. |
Prod 7 Weight | The weight of the product. |
Prod 7 Inventory Location | The inventory location of the product. |
Product 8 Supplier | The supplier of the product. |
Prod 8 SKU | The product's SKU. |
Prod 8 Name | The name of the product. |
Prod 8 Tax | The tax of the product. |
Prod 8 Price | The product's price. |
Prod 8 Alchol % | The alcohol % of the product. |
Prod 8 Weight | The weight of the product. |
Prod 8 Inventory Location | The inventory location of the product. |
Product 9 Supplier | The supplier of the product. |
Prod 9 SKU | The product's SKU. |
Prod 9 Name | The name of the product. |
Prod 9 Tax | The tax of the product. |
Prod 9 Price | The product's price. |
Prod 9 Alchol % | The alcohol % of the product. |
Prod 9 Weight | The weight of the product. |
Prod 9 Inventory Location | The inventory location of the product. |
Product 10 Supplier | The supplier of the product. |
Prod 10 SKU | The product's SKU. |
Prod 10 Name | The name of the product. |
Prod 10 Tax | The tax of the product. |
Prod 10 Price | The product's price. |
Prod 10 Alchol % | The alcohol % of the product. |
Prod 10 Weight | The weight of the product. |
Prod 10 Inventory Location | The inventory location of the product. |
Product 11 Supplier | The supplier of the product. |
Prod 11 SKU | The product's SKU. |
Prod 11 Name | The name of the product. |
Prod 11 Tax | The tax of the product. |
Prod 11 Price | The product's price. |
Prod 11 Alchol % | The alcohol % of the product. |
Prod 11 Weight | The weight of the product. |
Prod 11 Inventory Location | The inventory location of the product. |
Product 12 Supplier | The supplier of the product. |
Prod 12 SKU | The product's SKU. |
Prod 12 Name | The name of the product. |
Prod 12 Tax | The tax of the product. |
Prod 12 Price | The product's price. |
Prod 12 Alchol % | The alcohol % of the product. |
Prod 12 Weight | The weight of the product. |
Prod 12 Inventory Location | The inventory location of the product. |