Graphql MetaObect Details from Shopify

Metaobjects entries details can be fetched from Shopify with the following graphQL query: query getMetaobjectByName($afterCursor: String) { metaobjects(type: “${metaObjectType}”, first: 200, after: $afterCursor) { edges { node { id handle type fields { key value } } } pageInfo { hasNextPage endCursor } } }

Boomi SFTP GET Operation: Get and Delete

The SFTP GET operation in Boomi is used to retrieve files from a remote SFTP server. One of the most commonly used actions is “Get and Delete”, which not only downloads the file but also removes it from the remote directory after successful retrieval. This is useful for workflows where files should not remain on… Continue reading Boomi SFTP GET Operation: Get and Delete

Applying Logic to a Button (Make Copy) in NetSuite

Overview In NetSuite, the “Make Copy” button allows users to duplicate existing transaction records—such as Sales Orders, Invoices, or Purchase Orders—while retaining most of the original data. However, there may be cases where you need to apply custom logic during this duplication process (for example, clearing certain fields, recalculating amounts, or setting new default values).… Continue reading Applying Logic to a Button (Make Copy) in NetSuite

Fulfillment Request Statuses

Fulfillment requests can have one of the following statuses: Updating Fulfillment Request Status in NetSuite via SuiteScript To update the status of a Fulfillment Request, use the transtatus field record.setValue({  fieldId: ‘transtatus’,  value: ‘B’ // ‘B’ typically represents “Pending Fulfillment” });

How to Export Formatted Excel Reports Using ExcelJS in JavaScript

This example demonstrates how to generate a styled Excel report using ExcelJS in JavaScript. It includes custom headers, conditional formatting, column alignment, and dynamic column width adjustment. import ExcelJS from ‘exceljs’; import { saveAs } from ‘file-saver’; const downloadReport = async (reportData, options = {}) => {  try {   const {    centerAlignedCols = [‘Quantity’],    rightAlignedCols… Continue reading How to Export Formatted Excel Reports Using ExcelJS in JavaScript

BitBar – cloud-based testing platform

BitBar, is a cloud-based testing platform designed for both mobile and web applications. It enables teams to perform manual (live) and automated testing on real devices and browsers, eliminating the need for maintaining physical infrastructure. Key Features Real Device & Browser Testing Mobile Testing: Access thousands of real iOS and Android devices for manual and… Continue reading BitBar – cloud-based testing platform

Basic Joins in Sequelize

Sequelize makes it easy to work with related database tables. Often, a table is connected to another, and fetching related data requires a join. This article explains how to perform basic joins in Sequelize using simple associations. 1. Setting up models Consider two tables: User and Invoice. A user can have many invoices, and each… Continue reading Basic Joins in Sequelize

Inventory Inactivity & Obsolescence report

Requirement: We need a reliable way to measure how long items have been sitting without movement at each location. The default aging report in NetSuite has helped us get part of this visibility, but it does not pull last movement dates or values accurately enough. We’re requesting an Inventory Inactivity & Obsolescence report that shows,… Continue reading Inventory Inactivity & Obsolescence report