到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| YY26012100129904 | ALIAS-RESPIRA女款抓绒夹克-头版-YS9474WAO | L | 刘莹滢 | 320649 | 360342 | 2026-02-07 15:52:52 | 1 | 2026-03-22 17:35:33.077899 |
| YY26012100129902 | ALIAS-RESPIRA女款抓绒夹克-头版-YS9474WAO | S | 刘莹滢 | 320649 | 360342 | 2026-02-07 15:52:52 | 1 | 2026-03-22 17:35:33.076138 |
| RX26012100159904 | JarneVos男款短袖连体衣-头版-YS9230MBK | L | 袁日仙 | 320644 | 360344 | 2026-02-07 15:53:17 | 1 | 2026-03-22 17:35:33.074573 |
| BH26012100019906 | MTB TAC男款T恤-头版-YS9068MAX | 2XL | 凌碧红 | 320266 | 360345 | 2026-02-07 15:53:38 | 5 | 2026-03-22 17:35:33.072873 |
| BH26012100019905 | MTB TAC男款T恤-头版-YS9068MAX | XL | 凌碧红 | 320266 | 360345 | 2026-02-07 15:53:38 | 10 | 2026-03-22 17:35:33.071308 |
| BH26012100019904 | MTB TAC男款T恤-头版-YS9068MAX | L | 凌碧红 | 320266 | 360345 | 2026-02-07 15:53:38 | 5 | 2026-03-22 17:35:33.069729 |
| BH26012100019903 | MTB TAC男款T恤-头版-YS9068MAX | M | 凌碧红 | 320266 | 360345 | 2026-02-07 15:53:38 | 5 | 2026-03-22 17:35:33.068076 |
| LF25021200089905 | 25Stelvio-C33鞋套 | XL | 袁日仙 | 318066 | 360346 | 2026-02-07 15:54:17 | 48 | 2026-03-22 17:35:33.064854 |
| LF25021200089904 | 25Stelvio-C33鞋套 | L | 袁日仙 | 318066 | 360346 | 2026-02-07 15:54:17 | 48 | 2026-03-22 17:35:33.063226 |
| LF25021200089903 | 25Stelvio-C33鞋套 | M | 袁日仙 | 318066 | 360346 | 2026-02-07 15:54:17 | 36 | 2026-03-22 17:35:33.061587 |
| LF25021200089902 | 25Stelvio-C33鞋套 | S | 袁日仙 | 318066 | 360346 | 2026-02-07 15:54:17 | 22 | 2026-03-22 17:35:33.059946 |
| LF26011700159904 | VORA-WHITE2鞋套 | L | 罗兰方 | 318144 | 360347 | 2026-02-07 15:54:39 | 30 | 2026-03-22 17:35:33.058336 |
| LF26011700159903 | VORA-WHITE2鞋套 | M | 罗兰方 | 318144 | 360347 | 2026-02-07 15:54:39 | 20 | 2026-03-22 17:35:33.056694 |
| LF26011700169904 | VORA-BLACK2鞋套 | L | 罗兰方 | 318144 | 360347 | 2026-02-07 15:54:39 | 40 | 2026-03-22 17:35:33.054933 |
| LF26011700169903 | VORA-BLACK2鞋套 | M | 罗兰方 | 318144 | 360347 | 2026-02-07 15:54:39 | 10 | 2026-03-22 17:35:33.053137 |
| ZT26011700609904 | ALOVE blueTT半指手套-YS17033O | L | 曾亭 | 323693 | 360350 | 2026-02-07 15:55:15 | 6 | 2026-03-22 17:35:33.050528 |
| ZT26011700609903 | ALOVE blueTT半指手套-YS17033O | M | 曾亭 | 323693 | 360350 | 2026-02-07 15:55:15 | 13 | 2026-03-22 17:35:32.998155 |
| ZT26011700619904 | ALOVE black-TT半指手套-YS17033O | L | 曾亭 | 323693 | 360350 | 2026-02-07 15:55:15 | 6 | 2026-03-22 17:35:32.996544 |
| ZT26011700609902 | ALOVE blueTT半指手套-YS17033O | S | 曾亭 | 323693 | 360350 | 2026-03-18 18:08:19 | 38 | 2026-03-22 17:35:32.996449 |
| ZT26011700619903 | ALOVE black-TT半指手套-YS17033O | M | 曾亭 | 323693 | 360350 | 2026-02-07 15:55:15 | 13 | 2026-03-22 17:35:32.993857 |