到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT26011700489902 | BH 26 white Speed男款短上衣-头版-YS9842MEO | S | 曾亭 | 320074 | 359935 | 2026-02-06 13:33:28 | 1 | 2026-03-22 17:35:34.164462 |
| RX2412200069905 | LBCC-25AIR-grey女款背带短裤-YS2151WAO | XL | 袁日仙 | 307288 | 359936 | 2026-02-06 13:34:04 | 2 | 2026-03-22 17:35:34.162759 |
| RX2412200069904 | LBCC-25AIR-grey女款背带短裤-YS2151WAO | L | 袁日仙 | 307288 | 359936 | 2026-02-06 13:34:04 | 9 | 2026-03-22 17:35:34.160969 |
| RX2412200069903 | LBCC-25AIR-grey女款背带短裤-YS2151WAO | M | 袁日仙 | 307288 | 359936 | 2026-02-06 13:34:04 | 17 | 2026-03-22 17:35:34.159359 |
| RX2412200069902 | LBCC-25AIR-grey女款背带短裤-YS2151WAO | S | 袁日仙 | 307288 | 359936 | 2026-02-06 13:34:04 | 20 | 2026-03-22 17:35:34.157854 |
| RX2412200069901 | LBCC-25AIR-grey女款背带短裤-YS2151WAO | XS | 袁日仙 | 307288 | 359936 | 2026-02-06 13:34:04 | 16 | 2026-03-22 17:35:34.156340 |
| RX2412200069911 | LBCC-25AIR-grey女款背带短裤-YS2151WAO | 2XS | 袁日仙 | 307288 | 359936 | 2026-02-06 13:34:04 | 4 | 2026-03-22 17:35:34.154820 |
| YK25102900029905 | LeMont男款短袖连体衣-头版-YS9229MK | XL | 何咏凯 | 320044 | 359937 | 2026-02-06 13:34:49 | 2 | 2026-03-22 17:35:34.153241 |
| YK25102900029904 | LeMont男款短袖连体衣-头版-YS9229MK | L | 何咏凯 | 320044 | 359937 | 2026-02-06 13:34:49 | 2 | 2026-03-22 17:35:34.150954 |
| YK25102900029903 | LeMont男款短袖连体衣-头版-YS9229MK | M | 何咏凯 | 320044 | 359937 | 2026-02-06 13:34:49 | 7 | 2026-03-22 17:35:34.098517 |
| YK25102900029902 | LeMont男款短袖连体衣-头版-YS9229MK | S | 何咏凯 | 320044 | 359937 | 2026-02-06 13:34:49 | 4 | 2026-03-22 17:35:34.096962 |
| YY26012100089904 | ALIAS-RESPIRA男款短袖连体衣-头版-YS9251MDIO | L | 刘莹滢 | 320252 | 359941 | 2026-02-06 13:35:53 | 1 | 2026-03-22 17:35:34.095425 |
| YY26012100089903 | ALIAS-RESPIRA男款短袖连体衣-头版-YS9251MDIO | M | 刘莹滢 | 320252 | 359941 | 2026-02-06 13:35:53 | 3 | 2026-03-22 17:35:34.093826 |
| MY26011700019906 | B3L Bozza2 2196男款背带短裤-二版-YS2196MO | 2XL | 胡美英 | 319273 | 359942 | 2026-02-06 13:38:02 | 1 | 2026-03-22 17:35:34.092263 |
| MY26011700019905 | B3L Bozza2 2196男款背带短裤-二版-YS2196MO | XL | 胡美英 | 319273 | 359942 | 2026-02-06 13:38:02 | 2 | 2026-03-22 17:35:34.090709 |
| MY26011700019904 | B3L Bozza2 2196男款背带短裤-二版-YS2196MO | L | 胡美英 | 319273 | 359942 | 2026-02-06 13:38:02 | 5 | 2026-03-22 17:35:34.089222 |
| MY26011700019903 | B3L Bozza2 2196男款背带短裤-二版-YS2196MO | M | 胡美英 | 319273 | 359942 | 2026-02-06 13:38:02 | 5 | 2026-03-22 17:35:34.087582 |
| MY26011700019902 | B3L Bozza2 2196男款背带短裤-二版-YS2196MO | S | 胡美英 | 319273 | 359942 | 2026-02-06 13:38:02 | 4 | 2026-03-22 17:35:34.086055 |
| MY26011700019901 | B3L Bozza2 2196男款背带短裤-二版-YS2196MO | XS | 胡美英 | 319273 | 359942 | 2026-02-06 13:38:02 | 2 | 2026-03-22 17:35:34.084533 |
| RX26011000359905 | 2022Stelvio-C13护臂-二版-4203M | XL | 袁日仙 | 318898 | 359943 | 2026-02-06 13:38:28 | 6 | 2026-03-22 17:35:34.082995 |