English
Contact us
Contact us

Our work

Delivery-app merchant collection and matching tool

Merchant lists that could only be viewed inside the apps are compiled into 12 fields automatically once a region is selected. Business registration numbers are then matched to check which merchants are also listed on other apps.

Merchant data across three delivery apps

Before

Staff opened the app, tapped through each store, and typed details into Excel

After

Select a region and run · 12 fields compiled in Excel, with listings on other delivery apps matched

Excel sheet generated by the delivered tool. Column headers, in order: region, category, store name in listing, registered business name, address, business registration number, owner name, recent orders, recent reviews, recent owner replies, and phone number. The store name and business name columns are blurred, as are the address, registration number, owner name, and phone number. Region shows only the province, with the city and district blurred. The category column includes meat and grill, chicken, café and dessert, jokbal and bossam, Chinese, and snacks. The three right-hand columns hold figures such as 400, 500, 900, and 1,000 recent orders, 50, 76, and 321 reviews, and 55, 94, and 154 owner replies. About thirty rows fit on one screen.

To protect client information, these screens recreate the same features with mock data.

Client
Logistics
Industry
Logistics
Delivered
2025
Duration
4 weeks
Area
Workflow automation
  • App screen structure parsing
  • Automated web lookup
  • Collection by region and category
  • Business registration number matching
  • Standalone executable
  • Automated Excel output

Background

Which stores are listed on delivery apps, and how many orders and reviews they receive, is useful data for understanding a local market. That information sits separately in each app, and there is more than one way to reach the same data.

What we found

Staff were opening the app, tapping through each store, and typing the details into Excel.

They set the region, chose a category, opened each store’s page, and copied the fields they needed. Then they looked up each business registration number again to see whether the same store was listed on other delivery apps.

There were many regions and many categories. Each new region meant starting over from the beginning.

The problem

Each task could only be done through a different channel.

Merchant lists are only visible in the app. Whether a store is also listed on another app can be checked on the merchant portal by business registration number. Relying on a single method would either leave one task undone or make the easier one harder.

What we built

  • Lists from the app’s screen structure — The tool does not capture and OCR the screen. It locates each field in the structure the app renders and interacts with it directly
  • Listing checks on the merchant portal — Listing status can be looked up on the web, so the tool drives a browser to check it. Where a simpler route exists, the tool uses it
  • By region and category — Select a region and the tool collects data category by category, saving one folder per region
  • 12 fields — Region, category, store name, registered business name, address, business registration number, owner, orders, reviews, owner replies, phone number, and opening hours, all in one row
  • Matching by registration number — Numbers collected from one app are checked against another to confirm listings. Upload one Excel file and get it back with listing status added
  • No installation — The verification tool was delivered as a standalone executable. Choose a file, press Start, and progress is shown. It can be stopped at any point. Staff without Python knowledge can use it immediately

Results

Select a region and run the tool to compile merchants by category in 12 fields. Enter business registration numbers to get a table of listings on other delivery apps.

Related work is listed under App crawling.

Ask about a similar problem Pricing View other cases