How to integrate kintone with WooCommerce to add product information registered in kintone to WooCommerce

The process of registering products for sale on an e-commerce site inevitably becomes more labor-intensive as the number of products increases. Additionally, when there are similar products with different sizes or capacities, the risk of input errors increases, making pre-sale checks more challenging. Wouldn't it be convenient if the product information registered in the database could be directly reflected in the e-commerce support tool?

This article introduces a method to automatically sync product information added to kintone with WooCommerce. This automation reduces the effort of product registration and maintains data consistency. Streamline product management and start selling products smoothly.

Benefits of Integrating kintone with WooCommerce

Benefit 1: Time Savings

Through integration, product information added to kintone is reflected in WooCommerce in real-time. This eliminates the need for manual data entry, allowing e-commerce sales staff to focus on other tasks such as planning sales promotions and creating email newsletters. When replacing seasonal products or conducting large-scale sales with many products at once, or when the frequency of new product sales is high, the time for manual input is significantly reduced, enabling rapid product deployment.

Benefit 2: Improved Data Consistency

By automatically syncing kintone's product information with WooCommerce, information consistency is maintained. This prevents human errors during manual data migration between different systems, allowing you to start selling products based on accurate information.

Errors in product information, registration omissions, or duplicate listings can lead to customers making decisions based on incorrect information at the time of purchase or spending time on inquiries, increasing the risk of lower evaluations of the product or store by customers. Additionally, if problems arise, investigating the cause of where the information went wrong requires effort. To mitigate these risks, it is recommended to ensure data consistency through automation.

[What is Yoom]

How to Create a kintone and WooCommerce Integration Flow

Let's set up the integration and workflow automation between kintone and WooCommerce.

Using a template, we will introduce the steps to create a workflow that "adds products to WooCommerce when product information is registered in kintone."

Before You Start

1. Please prepare a database app for product management in kintone.
　※The diagram below is an example created for flow explanation purposes.

2. Please log in to Yoom.

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

Step 1: Integration of My App with kintone and WooCommerce

*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 new connection list in My Apps, select kintone and WooCommerce respectively and integrate the apps.
　*Reference: How to register kintone My App
　*For WooCommerce integration, you need to enter the account and access token as shown in the figure below. If you are unsure about Base64 encoding, please refer to this article.

Next, copy the template to My Project and create a Flow Bot.
If you haven't copied it yet, please copy the Flow Bot template from below.

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 completed registration, the login screen will be displayed, so please log in.

‍

Step 2: Setting the Trigger to Activate When a Record is Added in kintone

1. Open the copied template.
　※ You can change it to any title from the red frame part in the image below.

2. Click the Flowbot's "App Trigger: When a Record is Registered (Webhook Activation)".

3. Select the linked account and action.
　Change the title if necessary and click "Next".

4. Set the "Webhook Event Reception Settings for App Trigger".
　Refer to the instructions and precautions to set it to activate when a record is added.
　※ Reference: Setting up Webhooks in kintone

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

Step 3: Setting the Action to Retrieve Record Information from kintone

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

2. Integrate the database.
　・Title: Can be changed if necessary.
　・Database Integration "App ID": Enter or select the ID of the product management app.

3. Click "Next".

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

　※ The image below is an example of output reference.

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

Step 4: Setting the Action to Add Product Information to WooCommerce

1. Click the Flowbot's "Integrate with App: Create Product".

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

3. Configure the API connection settings.
　Enter the necessary information in each field.
　※ You can refer to the output information obtained in Step 3.
　※ The image below shows some of the input fields, and the input/output reference content is an example.

　※ The image below is an example of output reference.

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

Finally, switch the trigger of the saved flow to "ON" to activate it.

This completes the flow of "Adding Product Information to WooCommerce When Registered in kintone".

Other Automation Examples Using kintone and WooCommerce

There are many other examples of automation using kintone and WooCommerce available in Yoom, so here are a few introductions.

1. A flow that synchronizes with WooCommerce when product information is registered in Notion. If you are using different databases depending on the type of product, or if you are selling products managed in other databases at physical stores on EC, please use this flow in conjunction with the synchronization flow from kintone.

2. A flow to notify Slack when information is added to kintone. By integrating kintone with a chat tool, you can automatically share record details when information is added or updated. If combined with a flow to sync product information to WooCommerce, you can also notify the product ID after registration.

3. This is the flow for synchronizing with Smaregi when product information is added to kintone. The information from kintone can be automatically reflected in EC support tools and POS systems other than WooCommerce. If you are using Smaregi for operating physical stores or other EC sites that handle the same products, please use this flow.

Summary

By integrating kintone with WooCommerce, it is possible to automatically synchronize product information. This automation reduces the effort required for product registration and minimizes the occurrence of human errors. Since products can be sold smoothly based on accurate data, it is expected to improve the satisfaction of customers using the e-commerce site. Please try the automation flow introduced in this article using Yoom.