Shipping Integration

In a world where efficiency is a key factor for the success and profitability of a business Keystone Data developed the perfect product to save time and effort. With just one click you will be able to send all the delivery details to your selected carrier and at the same time get back the tracking number assigned to that delivery.

Untitled-2At the point of shipping the order in NetSuite a script will send the shipment details to the carrier. Once the details are in, the carrier will send back the tracking number which will then be displayed on the dispatch e-mail and on the item fulfilment. Also carrier shipping labels will be automatically printed. Say goodbye to manually inputting the delivery details for each order.


  1. The product will speed up the shipment process and make it more efficient.
  2. The client has access to his tracking number withing seconds from the shipment of his order.
  3. Automatic printing of shipping labels for the desired carrier.
  4. Frees up human resources.


We encourage you to contact us and get a taste of this product which will change the way you ship items and it will give your business more freedom.

Have a great day!


kit components

Kit Components Tree

Hello Everyone!

We’ve just developed a new way of looking at your KIT components in a more user friendly manner.

As you can see in the picture below KIT5 is made of KIT1 which is made of inventory items INVN-1 and INVN-2. In a simple scenario where a KIT is made only of inventory items you could easily find and access them from the item tab. In a complex case where your KIT is made of multiple KITS which in turn are made of multiple items you would have to dig different levels and open many tabs to be able to access the information and then use the information to create a complete list of the components.

Luckily, we at KeyStone Data developed a custom high level visual map which is available at the KIT level and lets you navigate through all the components of your KIT. The way we do this is through an IFRAME which access a SUITELET. The SUITELET finds out the children of your particular KIT and returns it in a HTML format.


If you are interested about this bundle please give us a shout.


Hope this helps, Have a nice day!

KeyStone Data





NetSuite – Aftership Integration

NetSuite as standard is integrated with UPS and FedEx. Also as a NetSuite partner we regularly integrate with other carries such TNT, The Post Office and Parcel Force for our clients.

These integrations allow us to automatically generate carrier labels when goods are scanned out of warehouse and pull tracking no. back into NetSuite. However in order to provide an excellent level of customer service we need to be able to update our customer at any moment in time on where exactly is their order. For example we ship one pencil and we get a tracking no. which we then use to interrogate our carrier website to get the details that we need.

One way of doing this is to create a script in NetSuite for each carrier, or you could use AfterShip www.aftership.com app which will do this for you, thus you will only need to create one NetSuite script which links NetSuite to AfterShip. The result is that you reduce the number of scripts that you have to create/to run in order to have access to all your tracking no. independent of the carrier.



If you need more clarification don’t hesitate to contact us, thank you everyone and have a nice day!



Netsuite Available Kit Quantity

Hello people of NETSUITE land!

Today’s issue that we at Keystone Data tackled was to have the available kit quantity easily accessible for internal (client access-backend) and external(available on website-fronend) purposes. For example we need to calculate the available KIT A quantity which consists of 1 inventory ITEM GREEN,  1 YELLOW and 1 ORANGE each with their respective quantities.


In the above example the quantity for KIT A should be 2 because we only have 2 YELLOW items, thus we can only create 2 KITs. Another important step is to make that quantity easily accessible.

Our first solution is just a simple three steps process.

1.Create a customised item field (ex: Available KIT quantity) which will be available to all the KITs created by our customer.



2.Write a scheduled script which will calculate the available KIT quantity based on its components quantities.

3.Make the script post into the customised field created at step 1.

This way the user can see the available quantity at all times at the kit level and also can use the field as a transaction column.


The Second solution is just to create a saved search which returns the available quantity for each kit item.


Depending on your preference and client needs you can opt for one or the other.

If you need more clarification don’t hesitate to contact us, thank you everyone and have a nice day!

Keystone Data out!

whitestores tile

White Stores signs with Keystone Data and NetSuite

We are delighted to have signed White Stores, the UK’s largest on-line garden furniture store based in Leigh-on-Sea in Essex as another NetSuite implementation project.

This project includes introducing new processes throughout the organisation, and re-implementing their web sites to be fully integrated with NetSuite.

The project has already begun and we hope to be live in another three to four months .

We are very excited to be running such a project and expanding our knowledge of using NetSuite in the Retail sector.

Easy Comps - Web Present

Building a NetSuite Ecommerce Website with Keystone Data

Keystone Data produce high-performance, Ecommerce websites that integrate with a NetSuite system to provide an Ecommerce Platform without compromise. As an extension of Site Builder, Keystone Data can provide a complete, omnichannel experience that promotes directly accounting for online systems in one unified system. We believe Ecommerce should be seamless, and it’s time to support your customer’s interaction with NetSuite’s Order Management, Sales, Accounting and CRM capabilities.

Our design process and development experience allow us to offer clients advanced and bespoke website front-ends that are designed to be fit for purpose from the get go.

While our process is forever evolving, we utilise the following proven formula for supplying beautiful, high-performance websites:

Step 1 – The Creative Brief

The Creative Brief could be defined by either our experienced designer at Keystone Data, or supplied by our client with the consultation of their own designer. This stage is about getting to know your company, its personality and how you’d like to convey that through the website. Added to that, we like to explore elements of other websites that you may wish to incorporate or any must have features.

The Creative Brief may include:

  • The logos and branding concepts for the project.
  • Examples of websites to specify features for the website.
  • Examples of design elements or websites with a look or feel the client wishes to incorporate into the website.
  • Notes relating to the target market/demographic for the website

Step 2 – Website Design and Specification

At Keystone Data we like to make sure we are making the best possible website for our client, and a big part of that is working cohesively with the client to produce extensive designs and detailed specifications. We believe that in drawing up great plans, the customer can start to visualise what can be achieved and explore the functionality to aim for proactively, rather than in hindsight.


The Website Design stage utilises the design parameters established in the Creative Brief to create a rich mock-up of each key page within the website.

The outcome of this phase is the creation of a Photoshop Design for each key page within the website. Images are often the easiest way to convey ideas and the client can evaluate at an early stage the websites potential appearance.

The Designs will form a key part of the documentation, which can be referred to as a specification of website features, as well as the look and feel.

During this stage Keystone Data present ideas to the client, collaborate on any potential changes and ensure the designs are signed off ready for development.


At Keystone Data, we ensure the Specification is thorough and accessible for the client to make sure the build is developed to exacting standards. In the specification stage we annotate the website designs to explore how the website will function.

The specification will be provided as a rich document detailing how the underlying NetSuite products, categories and website content will be displayed on the website and edited in NetSuite.

Step 3 – Website Development

The Website Development stage involves Keystone Data using modern technologies to build the website itself. Using our own bespoke Ecommerce platform, we are able to ensure that the website is built with NetSuite in mind; offering a platform that far exceeds the possibilities available when integrating with an external Ecommerce system.

Step 4 – Initial Website testing

During this phase Keystone Data will set up example products within NetSuite’s Inventory and website content, so as the website closely matches the initial designs. This allows us to mimic the functionality defined in the specification and test the processes in preparation for our clients to begin managing the backend.

At this stage we like to present the functionality of the website to our client and ensure the build is surpassing expectations.

Step 5 – Website Refinement and Population of Data

Within the Website Refinement stage, the client will begin to populate the website with their own data and complete the website testing under tutelage from Keystone Data. We have produced extensive guides and documentation that adds to NetSuite’s own support to ensure the system is accessible and manageable.

With an open line of communication, our clients can feedback to us on any issues or discuss any future developments.

Step 6 – Website Go Live Pre-Testing

Going live with a web store can be a daunting undertaking. At Keystone Data, we test the build at every stage to promote reliability but prepare the client for Go Live with a Test Plan prepared for all eventualities.

Testing isn’t just limited to the frontend however, with the full order system tested in NetSuite too.

Keystone Data work to provide the best possible solutions for all our clients, and so while this process gives an insight into what you could expect when building a website with us, our exhaustive approach to NetSuite means that may just be the start.

The process above focuses on the front-end implementation of an Ecommerce website with an existing NetSuite system, however at Keystone Data we specialise in NetSuite implementations that coincide with delivery of an Ecommerce platform too. For more information, please don’t hesitate in contacting Keystone Data today.


Complexity of Ecommerce in relation to Magento, Shopify & NetSuite SuiteCommerce

NetSuite Ecommerce – Magento, Shopify or SuiteCommerce – Choosing the best option.

In this post I provide an overview of some of factors users of NetSuite should consider when choosing an Ecommerce Platform.


Whilst at Keystone Data and in a previous company I have built a great many NetSuite integrated websites.  As a general rule, for simpler sites, integration with Best of Breed is a good idea, however as sites get more complex the cost of integration can outweigh some of the benefits the best of breed platforms offer.


Before discussing which platform you should choose, I have clarified a few often misunderstood terms relating to SuiteCommerce, SiteBuilder and SuiteCommerce Advanced (often referred to as SCA)


What is NetSuite SuiteCommerce?  

NetSuite SuiteCommerce is NetSuites native ecommerce platform.  One way to think of this is a way of opening up your internal ERP system and allowing customer to interact directly with it.

Doing this has significant advantages over integrating with an external platform as your customers can be provided with live data directly from your internal system and are effectively accessing the same system as your internal staff via a customer facing website.

SuiteCommerce offers two distinct products, SuiteCommerce SiteBuilder and SuiteCommerce Advanced.


What is SiteBuilder?

SiteBuilder is NetSuites legacy ecommerce platform offering a well road tested but rather simplistic ecommerce front end with limited customisation ability.

What is SuiteCommerce Advanced?

SuiteCommerce Advanced is a more flexible, higher end product offering full flexibility and higher performance.


Best of Breed vs SuiteCommerce

NetSuite SuiteCommerce platform offers an extensive set of capabilities for building Ecommerce Websites.  However, building out Ecommerce functionality directly on NetSuite using SuiteCommerce can be more expensive that building using a best in class platform such as Magento or Shopify.

You might therefore conclude that best in class is the way to go, however if you have experience integrating ecommerce sites with ERP or you have read our article “How to Integrate Ecommerce Sites with NetSuite” you might have noted that although it can be cheaper to build on a best in class platform, the integration costs can outway the savings made by doing this.

Although this is true, for very simple ecommerce websites integration can be fairly straightforward and therefore best of breed is more suitable than SuiteCommerce.

A list of features which make ecommerce sites more complex and more difficult to integrate with an ERP system include:

  1. Complex or quantity driven pricing –  the methods used to configure these pricing structures will often differ between the ERP system and Ecommerce Platform.  Therefore integrating this can be very tricky.
  2. Offers, promotions and coupon codes – In addition to differing methods of configuring these elements, these can be represented differently on orders / invoices.  This can introduce considerable challenges when integrating
  3. Multi Language, multi currency, and multiple geographical zones targeted – These elements can introduce a whole range of issues when integrating, from issues with currency exchange rates, issues with lack of centralisation of multilingual product data.
  4. Complex delivery options – these very quickly become next to impossible to integrate due to differences in the way these are set up.
  5. Customer based pricing – this area will almost certainly differ between Ecommerce System and NetSuite, if the business has a large number of customers this area can prove very time consuming and challenging to integrate.
  6. Integrated support systems
  7. Fully integrated returns processes
  8. Live orders required for customer orders not placed online – this would require a 2 way integration.
  9. Online statement downloads – As Accounts Receivable procedures are not operated in the Ecommmce platform this must be provided by the ERP System.

However, in addition to the features I outline in this document, other factors will play into the decision on platform such as:

  • Budget – If a business generates a large volume of business online and has a considerable budget, an additional spend required to implement SuiteCommerce Advanced will not be significant when compared to the advantages to be gained from a fully integrated ecommerce front end.
  • Technical Skills of In house staff – The customer might have an existing Ecommerce site or technical skills developing an another ecommerce technology.


Ecommerce Support

4 ways to get the most from NetSuite’s Customer Service & Support System for Retailers

1. Quick Add Solutions

When responding to customer queries we often find we reuse the same snippets and templates over and over again. To make the process more efficient, you should use Topics & Solutions to organise your predefined copy for use in customer cases.

NetSuite’s Knowledge Base can be used to feed FAQs onto your website or to advise employees; but in this instance, we suggest that you use them to standardise your case handling and email responses.

Topics act as a Category for the different Solutions which help when finding and adding Solutions to email responses.

To add a Solution, begin by going to Lists > Support > Solutions > New.

Setting a descriptive Title is really important here, so users can find the solution easily when adding it as a snippet to a Case response. In this example we will be adding a “Customer Returns Information Snippet (Standard)” Solution that could be used to drop the standard process information into an email to respond to a customer return request.

The “Status” must be set to Approved to allow use of the Solution on Cases and can be used for employees to create drafts before management approval. Checking “Display Online” will make the Solution available for Website Content.

The “Abstract” acts as a brief description, and will be displayed on the Solutions list to help identify each distinctive Solution. The “Description” section is where you can define the Snippet you’d like to appear in the case email. This area is HTML editable to help maintain your Email Templating, but can also just be added via the Rich Text Editor. CRMDSK Tags are also available in Solutions which are able to incorporate live NetSuite information in the copy.

As mentioned earlier, Topics help to categorise the Solution and can be used as a filter searching for Solutions to add to case responses. Other Solutions can be added to “Related Records” too to allow links through to similar responses.

Once saved the Solution can be used in the “Outgoing from Support Rep” section of NetSuite cases. This means that by clicking on the Solution it will automatically be added to the body of the email, saving time and ensuring consistent communication standards from all employees.

It is possible to add multiple solutions to a single message and therefore construct formulaic and consistent replies to different variations of queries.

2. Using Rules and Criteria

As a basic customer support system, NetSuite will supply all queries in one place with a Round Robin approach to sharing them out between support reps. However, if certain Case or Customer fields would be great filters for focusing who receives which queries they should be incorporated as Rules. For example, using Case Types (as discussed later) to better define what the customer is asking and associate it with the equivalent department is a lot more efficient than bouncing it between support reps until it finds the right knowledge base.

Rules can be added by going to Setup > Support > Case Rules and they work similarly to a Saved Search. For example, if you wished to associate merchant customers with a senior support group, a Case Field Rule could be added that declares if Merchant Account checkbox is TRUE on the customer record, then apply that case to the Case Territory with a senior support group added as members.


3. Efficient Case Capture Forms

Ecommerce Retailers can make use of a link between Website Capture Form and NetSuite to drag queries straight from the customer into the system. Unfortunately lots of retailers tend to stick to the default form that doesn’t make the customers do a bit more of the leg work for them.

Directing cases to the right people not only helps the customer get the right answer but saves the business huge amounts of time. With groups or territories set up, it makes sense to make your customer select a case type that adds their case to the relevant territory.

A good Case Capture Form can help tailor a customer’s query to your system and guide it towards more formulaic responses to help save time. NetSuite can allow the user to attach Files, which is a great way to encourage customers to add screenshots, while it is also easy to add an auto-reply to confirm to the customer the issue has being received.

Multiple forms could be added to help your website to categorise different queries and direct them directly to the equivalent group, or a rule set up to send all with a Case Type of “Returns Query” directly to the Returns Department.


4. Defining Unique Case Types

Case Types are used to help process and understand the type of customer query the business has received. However, the NetSuite default types are fairly basic; comprising of: “Question”, “Concern” or “Problem”. Tailoring the types to better suit your business is an efficient way to help focus your Customer Support.

Evaluating the current types of queries you tend to receive, and defining them within categories could help you better direct incoming cases. For example, the three types could be split into “Sales”, “Product”, “Website”, “Order Management” and “Return’s” “Questions”, “Concerns” and “Problems”.

Using unique Types can help break down the lists of Cases, and associate them to the relevant Support Groups; but then also can be used for Online Forms to encourage the customer to direct queries better too. A list like the following could make identifying cases much easier.


For more information on implementing Customer Service & Support features for your NetSuite account, contact Keystone Data today.



dd heading

The internet in the consumer’s pocket : What retailers can do about Smartphones, Tablets and becoming Omnichannel

Consumers are swimming in more channels than ever when taking the purchase journey. Businesses have accepted they need to consider more than ever just how connected to the world of pricing and product information their customers are. With 31% of consumers visiting in-store before buying online and  34% doing research online then coming in-store, there is a worry retail outlets could be on their way to just being Amazon’s showroom (The Omnichannel Opportunity, Deloitte/ebay, 2014).

The answer, it is implied, is Omnichannel. Consumer expectations are sky-high and so a need for a seamless system has arisen, where the brand connects its bricks and mortar to ecommerce, mobile apps and social media seamlessly.

And so the focus of this blog materialises, when mobile devices now mean consumers can be connected to the web and wandering through your store at the same time, what should you do about it?


Internet-in-their-pocket shoppers and Google

The first worry with Android shoppers is their ability to quickly Google your product straight from the barcode. Why is this a worry? Well first of all you’re not price-competitive, second of all you’re not on the first page of search results and finally you haven’t given any reason for brand loyalty.

Luckily that wasn’t actually your scenario and we can think on this first. The first and biggest concern posed by the internet is the threat of substitute. Are you selling someone else’s product or brand that is subject to price wars, or is your product fairly generic and alternatives can be easily found? If yes and yes it is time to deliver a compelling argument to your customer. A great brand is a reassurance and great service a way to be distinctive, but the modern millennial is a thriftier adversary than ever before.

One solution is for the retailer to develop their own range and brand so they can dictate how much their product is worth through marketing and customer experience, rather than eBay’s average auction price. That level of brand control is what you see all across the high street, but what about using a bit of the consumer’s tech against them. Could it be possible to use consumer’s searching devices to even the playing field?


Wi-fi-ght at all

Some retailers have started offering wi-fi in-store and it isn’t just for bored husbands at the changing rooms. Sure it may trap people in Debenhams a while longer, and offer a way to collect some extra people for the mailing list; but what happens if the consumer jumps from product reviews to competitor checkout? (Want to make use of your competitor’s wi-fi? Keystone Data offer a fully-unified NetSuite ecommerce solution and responsive website development that will look and function beautifully on the shopper’s mobile)

This is where the omnichannel approach starts to take shape. If the customer has the opportunity to go online, give them a reason to stay loyal to you on the web. Invest in the SEO for your likely product searches to reassure the customer of your brand’s legitimacy, offer incentive codes at point-of-sale in-store to force them through the checkout online or give cues in-store to further rich content available online or on your Social Media (video tutorials for example).


Connecting your customer service

Anything your customers can do, your staff might just be able to do better. The advancements in tablets and unified cloud solutions, like NetSuite, means retail staff can now be given the whole supply chain at their fingertips. Having the opportunity to give Mr & Mrs Smith a live, accurate and instant promise when it comes to stock, is a reassurance that will remind them of the usability they enjoy from Amazon. Being able to transition this quote into an order in no time, even better. Being able to set them up with an account for your web-store at the same time and you’re ready to enjoy omnichannelling.

Once Mr & Mrs Smith have their access online it is easy for retailers to forget that they were happy to come in-store once upon a time. Click and Collect is often seen as the reserve for larger companies, but it’s often just a case of being the person willing to stay in all day for the delivery. If your opening hours are more likely to be accessible to the young professional than Royal Mail’s vague midday drop-off, that could be a unique selling point that makes you money in your area. Offer out a discount for Click & Collect through your mailing list and social media, and then you could be punching above your weight in the omnichannel arena.