到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25122200179905 | TriRig 26护臂-头版-YS9945T | XL | 曾亭 | 313666 | 348941 | 2026-01-06 10:46:07 | 1 | 2026-03-22 17:35:53.769331 |
| ZT25122200209903 | TriRig 26女款短袖三铁连体衣-头版-YS9794WBS | M | 曾亭 | 313341 | 348940 | 2026-01-08 17:38:14 | 3 | 2026-03-22 17:35:53.769222 |
| ZT25122200179903 | TriRig 26护臂-头版-YS9945T | M | 曾亭 | 313666 | 348941 | 2026-01-06 10:46:07 | 1 | 2026-03-22 17:35:53.766497 |
| ZT25122200169905 | TriRig 26抓绒护臂-头版-YS9935MO | XL | 曾亭 | 313666 | 348941 | 2026-01-06 10:46:07 | 1 | 2026-03-22 17:35:53.765019 |
| ZT25122200169903 | TriRig 26抓绒护臂-头版-YS9935MO | M | 曾亭 | 313666 | 348941 | 2026-01-06 10:46:07 | 1 | 2026-03-22 17:35:53.763514 |
| ZT25122200159904 | TriRig 26抓绒护膝-头版-YS9927MO | L | 曾亭 | 313666 | 348941 | 2026-01-06 10:46:07 | 1 | 2026-03-22 17:35:53.761981 |
| ZT25122200149904 | TriRig 26抓绒护腿-头版-YS9967MO | L | 曾亭 | 313666 | 348941 | 2026-01-06 10:46:07 | 1 | 2026-03-22 17:35:53.760437 |
| ZT25122200149903 | TriRig 26抓绒护腿-头版-YS9967MO | M | 曾亭 | 313666 | 348941 | 2026-01-06 10:46:07 | 1 | 2026-03-22 17:35:53.758861 |
| ZT25121700119903 | GNV Cargo-1女款背带短裤-头版-YS9113WP | M | 曾亭 | 311694 | 348948 | 2026-01-06 10:47:04 | 1 | 2026-03-22 17:35:53.757263 |
| ZT25121700109903 | GNV sport-1男款背带短裤-头版-YS9149MH | M | 曾亭 | 311694 | 348948 | 2026-01-06 10:47:04 | 1 | 2026-03-22 17:35:53.755635 |
| ZT25121700109902 | GNV sport-1男款背带短裤-头版-YS9149MH | S | 曾亭 | 311694 | 348948 | 2026-01-06 10:47:04 | 2 | 2026-03-22 17:35:53.753953 |
| ZT25121700109911 | GNV sport-1男款背带短裤-头版-YS9149MH | 2XS | 曾亭 | 311694 | 348948 | 2026-01-06 10:47:04 | 1 | 2026-03-22 17:35:53.751926 |
| RX25122000399904 | Jlife-Raid MTB 2025-B男款短上衣-头版-YS9640MY | L | 袁日仙 | 313204 | 348950 | 2026-01-06 10:47:35 | 2 | 2026-03-22 17:35:53.699019 |
| RX25122000399903 | Jlife-Raid MTB 2025-B男款短上衣-头版-YS9640MY | M | 袁日仙 | 313204 | 348950 | 2026-01-06 10:47:35 | 4 | 2026-03-22 17:35:53.697440 |
| MJ25112600129907 | TCHACO GROUP男款POLO衫-二版-YS9450MCO | 3XL | 庄镘洁 | 313696 | 348951 | 2026-01-06 10:48:21 | 2 | 2026-03-22 17:35:53.695709 |
| MJ25112600129906 | TCHACO GROUP男款POLO衫-二版-YS9450MCO | 2XL | 庄镘洁 | 313696 | 348951 | 2026-01-06 10:48:21 | 2 | 2026-03-22 17:35:53.694135 |
| ZT25122700079904 | PARIA26 Pink女款短上衣-头版-YS9640WEO | L | 曾亭 | 313024 | 348952 | 2026-01-06 10:49:06 | 2 | 2026-03-22 17:35:53.692521 |
| ZT25122700079903 | PARIA26 Pink女款短上衣-头版-YS9640WEO | M | 曾亭 | 313024 | 348952 | 2026-01-06 10:49:06 | 5 | 2026-03-22 17:35:53.690959 |
| ZT25122700079902 | PARIA26 Pink女款短上衣-头版-YS9640WEO | S | 曾亭 | 313024 | 348952 | 2026-01-06 10:49:06 | 5 | 2026-03-22 17:35:53.689372 |
| ZT25122700079901 | PARIA26 Pink女款短上衣-头版-YS9640WEO | XS | 曾亭 | 313024 | 348952 | 2026-01-06 10:49:06 | 4 | 2026-03-22 17:35:53.687831 |