Browse Guides

Datto Commerce Integration
Reading mode
Copy Link
Link Copied!
Print
Feedback
This guide has multiple versions available:
<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}.fr-fic.fr-dii{ float: none; margin: 5px auto;}.fr-fic.fr-dii.fr-fil{ float: left; margin: 5px auto;}.fr-fic.fr-dii.fr-fir{ float: right; margin: 5px auto;}img.fr-dib.fr-fir { margin-right: 0; text-align: right;}img.fr-dib.fr-fil { margin-left: 0; text-align: left;}img.fr-dib { margin: 5px auto; display: block; float: none;}img.fr-bordered { box-sizing: content-box; border: solid 5px #CCC;}img.fr-shadow { box-shadow: 10px 10px 5px 0px #cccccc;}img.fr-rounded { border-radius: 10px; -moz-border-radius: 10px; -webkit-border-radius: 10px; -moz-background-clip: padding; -webkit-background-clip: padding-box; background-clip: padding-box;}</style><p><strong>In this guide we will cover:</strong></p><p><strong>- What is the Datto Commerce Integration?</strong></p><p><strong>- Connecting to Datto Commerce</strong></p><p><strong>- Customer Imports</strong></p><p><strong>- Quote Imports</strong></p><p><strong>- Sales Order Imports</strong></p><p><strong>- Halo Integrator</strong></p><p><br></p><p><br></p><p><strong><span style="font-size: 14pt;">What is the Datto Commerce Integration?<br></span></strong></p><p>Datto Commerce can be integrated with Halo to import and view Customers, Quotations and Sales Orders from Datto into Halo. The Halo Integrator can be used to have these entities imported from Datto into Halo automatically on a scheduled basis.&nbsp;</p><p><br></p><p id="isPasted"><strong><em>Note: The integration with Datto Commerce is one way. Any changes made in Halo will not be reflected in Datto Commerce as their API is read-only.</em></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Connecting to Datto Commerce<br></span></strong></p><p>In Configuration &gt; Integrations &gt; Quotation Management, hover over the Datto Commerce module, and click the &quot;+&quot; sign to enable it.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImM0MDIwNDQzLTUyOTctNGQ3OC1hM2MzLTE4NDc5M2QxYjI3OCJ9.8shwN1tjqKIJvxBjSN61CoQBxC-OjunkB_tSmPQsYcI" class="fr-fic fr-fil fr-dib" width="526" height="255"></p><p><strong><span style="font-size: 10pt;">Fig 1. Enabling the module</span></strong></p><p><br></p><p>Clicking into the module will show a button to view/create Tenants. Click this.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImQ5NjYwM2I4LWFhZGUtNGNkNS1hNDExLTc3ZTAxMGI1ZDc4NiJ9.zpMJUvUIn10_9e_ncROhgPMwR4rPfZFGK514asLtYYM" class="fr-fic fr-fil fr-dib" width="735" height="204"></p><p><strong><span style="font-size: 10pt;">Fig 2. Tenants button</span></strong></p><p><br></p><p>This will bring up a list of any existing Datto Commerce Tenants with their URL. Click the &quot;New&quot; button to add a Tenant.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjY3NDQ1NGJmLTRlZDMtNGQ3MS04MmIxLTNlNjcxOGQzODVjMCJ9.gOWiR3E4eTMiS0Z_WIrOHqJ8m7hGqqVJdrl0nalN-Ig" class="fr-fic fr-fil fr-dib" width="1216" style="width: 1218px; height: 115.111px;" height="115"></p><p><strong><span style="font-size: 10pt;">Fig 3. List of Datto Commerce Tenants</span></strong></p><p><br></p><p>Here you enter the URL and an API Token to connect to your Tenant. This Token can be generated from Datto Commerce in API &gt; New API Key.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjA1YmFhYjk5LTc1MzItNDQ1MC1iOTBkLTkwYzJhY2ViNjNlYSJ9.QBbQdGUtIgRG4V5D6CjCa5MRv0SwBI3eWcw3OYWKv9w" class="fr-fic fr-fil fr-dib" width="863" height="436"></p><p><strong><span style="font-size: 10pt;">Fig 4. Connecting to Datto Commerc</span></strong></p><p><br></p><p id="isPasted">Clicking the &quot;Save&quot; button will now show the option to configure the imports.</p><p><br></p><p><strong><span style="font-size: 14pt;">Customer Imports<br></span></strong></p><p>Open the &quot;Customer Imports&quot; dropdown. Here a few options will show:</p><p><br></p><ul><li><strong>Field Mappings:</strong> This table can be used to map Custom Fields of type &quot;Customer&quot; to Datto Fields.</li><li><strong>Minimum Start Date:&nbsp;</strong>This can be set to another date to allow the manual import to go further back than the default date set. This defaults to 30 days ago.</li><li>I<strong>mport Customers:</strong> This button will bring up the import screen.</li></ul><p><br></p><p>Click &quot;Add&quot; on the Field Mappings table.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjE2NmMzZGIzLTlkYmUtNDFhNy1hMTJmLWVjNmJjNWNiNTkxOSJ9.dpSQKRoK0R7tD7RcwS1sbJMu0eRXHSAqIXyErkyLNL8" class="fr-fic fr-fil fr-dib" width="1212" style="width: 1214px; height: 427.923px;" height="428"></p><p><strong><span style="font-size: 10pt;">Fig 5. Customer Imports dropdown.</span></strong></p><p><br></p><p>A popup will show to map a Datto Commerce Field to a Halo Field. The Halo Field must be a Custom Field with the &quot;Customer&quot; entity.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjgzOTk4N2Q1LTUzNzctNDI5ZS04YjdmLTBhYWUxYTgxYTIzNSJ9.AMFUzzTrgfgcXeypmeVjSTfYhDpEba0Bs-LhUtlpR5A" class="fr-fic fr-fil fr-dib" width="708" height="507"></p><p><strong><span style="font-size: 10pt;">Fig 6. Customer Field Mappings popup</span></strong></p><p><br></p><p>Once mapped, you can import your customers with the &quot;Import Customers&quot; button.</p><p><br></p><p><strong><span style="font-size: 14pt;">Quote Imports<br></span></strong></p><p>The next dropdown is for &quot;Quote Imports&quot;.</p><p><br></p><ul><li><strong>Product Group Mappings:</strong> This table can be used to map Product Groups to Datto Product Categories.</li><li><strong>Default Product Group:</strong> This sets the Product Group to use for unmapped categories.</li><li id="isPasted"><strong>Import items from Datto Commerce when creating Quotes:</strong> If enabled, Products will be created from imported Quotations if they do not yet exist in Halo. When importing Products into Halo, we import name, price (recurring price is product is marked as recurring in Datto Commerce), billing period (if recurring), date created/last modified, is consignable (marked as &#39;true&#39; in halo when the product is serialised in Datto), group, tax and SKU.</li><li id="isPasted"><strong>Set line cost from Datto Commerce when creating Quotes:</strong> If enabled, Quotation Lines will have the cost set from Datto Commerce when imported.</li><li id="isPasted"><strong>Status Mappings:</strong> This table can be used to map Ticket Statuses to Datto Commerce Statuses.</li><li><strong>Minimum Start Date:&nbsp;</strong>This can be set to another date to allow the manual import to go further back than the default date set. This defaults to 30 days ago.</li><li><strong>Import Quotes modified in the last X days:</strong> This allows you to set the number of days to include in the import since the quote was last modified. This defaults to 30 days.</li><li><strong>Import Quotations:&nbsp;</strong>This button will bring up the import screen.</li></ul><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjRkNmNlZjI0LWNlNmUtNGQ5ZS05NDZkLTkwNWI2YTljNmE4ZCJ9.SKpuqOn__h1EaNt45L588RfVUDjQz9VskO6vH9FDFLk" class="fr-fic fr-fil fr-dib" width="1573" style="width: 1575px; height: 688.692px;" height="689"></p><p><strong><span style="font-size: 10pt;">Fig 7. Quote Imports dropdown</span></strong></p><p><br></p><p>Quotation Statuses will be matched by name automatically when importing. If a Quotation Status of that name does not already exist in Halo, one will be created.</p><p><br></p><p>The &quot;Status Mappings&quot; table uses Ticket Statuses. If a Ticket is linked to the Quotation, any change in the Datto Commerce Status will change the Status of the linked Ticket to the mapping set here.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijc5YTJjYjFkLTc4NzctNDJhZC04ZDE5LWI3ODFjYzcxNmIzZiJ9.X4bdZp9Z63u_IXyfg-ZhTLBsNTZVue8oNvJQzdsVupw" class="fr-fic fr-fil fr-dib" width="1221" style="width: 1223px; height: 456.18px;" height="456"></p><p><strong><span style="font-size: 10pt;">Fig 8. Status Mappings</span></strong></p><p><br></p><p>The quotation shown in Figure 9 was pulled in with the above configuration. It has been linked to one of the Customers we previously imported.&nbsp;</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6Ijk3NTVlYTJiLTY3OGYtNGJmMC05ZTg3LTNjOTUwOTg0M2IyMiJ9.Bf7oxiMXLgZWazwcFv1kge8J_8BGUrDw2ymwnlBkhSw" class="fr-fic fr-fil fr-dib" width="1225" style="width: 1227px; height: 542.983px;" height="543"></p><p><strong><span style="font-size: 10pt;">Fig 9. Imported Quotation</span></strong></p><p><br></p><p><span style="font-size: 10pt;"><em><strong>Note: Only quotation prices will be present on quotes imported from Datto, no cost will be imported due to how cost is exposed via Datto&#39;s API.</strong></em></span></p><p><br></p><p><span style="font-size: 10pt;"><span style="color: rgb(0, 0, 0); font-family: sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;" data-pasted="true">Any quotes imported from Datto Commerce will have no option to edit the quote as the API for Datto Commerce is read-only so we can only retrieve data from there but not post updates to it.&nbsp;</span></span>However, there are two options available instead, linking quotes directly to tickets in Halo and viewing quotes in Datto Commerce. Also please note that you will be able to do all standard Halo actions on a quote except for specifically editing and deleting (e.g. create sales order, send) and please note that any changes to the quote made using these actions (e.g. sending, updating status) will not be reflected in Datto Commerce.</p><p><br></p><p data-pasted="true">Once the Datto Commerce integration module is enabled a new button will show in the quotations list under the three dots where you can open the new quote screen for Datto Commerce.</p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImIwMjM5MmYyLTlhOGUtNGYyYi04ZTk3LTI0Njg5YjlkYjFjOCJ9.3gDi3MprRi9EghQFora_88OYnXfywTwdLZph3G1LCws" class="fr-fic fr-fil fr-dib" width="1811" style="width: 1813px; height: 298.918px;" height="299"></p><p><strong><span style="font-size: 10pt;">Fig 10. Raise Quote in Datto Commerce from Halo&nbsp;</span></strong></p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjJjOTE1NjcxLTA3ZDAtNDJjZC1hNTQ1LWMxYTRjMGRlN2FjNCJ9._Kmt64iooKmCwLkFNJ4GF0-muxQmhptGZUXi77iPJ2k" class="fr-fic fr-fil fr-dib" width="1081" style="width: 1083px; height: 241.207px;" height="241"></p><p style="box-sizing: inherit; margin: 0px; line-height: 1.4285em;" data-pasted="true"><strong><span style="font-size: 10pt;">Fig 11. View Quote in Datto Commerce button</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Sales Order Imports<br></span></strong></p><p>The next dropdown is &quot;Sales Orders Imports&quot;.</p><p><br></p><ul><li id="isPasted"><strong>Sales Order Statuses to Import:&nbsp;</strong>Only Sales Orders with the Datto Commerce Statuses set here will be imported.</li><li id="isPasted"><strong>Minimum Start Date:</strong> This can be set to another date to allow the manual import to go further back than the default date set. This defaults to 30 days ago.</li><li><strong>Import Sales Orders:</strong> This button will bring up the import screen.</li></ul><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjcxOGQyZTI2LWQwMmQtNDk0MS1hMGViLWI3Y2MxY2ZlNDAzYSJ9.uLocm0vb9bwo4_ohNxBMnmo2NGx4_5LxO6qjQAEayyQ" class="fr-fic fr-fil fr-dib" width="1222" style="width: 1224px; height: 433.205px;" height="433"></p><p><strong><span style="font-size: 10pt;">Fig 12. Sales Orders Imports</span></strong></p><p><br></p><p>The Sales Order below has been imported, and has additionally been linked to the associated imported Quotation.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjZmNWVmZjMzLWQ5MmEtNDk5Yi05MmE4LTgzMTgzZTE0YjJjOSJ9.ZofHbjYFLionIcb_foZi8t4Mk4cEv6lHdyGqNY9tSPU" class="fr-fic fr-fil fr-dib" width="1213" style="width: 1215px; height: 494.595px;" height="495"></p><p><strong><span style="font-size: 10pt;">Fig 13. Imported Sales Order</span></strong></p><p><br></p><p><strong><span style="font-size: 14pt;">Halo Integrator<br></span></strong></p><p>The final dropdown is for the &quot;Halo Integrator&quot;. Customers, Quotes and/or Sales Orders can be imported automatically on a recurring basis. Ensuring when these entities are created or updated in Datto, these changes will be reflected in Halo.&nbsp;</p><p><br></p><ul><li id="isPasted"><strong>Enable the Halo Integrator for this Datto Commerce URL:&nbsp;</strong>Enables the Integrator.</li><li id="isPasted"><strong>Entities to Sync:&nbsp;</strong>Selects which entities will sync automatically.</li></ul><p><br></p><p>Due to the &quot;Minimum Start Date&quot; Fields only applying for manual imports, the integrator will by default only import the last 30 days of modified Customers/Quotations/Sales Orders.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjMzZWQ1ZjBlLTliZDMtNDM0MC1iZDcxLTQwM2U5MGFkYjZjYSJ9.7qPw0SMfoAMlXQb-tumImJ8mTtMOvhmoafyw5YTsRtY" class="fr-fic fr-fil fr-dib" width="1211" style="width: 1213px; height: 575.845px;" height="576"></p><p><strong><span style="font-size: 10pt;">Fig 14. Halo Integrator dropdown</span></strong></p><p><br></p><p><br></p>
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.