Case Study

Auto Complete Address in BigCommerce Website Using Google API

Frame 2085664679.jpg
Think of a situation where you need to purchase a product or obtain help from a specific provider through a website. Entering your address manually can be error-prone and time-consuming, as there is a risk of misspellings. Want the initial input to automatically populate the address field?
About Project
Smart Address Autofill: BigCommerce Integration Using Google API
Integrated Google API into the BigCommerce website to auto-fill customer addresses, ensuring faster checkout, error-free delivery details, and an improved overall e-commerce experience.
Industries

Wholesale Distribution

Location

New Zealand

Service

eCommerce

Client Portfolio

A New Zealand-based pipeline supply and support provider approached us with an automation request. Their clients have to manually input addresses when purchasing a product or seeking support. As they deliver essential household products and support, accurately finding their clients' locations is important for them.

Problem Statement

Our client faced a significant issue in accurately collecting and managing customer addresses on their BigCommerce website. Manual entry resulted in errors in address data, causing logistical complications and disrupting the smooth flow of transportation. The New Zealand company was looking to automate the customer addresses filling to ensure precision. They also wanted to expedite the order fulfillment process.

90%
Reduction in manual data entry efforts
95%
Elimination of address tracking issues

What We Suggested

In response to the client’s needs, we recommended integrating their BigCommerce website with the Google API. This integration ensures automatic filling of address fields when customers start entering the first few characters of their location. Initially, users need to provide the country name before selecting the address field.

The system displays a list of corresponding addresses, giving users accurate options for selection. This user-friendly solution works effectively across various countries. It ensures accurate presentation of addresses.


Key Features of the Suggested Solution:  

  • Google API Integration: By integrating with Google API, we enable real-time address suggestions based on user input.  
  • Global Compatibility: Our solution caters to customers worldwide, accommodating addresses from various countries and regions.  
  • Location Selection: Customers also have the option to select the delivery location. This way, they can collect the product from a nearby location without any delivery payment.
NetSuite Integration:
  • Established a custom integration using the Bank Connectivity Plugin and Financial Institution Parser Plugin to sync ICICI Bank data automatically into NetSuite.  
  • Transactions are now fetched from the bank’s database and displayed directly on NetSuite’s match bank data page, simplifying the reconciliation process.  
Intermediate Server Setup:
  • As NetSuite does not provide static IPs, which is a critical ICICI Bank security requirement, we implemented an intermediate server to solve the issue. This server securely fetches and stores bank data from ICICI bank before sending it to the ERP software for reconciliation.  
Automated Sync:
  • Bank transaction data from the client’s 4 ICICI accounts are automatically fetched daily between 4 AM and 6 AM, eliminating the need for manual uploads.
Manual Import Flexibility:
  • If needed, the client can still manually import bank data to the cloud ERP.
Seamless Reconciliation:
  • Each ICICI account is mapped to its respective Chart of Accounts, allowing users to view and reconcile bank data easily within NetSuite.  
  • Created reconciliation rules so that the finance team only needed to verify and match bank statements with the transaction records on NetSuite. 
Bank Reconciliation Summary Portlet:
  • Displayed the ICICI account statement in a Bank Reconciliation Summary Portlet, offering a quick and comprehensive view of account statements directly within NetSuite.

Customer Success

With this implementation, customers now experience a smoother address entry process, minimizing errors and enhancing overall satisfaction. Additionally, a new feature allows customers to select their preferred product pickup location without any upfront payment. This addresses the diverse needs of customers who prefer to collect orders from nearby centers.

Key Achievements:

  • Reduced manual typing of entire address information  
  • Eliminated address tracking issues

Way Forward

The integration of the BigCommerce website with Google API has enabled the auto-population of addresses, removing tracking errors and ensuring accurate location information. This allows them to reach their customers’ locations and deliver products and support at the right time.  

Are you looking to customize your business processes? Want to enhance your clients’ experience when they visit your website? Our expert team is ready to assist you and will suggest the best methods to optimize your operations. Feel free to reach out to discuss your specific needs.

Expert NetSuite Implementation with Jobin & Jismi
Optimize your business with our expert NetSuite solutions seamless integration, efficient workflows, and maximum potential.
Our Case Studies

Related case studies

Group 1597880888 2.png

Automate Financial Workflows with NetSuite-ICICI Bank Integration

65%Reduction in manual reconciliation
50%Faster financial data processing
image 8105 (1).png

Dynamic Graphical Reports for Customer Sales in NetSuite

80%Reduction in manual effort
100%Accuracy in sales data history
Group 1597880892 1 (1).png

All About Migration from QuickBooks & ZohoBooks to NetSuite ERP

85%Decrease in manual workload
70%Increase in business performance