Allow your customers to retrieve product documents by simply SMS texting a picture of a barcode from the product

Allow your customers to retrieve product documents by simply SMS texting a picture of a barcode from the product

Getting product documents to your customers and your field technicians is always difficult.  SMS Central makes it easier.  Your customer or field personnel only needs to take a picture of a barcode on the product and SMS text it through SMS Central, which will look up the proper document and text it back.  No app is needed, no website, no jotting down of serial numbers and then running to a computer to google.  Just simply text a picture and get the document.

You can link any type of barcode to a document.  Whether it is a manufacturer’s barcode or you have your own barcode standards.  We just link that barcode to a document and when a customer or field person texts a picture of a matching barcode or QR code, we lookup the appropriate document and send it back to them.

Documents can be stored in SharePoint, SQL Server, Azure Storage, Web, or we can store it for you in our cloud storage.

Advertisements
SMS and Barcodes make for quick and easy communication to your ERP, Helpdesk, Field Service, or other system

SMS and Barcodes make for quick and easy communication to your ERP, Helpdesk, Field Service, or other system

SMS Central provides you with a way for customers and employees to quickly communicate information stored on barcodes directly back to your back-office systems by doing nothing more than taking a picture of the barcode and texting it.  You don’t need any app installed on a phone other than SMS messaging.  Those barcodes can then be used to create sales orders, service calls, inventory changes, as well as countless other things that you can use when tagging an item with a bar or QR Code.

Barcode formats SMS Central can handle

UPC-A, UPC-E, EAN-8, EAN-13, Code 39, Code 93, Code 128, ITF, Codabar, MSI, RSS-14, QR Code, Data Matrix, Aztec, PDF-417 

For Customers

Wouldn’t it be great if you could communicate information with high accuracy between you and your customers?  What if your customer has a problem with one of your products and you are trying to determine exactly which one it is?

SMS Central allows you to give your customer a phone number to SMS text to and mail a QR or barcode directly to your system already decoded!

All a customer has to do is take a picture of the barcode on their product and SMS message it to you.  They don’t have to install any special app on their phone and it will work on any phone.  SMS Central will then automatically decode that barcode and can then save it directly into your ERP, helpdesk, field service, CRM, or any other system so that you can have that information at your fingertips. 

For Sales

If you have sales people out in the field needing to restock shelves, supply restaurants, or other situation where the sales rep can snap a picture of the barcode on a product, SMS text it to your order management system, and then get it ordered.  All without any app installed on their phone.

Just snap a picture of a barcode of a product and send it to your order management or other system!

There are countless ways that SMS Central could be configured to handle most any workflow or need.

For Field Service, Inventory, and Asset Management

Your people in the field can quickly snap shots of barcodes and QR codes at customer sites to track what equipment is on site, what hardware has problems, or take inventory of assets at a location by simply using any phone and taking a picture and texting it.

Getting information about an asset or tracking assets is as easy as taking a picture of a barcode and sending it to your back-office system.  SMS Central does the rest!

Communicate quicker and easier with your Customers using Catalina’s SMS Central

Communicate quicker and easier with your Customers using Catalina’s SMS Central

SMS Central is perfect for quick communication with your customers over SMS texts.  Unlike email, SMS messages have an extremely high open rate (usually greater than 99%) and 90% are read within 3 minutes of delivery.  This makes SMS ideal for delivering important information from business applications to your customers.  Your customers can also text information back which can then be recorded in your business systems.

SMS Central can send notifications to your customer

  • Notify customers of pending field service visit or changes in date/time
  • Notify customers of product shipment
  • Notify customers of tracking information or delivery
  • Schedule automatic follow up messages to customers after a service call or support incident is closed
  • Send images to field staff so they can see what the customer has reported needs work
  • Send images to customers showing damages found, repairs needed, proposed work site
  • Get customer approval on completed work displayed in images sent to their phones

Appointment Reminders and Confirmations

  • Send customers messages when a service call is scheduled
  • Send an automatic service call appointment reminders prior to scheduled visit
  • Have customers confirm they can be available for a service call (if required)
  • Have customers confirm site will be ready for the service call
  • Send customers notices when service calls need to be delayed or changed
  • Have customers confirm service call date/time changes

Photos

  • Get photos from customers of damages, repair sites, or other useful images
  • Get GPS coordinates of mobile images for proof of location, tracking movement
  • Get before/after service photos as proof of work
  • Read barcodes using only a mobile phone camera and record results in business application (GPS coordinates are also available on barcode images)
  • Send images to customers showing damages found, repairs needed, proposed work site
  • Get customer approval on completed work displayed in images sent to their phones

 

Send Pictures and Locations to Dynamics SL through SMS Texts

Send Pictures and Locations to Dynamics SL through SMS Texts

You can allow your field service and sales people send pictures, updates, and even location to Dynamics SL service module with SMS text messaging.  No app needed and any phone will work (even a flip phone)!

Some of SMS Central’s features:

  1. Catalina’s SMS Central allows a field person to update status of a field service call by just sending an SMS text message (no app needed) on any phone.
  2. Take pictures from your phone and auto-attach to a service call in Dynamics SL.
  3. Catalina’s SMS Central can capture the GPS coordinates of the picture and plot it on a map.
  4. SMS Central can forward pictures to your customer for them to reply to, for proof of work.
  5. Catalina’s portal allows easy viewing of history using any web browser.

Catalina Portal for Viewing Messaging History

Images are not only stored as attachments in Dynamics SL, but also captured in a web based portal accessible by any modern browser.  The Catalina portal can also pin the locations of the photos on a map as well as display Dynamics SL data for quick access of the Service Call information.

smsCentral

 

Catalina does IoT with MQTT

 

Catalina Technologies Integration Toolkit is IoT ready with strong MQTT connectivity.

Catalina is IOT Ready-smaller

You can subscribe to feeds on existing MQTT brokers, publish to feeds on MQTT brokers, and the Catalina Toolkit even has it’s own built in broker that can be published to which maps and routes the MQTT packets to other systems.

Features:

Subscribe to feeds

Catalina Integrator can subscribe and listen to feeds on existing brokers.  This allows you to monitor data coming in from devices and map that data to other systems and storage.  If you don’t have an existing MQTT broker, Catalina Integrator has a built in MQTT broker.

MQTTDetail

Data mapping and route to other systems

When data is received from a monitored feed, Catalina Integrator can then push it to a script and redirect it to other systems such as field service, ERP, CRM, Support, and Help Desk systems.

Scripting

Send data to an MQTT broker

So far, we have been talking about subscribing to MQTT feeds and acting on them.  But what if you need to send data to a device through MQTT?  Catalina Integrator allows you to redirect any data to an MQTT broker feed.  This means that you can send messages and control devices out in the field directly from your Service, Helpdesk, Dispatch, CRM, ERP, or other system.  Below, is an example where we are turning on lighting based on an event in the service call system in Dynamics SL.

postToMQTT

Create your own incrementing scheme in SQL for Dynamics SL Order Line Items

Earlier today, I was asked if I could come up with a query that would allow you to bring back line items for a sales order.  But create a numbering scheme for the line items that re-start for each new order number.  So, example:

You can see below, that ORD1234 has 3 items, indexed 1,2,3.  and ORD5555 has 2 line items indexed 1,2

OrdNbr InvtID LineIndex
ORD1234 IN82344 1
ORD1234 IN82341 2
ORD1234 IN82344 3
ORD5555 IN089723 1
ORD5555 IN0123998 2

I accomplished this by using the DENSE_RANK().

Here is sample code:


SELECT DENSE_RANK() OVER (PARTITION BY OrdNbr ORDER BY OrdNbr, LineRef) * 10  AS LineIndex
, OrdNbr
, LineRef
, InvtID
, QtyOrd
FROM   SOLine
ORDER  BY OrdNbr, LineIndex

What I wanted to do in this was to show the order number, lineRef, invtID, and qtyOrd.  But I wanted to show the LineIndex in increments of 10 that restarted for every time the OrdNbr changed.  I have one of the orders that have multiple line items circled below.

sql