--- title: "ATS Healthcare Report" slug: "ats-healthcare-report" updated: 2023-03-29T18:05:42Z published: 2023-03-29T18:05:42Z canonical: "docs.winedirect.com/ats-healthcare-report" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.winedirect.com/llms.txt > Use this file to discover all available pages before exploring further. # ATS Healthcare Report **For Canadian Wineries Only** The. CSV export from the ATS Healthcare Report is formatted explicitly for [ATS healthcare](http://www.atshealthcare.ca/index.aspx) to batch-update orders for shipping. --- Report Setup To ensure the accuracy of all orders, we recommend taking additional setup steps for each of the following columns. **Webservices Account** For orders to be imported from Flamesoft, a web service account must be set up for your winery. Please get in touch with support@winedirect.com to get an account set up. This account information then needs to be provided to ATS Healthcare. **Weight** Take the time to make sure you've added weight as detail on each of your products. Every time you create a new order, the report will calculate the total weight based on the weight you entered for each product. --- ## Running The Report 1. Go to **Reports > Shipping > ATS Healthcare** 2. Select the date range (DD/MM/YYYY) 3. Under **Manage Filters**, confirm that your report settings are accurate. 1. You'll find **All Types** as the default Order Type option, but it can up updated only to include the Club Order Order Type if needed. 2. **Order Status** will only pull **Completed and Submitted** orders 3. **Shipping** status will only use **Not Shipped** and **Sent to fulfillment orders**For the most part, you will only need to filter orders that have not yet shipped. Set your Shipping Status to Not Shipped to find only the charges waiting to be shipped. 4. **Clubs**is an optional filter that allows you to select one or more clubs to include for the returned ordersNOTE: You can filter by club using the club option, but the ATS Report does not have a column that displays each club name. If using, make sure to double-check this filter. 4. Preview your report with **View** or click **Export** to download in a . CSV format. --- ## ATS Healthcare CSV Below is the documentation for the columns in the ATS Healthcare report and what data from WineDirect is used for each. (Definitions are only included for columns populated with WineDirect order information.) To import into ATS Healthcare, file headers must match spelling and formatting to those displayed below, and columns cannot be removed. For more information, see the ATS Healthcare Documentation PDF. *Mandatory rows are marked with a ****** | **Column Name** | **ATS Instructions** | **WineDirect Report** | | --- | --- | --- | | Docket * | Enter your unique customer ID number. | This column is left **blank** and must be manually populated by the winery. | | Attention | Special attention line. | If there is one, the **Company Name** from the shipping address is populated. Otherwise, this column will be blank. | | Name * | Name of the recipient. | The **Shipping First and Last Name** is populated. | | Address * | Address line of the recipient. | The **Shipping Address** is populated. | | Address1 | Address line #2 - suite # etc., of the recipient. | Shipping **Address 2** is populated. | | City * | City of the recipient. | The **Shipping City** is populated. | | Province * | Two-letter province code of the recipient. | The **Shipping State** is populated. | | Country * | Country code of the recipient. | The **Shipping Country** is populated. | | Zip * | Postal code of the recipient. | The **Shipping Postal Code** is populated. | | Phone * | Phone number of the recipient. | The **Shipping Phone Number** is populated. | | Email * | Phone number of the purchaser. They will receive tracking notifications. | The **Billing Email** is populated. | | Send | 1 = send tracking information | This column is set to 1 by default. | | Pieces * | How many package(s) are being shipped? | This column is populated **1oneby default** but may need to be manually updated if the order is split into multiple packages. | | Weight * | The weight of the package(s) being shipped. | This column is calculated based on the **P****roducts Weight** you have entered for each product and represents the total weight of all the products in the package. You should enter all the weights for your products, so this column does not require manual intervention. You will want to double-check this column if you have not done this. | | Instructions | Any special instructions there may be for the order/package. | The **Order Notes** are populated. | | Service * | The service level for the package(s) being sent. | This column is populated to **GE** - Ground Expedited by default but can be manually updated. | | Accessorials | HS (Heated Service) KC (Keep Cool) NS (no signature required) | This column is left **B****lank** by default but can be manually populated. | | Ref | A reference number for the shipped package(s) | The **O****rder Number** is populated. | | Description Of Goods | A description of the goods in the package(s) being shipped. | This column is populated to **Wine** by default but can be manually updated | | Vin65 * | Column AO This lets ATS know the order came from WineDirect | The **O****rder Number** is populated. | --- ## Importing ATS Healthcare Report 1. Ensure to update any columns manually (refer to the columns guide above) 2. Re-save the file in XLS (Office 97 – 2003) format, not XLSX. 3. Login to your Flamesoft account. 4. Follow the setup steps outlined by ATS Healthcare to batch upload the orders for shipping. If you need additional help importing into ATS Healthcare / Flamesoft or for new accounts, contact the ATS support team by email at atshelp@ats.ca.