Shopify × Kintone × Ship&Co連携によるEC業務自動化システム
EC事業者向けERP-lite｜受注・在庫・配送・業務管理を一元化するバックオフィス自動化
Overview
AMCOLAB developed an e-commerce operations automation system by integrating Shopify, Kintone, and Ship&Co.
Before the project, order management, inventory checks, shipping label creation, tracking number updates, internal confirmations, and reporting were spread across multiple tools and manual workflows. This created a high operational workload and increased the risk of missed checks and data entry errors.
The system connects Shopify order data to Kintone and centralizes order management, inventory management, shipping operations, status tracking, and operational reporting. Through Ship&Co integration, the system also supports more efficient shipping label creation and tracking number management.
Challenges
| Fragmented order data | Order information was spread across Shopify, Kintone, CSV files, and internal spreadsheets. |
|---|---|
| Too many manual tasks | Staff manually checked orders, confirmed inventory, entered shipping details, and updated statuses. |
| Inventory mismatches | Physical inventory and system inventory could become inconsistent, creating oversell risk. |
| Shipping workload | Shipping label creation, tracking number management, and shipping status confirmation required time and manual checks. |
| Lack of visibility | Managers could not quickly see order status, shipping progress, or inventory conditions. |
| Limited scalability | The existing operation was difficult to expand toward B2B, agencies, affiliates, or multi-warehouse operations. |
Technology Stack
| Business Platform | Kintone, Shopify, Ship&Co |
|---|---|
| Backend / Middleware | Ruby on Rails |
| API Integration | Shopify API, Kintone REST API, Ship&Co API |
| Frontend / Custom UI | React / Next.js where needed |
| Cloud / Infrastructure | AWS, RDS, S3 |
| Data Handling | CSV import/export, order data sync, inventory data management |
| Operation Support | Status management, dashboard view, workflow design |
AMCOLAB Role
AMCOLAB supported the project from business workflow analysis to system design, development, API integration, testing, and operational improvement.
| Requirement Analysis | Clarified the current order, inventory, and shipping workflows. |
|---|---|
| System Design | Designed the integration structure between Shopify, Kintone, and Ship&Co. |
| Development | Implemented API integration, data synchronization, and business logic. |
| Kintone Customization | Designed fields, views, and statuses that are easy for operation staff to use. |
| QA / Testing | Tested order sync, inventory update, and shipping workflows. |
| Operation Support | Reviewed operational issues and proposed improvements. |
Similar Use Cases
| Shopify businesses | Companies that want to automate order, inventory, and shipping operations. |
|---|---|
| E-commerce companies | Businesses that want to centralize multi-channel order management. |
| D2C brands | Brands that need more efficient inventory, fulfillment, and customer operation workflows. |
| Kintone users | Companies that want to use Kintone as an operational management foundation. |
| Wholesale / B2B EC | Businesses that need agency, partner, commission, billing, or account management extensions. |
| Logistics / warehouse operations | Teams that want to improve picking, packing, and shipping label workflows. |
Solution
Order Management
Shopify order data is synced to Kintone, enabling centralized order management.
Inventory Management
Inventory is managed by SKU, with a design that separates logical inventory and physical inventory.
Shipping Management
Ship&Co integration helps streamline shipping label creation and tracking number management.
Status Management
Order, inventory, fulfillment, and shipping statuses can be checked directly in Kintone.
Workflow Design
The order-to-shipping workflow was clarified and redesigned to reduce manual work.
Extensible Design
The architecture considers future expansion into B2B, agency management, multi-warehouse operation, and commission management.
Key Features
Shopify Order Sync
Shopify order information is synced into Kintone, including customer details, product information, SKU, quantity, amount, shipping information, and order status.
Smart Inventory Management
The system separates logical inventory and physical inventory, helping distinguish reserved items, in-warehouse items, and items waiting for fulfillment.
Ship&Co Integration
The system supports shipping label creation, tracking number acquisition, and status updates, reducing manual work in shipping operations.
Kintone Operation Dashboard
Kintone views were designed so staff and managers can easily see statuses such as waiting for shipment, in progress, shipped, or low inventory.
ERP-lite Architecture
Instead of introducing a large ERP from the beginning, the system uses Kintone as a flexible foundation to automate operations step by step.
Future Expansion
The system was designed with future extensions such as agency management, B2B orders, affiliate integration, billing, and payment workflows in mind.
Result / Business Impact
The system helped reduce multiple manual tasks in e-commerce operations and enabled centralized visibility of order, inventory, and shipping information.
Short Version for Portfolio Card
AMCOLAB developed an ERP-lite e-commerce operations automation system by integrating Shopify, Kintone, and Ship&Co. The system centralizes order management, inventory management, shipping label creation, tracking number management, and fulfillment status monitoring. By reducing manual data entry, missed checks, and inventory mismatches, the Kintone-based operation interface supports more efficient EC back-office operations and future business expansion.
