到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| WT26011400049901 | A BODY 2 FIT 2026女款铁三无袖连体衣-头版-YS9263WET | XS | 黄婉婷 | 319295 | 359917 | 2026-02-06 11:42:32 | 1 | 2026-03-22 17:35:34.197033 |
| ZT26012100079902 | Elite Spine blue女款短上衣-头版-YS9842WDO | S | 曾亭 | 320280 | 359918 | 2026-02-06 11:43:00 | 1 | 2026-03-22 17:35:34.195526 |
| RX26012400159904 | EMERALD blue 2026童装短上衣-头版-YS9892MV | L | 袁日仙 | 322185 | 359919 | 2026-02-06 11:43:53 | 1 | 2026-03-22 17:35:34.194027 |
| RX26012400149905 | EMERALD grey 2026男款短上衣-头版-YS9415MEGO | XL | 袁日仙 | 322185 | 359919 | 2026-02-06 11:43:53 | 5 | 2026-03-22 17:35:34.192475 |
| RX26012400149904 | EMERALD grey 2026男款短上衣-头版-YS9415MEGO | L | 袁日仙 | 322185 | 359919 | 2026-02-06 11:43:53 | 7 | 2026-03-22 17:35:34.190964 |
| RX26012400149903 | EMERALD grey 2026男款短上衣-头版-YS9415MEGO | M | 袁日仙 | 322185 | 359919 | 2026-02-06 11:43:53 | 8 | 2026-03-22 17:35:34.189415 |
| RX26012400149902 | EMERALD grey 2026男款短上衣-头版-YS9415MEGO | S | 袁日仙 | 322185 | 359919 | 2026-02-06 11:43:53 | 5 | 2026-03-22 17:35:34.187893 |
| RX26012400149901 | EMERALD grey 2026男款短上衣-头版-YS9415MEGO | XS | 袁日仙 | 322185 | 359919 | 2026-02-06 11:43:53 | 7 | 2026-03-22 17:35:34.186375 |
| RX26012400139904 | EMERALD grey 2026童装短上衣-头版-YS9892MV | L | 袁日仙 | 322185 | 359919 | 2026-02-06 11:43:53 | 1 | 2026-03-22 17:35:34.184809 |
| JN26011000129904 | PW BHY redblue男款短袖连体衣-头版-YS9251MGIO | L | 陈锦娜 | 318323 | 359934 | 2026-02-06 13:32:01 | 1 | 2026-03-22 17:35:34.183159 |
| JN26011000129903 | PW BHY redblue男款短袖连体衣-头版-YS9251MGIO | M | 陈锦娜 | 318323 | 359934 | 2026-02-06 13:32:01 | 1 | 2026-03-22 17:35:34.181628 |
| JN26011000129902 | PW BHY redblue男款短袖连体衣-头版-YS9251MGIO | S | 陈锦娜 | 318323 | 359934 | 2026-02-06 13:32:01 | 1 | 2026-03-22 17:35:34.180000 |
| JN26011000109904 | PW BHY teal男款短袖连体衣-头版-YS9251MGIO | L | 陈锦娜 | 318323 | 359934 | 2026-02-06 13:32:01 | 1 | 2026-03-22 17:35:34.178392 |
| JN26011000109903 | PW BHY teal男款短袖连体衣-头版-YS9251MGIO | M | 陈锦娜 | 318323 | 359934 | 2026-02-06 13:32:01 | 1 | 2026-03-22 17:35:34.176715 |
| JN26011000109902 | PW BHY teal男款短袖连体衣-头版-YS9251MGIO | S | 陈锦娜 | 318323 | 359934 | 2026-02-06 13:32:01 | 1 | 2026-03-22 17:35:34.174866 |
| JN26011000079904 | PW BHY redblack女款短袖连体衣-头版-YS9251WKCO | L | 陈锦娜 | 318323 | 359934 | 2026-02-06 13:32:01 | 1 | 2026-03-22 17:35:34.173042 |
| JN26011000069904 | PW BHY teal女款短袖连体衣-头版-YS9251WKCO | L | 陈锦娜 | 318323 | 359934 | 2026-02-06 13:32:01 | 1 | 2026-03-22 17:35:34.171300 |
| ZT26011700489904 | BH 26 white Speed男款短上衣-头版-YS9842MEO | L | 曾亭 | 320074 | 359935 | 2026-02-06 13:33:28 | 1 | 2026-03-22 17:35:34.169610 |
| ZT26011700489905 | BH 26 white Speed男款短上衣-头版-YS9842MEO | XL | 曾亭 | 320074 | 359935 | 2026-02-06 13:33:28 | 1 | 2026-03-22 17:35:34.167931 |
| ZT26011700489903 | BH 26 white Speed男款短上衣-头版-YS9842MEO | M | 曾亭 | 320074 | 359935 | 2026-02-06 13:33:28 | 3 | 2026-03-22 17:35:34.166224 |