“The advance of technology is based on making it fit in so that you don’t really even notice it, so it’s part of everyday life.”

– Bill Gates

Explore Our Latest Work

Showcasing 5 Projects

NetSuite Implementation

NetSuite full implementation included a 3 subsidiary company migrating from Quickbooks Desktop to NetSuite.

The implementation took over 6 months and resulted in an increase accounting and manufacturing productivity while ensuring inventory levels are accurate after training and using NetSuite best practices

Project Highlights:

  • 3 years of historical data migrated
  • Training of over 50 employees in various departments
  • Customizing approval workflows using SuiteFlow  

3PL Integration

Connecting NetSuite with a 3PL in Berkeley, California required a custom integration using an SFTP server as the middle server to host CSV and XML files for both shipments and item receipts.

Used a custom record within NetSuite for logging and ensuring the customer can inspect every time the service runs in the background to fetch or send data to the SFTP

Project Highlights:

  • Built custom script to send CSV representations of items receipts
  • Built a custom script to send XML representations of item fulfillments.
  • Build a custom record representing each run of the script for non-technical users to debug

Custom Warehouse Inventory Portal

A manufacturing company required custom-built inventory tracking software for inventory count, RMA’s, inventory documentation, and demand planning.

We built a custom web-based solution using React and NodeJS server hosted on Google Cloud Platform (GCP). The platform is responsive (mobile friendly) and persists data on a MySQL database hosted on GCP.

Project Highlights:

  • React / Node Typescript Codebase
  • Fully customizable with more data fields (columns) from the front-end
  • An associated app was built to capture images of products from the phone and scan barcodes
  • Hosted on GCP for access anywhere, anytime

Shopify - NetSuite Integration

A customer had a Shopify store that they wanted to connect to NetSuite to sync new orders, fulfillment, and inventory.

We built a custom integration using SuiteScript and Shopify ‘s API endpoints.

To ensure idempotency and consistency, we used a custom record to track every run (polling) between NetSuite and Shopify and log any errors, while notifying the administrators via email of any issues. 

Project Highlights: 

  • SuiteScripts scheduled scripts to sync data between NetSuite and Shopify.
  • Custom Record displaying errors, logs, and information on every pull and push.
  •  Synced over 10,000+ orders successfully with our integration

 

EDI - NetSuite Integration (Celigo)

EDI (Electronic Data Interchange) is a specific format for sending data between organizations. Our client needed to use EDI to connect their NetSuite instance with a 3PL.

As Celigo partners, we chose to go with Celigo as our integration tool to give the client better visibility on the status of their integration and easily debug future issues

In this project, we have successfully implemented the following document sync:

  • EDI 850 – Purchase Order
  • EDI 855 – Purchase Order Acknowledgment
  • EDI 810 – Invoice
  • EDI 846 – Inventory Inquiry/Advice

The integration was transferred through an SFTP server.

Project Highlights:

  • NetSuite – EDI successful integration through an SFTP server
  • Purchase Orders, Item Receipts, and Inventory Adjustments are continuously synced between NetSuite and the 3PL
  • User has complete visibility on status of each Pull and Push data run on Celigo