ATS Healthcare App

The ATS Healthcare integration app for Commerce7 is owned and developed by a 3rd-party developer (Treefrog Digital). For questions regarding custom reports, setup, or support, please contact us at support@treefrogdigital.com


App Technical Description

The ATS Healthcare Integration for Commerce7 uses a file-based workflow to support order fulfillment and tracking updates. It generates ATS-formatted order reports from Commerce7 and allows tracking numbers from ATS Healthcare to be uploaded via CSV, marking orders as fulfilled and applying tracking data. Automated data exchange is not supported due to the absence of an ATS Healthcare API.

For quick access to the topic you are looking for, click the corresponding link below:


Setup Instructions


  1. Install the App on Commerce7
  • From the Commerce7 Admin Panel, go to Apps & Extensions, then select Apps. (You must have Admin Owner role to install the app)
  • Search for 'ATS Healthcare by Treefrog Digital', click the app, then click 'Install App'.

2. Once installed, before you start using it, you must configure the app.

3. Head into Reports - Order Reports - ATS Healthcare - Settings - General 

  • Complete the following fields:
  • Docket: Enter your ATS Healthcare Docket (the Docket can be obtained from ATS Healthcare)
  • Service: Select the service type from the drop-down menu
  • Accessorials: Select all that apply
  • Shipment Tracking Emails: Enable to send emails with tracking information. 

Note: You can obtain your ATS Healthcare Docket from ATS Healthcare, as well as confirm which service type you use and any applicable accessorials.

4. Once all information is entered, scroll down and click Save.


How to Export a Report with ATS Healthcare

The app allows you to export a report with the exact format ATS needs. Once you download this report, you can upload it to ATS Healthcare for bulk processing orders.


  1. Log in to the admin panel.
  2. Navigate to the Reports tab.
  3. Select Order Reports.
  4. Scroll down and click on ATS Healthcare.

  1. Select the date range for the shipping orders you want to export:
    • Choose a Start Date.
    • Choose an End Date.
  2. Click Email Report to request the report.

  1. A message will pop up confirming the request and the number of records it will export. Click on Email Report

  1. Wait while the system processes your request. Processing time may vary depending on the amount of data being exported and the selected date range.
    • Orders will be exported to a CSV file in the ATS Healthcare format. You'll be notified by email when the export is complete.
    • If you have Admin Owner permissions, you can check its progress in the Bulk Actions area. Click on Settings - Bulk Actions.

  1. If you are monitoring your report request in the Bulk Action area, once the status changes to Done, the report is ready for download; click the Download button to download it.
    • Retrieving Data – The report is still being generated.
    • Done – The report is ready for download.
    • No Orders Found – No orders were found within the selected date range.

  1. A copy of the report will also be sent to your email address. Note that the download links expire after 24 hours.


How to Import your file into ATS Healthcare


The downloaded file will be in a CSV format. 


After reviewing the information, you’ll need to log in to your ATS Healthcare account and follow the steps they outline for batch uploading the orders for shipping.



How to upload yout ATS Healthcare file back into Commerce7 (to fulfill orders and push tracking information)

Before uploading a file, ensure the following:


  1. The export option is enabled within ATS Healthcare.
  2. The needed download file is available in the following path: C:\ATS
  3. The file is a .csv file that starts with: ATSOut
  4. Review the file and make sure it contains the following header columns: PO, Reference, Shipment Number, ConsigneeName, DocketCode, and Date.
  5. In Commerce7, navigate to Orders - Orders Report
  6. Scroll down until you find the ATS Healthcare option, then click on it.

  1. Select Import, then click Upload Tracking Numbers.
  2. Enter a Title for the upload.
  • This is an internal reference name only.
  • The title helps identify uploaded files and does not affect the import process.

9. Click Choose File and select the ATS Healthcare CSV file.

10. Click Save to begin the upload.

11. Once the file is uploaded:

  • Orders included in the file will automatically be marked as Fulfilled.
  • Tracking numbers will be added to the corresponding orders.

12. Review the Status of the upload.

  • You can review the status under imports; it will indicate whether the upload was successful.
  • Any errors encountered during processing will also be displayed.

13. Click on the upload Status to view a detailed summary of all orders included in the file and their individual import statuses.


ATS Healthcare Export CSV Fields


To understand better your exported file, below is the documentation for the columns available in the ATS Healthcare report:

COLUMN ATS INSTRUCTIONS
Docket Your unique Customer ID number
Attention Special Attention Line
Name Name of Recipient 
Address Address of recipient
Address 1 Address line #2- suie # etc of the recipient
City City of recipient
Province Two letter province code of the recipient
Country Country code of the recipient
Zip Postal code of the recipient
Phone Phone number of the recipient
Email Email of the recipient. They will receive tracking notifications.
Send 1= send tracking information
Pieces How many package(s) are being shipped
Weight The weight of the package(s) being shipped
Instructions Any special instructions there may be for the order/package
Service The service level for the package(s) being sent
Accessorials HS (Heated Service), KC (Keep Cool), NS (No Signature Required), BD (Back Door), etc.
Ref A reference number for the shipped package(s)
Description of Goods A description of the goods in the package(s) being shipped

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.