Online Bookstore Auto Order Collection Program - AutoOrder
I made a program to automate publishing company work and also made an ERP, but I'm just releasing the parts that are needed.
yes24 orders require SMS authentication once. Be sure to enter the mobile phone number registered with Yes24 in the environment settings!
`# AutoOrder User Manual
AutoOrder is a desktop program that collects bookstore order Excel files, verifies them as standard order data, and generates Excel files formatted for warehouse and delivery company uploads.
1. Initial Setup
1. Check the default save path, supply rate, and discount rate by transaction method in Environment Settings.
2. Enter your ID, password, contact phone number, and supplier code in Bookstore Settings.
3. The API endpoint is fixed based on the distribution version and is not modified by the user.
4. Initial setting values are saved in the .env and settings files in the app data folder.
2. Bookstore Data Collection
1. Select the bookstore to use from the Yes24, Aladdin, Kyobo Bookstore, and Orderpia menus.
2. Secure a bookstore session with the Login button.
3. If SMS authentication is required, use the app's authentication number input window.
4. Save today's orders or orders by period as an Excel file.
5. Saved Excel files are managed in the C:\data\bookstore name structure by default.
3. Excel Reload
1. Check the file to retrieve from the Excel list on the bookstore screen.
2. Running DB import will delete and re-register existing data for the same bookstore/same order date.
3. Verify that the bookstore screen table matches the actual Excel content using ISBN, book title, quantity, and amount as criteria.
4. If the Excel structure has changed, adjust the header mapping of the collection script and reload it.
4. Order List Verification
1. Filter data by period, bookstore, and keyword conditions in the order list.
2. Check if the quantity, regular price, supply rate, and supply amount match the actual order form.
3. Organize problematic data by reloading the Excel file for the corresponding date/bookstore.
4. Verified data can be exported as a standard order Excel file.
5. Logistics Format Conversion
1. Select the profile to use from the logistics format menu, such as Moasis, Nalgae Logistics, and ChoiGang Logistics.
2. Register the Excel template provided by the warehouse or delivery company.
3. Select the order period and bookstore and generate an Excel file for upload to the logistics company.
4. If there is no template, an Excel file will be created based on the default header criteria.
6. Operating Principles
1. Do not delete the original Excel file and keep it stored.
2. Reloading from the original Excel file is the safest way to resolve issues.
3. If the bookstore screen table and the original Excel are different, modify the mapping based on the original Excel.
4. Korean encoding problems can be addressed by fixing the Excel file save method and header mapping.
https://drive.google.com/file/d/1GbYazfAPMshbHfjF-K31psPfR2bEXcgN/view?usp=sharing
I don't know if anyone runs a publishing company, but I'm making it public. Downloads are available via the link.
