Overview

To streamline and automate the process of assigning ARMOR shipped devices to customers, manufacturers need to send a daily file via email that conforms to a specific format. This guide will outline the necessary steps and provide a sample Excel template for reference (bottom of article). 

File Format Requirements

The file should be in Excel format (.xlsx) and contain the following column headers:

1. TRANSTYPE: Indicates the type of transaction.
   • "I" for Inbound return from customer to manufacturer.
   • "O" for Outbound shipment from manufacturer to customer.
2. CUSTOMER: The name of the customer.
3. SITENAME: The specific site or store name.
4. MFG: The manufacturer of the device.
5. MODEL: The model number of the device.
6. SERIAL: The serial number of the device.
7. IMEI: The IMEI number of the device.
8. ADDR_1: The first line of the address.
9. ADDR_2: The second line of the address (optional).
10. CITY: The city of the address.
11. STATE: The state of the address.
12. ZIPCODE: The ZIP code of the address.
13. SHIP_DATE: The date and time when the shipment occurred.

Sample File Structure

Below is a sample structure based on the provided Excel template:

Integration Process

1. Daily File Submission:

   • Manufacturers must send a daily email with the Excel file attached.
   • The email should be sent to the designated email address provided by ARMOR.

2. Email Subject Line:

   • The subject line of the email should be the same on all emails. 
     • Example: "ARMOR Daily Shipments".

3. File Naming Convention:

   • The Excel file should be named similar to the format: ManufacturerName_ShippingData.xlsx. For example: MFGName_ShippingData.xlsx.

4. Email Body:

   • The body of the email is not parsed by our systems.

5. Data Validation:

   • Ensure that all required fields are filled out accurately.
   • Any missing or incorrect data could lead to delays in processing and assigning the shipped devices.

Handling Inbound and Outbound Transactions

• Inbound Transactions (TRANSTYPE = "I"):

  • Used when devices are returned from customers to the manufacturer.
  • Ensure the shipment details reflect the return journey accurately.

• Outbound Transactions (TRANSTYPE = "O"):

  • Used when devices are shipped from the manufacturer to customers.
  • Ensure the shipment details reflect the outbound journey accurately.

Support

For any issues or questions regarding the file format or the submission process, please contact ARMOR Support at [email protected].

By following these guidelines, manufacturers can ensure a smooth and efficient process for assigning shipped devices to customers, enhancing traceability and customer satisfaction.