Answers - Quick Links

MINDBODY Integration: Number of Separate Sync Profiles needed for locations?

Did you know that the number of separate Sync Profiles is equivalent to the number of unique MINDBODY (MBO) Studio IDs you have in terms of integration? 

Not the number of locations in MINDBODY.

Let's take a look at the way it works with Pure Barre Studios:

If your business happens to have multiple locations utilizing separate Studio IDs from MINDBODY like Pure Barre Studios that you would want to sync to Infusionsoft, then you will just need to create separate Sync Profiles for each Studio ID. If QuickBooks Online then a Separate SyncApps account is needed for Intuit API certification rules.

save image

So for instance, since you will be on our real-time Enterprise plan integration with, let’s say 40 MINDBODY locations, you have set up 2 in the above example and will need to set up 38 more Sync Profiles for them set up in the exact same way if using Infusionsoft.

Should take 5 minutes to set up each integration for each separate MINDBODY Studio ID.

However, if you're just intending on syncing "Locations" in MINDBODY this is optional so if it is not specified in Step 1 then SyncApps will retrieve data from all of your locations within the MINDBODY site.

save image

If you have recently added a new location which has it's own location on your MINDBODY account and would like to set up similar syncing between that location on MINDBODY and it's own Infusionsoft account you can set that up using the Location to Sync feature and in Step 2 use the unique Infusionsoft account needed to integrate to.

If multiple QuickBooks Online instances needs to be integrated to MINDBODY Studio(s) then separate SyncApps account(s) are needed for Intuit API certification rules. 

Reach out to our team for any help in this setup.

We've found that over time this should save your business 2 hours per month per location.

Feel free to drop our product team support a note here if you hit any snags during the setup process.

Sync Specific NetSuite Transaction Saved Searches To Mailchimp Groups, Constant Contact Lists or even Infusionsoft or Drip Tags

Want to use NetSuite Transactional Saved Searches to Mailchimp Groups, Constant Contact Lists or even Infusionsoft or Drip Tags, so that you can target customers who have purchased before, based on price point, a varietal of product, region etc?

It's easy to do in SyncApps.

See how Drip to NetSuite example works in this video...

In Step 1 of your integration choosing a NetSuite Saved Search is easy to do:

Whether you are integrating CUstomers, Contacts, Transactions or Vendors.

In this example is a Transaction Saved Search.

This can be useful to bring over to your Marketing Automation Solution those records to market to which have a higher transaction value, buying patterns and other key indicators for your business.

save image

MailChimp Groups:

Constant Contact Lists:

 Easily upload your current email list to your Constant Contact account

Drip Tags:

save image

Infusionsoft Tags:

infusionsoft tag strategy

 

Own your Marketing Automation integration to NetSuite today.

Get started here...

NOTE:

Using NetSuite Saved Searches for Customer, Contact or Transaction from NetSuite will expose fields in Field Mapping step for each. More than one Saved Search can be specified. NetSuite supported Saved Search record types: Contact, Customer, Partner, Transaction. 

  • Each NetSuite Saved Search will be synced to a Mailchimp Group within the specified List and Group Title.
  • Each NetSuite Saved Search will be synced to an Infusionsoft Tag.
  • Each NetSuite Saved Search will be synced to a Drip Tag.
  • Each NetSuite Saved Search will be synced to an Infusionsoft Tag.
NetSuite Saved Search best practices & options for integration

Hi there!

Do you have any questions regarding the integration options?

Are you encountering challenges with your integration and sync procedures?

Well, we are super delighted to inform you that we provide our NetSuite platform for inquiries and guarantee solutions.

In case you are encountering any challenges, please feel free to send us your question(s) and our team will help out.

In the meantime, this inquiry sample with one of our subscribers can help you shed some light on your own questions:

Subscriber:

I have noticed over the past few weeks that our syncs seem to be taking a lot of time for a small amount of data. For instance, it takes 15-20 minutes for the syncs when only one or two records have changed. What might be the problem? Is it beyond regular NetSuite slowness and can it be rectified?

Cazoomi:

It seems the NetSuite Saved Search last modified criteria addition does not work. Alternatively, another reason could be that the customers are constantly being updated, thus explaining the 229 records retrieved from NetSuite.

 

Could you please send us a screenshot of your last Saved Search criteria?

Subscriber:

Here is the requested screenshot below. What are your thoughts?

 

Cazoomi:

We noticed that the last modified date criteria addition does not work for "Use Expressions" with OR logic. It will produce an incorrect Saved Search result.

Please put one more outermost parenthesis:

(Inactive = false AND .. AND ..) OR Name/ID = ... OR Name/ID = ...

TO

(( Inactive = false AND .. AND .. ) OR Name/ID = ... OR Name/ID = ...)

We have updated SyncApps tooltip and docs with the following rule to rectify the error:

If Saved Search criteria "Use Expressions" is checked then criteria MUST be wrapped with parenthesis "(" and  ")"

SyncApps will need to add one more last modified criteria.

If wrapper parenthesis is not added then saved search could produce incorrect result especially if criteria contains OR logic.

For example: Name = "A" OR Name = "B" must be changed to (Name = "A" OR Name = "B")

If you get any permissions Error on Sync Profile or NetSuite Saved Search with the internal ID x does not exist, please go to the following URL to review NetSuite User/Role permissions solution.

 

Note:

  • Do not use the Summary Saved Searches because they are not supported in NetSuite API.

Options available to determine which records to sync from NetSuite to Handshake:

They include:

  1. Sync All Customers

All Customers will be synced to Handshake.

  1. Sync Specific NetSuite Subscriptions

All Customers subscribed to the selected subscriptions will be synced to Handshake.

  1. Sync Specific NetSuite Saved Searches

Only records returned by the specified Saved Searches will be synced.

Please do not forget to give us feedback if our support was helpful. We strive to provide the best user experience from your feedback.

 

Sync Revenue Data From NetSuite to HubSpot

Looking for an integration that lets you pass or sync revenue data from NetSuite to HubSpot?  Such revenue data comes from the financial system of NetSuite.  Look no further!  Definitely, it is SyncApps’ NetSuite to HubSpot integration.

https://www.cazoomi.com/syncapps/netsuite-to-hubspot/

A subscriber just recently raised this certain idea whether SyncApps supports such an integration scenario to sync revenue data specifically from NetSuite to HubSpot.

Specific fields needed to map include:

1. Date of first invoice issued
2. Date of latest invoice
3. Amount of latest invoice
4. Total invoice amount for each company (Total Revenue)
5. Number of invoices for each company

And sure, SyncApps can meet this requirement!

Instead of mapping fields from multiple objects like the Customer, Contact, or an Invoice record, a best practice using SyncApps is just to use a NetSuite Transaction Saved Search.

To elaborate, use a Transaction Saved Search to drive records from NetSuite into HubSpot is simple OR you can also create those 5 fields on the Customer record in NetSuite and map them in SyncApps to be populated into HubSpot as well. Just an issue with that is they would always be updating NetSuite to HubSpot, if this is ok then you can do this method.

Take a NetSuite for HubSpot test drive today! https://www.cazoomi.com/syncapps/netsuite-to-hubspot/

If you hit any snags, give our experts a shout-out support@cazoomi.com.

NetSuite Summary Saved Search search column not Syncing

Wondering if your NetSuite Summary Saved Search search column is not Syncing?

SyncApps does not currently support this feature in NetSuite's API yet might in the future.

To prevent this type of error:

Error on sync: Error on retrieving page 1 of saved search: Cazoomi Test List. We cannot return search columns for summary saved search XXXX. Please make sure that save search type in configuration matches save search type in NetSuite. If the problem still persists please read the following KB article http://support.cazoomi.com/hc/en-us/articles/204089345 (Error code: INVALID_SAVEDSEARCH)

What you need to do is in NetSuite, edit the Saved Search and make sure no summary column (max, min, max, sum, etc)  is defined in "Results" tab. The summary type must be blank for all fields.

save image

 

Having trouble with Netsuite permissions? See it here today and get your Sync Profile syncing correctly.

NetSuite Concurrency for web services with SyncApps

Concurrency for web services and RESTlets is currently governed separately per user and authentication method. When the upcoming change takes effect, the new account governance limit will apply to the combined total of web services and RESTlet requests. With the change, you will not need to use a concurrent web services user to be able to send more concurrent requests for web services with token-based authentication.

We have identified that you may exceed the new account concurrency limit. Please review this notice to understand how to avoid errors after the new limit is enforced.

1) Does the SyncApps code use NetSuite web services? 

  • SyncApps uses web services


2) Does it make concurrent calls? 

  • SyncApps does not make concurrent calls


3) Is there a danger in this change?

  • That should not be a problem. SyncApps also will retry the API call if it gets concurrent exceed limit error

If you get an error using SyncApps around NetSuite Concurrent Web Services please see if other integrations are being scheduled at the same time.

15 Apr 2018 ERROR Error on sync: Only one request may be made against a session at a time (Error code: WS_CONCUR_SESSION_DISALLWD)


This usually occurs when you have simultaneous integrations scheduled to run at the same time. To fix this please schedule integrations to run at different times to avoid this error.

 

Xero is online accounting software for your small business, connected to your Apps!

SYNC XERO TO SYNCAPPS!

Don't spend hours every month creating invoices from CRM opportunities in Xero or importing contact data into your Email Marketing platform. Get connected.

Connect_Xero_to_your_other_applications_today_using_SyncApps..png

Unprocessed and filtered records

When using our powerful Filtering feature, SyncApps will only sync specific records that do not contain these Group/Role email addresses. Reason for this is that these are not "person" emails because they might cause spam complaints and blacklisting.

These are the following Group/Role email addresses that SyncApps will ignore when Filtering feature is enabled:

  • abuse@
  • admin@
  • all@
  • everyone@
  • ftp@
  • investorrelations@
  • jobs@
  • marketing@
  • media@
  • noc@
  • postmaster@
  • prime@
  • privacy@
  • remove@
  • request@
  • root@
  • sales@
  • security@
  • spam.*@
  • subscribe@
  • usenet@
  • users@
  • uucp@
  • webmaster@
  • www@
  • @yahoogroups.com
  • @googlegroups.com
  • noreply@
  • @example.com

Note:

If you are syncing any @yopmail emails with your email marketing this will cause errors to appear as Mailchimp and others have banned this domain so to avoid any errors just set up a filter in SyncApps with "Email does not contain @yopmail.com" criteria in your Sync Profile.

NetSuite Dynamic Discovery Method

SyncApps uses Dynamic Discovery Methods so you are all set with us.

save image

If you have more concerns with the NetSuite Dynamic Discovery Method then please reach out to our24/7 Support Team today!

Streamline your CPQ with Zoho CRM to QuoteWerks
The integrated solution for QuoteWerks and Zoho CRM, as seen on QuoteWerks, is out!
 
Many thanks to the team at QuoteWerks who worked with Cazoomi's top Zoho team lead these past few years on this awesome solution.
 
Now you'll be able to track your clients and business easily on QuoteWerks and Zoho CRM by using SyncApps which even works for Access or SQL Server. 
 

Zoho for QuoteWerks Integration features:

  • Sync customer and contacts in Zoho CRM to QuoteWerks
  • Drive your QuoteWerks estimates from Zoho customer lists
  • Sync Quotes from QuoteWerks to Zoho CRM
  • Supports QuoteWerks for Access and SQL Server versions
Data integration for QuickBooks Online to MINDBODY

Synchronize your MINDBODY Online to QuickBooks. Once available to only Fortune 1000 companies, SyncApps introduces a way for your business applications to talk to each other for less than the price of a Netflix subscription.

social_w3.jpg

Data integration is hard.  Let SyncApps do it!

QuickBooks Online with MINDBODY Online

Watch a quick video on initial setup...

Sync your  MINDBODY Online Transactions data to QuickBooks Online hassle-free and saves tons of time without manually uploading CSV's or manually inputting data. Give it a try today!

In a few easy Steps, just connect your two applications and set it up based on your requirements.

Book our experts 24/7 here for a personal guide...

SyncApps will use name matching for all products to be integrated. If the specified product name does not exist in QuickBooks, a new item will be created.

Payments mapping is automatic as well yet each needs to be set up prior in QuickBooks Online.

If needing to customize the Items Mapping for an existing client you can do this in Step 3 of Setup.

Major Features

  • Compatibility with the International Version of QuickBooks Online available.
  • Sync multiple MINDBODY locations with different QuickBooks Online instances.
  • Automatically sync your MINDBODY Online Clients to QuickBooks Online Customers.
  • Custom Field Mapping between both systems.
  • Assign Client Indexes to MINDBODY clients to sync to QuickBooks.
  • Sync MINDBODY Location to QuickBooks Online Sales Receipt Notes.
  • Option to Split Discount and Tax into separate line items.
  • Sync MINDBODY Online Sales receipts to QuickBooks Online Sales Receipts with ease.
  • Migrate unlimited QuickBooks historical data via our Advanced base date feature.
  • Quickly map MINDBODY Online Products/Services to QuickBooks Online Items.
  • MINDBODY Online Products or Services are only synced to QuickBooks if a new sale is created in MINDBODY Online for the specific MINDBODY Online Product or Service.
  • MINDBODY to QuickBooks Sync is sales centric so only products and a customer in each sale from MINDBODY Online will be synced.

We are available 24/7 so feel free to reach out to our team for assistance.

 

 

Cazoomi Answers and Best Practices

We're always working to deliver best practices around SyncApps that are relevant to your business. Now you don't have to look any further than Cazoomi Answers for up-to-date SyncApps advice and integration tips.

Getting Started