到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25121700379903 | Alpha 26 EVO男款短上衣-头版-YS9640MXO | M | 曾亭 | 312372 | 349200 | 2026-03-02 17:25:12 | 8 | 2026-03-22 17:35:53.376923 |
| ZT25121700189903 | USF 26女款短袖连体衣-头版-YS9212MJF | M | 曾亭 | 311994 | 349202 | 2026-01-06 17:51:56 | 1 | 2026-03-22 17:35:53.372564 |
| ZT25121700189902 | USF 26女款短袖连体衣-头版-YS9212MJF | S | 曾亭 | 311994 | 349202 | 2026-01-06 17:51:56 | 1 | 2026-03-22 17:35:53.370890 |
| JB25121700129904 | ID-DRFT 26-1 M男款背带短裤-头版-YS2132MF | L | 郑杰彬 | 312015 | 349204 | 2026-01-06 17:52:23 | 8 | 2026-03-22 17:35:53.369092 |
| JB25121700129903 | ID-DRFT 26-1 M男款背带短裤-头版-YS2132MF | M | 郑杰彬 | 312015 | 349204 | 2026-01-06 17:52:23 | 20 | 2026-03-22 17:35:53.367526 |
| JB25121700129902 | ID-DRFT 26-1 M男款背带短裤-头版-YS2132MF | S | 郑杰彬 | 312015 | 349204 | 2026-01-06 17:52:23 | 5 | 2026-03-22 17:35:53.365988 |
| ZT25122000339906 | Pace Racing男款短上衣-头版-YS9409MEKO | 2XL | 曾亭 | 313206 | 349205 | 2026-01-06 17:52:53 | 1 | 2026-03-22 17:35:53.364446 |
| ZT25122000339903 | Pace Racing男款短上衣-头版-YS9409MEKO | M | 曾亭 | 313206 | 349205 | 2026-01-06 17:52:53 | 1 | 2026-03-22 17:35:53.362673 |
| ZT25122000339902 | Pace Racing男款短上衣-头版-YS9409MEKO | S | 曾亭 | 313206 | 349205 | 2026-01-06 17:52:53 | 4 | 2026-03-22 17:35:53.361147 |
| ZT25122000339901 | Pace Racing男款短上衣-头版-YS9409MEKO | XS | 曾亭 | 313206 | 349205 | 2026-01-06 17:52:53 | 4 | 2026-03-22 17:35:53.359449 |
| BH25121700079907 | MTB Cro Slate男款T恤-头版-YS9068MAX | 3XL | 凌碧红 | 312387 | 349206 | 2026-01-06 17:54:23 | 6 | 2026-03-22 17:35:53.357618 |
| BH25121700079906 | MTB Cro Slate男款T恤-头版-YS9068MAX | 2XL | 凌碧红 | 312387 | 349206 | 2026-01-06 17:54:23 | 15 | 2026-03-22 17:35:53.356047 |
| BH25121700079905 | MTB Cro Slate男款T恤-头版-YS9068MAX | XL | 凌碧红 | 312387 | 349206 | 2026-01-06 17:54:23 | 30 | 2026-03-22 17:35:53.354330 |
| BH25121700079903 | MTB Cro Slate男款T恤-头版-YS9068MAX | M | 凌碧红 | 312387 | 349206 | 2026-01-06 17:54:23 | 30 | 2026-03-22 17:35:53.351602 |
| BH25121700079904 | MTB Cro Slate男款T恤-头版-YS9068MAX | L | 凌碧红 | 312387 | 349206 | 2026-01-06 17:54:23 | 40 | 2026-03-22 17:35:53.298379 |
| BH25121700079902 | MTB Cro Slate男款T恤-头版-YS9068MAX | S | 凌碧红 | 312387 | 349206 | 2026-01-06 17:54:23 | 10 | 2026-03-22 17:35:53.296855 |
| BH25121700079901 | MTB Cro Slate男款T恤-头版-YS9068MAX | XS | 凌碧红 | 312387 | 349206 | 2026-01-06 17:54:23 | 4 | 2026-03-22 17:35:53.295275 |
| BH25121700069907 | MTB Cro Sage男款T恤-头版-YS9068MAX | 3XL | 凌碧红 | 312387 | 349206 | 2026-01-06 17:54:23 | 6 | 2026-03-22 17:35:53.293710 |
| BH25121700069906 | MTB Cro Sage男款T恤-头版-YS9068MAX | 2XL | 凌碧红 | 312387 | 349206 | 2026-01-06 17:54:23 | 15 | 2026-03-22 17:35:53.292191 |
| BH25121700069905 | MTB Cro Sage男款T恤-头版-YS9068MAX | XL | 凌碧红 | 312387 | 349206 | 2026-01-06 17:54:23 | 30 | 2026-03-22 17:35:53.290597 |