Automation Case Study: ERP Work Automation: From 11 Steps to 2
If you work in apparel or manufacturing, you've probably experienced this at least once.
Fabrics, colors, zippers, pieces... there are dozens of component types alone.
Sorting each one manually into sheets, then organizing them into work orders, then creating print labels and shipping information.
And all of this doesn't end with just creating one or two documents.
You have to pull product information from the ERP, fetch images from Google Drive, apply various order quantities and formulas, and format everything into Excel or PDF.
The tools alone include ERP, Google Sheets, Drive, PDF editors, and more...
Ultimately, spending time on 'document busywork' day after day means important planning, decision-making, and strategy work gets pushed to the back burner.
A few months ago, we received an inquiry from Company L.
"Products are registered in our ERP, but creating sheets from that data, writing work orders, and printing labels and shipping information is all manual work. We want to automate this."
Company L had three major problems:
- Product info sheets, purchase orders, work orders, labels, and shipping info tables were created manually every time
- Every detail like order quantities, image insertion, and quantity calculations had to be filled in by hand
- Copying and pasting across multiple tools frequently caused data omissions and incorrect entries
The resulting time waste and cost burden were impossible to ignore.
Access Ecount ERP → Search production receipt status → Find products and fetch info by item → Create sheets per item → Create rows and copy-paste fetched info, copy-paste, copy-paste → Create new purchase order sheet and copy-paste info again → Create new work order sheet and copy-paste info again → Create new label sheet and copy-paste info again → Create new shipping info table sheet and copy-paste info again → Extract PDFs individually and upload to Drive → Repeat this process every time production receipt occurs
So We Automated the Entire Document Work Process
With just one button click, purchase orders, work orders, labels, and shipping info tables are automatically generated.
The key was to make all documents generate automatically so that no manual work was needed beyond entering data into the ERP.
Click the 'Generate Purchase Order' button → View purchase order, work order, label, and shipping info files instantly
Let's look at the specific process through the Make scenario below!
- Viewing the Full Process via Make Scenario
1. A webhook is attached to a button, and when the button is pressed
2. Find the production receipt status in Ecount ERP and look up received products and items.
3. Integrate with sheets to automatically populate received product and item information.
4. Based on the fetched information, module scenarios configured to create each of the purchase order list / work order / label / shipping info table
② Module that filters information to match specific products and creates purchase order lists
③ Module that creates label rows based on product details (color, size, product code, etc.)
④ Module that enters shipping information based on ordering customer data
- Now Company L Just Needs to Press a Button
With one button press, all documents are automatically categorized and generated.
This is how 11 steps were reduced to just 2!
For work orders, Ecount ERP does support this feature, but the image capacity displayed within is limited.
Pretty Simple Now, Right?
- Update product information in Ecount ERP
- Press the 'Generate Purchase Order' button
- All documents are automatically generated.
ERP Work Automation: A Work Environment Free of Copy-Paste
Document work is important, but it doesn't have to be something people do manually every time.
Boldly automate what can be automated,
and create an environment where people can focus on more valuable work.
If you or your employees are spending entire days copying and pasting documents,
that's not just simple inefficiency — it could be eating away at your company's growth.
Before automation, one person had to spend over 1.5 hours daily on document work.
By that calculation, that's a staggering 390 hours per year,
which even at minimum wage translates to 3,911,700 KRW in labor costs spent on repetitive busywork.
In contrast, MAKE costs about $108 per year, approximately 151,366 KRW.
In other words, total document work costs were reduced by approximately 96.1%.
We hope many companies lacking development resources find breathing room through automation,
and within that breathing room, unlock even greater possibilities.