TOP

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 >


Running The Report

1. Go to Reports > Sales > WSN Report.

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. By default the date range should be a single day.

3. Adjust any additional Date Type parameters, such as: 

  • Submitted Date
  • Completed Date
  • Ship/Pickup Date

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.

  • All Statuses
  • Submitted
  • Completed
  • Pending
  • Hold
  • Quarantine

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.

  • All Statuses
  • No Status
  • Sent to Fulfillment
  • Shipped
  • Picked Up
  • Handled Externally
  • Pending Carrier Pickup
  • Not Shipped
  • Not Picked Up

6. Click View Report to run download your report. Your report will download automatically so you may need to check your browser downloads or the downloads folder of your workstation.

Page Top


WSN Report Export

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.

Page Top