到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| WT25122200039903 | 360-Fred Whitton男款抓绒长上衣-头版-YS9892MG | M | 黄婉婷 | 313684 | 349904 | 2026-01-08 17:37:19 | 5 | 2026-03-22 17:35:52.159289 |
| WT25122200039902 | 360-Fred Whitton男款抓绒长上衣-头版-YS9892MG | S | 黄婉婷 | 313684 | 349904 | 2026-01-08 17:37:19 | 4 | 2026-03-22 17:35:52.157685 |
| WT25122200039901 | 360-Fred Whitton男款抓绒长上衣-头版-YS9892MG | XS | 黄婉婷 | 313684 | 349904 | 2026-01-08 17:37:19 | 1 | 2026-03-22 17:35:52.156058 |
| ZT25122200809905 | Clash GREY CHECKERED男款T恤-头版-YS9068MT | XL | 曾亭 | 314031 | 349905 | 2026-01-08 17:37:51 | 9 | 2026-03-22 17:35:52.154447 |
| ZT25122200809904 | Clash GREY CHECKERED男款T恤-头版-YS9068MT | L | 曾亭 | 314031 | 349905 | 2026-01-08 17:37:51 | 18 | 2026-03-22 17:35:52.152761 |
| ZT25122200809903 | Clash GREY CHECKERED男款T恤-头版-YS9068MT | M | 曾亭 | 314031 | 349905 | 2026-01-08 17:37:51 | 18 | 2026-03-22 17:35:52.099558 |
| ZT25122200809902 | Clash GREY CHECKERED男款T恤-头版-YS9068MT | S | 曾亭 | 314031 | 349905 | 2026-01-08 17:37:51 | 5 | 2026-03-22 17:35:52.097974 |
| BH25121700059907 | MTB Cro Olive男款T恤-头版-YS9068MAX | 3XL | 凌碧红 | 312387 | 349908 | 2026-01-08 17:38:51 | 5 | 2026-03-22 17:35:52.094635 |
| BH25121700059906 | MTB Cro Olive男款T恤-头版-YS9068MAX | 2XL | 凌碧红 | 312387 | 349908 | 2026-01-08 17:38:51 | 12 | 2026-03-22 17:35:52.092804 |
| BH25121700059905 | MTB Cro Olive男款T恤-头版-YS9068MAX | XL | 凌碧红 | 312387 | 349908 | 2026-01-08 17:38:51 | 21 | 2026-03-22 17:35:52.091159 |
| BH25121700059904 | MTB Cro Olive男款T恤-头版-YS9068MAX | L | 凌碧红 | 312387 | 349908 | 2026-01-08 17:38:51 | 30 | 2026-03-22 17:35:52.089546 |
| BH25121700059903 | MTB Cro Olive男款T恤-头版-YS9068MAX | M | 凌碧红 | 312387 | 349908 | 2026-01-08 17:38:51 | 21 | 2026-03-22 17:35:52.087881 |
| BH25121700059902 | MTB Cro Olive男款T恤-头版-YS9068MAX | S | 凌碧红 | 312387 | 349908 | 2026-01-08 17:38:51 | 8 | 2026-03-22 17:35:52.085898 |
| BH25121700059901 | MTB Cro Olive男款T恤-头版-YS9068MAX | XS | 凌碧红 | 312387 | 349908 | 2026-01-08 17:38:51 | 3 | 2026-03-22 17:35:52.084049 |
| ZT25123000159904 | Picky 26男款内搭背心-头版-YS9050MK | L | 曾亭 | 314757 | 349909 | 2026-01-08 17:40:12 | 2 | 2026-03-22 17:35:52.082443 |
| ZT25123000159903 | Picky 26男款内搭背心-头版-YS9050MK | M | 曾亭 | 314757 | 349909 | 2026-01-08 17:40:12 | 1 | 2026-03-22 17:35:52.080754 |
| ZT25123000129905 | Picky 26男款长上衣-头版-YS9068MCDT | XL | 曾亭 | 314757 | 349909 | 2026-01-08 17:40:12 | 1 | 2026-03-22 17:35:52.079001 |
| ZT25121700229904 | Fulgz Pink speed-1男款短上衣-头版-YS9842MEO | L | 曾亭 | 312017 | 349911 | 2026-01-08 17:40:43 | 1 | 2026-03-22 17:35:52.077392 |
| ZT25122200609907 | Blue70 26护臂-头版-YS9945T | 3XL | 曾亭 | 314497 | 349912 | 2026-01-08 17:41:10 | 1 | 2026-03-22 17:35:52.075818 |
| ZT25122200609903 | Blue70 26护臂-头版-YS9945T | M | 曾亭 | 314497 | 349912 | 2026-01-08 17:41:10 | 1 | 2026-03-22 17:35:52.074176 |