Skip to main content

7 Steps to Replace NetSuite Search with Searchspring

By Caleb Schmitz

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:

  1. Unique ID
  2. SKU
  3. Name
  4. Product URL (Needs some NetSuite magic to create)
  5. Price
  6. 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:

  1. Category Assignments similar to a breadcrumb
  2. Searchable Fields
  3. Price Rules
  4. Inventory Levels
  5. Date Created
  6. Badges
  7. Product Rating (You can even get Yotpo rating here)
  8. Total Sold
  9. Exclude Rules
  10.  Additional Thumbnails
  11.  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:

CONCAT(‘https://www.anchorgroup.tech/’,{urlcomponent})

The output would look like this… 

https://www.anchorgroup.tech/product-page-url

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’.

Website - Replace NetSuite Search

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: 

Website - Replace NetSuite Search

Figure 1: Criteria for saved search

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. 

Figure 2: Results (Columns) for saved 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. 

Ebook: Prepare for Black Friday

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.

Product feed results

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:

Save as csv

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.

File Cabinet

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.

Bonus step

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.