到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| RX26011000169904 | NSBT男款背带短裤-头版-YS9163MPA | L | 袁日仙 | 317634 | 355402 | 2026-01-24 13:53:34 | 3 | 2026-03-22 17:35:43.675898 |
| RX26011000169906 | NSBT男款背带短裤-头版-YS9163MPA | 2XL | 袁日仙 | 317634 | 355402 | 2026-01-24 13:53:34 | 9 | 2026-03-22 17:35:43.674351 |
| RX26011000169905 | NSBT男款背带短裤-头版-YS9163MPA | XL | 袁日仙 | 317634 | 355402 | 2026-01-24 13:53:34 | 10 | 2026-03-22 17:35:43.672839 |
| MN25123000129903 | Blue70 26女款短袖三铁连体衣-头版-YS9794WBS | M | 林美霓 | 315445 | 355404 | 2026-01-24 13:54:41 | 3 | 2026-03-22 17:35:43.671269 |
| MN25123000129902 | Blue70 26女款短袖三铁连体衣-头版-YS9794WBS | S | 林美霓 | 315445 | 355404 | 2026-01-24 13:54:41 | 1 | 2026-03-22 17:35:43.669691 |
| MN25123000119903 | Blue70 26女款无袖三铁连体衣-头版-YS9794WCS | M | 林美霓 | 315445 | 355404 | 2026-01-24 13:54:41 | 1 | 2026-03-22 17:35:43.668160 |
| ZT26011000419907 | ENVE 26男款抓绒夹克-头版-YS9655MT | 3XL | 曾亭 | 317658 | 355405 | 2026-01-24 13:55:07 | 1 | 2026-03-22 17:35:43.666588 |
| ZT26011000419904 | ENVE 26男款抓绒夹克-头版-YS9655MT | L | 曾亭 | 317658 | 355405 | 2026-01-24 13:55:07 | 1 | 2026-03-22 17:35:43.664987 |
| LF25123000099906 | TG-BLUE男款T恤-头版- YS9492MBKO | 2XL | 罗兰方 | 317014 | 355406 | 2026-01-24 13:55:55 | 10 | 2026-03-22 17:35:43.663349 |
| LF25123000099905 | TG-BLUE男款T恤-头版- YS9492MBKO | XL | 罗兰方 | 317014 | 355406 | 2026-01-24 13:55:55 | 40 | 2026-03-22 17:35:43.661787 |
| LF25123000099904 | TG-BLUE男款T恤-头版- YS9492MBKO | L | 罗兰方 | 317014 | 355406 | 2026-01-24 13:55:55 | 90 | 2026-03-22 17:35:43.660235 |
| LF25123000099903 | TG-BLUE男款T恤-头版- YS9492MBKO | M | 罗兰方 | 317014 | 355406 | 2026-01-24 13:55:55 | 70 | 2026-03-22 17:35:43.658665 |
| LF25123000099902 | TG-BLUE男款T恤-头版- YS9492MBKO | S | 罗兰方 | 317014 | 355406 | 2026-01-24 13:55:55 | 60 | 2026-03-22 17:35:43.657039 |
| LF25123000099901 | TG-BLUE男款T恤-头版- YS9492MBKO | XS | 罗兰方 | 317014 | 355406 | 2026-01-24 13:55:55 | 30 | 2026-03-22 17:35:43.655444 |
| LF25123000099911 | TG-BLUE男款T恤-头版- YS9492MBKO | 2XS | 罗兰方 | 317014 | 355406 | 2026-01-24 13:55:55 | 20 | 2026-03-22 17:35:43.653025 |
| LF25123000099918 | TG-BLUE男款T恤-头版- YS9492MBKO | 4XS | 罗兰方 | 317014 | 355406 | 2026-01-24 13:55:55 | 20 | 2026-03-22 17:35:43.599330 |
| LF25021200069907 | RD-25ASTANA男款短上衣-YS8008M | 3XL | 罗兰方 | 317643 | 355407 | 2026-01-24 13:56:29 | 2 | 2026-03-22 17:35:43.597126 |
| LF25021200069906 | RD-25ASTANA男款短上衣-YS8008M | 2XL | 罗兰方 | 317643 | 355407 | 2026-01-24 13:56:29 | 3 | 2026-03-22 17:35:43.594933 |
| LF25021200069905 | RD-25ASTANA男款短上衣-YS8008M | XL | 罗兰方 | 317643 | 355407 | 2026-01-24 13:56:29 | 5 | 2026-03-22 17:35:43.592726 |
| LF25021200069904 | RD-25ASTANA男款短上衣-YS8008M | L | 罗兰方 | 317643 | 355407 | 2026-01-24 13:56:29 | 5 | 2026-03-22 17:35:43.590397 |