> ## Documentation Index
> Fetch the complete documentation index at: https://docs.qoder.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Case 17: E-commerce Data Auto-Sync

## Scenario

Mike has been running cross-border e-commerce for three years, managing five stores and 200+ SKUs. Every morning he used to log into each store, export yesterday’s sales, paste into a spreadsheet, and compute trends. One hour-plus, and he often missed a store.

He wanted QoderWork to automate it.

## Prompt Example

```plaintext theme={null}
Sync my e-commerce store data:
1. Open a browser and log into these 5 seller dashboards:
   - US: [URL]
   - EU: [URL]
   - Japan: [URL]
   - ...
2. On each "Business Reports" page, export yesterday's sales data
3. Merge into one Excel with:
   - Sales, orders, return rate per store
   - Top 10 SKUs and performance
   - Day-over-day changes (highlight declines)
4. Write a short daily summary (~200 words)
```

## What QoderWork Did

QoderWork used browser automation to log into each store, go to reports, export data, merge, and produce a summary. Mike now opens his laptop and the report is ready.

## Ongoing Use

Turn this into a fixed Skill. Daily: "Run today's store report." As data accumulates: "Compare the last 30 days and flag SKUs that are declining."

## Key Metrics

| Metric     | Result                              |
| ---------- | ----------------------------------- |
| Automation | Common for cross-border sellers     |
| Time saved | From \~1 hour to \~10 minutes daily |
| Data       | Enables trend analysis over time    |

## Pro Tips

Use **browser automation + Skill packaging** for tasks that require logging into sites.

Mike’s flow doesn’t use local files—it’s all browser. The prompt lists each site and path (e.g., "export yesterday’s sales from Business Reports"). A daily Skill is ideal: "Run today's store report." **Browser automation + Skill = big daily time savings.**