skills.rest
xu1713
xu1713COMMUNITY
Explore all skills by this author →
GitHub

taobao-seller-service

Collects Taobao seller metrics from Sycm via Chrome CDP and writes them into Excel.

Updated Jun 5, 2026
Search Tags:#data collection#web scraping#excel#playwright#ecommerce#taobao#sycm
One-click install
npx skills add https://github.com/xu1713/openhorse --skill taobao-seller-service-xu1713
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: taobao-seller-service
Source: https://github.com/xu1713/openhorse/tree/main/openhorse/openhorse/skills/ecommerce/taobao-seller-service
Command: npx skills add https://github.com/xu1713/openhorse --skill taobao-seller-service-xu1713

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires playwright, openpyxl, and includes scripts (resource) and references (resource) components.

What problem does it solve? Manually copying daily store metrics (visitors, traffic sources, add-to-cart counts, conversion rates) from Qianniu/Sycm into Excel is repetitive and error-prone. This Skill automates the collection and writes each metric into the correct Excel column. ## Core Features & Use Cases - Automated Sycm scraping: Connects to a logged-in Chrome session via CDP and reads item archives, item source, and item rank pages for each product ID. - Structured Excel writing: Maps row-1 headers to columns automatically (Pattern A/B layouts), writes visitors, source breakdowns, add-to-cart counts, computed UV values, and add-to-cart rate formulas. - Resumable runs: Saves progress state so interrupted runs resume where they stopped; pauses with NEED_MANUAL_LOGIN when the Taobao session expires. - Use Case: A Taobao seller runs one command each morning to fill yesterday's per-product metrics into their sales tracking workbook. ## Quick Start Ask the assistant to run the taobao-seller-service script with your target date to collect yesterday's store data into your Excel workbook.

Frequently Asked Questions about taobao-seller-service

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I collect Taobao Sycm store data into Excel automatically?▼

Run the run.py script with a target date; it connects to Chrome over CDP, reads each product's metrics from Sycm pages, and writes visitors, sources, add-to-cart counts, and conversion rates into the mapped Excel columns.

What tools are needed to scrape Sycm (生意参谋) data?▼

The workflow uses Python with playwright for browser automation over Chrome DevTools Protocol and openpyxl for Excel read/write. Chrome must run with --remote-debugging-port=9222 and an active Taobao login session.

Does this work without a logged-in Taobao session?▼

No. The script checks the Sycm login state and returns NEED_MANUAL_LOGIN if the session expired. Log in manually in the opened Chrome window, then rerun the same command; completed products are skipped via saved state.

Why are some Excel cells empty after a run?▼

Empty cells usually mean Sycm page selectors changed or the header row no longer matches the column mapping. Check the run report, inspect the page, and update selectors in sycm_fetch.py or verify headers against the column mapping reference.

Can I limit or test the collection before a full run?▼

Yes. Use --dry-run to list product IDs without collecting, --limit N to process only the first N products, and --reset-state to clear checkpoint data and force a full rerun.

Related Skills

Explore More Data & Analytics Skills→
zpointzpoint
40

qianniu-listing

Bulk update Taobao/Tmall product listings via Excel export-edit-import workflow.

Community
Intermediate
GACLoveGACLove
2

performance-analytics

Analyze cross-channel marketing metrics to identify trends and optimization opportunities.

Community
Intermediate
bungkustbungkust

fb-marketplace-scraper

Extract Facebook Marketplace listing titles, prices, locations, and seller info via browser automation.

Community
Intermediate
zpointzpoint
40

qianniu-shared

Standardize login, popup handling, and navigation for Taobao/Tmall seller automation.

Community
Advanced