Easily convert and import CSV sales slip data, etc. into Yayoi Hanbai
What is the mail order data conversion and import module?
Easily convert and import CSV sales slip data, etc. into Yayoi Hanbai
What is the mail order data conversion and import module?
This module allows you to import multiple different order data, such as from mall-type EC sites and your own EC site, without having to open Yayoi Hanbai directly. It greatly contributes to improving business efficiency by converting CSV data output from EC sites into the import format of Yayoi Hanbai and importing it.
No need to manually sort the order data you want to import into the Yayoi import format
You can create templates for conversion formats that correspond to multiple output data
You can import data even if another user is logged in to Yayoi Hanbai
No need to manually sort the order data you want to import into the Yayoi import format
You can create templates for conversion formats that correspond to multiple output data
You can import data even if another user is logged in to Yayoi Hanbai
Easy 2-step import
With the mail order data conversion and import module, your daily work is just 2 steps away!
mail order data conversion and import module
Easy 2-step import
 |  |
Output transaction data | Import into Yayoi Hanbai based |
|
|
You can create as many templates as you want!
Create and use according to the number of EC sites
4 merits of using it
1.Flexible response by updating conversion templates
| 2.Reducing errors by omitting input work
|
Even if the order data format changes irregularly, such as in the case of online shops, users can freely change the conversion template at their own convenience. Multiple conversion templates can be created, so conversion templates can be prepared for multiple EC sites. | Conversion templates can significantly reduce input work. Since there is no need to enter order data from the EC site into Yayoi Sales, it is possible to minimize human errors such as missing data or input errors. |
3.Enabling direct data integration with Yayoi Hanbai
| 4.No additional costs besides the monthly fee
|
After converting the data with the module, you can import it directly into Yayoi Hanbai. | The maintenance costs that you may be concerned about are included in the monthly fee.The number of templates is also unlimited, so no additional fees are incurred. |
4 merits of using it |
|
4 functions
|
|
|
|
4 functions |
Import function
You can convert and import data into Yayoi Hanbai' customer ledger, delivery ledger, order slip, and sales slip. Since it is directly linked, there is no need to open Yayoi Hanbai. In addition, you can import any data even if other users are using Yayoi Hanbai. |
Free creation of conversion templates
Users can freely assign (map) items so that data can be imported from any order data format into Yayoi Hanbai ledgers and slips. With this template, you can import order data from any EC site into Yayoi Hanbai. |
Customer matching function
For customers with a sales record, such as repeat customers, the customer code in Yayoi Hanbai is referenced based on the purchase source information (name, phone number, address, etc.) in the order data. This eliminates the need to repeatedly enter purchase source information for existing customers, making work more efficient. In addition, since they are registered as customers in Yayoi Hanbai, this is reflected in sales aggregation and analysis. |
Obtaining product ledger information
When converting and importing information such as product cost and tax classification information that is not managed on the EC site, this tool can obtain information from Yayoi Hanbai' product ledger and reflect it in the invoice registration. |
＼For more detailed information, click here／
Examples of target mall-type EC sites
| |
In addition, you can connect to any e-commerce site including online shops such as Amazon and Rakuten, and your own e-commerce site as long as you can extract CSV files. *Depending on the plan and version, importing may not be possible for online shops (EC sites). |
Amazon Rakuten Ichiba Sukeneko Welcart EC-CUBE In addition, you can connect to any e-commerce site including online shops such as Amazon and Rakuten, and your own e-commerce site as long as you can extract CSV files. *Depending on the plan and version, importing may not be possible for online shops (EC sites). |
How to use the order data conversion and import module of mail order
＜ Initial settings items ＞
License authentication
License authentication is required the first time you start the program. From the next time onwards, authentication will be performed automatically. | Connection settings with Yayoi Hanbai
You will need to connect to Yayoi Hanbai, which you are currently using. Please also select the business office data. | Create a template for transaction data
Data matching (mapping) can be done to match the transaction data. This setting can simplify your daily work. |
List of functions for the order data conversion and import module for mail order
| Menu | Description |
|---|---|
| Template conversion | Converts order data according to specified conversion conditions and imports it into Yayoi Hanbai |
| Event log | Records operations performed on the module, such as converting and importing order data and changing settings |
| Template settings | Registers specified conversion conditions as a template |
| Template list | Displays a list of registered templates. Confirmation, editing, and deletion can be performed from this menu |
| Product settings | If the product code is not included in the order data, set the matching between the product name and the Yayoi Hanbai product code |
| System settings | Module database settings |
| Yayoi Hanbai settings | Set the Yayoi Sales database to which the order data is imported *Data of 1 Business office only |
| Version information | Display module version information, license information, and help |
| End | Exit the module (close) |
Image of the screen for converting and importing order data
Click here for instructions on how to use the mail order order data conversion and import module
List of specifications for the order data conversion and import module for mail order
| PC environment | Japanese OS: Microsoft Windows 11/10 |
|---|---|
| Terminal requirements | Terminals with Yayoi Hanbai database (SQLServer2014 SP3 or later) |
| Compatible Yayoi products | Yayoi Hanbai Standard |
| Target ledger | Customer ledger/Delivery destination ledger |
| Target slip | Order slip/Sales slip |
| Operational notes | In order to run this module, Yayoi Sales must be installed on the same terminal. It may not run properly in a virtual environment. Please consult us in advance. |
Conditions for importing order data | Purchase information and purchaser information are required in each line of the order data to be imported. |
Our technology |
Price
Initial fee: JPY 50,000 (excluding tax) / Monthly fee: JPY 30,000 (excluding tax)
Initial fee: JPY 50,000 (excluding tax)
Monthly fee: JPY 30,000 (excluding tax)
*The monthly fee includes maintenance and operation fees.
Payment method
The monthly fee is free for the first month of use.
In the case of direct debit
Payment by bank transfer is required only for the first payment, which includes the monthly fee and the initial fee for the month after the start of use and the month after that.
We will send you a direct debit request form, so you will pay by direct debit after the procedure.
Installation process
Please check “Installation process” for the installation schedule for each app.
Please check before installation
- Only the Yayoi Sales series is supported. (Recommended version: Latest version of Yayoi Hanbai)
Please prepare the Yayoi Hanbai software separately. - In order to operate this module, Yayoi Hanbai must be installed on the same device.
*It will not work on devices on which Yayoi Sales is not installed. - It may not work properly in a virtual environment. Please consult in advance.
- Each line of the order data to be imported must contain “purchase information” and “purchaser information (customer information).”
Order data that contains only purchase information, or that is separated from purchase information and buyer information, cannot be imported. - Please contact us if you have any questions regarding operation, etc.
- We will inform you separately if the program is revised due to a change in Yayoi Hanbai specifications.
(Please note that a separate program update fee may be required.) - Depending on the settings of your current online store (online shopping site) or unique system, “the Order Data Conversion and Import Module for Mail Order” may not be compatible, so we may ask you to use a trial version or check your CSV file in advance.
- For inquiries regarding the operation and settings of the online store and order system, please contact the operating company.
- For those who do not need to convert the transaction data to be imported into Yayoi’s import format, we also have a tool that can automatically import it.
≫ Yayoi Sales Automatic Import Tool
Differences between the Yayoi Sales Automatic Import Tool and the Order Data Conversion Import Module for Mail Order
| Requirements | Yayoi Sales automatic import tool | Order data conversion and import module for mail order |
|---|---|---|
| Linked to Yayoi Sales | 〇 Most ledgers and slips | 〇 Customer ledger, sales slip, order slip |
| Data import method | 〇 Automatic execution, manual execution | 〇 Manual execution only |
| Scheduling function | 〇 Automatic import possible at specified time | × Manual execution only |
| Imported data conversion function | × Only Yayoi import format supported | 〇 Can convert any format (conditions apply) |
| Linked to data of multiple business offices | 〇 Data of multiple business offices can be set | × Links data from one business office only |
| CSV output in Yayoi import format | × No CSV output function | × No CSV output function |
| Acquisition of Yayoi sales ledger information | × Imported data directly into Yayoi Hanbai | 〇 Acquires and assigns ledger information for some items |
| Event log | 〇 | 〇 |
Release Notes Ver.2.2-a 2023/7/20 Ver.2.2 2023/5/10 |
Frequently asked questions about this app
Requirements | Yayoi Hanbai automatic import tool | Order data conversion and import module for mail order |
Linked to Yayoi Sales | 〇 Most ledgers and slips | 〇 Customer ledger, sales slip, order slip |
Data import method | 〇 Automatic execution, manual execution | 〇 Manual execution only |
Scheduling function | 〇 Automatic import possible at specified time | × Manual execution only |
Imported data conversion function | × Only Yayoi import format supported | 〇 Can convert any format (conditions apply) |
Linked to data of multiple business offices | 〇 Data of multiple business offices can be set | × Links data from one business office only |
CSV output in Yayoi import format | × No CSV output function | × No CSV output function |
Acquisition of Yayoi Hanbai ledger information | × Imported data directly into Yayoi Sales | 〇 Acquires and assigns ledger information for some items |
Event log | 〇 | 〇 |
The “Data Conversion Import Module for Mail Order (formerly: Web Order Data Conversion Tool)” linked to the Yayoi Hanbai Series is compatible with shopping sites (EC sites) that can output CSV files, such as Rakuten Ichiba, Amazon, Welcart, and Sukeno.
*The above shopping sites may not operate correctly, so we may ask you to use a trial version or check your CSV file in advance.
(Yahoo! Shopping will be supported in the next version)
We may also be able to support other shopping sites (EC sites) or unique order systems, so please feel free to contact us.
We have tools that can be linked to Yayoi Hanbai and Yayoi Kaikei via API.
We offer the Yayoi Hanbai automatic import tool, which works in conjunction with Yayoi Hanbai via API to automatically import data such as external product ledgers and sales slips, as well as a order data conversion and import module for mail order, which allows you to easily import external quotation data and online shop transaction data by using templates.
In addition to Yayoi Hanbai, we also offer applippli Cloud, which clouds a variety of back-office sales management software and accounting software such as Sorimachi products and Ouken products, as well as applippli Dx Pro, a cloud-based virtual desktop service (DaaS) that allows you to easily use virtual desktops (VDI) without server management.
Our subscription pricing system allows us to offer services at an affordable monthly rate, so please feel free to contact us.
＜アプリ例＞
Yayoi Hanbai and API integration 1: [Yayoi Hanbai automatic import tool] |
 |
CSV files can be automatically imported into Yayoi HanbaiIssues to be resolved
弥生公式の連携製品として認定されました！
|
Yayoi Hanbai and API Link 2: [Mail Order Data Conversion Import Module] |
 |
You can convert and import order data from Amazon and Rakuten into Yayoi HanbaiProblems to be solved
Online order data conversion and import module | Yayoi linked app here |
API linkage with other than Yayoi Hanbai 3: [applippli Dx Pro] |
 |
弥生以外の業務ソフトのデスクトップをクラウド化するDaaS |
Problems which can be solved
|
弥生販売とapi連携1 |
|
CSVファイルを自動で弥生販売へ取り込む解消される課題 ・他のユーザーが弥生販売を使用していても、取り込み作業を行うことができるようになります。 ・自動でインポートするため、作業時間を大幅に削減でき、業務効率化に繋がります。 ・複数事業者の売上伝票や商品台帳をまとめてインポートが可能です。 弥生公式の連携製品として認定されました！
|
弥生販売とapi連携2 |
|
Amazonや楽天の受注データを弥生販売へ変換取込できます解消される課題 ・ECサイトや自社独自システムの受注データを弥生販売の受注伝票インポート形式に簡単に変換し、変換取込できます。手作業で転記していた伝票入力作業をなくすことで大幅な時短・ミス軽減につながります。 ・変換する受注データ形式によって変換テンプレートを作成。初回設定時にテンプレートを作成するため、2回目以降は変換処理のみですぐにインポート作業が可能となります。 ・ECサイト等では管理していない商品原価や税区分情報などを、当ツールの変換・取込処理の際に、弥生販売商品台帳から情報を取得し、伝票登録に反映させることができます。 ・リピーター顧客など販売実績のある得意先は、受注データの購入元情報（氏名、電話番号、住所など）をもとに弥生販売の得意先コードを参照します。そのため、既存顧客の購入元情報を何度も入力する必要がなく、作業が効率化されます。
|
弥生販売以外とも連携3 |
Business software other than Yayoi can also be moved to the cloud. |
Problems which can be solved ・The introduction of teleworking will eliminate labor shortages. By introducing teleworking, you can hire employees in areas that you could not target before. ・You can work without being tied to a location. It is also recommended for those who want to work from a business trip! ・Since you can manage your company’s business centrally, it reduces the workload of administrators. |
The recommended operating environment for the app is Windows 11/10 OS, 4GB or more of memory, and Intel Core i3 or higher CPU.
The recommended database specifications are Windows Server 2016 or later (64bit) OS, 4GB or more of memory, and 100GB or more of free space on the HDD.
*Microsoft SQL Server 2019/2017/2016 SP2
For more information, please see the recommended specifications on the details page of each app.
➤A service that allows you to run business software without worrying about the specs of your computer
If you have any questions, please feel free to contact us.
Usage fee for this app
Retail Price ¥121,000
（Excluding Tax）¥110,000
Example: Contract in May → August will be charged in July
* We will send you a direct debit slip later. Please return it within one month of receiving it. Can I use the "Yayoi Sales Automatic Import Tool"?
* We plan to accept payment by credit card soon. Thank you for your patience.
