到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| YL26011000029903 | AZ 34 tight-1男款七分裤-头版-YS2214MXA | M | 甘雅玲 | 317410 | 352671 | 2026-01-16 17:25:57 | 1 | 2026-03-22 17:35:48.258557 |
| YL26011000019903 | AZ half tight-5男款跑步短裤-头版-YS2214MX | M | 甘雅玲 | 317410 | 352671 | 2026-01-16 17:25:57 | 1 | 2026-03-22 17:35:48.257020 |
| MN26010300019906 | FV 26半指手套-YS17049MO | 2XL | 曾亭 | 314493 | 352672 | 2026-01-16 17:29:54 | 2 | 2026-03-22 17:35:48.255456 |
| MN26010300019905 | FV 26半指手套-YS17049MO | XL | 曾亭 | 314493 | 352672 | 2026-01-16 17:29:54 | 2 | 2026-03-22 17:35:48.253865 |
| MN26010300019904 | FV 26半指手套-YS17049MO | L | 曾亭 | 314493 | 352672 | 2026-01-16 17:29:54 | 11 | 2026-03-22 17:35:48.251988 |
| MN26010300019903 | FV 26半指手套-YS17049MO | M | 曾亭 | 314493 | 352672 | 2026-01-16 17:29:54 | 4 | 2026-03-22 17:35:48.199133 |
| MN26010300019902 | FV 26半指手套-YS17049MO | S | 曾亭 | 314493 | 352672 | 2026-01-16 17:29:54 | 1 | 2026-03-22 17:35:48.197529 |
| MN26010300029905 | FV 26长指手套-YS17045O | XL | 曾亭 | 314493 | 352672 | 2026-01-16 17:29:54 | 2 | 2026-03-22 17:35:48.196004 |
| MN26010300029904 | FV 26长指手套-YS17045O | L | 曾亭 | 314493 | 352672 | 2026-01-16 17:29:54 | 13 | 2026-03-22 17:35:48.194407 |
| MN26010300029903 | FV 26长指手套-YS17045O | M | 曾亭 | 314493 | 352672 | 2026-01-16 17:29:54 | 6 | 2026-03-22 17:35:48.192830 |
| RX25121300769906 | SG-READING CC半指手套 | 2XL | 袁日仙 | 310989 | 352674 | 2026-01-16 17:30:24 | 2 | 2026-03-22 17:35:48.191204 |
| RX25121300769905 | SG-READING CC半指手套 | XL | 袁日仙 | 310989 | 352674 | 2026-01-16 17:30:24 | 4 | 2026-03-22 17:35:48.189505 |
| RX25121300769904 | SG-READING CC半指手套 | L | 袁日仙 | 310989 | 352674 | 2026-01-16 17:30:24 | 8 | 2026-03-22 17:35:48.187990 |
| RX25121300769903 | SG-READING CC半指手套 | M | 袁日仙 | 310989 | 352674 | 2026-01-16 17:30:24 | 6 | 2026-03-22 17:35:48.186425 |
| RX25121300769902 | SG-READING CC半指手套 | S | 袁日仙 | 310989 | 352674 | 2026-01-16 17:30:24 | 4 | 2026-03-22 17:35:48.184820 |
| MY2404020169904 | windsock2 bont black鞋套-MT009 | L | 胡美英 | 308872 | 352677 | 2026-01-16 17:30:53 | 25 | 2026-03-22 17:35:48.183191 |
| MY2404020169903 | windsock2 bont black鞋套-MT009 | M | 胡美英 | 308872 | 352677 | 2026-01-16 17:30:53 | 30 | 2026-03-22 17:35:48.181581 |
| MY2404020169902 | windsock2 bont black鞋套-MT009 | S | 胡美英 | 308872 | 352677 | 2026-01-16 17:30:53 | 25 | 2026-03-22 17:35:48.180053 |
| MY2404020159904 | windsock2 bont white鞋套-MT009 | L | 胡美英 | 308872 | 352677 | 2026-01-16 17:30:53 | 40 | 2026-03-22 17:35:48.178427 |
| MY2404020159903 | windsock2 bont white鞋套-MT009 | M | 胡美英 | 308872 | 352677 | 2026-01-16 17:30:53 | 60 | 2026-03-22 17:35:48.176897 |