How to integrate kintone with OpenLogi to create a warehousing request in OpenLogi when the status is updated in kintone

Have you ever outsourced the logistics operations of your e-commerce site, only to find that handling product information and data on product inventory and shipments is cumbersome?

In this article, we will introduce a method to automatically create an inbound request in OpenLogi when the status of information managed in kintone is updated. Manually transferring data every time you deposit products or enclosures can be time-consuming and labor-intensive. By automating this process, staff can focus on other tasks and reduce human errors. Maintaining data consistency between systems will allow for accurate and smooth inventory management.

Benefits of Integrating kintone and OpenLogi

Integrating kintone and OpenLogi offers the following benefits in inventory management.

Improved Operational Efficiency

Automating the creation of inbound requests eliminates the need for manual data entry. This helps prevent human errors such as data entry mistakes. Additionally, staff can focus on other important tasks such as ordering products and arranging transportation to warehouses. By reviewing and optimizing human resources, productivity can be enhanced.

Centralized Data Management

With automatic data integration between kintone and OpenLogi systems, the time lag until the completion of inbound request creation is reduced. Maintaining data consistency between both systems is expected to improve the accuracy of inventory management.

Using Yoom makes it easy to set up integration and automation. Why not aim for efficient inventory management by gaining these benefits through integration?

[What is Yoom]

How to Create an Integration Flow between kintone and OpenLogi

Now, let's set up the integration and automation of business flows between kintone and OpenLogi.

We will introduce the steps to create a business flow using a template: "Create an inbound request in OpenLogi when the status is updated in kintone".

Before You Start

1. Prepare a database app in kintone to manage inbound request information.
　※ The "status" in the template introduced here refers to the "status" in kintone's process management feature, not a field name.
　※ The diagram below is an example.

2. Log in to Yoom.

3. Click the "Try it" button below to copy the template in Yoom.

Step 1: Integration of kintone and OpenLogi My Apps

*If you have already completed the app integration, please proceed to Step 2.

1. Select "My Apps" from the left menu and click "+ New Connection" on the right side of the screen.

2. From the list of new connections in My Apps, select kintone and OpenLogi respectively, and integrate the apps.
　*Reference: How to Register kintone My Apps
　*For OpenLogi integration, an API token issued on OpenLogi is required. Please issue it from the URL described in the "Usage" section of this official article.

1. Hover over the banner and click "View Details"
2. Click "Try This Template" on the redirected page
3. Register for Yoom
※ If you have already registered, the login screen will be displayed, so please log in.

‍

Step 2: Setting the Trigger to Activate When the kintone Status is Updated

1. Open the copied template.
　※ You can change the title from the red-framed section in the image below.

2. Click on the Flowbot's "App Trigger: When Status is Updated (Webhook Activation)".

3. Set up "Select Integration Account and Action".
　Change the title if necessary and click "Next".

4. Set up the Webhook event reception settings for the app trigger.
　Refer to the instructions and precautions to set it to activate when the status is updated.
　※ Reference: Setting up Webhooks in kintone

　※ The image below shows the Webhook settings screen in kintone.

5. Click "Test".

6. If the test is successful, click "Save".

Step 3: Setting the Action to Retrieve kintone Record Information

1. Click on the Flowbot's "Operate Database: Retrieve Record".

2. Select the integration account and action.
　・Title: Can be changed if necessary.
　・Database Integration "App ID": Enter or select the ID of the app managing the warehouse request information.

3. Click "Next".

4. Set the detailed settings for database operations.
　Set the conditions for the records you want to retrieve using the output obtained in Step 2.
　※ The image below is an example of input.

　※ The image below is an example of output reference. When you click the input field, candidates will be displayed, so please select the target item.

5. Click "Test".

6. If the test is successful, click "Save".

Step 4: Setting the Action to Create an OpenLogi Warehouse Request

1. Click on the Flowbot's "Integrate with App: Create Warehouse Request".

2. Select the integration account and action.
　Change the title if necessary and click "Next".

3. Set up the API connection.
　Enter/select each item.
　※ You can use the output obtained in Step 3.
　※ The image below shows some of the input items, and the entered output is an example.

　※ The image below is an example of output reference.

4. Click "Test".

5. If the test is successful, click "Save".

This completes the flow of "Creating a Warehouse Request in OpenLogi When the Status is Updated in kintone".
Turn the trigger of the saved flow to "ON" to activate it.

Other Automation Examples Using kintone and OpenLogi

There are many other examples of automation using kintone and OpenLogi at Yoom, so here are a few introductions.

‍

1. This is a flow to create a shipping request in OpenLogi when the status is updated in kintone. By automating both the shipping and receiving requests, you can manage all the inventory movements of products stored in OpenLogi in conjunction with the kintone database. If shipping becomes smoother, it is expected that the products will reach customers faster.

2. This is a flow to synchronize with OpenLogi when new product information is registered in kintone. By automatically reflecting product information, you can reduce the effort and errors of manual entry. Even if the number of products increases due to business expansion or the arrival of seasonal items, the burden of registration work can be alleviated.

3. This is a flow to synchronize with OpenLogi when product information in kintone is updated. Data synchronization is possible not only at the time of new registration but also when updates are made. Even if there are changes in the combination of set products or changes in storage temperature zones due to shipping times, simply updating the information in kintone will automatically reflect in OpenLogi.

Summary

With the integration of kintone and OpenLogi, there is no need for data transcription when making warehouse entry requests. By reducing manual work, human errors can be prevented, allowing staff to focus on other tasks. Additionally, maintaining data consistency is expected to improve the accuracy of inventory management. By using Yoom, integration settings can be easily configured without any code. Please consider implementing this opportunity.