Yayoi Hanbai automatic import tool

Automatic CSV import reduces
100 hours of work to 0 hours

弥生販売自動インポートツール designed for 弥生

  
|  What is the Yayoi Sales automatic import tool?▽  |  Merits ▽  |  Pricing plans ▽  |

Automatic CSV import reduces
100 hours of work to 0 hours

弥生販売自動インポートツール design for 弥生

＼It can also be used as a proposal document.／

First, download the materials!

弥生販売と連携して自動インポート

Easily and automatically import CSV sales slip data, etc. into Yayoi Hanbai

What is the Yayoi Hanbai automatic import tool?

What is the Yayoi Hanbai automatic import tool?

This tool is linked to Yayoi Sales via API and automatically imports multiple CSV files, such as sales slips and product ledgers created on e-commerce sites and business systems, into Yayoi Sales in bulk. Furthermore, it can automatically import files even when other Yayoi Sales users are logged in, greatly contributing to improved business efficiency.

Importing is possible even when other users are logged in to Yayoi Hanbai

Automatic importing is supported with the schedule function

Multiple CSV data can be imported at once

Importing is possible even when other users are logged in to Yayoi Hanbai

Automatic importing is supported with the schedule function

Multiple CSV data can be imported at once

Recommended for

  • Those who input invoice data into multiple systems, both in their own company system and Yayoi Hanbai
  • Those who have a huge number of invoices and ledgers to register
  • Those who want to reduce the time it takes to import data into Yayoi Hanbai
  • Those who are having trouble with other Yayoi Hanbai users being unable to enter data while importing data into Yayoi Hanbai
  • Those who manage multiple Yayoi Hanbai data from business offices
  • Those who want to perform import operations even while other users are logged in

 

Merits of using it

■Process multiple documents at once

  • No need to import multiple times a day
    *When an import file is generated for each document
  • If you use this tool and set it to “once every 60 minutes,” automatic importing becomes possible.
    *Can be set at intervals of 30 minutes (60 minutes recommended).
  • This allows you to automate the tedious import process that you would have had to perform multiple times.
  • Automating the process also helps prevent missing any imports.
  • Compatible with CSV and text formats.

複数伝票を一括インポート

 

■Multiple Data Management

  • Automatic import management can be managed and processed collectively for multiple Yayoi Hanbai business data.
    *This is limited to the extent that the automatic import tool can reference the Yayoi Sales database.

複数の事業所データを一括管理

 

Errors become clearer with separate file and folder management

■Automatic file movement function

  • Even if an import error occurs due to an input error or conversion error, it is possible to display which item the error occurred in.
  • Imported files that have errors are managed in a separate folder, making it easy to re-import them.
  • Imported data is sorted into a separate folder, preventing duplicate imports.
  • It makes it easier to check the status of data imports.

処理後のファイル自動移動

 

■Log function

  • You can check the execution log of automatic import.
  • If an import error occurs, you can check the cause of the error.

自動インポートの実行ログの生成

Export is also possible

■Export function

  • You can specify the range of update dates (last update date and time registered in Yayoi Sales) for the invoice data and automatically output it.
    *Yayoi Hanbai can narrow down the output by invoice date, invoice number, contact person, etc.
  •  You can specify the output range by the last update date and time.
    *Yayoi Hanbai cannot extract based on the last update date and time.
  • When exporting invoices, you can select multiple contact persons.
    *You can now specify [Mr. A] and [Mr. C] rather than the range [Mr. A] to [Mr. C].
    For “Product price list by customer” and “Product price list by supplier”, you can output price lists for multiple customers and suppliers at once.
    *Only products with unit price settings registered will be output.

エクスポート

＼Recommended for those who want to know more ／

Download the materials here

A service recommended for those who find it troublesome to prepare CSV files in Yayoi Hanbai import format
≫Module for converting and importing mail order data

Here are some common use cases!

 

Solves this problem!! 　Other users can import even while other users are logged in

Solves this problem!!  
Other users can import even while other users are logged in

Normally, with Yayoi products such as the Yayoi Sales Network Edition, if one user is using the import function, other users cannot use Yayoi Hanbai.
However, by installing the “Yayoi Sales Auto Import Tool”, you can use Yayoi Sales even while other users are importing various slips and ledger data! Work will not stop!

 

Solve this problem!! 　Automatic import with simple scheduling

Solve this problem!!  
Automatic import with simple scheduling

If you want to import on a regular basis, you can perform automatic import (automatic import) by setting the day of the week and time in the schedule settings.
You can also set the import interval in minutes or hours (set repeat execution).
Imports can be completed at any time you like!
*The automatic import tool must be set up on the device where Yayoi Sales is installed.

 

Click here for implementation examples

How to use the Yayoi Sales automatic import tool

＜ Easy 3 steps ＞

①Yayoi import file

→

②Execute automatic import

→

③Reflected in Yayoi Hanbai slips and ledgers

  1. Prepare the CSV data you want to import by sorting it into the Yayoi Sales import format, and save it in the previously set import folder.
    *If you want to semi-automate the sorting, we recommend the Order Data Conversion Import Module for Mail Order.
  2. Start the “Yayoi Hanbai Automatic Import Tool” and perform the import.
    *Other users can continue to register data in Yayoi Sales during such time!
    *By setting up a schedule, you can automate the import process!
  3. Import complete! The data will be reflected in Yayoi Sales’ ledgers and invoices.
    *The CSV file that has been imported will be automatically moved to the completion folder that you set in advance.
    *Files that failed to import will be saved in a folder separate from the completion import folder, so you can check and correct them as necessary.
  1. Yayoi import file
    Prepare the CSV data you want to import by sorting it into the Yayoi Sales import format, and save it in the previously set import folder.
    *If you want to semi-automate the sorting, we recommend the Order Data Conversion Import Module for Mail Order.
  2. Execute automatic import
    Start the “Yayoi Hanbai Automatic Import Tool” and perform the import.
    *Other users can continue to register data in Yayoi Hanbai during such time!
    *By setting up a schedule, you can automate the import process!

  3. Reflected in Yayoi Hanbai slips and ledgers
    Import complete! The data will be reflected in Yayoi Hanbai’ ledgers and invoices.
 

Video explanation from startup to import

＜Screen image＞

インポート設定画面

①Yayoi Hanbai Settings
・Select Yayoi Hanbai Data
・Register Destination for saving Import File
・Register destinatinon for saving Imported File
・Specify Invoice Number Rules

②Execution Settings
・Select Import Method
└Repeat Execution or Fixed Schedule Execution
・Set Repeat Execution Interval
・Set Fixed Schedule Execution Time and Day

For repeat execution
You can set intervals from 30 minutes (60 minutes is recommended), and you can import slips and ledgers all at once.

For scheduled execution
You can specify the type of data to import, such as [Every morning at 9:00] for customer data and [Every morning at 10:00] for order data.
*You will need to use separate folders (directories) to save the imported data.

Yayoi Hanbai Auto Import Tool Specifications List

Supported OS

Japanese OS Microsoft Windows 11 / 10
Windows Server 2016 or higher
*We can support any environment where Yayoi products can be run.
*We recommend using a server if available.
*We recommend 8GB or more of memory.
*It may not operate properly in a virtual environment. Please consult us in advance.

Recommended deviceDevice with Yayoi Sales Database (SQL Server 2016 or higher)
*To use this tool, you need an environment with internet access.
Compatible
Yayoi products

Yayoi Hanbai Standard
Yayoi Hanbai Professional, 2 users, 5 users
Yayoi Hanbai Network
*Compatible with Yayoi Hanbai 25 (Ver.28.0.1) and later versions
*Please contact us if you would like to use older versions

Target data

＜Ledger import＞
Customer ledger/Supplier ledger/Product ledger/Person in charge ledger/Warehouse ledger/Delivery destination ledger/Product price list by customer/Product price list by supplier/Component ledger
＜Slip import＞
Quotation/Order slip/Sales slip/Deposit slip/Purchase slip/Payment slip/Shipping slip/Warehouse transfer slip/Production slip
*Warehouse transfer slip and production slip are not included in Yayoi Sales’ import function.
＜Export ledger＞
Customer ledger/Supplier ledger/Product ledger/Person in charge ledger/Warehouse ledger/Delivery destination ledger/Product price list by customer/Product price list by supplier/Component ledger
＜Slip Export＞
Order slip/Sales slip/Deposit slip/Purchase slip/Withdrawal slip/Shipping slip/Warehouse transfer slip/Production slip

Our technology
  • AutoDB
  • GUREFURI
  • NO REGULATION
  • Cloud or PC

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)

Payment method

The monthly fee is free for the first month of use.

In case of direct debit from bank account

Payment will be made by bank transfer only for the first payment, which covers the monthly fee for the month after the start of use and the month after that and the initial fee.
We will send you a direct debit request form, so after completing the procedure, you will be able to make payment by direct debit.

Installation process

Please check the installation schedule for each app in “Installation process“.

Please check before installation

  • Only data in Yayoi import format can be imported.
    *This tool does not have a function to convert to Yayoi import format.
  • Only Yayoi Hanbai series products are supported.
    Please contact us if you would like an automatic import tool for other business software.
  • In order to run this module, Yayoi Hanbai must be installed on the same terminal.
    *It will not run on terminals where Yayoi Hanbai is not installed.
  • If you are operating a menu that cannot be executed simultaneously with other processes, such as bulk inventory adjustment or backup, this tool will also temporarily result in an error.
  • There is no function for issuing from sales invoice to sales invoice.
  • To perform an import, the computer must remain on.
  • If installed on your PC (client terminal), the tool will need to be launched when the PC is started.
    *The tool can be made to launch automatically when the PC is started by adding it to the startup launch process.
    *If installed on a server, it can be left running at all times.

Contact Us

Release Notes

Ver.3.13 2024/12/26
Confirmed to work with Yayoi Hanbai 25 (Ver.28.0.2)
Export function released
Fixed some bugs

Ver.3.12　2023/7/20
Confirmed to work with Yayoi Hanbai 23 Ver.26.2.1.

Ver.3.11　2023/3/20
We have released the “Yayoi Hanbai Automatic Import Tool” which works with Yayoi Hanbai 23 and Microsoft Windows 11.

≫ All release information

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

〇

〇

  • Question

I wanted to resolve the issue of not being able to use Yayoi Hanbai during import, so I searched and found your “Yayoi Hanbai Automatic Import Tool”. It says there is a customization fee, but I would like to know what that specifically entails.

  • Answer

If the order of the items in the CSV data to be imported is not the same as in Yayoi, customization will be required and a fee will be charged. We will send you an overview document with detailed specifications, so please contact us using the inquiry form below.

Contact us here

For more information on the Yayoi Hanbai Auto Import Tool, click here

If the CSV output of logistics data from your company’s proprietary system is compatible with the Yayoi Hanbai import format, you can use this tool.
If it is not compatible, you will need to customize the tool, so we will send you some CSV sample data and verify it.

Please contact us for details.

Contact us

Details of the “Yayoi Hanbai Automatic Import Tool”

 

It is possible to import CSV data into Yayoi Hanbai, but the cash register data will need to be customized.
First, we will receive a CSV sample of the cash register data, and we will provide you with a quote after verifying it.
*The product codes in the cash register data and Yayoi data must match.

Please contact us for details.

Inquiries about Yayoi Hanbai Data

Details of the “Yayoi Hanbai Automatic Import Tool”

 

In some cases, this is possible.
It depends on the Salesforce functions you are using, but by matching the order of CSV output (export) items to the order of the Yayoi product import format, you will be able to convert and import the data.

For more details, please contact us using the form below.

Contact us here

Order data conversion and import module for mail order

■Recommended Yayoi Hanbai integration tool

The following items can be automatically imported into Yayoi Hanbai using this tool.

＜Ledgers＞
Customer ledger, supplier ledger, product ledger, staff ledger, warehouse ledger, delivery destination ledger, product price list by customer, product price list by supplier, component ledger

＜Slips＞
Quotation, order slip, sales slip, deposit slip, purchase slip, purchase slip, withdrawal slip, shipping slip, warehouse transfer slip, production slip

For more information, please see the “Yayoi Hanbai Auto Import Tool.”

Yayoi Hanbai Auto Import Tool

Contact us here

 

The following items can be automatically imported into Yayoi Hanbai using this tool.

＜Ledgers＞
Customer ledger, supplier ledger, product ledger, staff ledger, warehouse ledger, delivery destination ledger, product price list by customer, product price list by supplier, component ledger

＜Slips＞
Quotation, order slip, sales slip, deposit slip, purchase slip, purchase slip, withdrawal slip, shipping slip, warehouse transfer slip, production slip

For more information, please see the “Yayoi Hanbai Auto Import Tool.“

Contact us here

 

The “Yayoi Hanbai Auto Import Tool” on the Appli Platform
can automatically import each ledger and invoice data into Yayoi Hanbai at a specified time.

By completely automating tasks that were previously done manually, mistakes in selecting and duplication of imported data are minimized!

This unique function, not included in Yayoi Hanbai, significantly improves work efficiency.

Features of the “Yayoi Hanbai Automatic Import Tool”

  1. Automate the import process for Yayoi Hanbai!
  2. Imports are possible even when other users are logged in to Yayoi Hanbai!
  3. The schedule function allows automatic imports even outside business hours!
  4. Imported files are automatically moved to a separate folder to prevent duplicate imports!

View the “Yayoi Hanbai Automatic Import Tool” linked to Yayoi Hanbai

For inquiries about the app:
For inquiries by email, please click here.

Automatic import is possible.
The applippli Platform’s “Yayoi Hanbai Automatic Import Tool” is a dedicated import tool that can shorten the time it takes to enter data into Yayoi Hanbai.
Customer information, various ledgers, and various invoice information can be automatically imported into Yayoi Hanbai.

Furthermore, you can import data even if other users are using Yayoi Hanbai, so you can import data without worrying about the time.

For more information, please see “Yayoi Hanbai Automatic Import Tool.“

 

 

For companies considering introducing the Yayoi Hanbai Linkage System

At applippli Platform, we customize the Yayoi Hanbai Linkage System.
Our staff will make suggestions so that you can introduce a system that suits your company.

Inquiries via the web

 

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.

List of apps

アプリップリの取得しているロゴ　弥生販売 連携

＜アプリ例＞

Yayoi Hanbai and API integration 1: [Yayoi Hanbai automatic import tool]

CSV files can be automatically imported into Yayoi Hanbai

Issues to be resolved

    • You will be able to perform import work even if other users are using Yayoi Hanbai.
    • Because the import is automatic, it can significantly reduce work time and improve work efficiency.
    • It is possible to import sales slips and product ledgers from multiple businesses at once.

弥生公式の連携製品として認定されました！

弥生販売と正式に連携製品として認定された場合に取得できるロゴ

Yayoi Hanbai Automatic Import Tool | Yayoi Link App here

 

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 Hanbai

Problems to be solved

  • Create a conversion template based on the order data format to be converted. Since a template is created during initial setup, from the second time onwards, you can immediately import data by simply converting it.
  • When using this tool to convert and import information that is not managed on e-commerce sites, such as product cost and tax classification information, this information can be obtained from the Yayoi Hanbai product ledger and reflected in the invoice registration.
  • When converting and importing information such as product cost and tax classification information that is not managed on EC sites, this tool can obtain information from the Yayoi Hanbai product ledger and reflect it in the slip registration.

  • For customers with a sales record, such as repeat customers, the customer code of 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.

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

    • Windowsのクラウドデスクトップ環境を活用することで、いつも扱っている作業環境（デスクトップ環境）にどのデバイスからでもどこにいてもアクセスできるようになるため、無駄な時間が発生しなくなり業務効率化に繋がります。
    • You can work without being tied to a location. It is also recommended for those who want to work from a business trip!
    • サーバー管理などの専門知識は必要なく、簡単に社業の一元管理ができるため、管理者の業務負担を軽減します。

 

Click here for applippli Dx Pro

弥生販売とapi連携1
【弥生販売用自動インポートツール】

CSVファイルを自動で弥生販売へ取り込む

解消される課題

・他のユーザーが弥生販売を使用していても、取り込み作業を行うことができるようになります。

・自動でインポートするため、作業時間を大幅に削減でき、業務効率化に繋がります。

・複数事業者の売上伝票や商品台帳をまとめてインポートが可能です。

弥生公式の連携製品として認定されました！

弥生販売と正式に連携製品として認定された場合に取得できるロゴ

弥生販売自動インポートツール｜弥生連携アプリはこちら

 

弥生販売とapi連携2
【弥生販売受注データ変換取込モジュール】

Amazonや楽天の受注データを弥生販売へ変換取込できます

解消される課題

・ECサイトや自社独自システムの受注データを弥生販売の受注伝票インポート形式に簡単に変換し、変換取込できます。手作業で転記していた伝票入力作業をなくすことで大幅な時短・ミス軽減につながります。

・変換する受注データ形式によって変換テンプレートを作成。初回設定時にテンプレートを作成するため、2回目以降は変換処理のみですぐにインポート作業が可能となります。

・ECサイト等では管理していない商品原価や税区分情報などを、当ツールの変換・取込処理の際に、弥生販売商品台帳から情報を取得し、伝票登録に反映させることができます。

・リピーター顧客など販売実績のある得意先は、受注データの購入元情報（氏名、電話番号、住所など）をもとに弥生販売の得意先コードを参照します。そのため、既存顧客の購入元情報を何度も入力する必要がなく、作業が効率化されます。

 

通販受注データ変換取込モジュール｜弥生連携アプリはこちら

弥生販売以外とも連携3
【アプリップリ Dx Pro】

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.

Click here for applippli Dx Pro

Click here for inquiries and questions about apps

Click here to contact us

Usage fee for this app

Retail Price ¥121,000
（Excluding Tax）¥110,000

Initial: ¥50,000 + Monthly: ¥30,000 x 2 months
The payment amount when signing up for the app will be the initial setup fee plus two months' worth of monthly usage fees (the month after you start using the app + the month after that). Since payment will be made in advance after the first payment, the monthly usage fee will be charged in the month before the month of use.
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.
Quantity

Inquiries about this service

Name of the app you are using
Keywords used when searching
If you have entered keywords on a search site, please enter them here.
Company name
*If you are an individual, please write "Individual".
Name of contact person
　Required
Phone number
　Required
Email address
　Required
Contact method
　Required
Details of question
　Required