7 Steps to replace NetSuite search with Searchspring
Written by: Guest Author
The beginning of the integration process is always the most challenging part of any new project. Getting past the unknowns is the scary part. Hopefully, this article will put you at ease with the NetSuite – Searchspring integration. Searchspring provides some really handy guides that pull together the essential data that they need. Check out this product feed guide to help with the initial steps you need to take inside of NetSuite. This article will translate that guide into NetSuite terms for you.
It can be challenging pulling data feeds together, but trust me…Searchspring is worth it and totally changes the user experience for your customers.
Step 1: Decide on the data you want
The first task is to decide which product details you want to be included for search. Luckily, you can add more without too much difficulty if you decide to later on in the integration. Of course, everyone likes having it all defined sooner rather than later.
Here are the main things you will need that are required:
- Unique ID
- Product URL (Needs some NetSuite magic to create)
- Thumbnail Image URL (Needs some NetSuite magic to create)
There are a few pieces of data that Searchspring suggests you will also probably want to include:
- Category Assignments similar to a breadcrumb
- Searchable Fields
- Price Rules
- Inventory Levels
- Date Created
- Product Rating (You can even get Yotpo rating here)
- Total Sold
- Exclude Rules
- Additional Thumbnails
- Variant Swatches
My suggestion for the non-required data is to at least pull in these things:
- Commerce Category
- Breadcrumb Path
- Badges (Things like Best Sellers or New Arrivals)
Step 2: NetSuite Saved Search
Pull together the product feed using a Saved Search in NetSuite. If you haven’t built any saved searches before, then take a look at this Free NetSuite Beginner Course that shows you how. Or, you can skip this step and contact Anchor Group NetSuite Consultants for a quick turnaround of this feed (under 3 days).
The goal of the saved search is to export a CSV file for Searchspring to use during their implementation.
A lot of the required fields are native fields in NetSuite that are easily accessible. You should be able to easily capture the Unique ID, SKU, Name, and Price without too much difficulty. The Product URL and Thumbnail Image URL can be a little tricky but I’ll try to guide you through it.
To get the Product URL, you will need to use a formula(text) option in the saved search which allows you to use some logic for the output.
This is what that result in the saved search might have in the formula column:
The output would look like this…
Lastly, the most challenging part of the required fields to capture in a saved search in NetSuite is probably the Thumbnail URL. This may require some basic scripting abilities to pull the information together. But you could also use a formula(text) option too. I ended up using a script because it was the easiest way for me to grab the CSV output in a hyperlink.
First, I created a new item field with the type set to ‘Hyperlink’.
Then I wrote a small script that populated that field for every item in the system (in my case it was over 8,000).
This is the logic of the script:
- Find the first associated image
- Grab the name which is a relative URL image like this: /product-image-thumbnail.jpg
- Find where your image is located in the file cabinet. In my case, they are located in Web Hosting Files > Live Hosting Files > Item Images. NetSuite just takes the /item-images part though so that’s the part you need
- Then concatenate all this information together to get you an output like this: https://anchorgroup.tech/item-images/associate-image-url
Once I had this image URL in a field on the item record, I had all the information I needed to complete the required fields Searchspring needs to get their team moving. Since this field is now on the item record, you just need to pull it into the saved search.
Step 3: Pull the pieces together
To get to this point may have been challenging, but you are near the finish line. Now you need to get your saved search working. Here are the criteria and results that I ended up using:
You’ll notice that I decided that it was only necessary to pull the products that actually appear on the webstore. That is why I wanted this criteria for the item search.
Since I wanted a few extra things to display, you can see that there are more results than simply the required fields. I decided that it would be best to add the breadcrumb category information to help make the search more powerful.
Step 4: CSV format
If you aren’t new to NetSuite, you probably know that you can easily export to excel with almost everything. It’s no different with a saved search. Confirm that all the data is coming in the way you want and then export the entire saved search results to excel.
Now that it is in an excel, it is super easy to convert to a CSV file, simply click “Save As” and change the file type to this:
Step 5: Upload to file cabinet
We are getting to the finish line here. You have the product feed in a CSV, now you need to get it uploaded to the file cabinet so that Searchspring can access the data. Upload it to the file cabinet and make sure to check the box that says “Available without Login” so that Searchspring can access the information.
Step 6: Give Searchspring product feed access
Now all you have to do is give Searchspring the URL they will be using which can be found in the file that you just uploaded. Email this URL to your Searchspring integration contact and that wraps up your responsibilities.
Step 7: Sit back and let Searchspring take over
Searchspring will have some questions about the look of how you would like your search to appear, but you will be fairly hands-off from this point on.
So all you are required to do is to sit back and let the integration team do what they do best…optimize your webstore search.
Once the integration is complete, it’s usually a good idea to automate the product feed so that as you update your items, it will also update the search appropriately. This can get a little more technical and is a good spot for your NetSuite integration partner to jump in to support.
NetSuite Consultant at Anchor Group
Caleb is a NetSuite developer and SuiteCommerce specialist at Anchor Group NetSuite Consultants. He works side-by-side with his brother, Ben, building out complex customizations to NetSuite clients across the United States. Caleb received his B.S. in Mechanical Engineering from Benedictine College and completed his MBA from Indiana Tech. During his free time, he enjoys mountain biking, writing books, and playing rugby. He finds that one of his bigger accomplishes was hiking 500 miles across Spain on the Camino de Santiago.
Want to keep tabs on us?
Sign up for our newsletter and get notified every month with what we've been up to.
Our Industry Guides
The Ultimate Ecommerce Site Search Guide
Here's EVERYTHING we know about site search for ecommerce stores.
How The Experts Are Merchandising
These are the best practices for merchandising you need to know.
What You Should Know Before Choosing A 3rd Party Provider
Don't waste time comparing features, we think there’s a more valuable approach you can take...