Home > FAQs > How to write a script for a server job to update stocks weekly in the warehouse system?

FAQs in this section

What is VTAP? What tools VTAP provides? What is Module Designer? What is API Designer? Where can I find documentation for VTAP? Which editions and version supports VTAP? What is the pricing of VTAP? What happens to customization done using Customizer in V7 version? How to get in touch with Platform team? What is the intent of Developer edition? What is Vtiger’s Add-on Publisher? Is Add-ons Publisher available in all the CRM editions? How do I publish Email Template add-ons? How do I publish any other module as an add-on? How do I update a published add-on? How do I test an add-on? What are the limitations of the Add-ons Publisher? Which different add-on features can I publish? What can a developer publish using Add-on Publisher? What are the conditions for updating a published add-on? What are the prerequisites for publishing an add-on? What is an Insights Designer? What is the use of Insigts Designer in Vtiger CRM? What are the queries in Insights Designer? What are the components of the Insight Designer? What are the components of a Widget in Insights Designer? What is the Input tab in Insights Designer? What is the Transfer tab in Insights Designer? What is the Output tab in Insights Designer? What are the benefits of using the Insights Designer? How do I access the Insights Designer in Vtiger CRM? How do I create an Insights page? How do I enable filters for a report? How do I pin an Insight to the Dashboard? Is Raw Query support available by default? In which editions of Vtiger CRM is the VTAP - App Creator available? Can I set access to my custom apps? What are Line Item Fields in Insights Designer? What are Server Scripts and Jobs in Vtiger CRM? What is a Server Script? What are Server jobs? How do I create a Server job? What are the different helper methods to write server scripts? What is the Debugging method to write Server scripts? What are HTTP methods to write server scripts? What is Vtiger REST API method to write server scripts? How to write code for Server Scripts and Jobs? How to write a script for a server job for importing daily leads from a file? How to write a server script to set case SLA by created day? How to write a server script to calculate the outstanding invoice amount? How to write a server script for contact email validation and data enrichment? how to write a server script to update the credit score of a contact?

How to write a script for a server job to update stocks weekly in the warehouse system?

Consider a company CompanyY, which sells construction materials. To manage their sales and billing they use CRM. To manage their warehouse they use a different warehouse management software.

Sometimes stocks available in the warehouse don't match with the data available in CRM. This happens because of human error but identifying that and correcting it takes a lot of time since they need to verify all the older data and find where the problem occurred.

To solve this problem, they want a weekly report of available stocks from CRM and warehouse software in a common tool where they can compare stocks for each product and find if there is any discrepancy. For any week if there is any discrepancy, they don’t need to verify historical data and verifying data for that week will be sufficient.

Their warehouse management system provides an API to update stocks available in other systems for comparison. From the CRM they need to send this data weekly to the warehouse system.

For that, you must create a weekly Server Job which runs every Sunday morning. It generates stock data of all available products and sends it to the warehouse system.

async function main() {
try {
//Get quantity in stock details for all active products using rest api query method
var response = await vtap.macro.ws.query("SELECT productname, product_no, qtyinstock FROM Products WHERE discontinued = 1 AND qtyinstock > 0;");
if(response && response.success && response.result) {
//Prepare stock data as required by warehouse management system
var stockData = [];
for(var index in response.result) {
var productData = response.result[index];
stockData.push({
id: productData.product_no,
name: productData.productname,
quantity: parseInt(productData.qtyinstock)
});
}

//Generating current date in YYYY-MM-DD format as required by warehouse system
var currentDateObj = new Date();
var currentDateVal = currentDateObj.getFullYear().toString() + '-' + (currentDateObj.getMonth() + 1).toString().padStart(2, '0') + '-' + currentDateObj.getDate().toString().padStart(2, '0');

//Send stock data to warehouse system using http post method
await vtap.macro.http.post(
'https://company.warehouse.com/api/externalstock', {
headers: {
Authorization: 'Basic XXXXXXXXXX'
},
body: {
source: 'CRM',
date: currentDateVal,
stocks: stockData
},
json: true
});
}
} catch(error) {

}
}

Was this FAQ helpful?

0 out of 0 found this helpful.

Comments 0

Be the first to comment

FAQs in this section

How to write a script for a server job to update stocks weekly in the warehouse system?

Table of Contents

Comments 0