Real People, 24/7

Mailchimp eCommerce integration with NetSuite

Are you trying to integrate all NetSuite Sales Orders, Products, and Customers from NetSuite to Mailchimp to analyze eCommerce metrics? 

SyncApps integrates with NetSuite’s SuiteCommerce Advanced eCommerce platform and NetSuite's ERP side so you're in luck.

Marketing automation from Mailchimp is a powerful tool for eCommerce businesses. 

"Whether you’re a brick and mortar looking to supplement your business online, an online-only retailer, a daily deals site, or a retail giant, Mailchimp has everything you need to connect with your audience, advertise your products, sell more stuff, and grow your business."

The eCommerce feature for NetSuite is a way to allow your marketing team to create Mailchimp segmentation for future marketing or remarketing using purchasing data from NetSuite to Mailchimp.

How To Get Started!

 

Be sure that your NetSuite Role, the one that is used in the integration, has the correct set of Permissions so that the eCommerce data will be syncing over to your Mailchimp Store.

To sync your NetSuite eCommerce data to segment based on purchases from NetSuite, please select this option in Step 2 of the Set Up, a term for your integration.

Sync eCommerce Data

image23__1_.gif

The first time the integration runs may take some time because it will sync all NetSuite Sales Orders, Products, and Customers from NetSuite to Mailchimp to analyze eCommerce metrics.

By default, SyncApps syncs all NetSuite Customers, including those that don't have a Sales Order, for the eCommerce functionality.

These NetSuite Customers are added as Non-subscribed in Mailchimp.

The reason for this is that the NetSuite Sales Order doesn't update the Customer's last modified date, used as an integration key, which could cause some Customers not to be synced.

This, in turn, could potentially cause an error when syncing a Sales Order to Mailchimp, as the Customer does not exist in Mailchimp.

Be sure to allow time for the first sync to process all your Customers and Orders for the Mailchimp eCommerce Feature.

If you're on the Free Trial or just testing it to see how it looks like, once you've enabled the "Sync eCommerce Data", please head over then to Step 6 and specify the integration Start Date of your preferred date:

mceclip0.png

On the example above, this means that SyncApps will only sync all your records including eCommerce Data that are created since " January 1, 2021" will just be the only ones that will be syncing over to Mailchimp. 

If you have a lot of these records then the best practice is to do this over a weekend to not interrupt other integrations running in NetSuite or actually turn these other integrations off to run only SyncApps for this process over the weekend.

If you already have an existing Set Up and want to update, once this option is selected, then please do not forget to Reset Sync Process and Resync.

Note: By setting the base date for the eCommerce feature the products that were last modified before the base date will not be included thus some errors will appear in logs. These can be ignored based on choosing a base date to sync orders and customers from NetSuite.

EXAMPLE ERROR:

29 Oct 2021 03:24:41 ERROR

Error sync order #166,  Id: 156774
{"type":"https://mailchimp.com/developer/marketing/docs/errors/","title":"Bad Request","status":400,"detail":"A product with the provided ID does not exist in the account for this list.","instance":""}

eCommerce Store Name

The Store name can be the SuiteCommerce Store Name in NetSuite where your eCommerce shoppers visit or any name you choose. 

eCommerce

Purchases from NetSuite will be displayed by date on the Mailchimp record as seen in the screenshot below.

mceclip3.png

For each transaction, Mailchimp includes the number of items purchased, the order total, average order value, and order number. Tap the order to view the details in your connected store. From these connected store value fields, you can run automation in Mailchimp to meet most any marketing automation requirements so give it a try today.

For metrics like "Total revenue" and "Average order value" we automatically place them inside the relevant placeholders that Mailchimp allows in their eCommerce 360 for each Mailchimp record.

Product images and their URL are synced to Content Studio> Products> (select a specific Product) View details.

mceclip1.png

For the Products images sync, these will be integrated from the NetSuite File Cabinet by default. These are the pre-mapped Products fields: 

NetSuite

Mailchimp

Item Internal ID

Product ID

Item ID

Product Title

Item Store Display Name

Product Description

Item Image URL

Product Image URL

Item Online Price

Product Variant Price


Product Custom field mapping is not supported due to NetSuite API not being available for it.

Need to also sync NetSuite Abandoned Carts to Mailchimp? Check this out!

Need some help?

image29__4_.gif

Check out the options below on how you can contact our Support Team and find the answers you need to help you with your SyncApps integrations.

Help Center & Email is 24/7 to support@cazoomi.com | Live Chat & Phone is scheduled.

FAQs

Check out these Help Desk articles for answers to frequently asked questions.

Get Started | Login Issues | Pricing

Check out our subscriber's story here on how SyncApps helped them save hundreds of hours per year!

Subscriber-Story-Sundance-CTA.jpeg

Have more questions? Submit a request

Comments