到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| JN26011000089904 | PW BHY redblue女款短袖连体衣-头版-YS9251WKCO | L | 陈锦娜 | 318323 | 359268 | 2026-02-04 16:19:58 | 1 | 2026-03-22 17:35:35.789205 |
| RX26011700069904 | CUPCKE-Respect女款抓绒长上衣-头版-YS9057WU | L | 袁日仙 | 319259 | 359269 | 2026-02-04 16:20:30 | 1 | 2026-03-22 17:35:35.787231 |
| MY26011700029905 | B3L Bozza2 2078男款背带短裤-二版-YS2078MO | XL | 胡美英 | 319273 | 359270 | 2026-02-04 16:21:36 | 1 | 2026-03-22 17:35:35.785330 |
| MY26011700029904 | B3L Bozza2 2078男款背带短裤-二版-YS2078MO | L | 胡美英 | 319273 | 359270 | 2026-02-04 16:21:36 | 4 | 2026-03-22 17:35:35.783399 |
| MY26011700029903 | B3L Bozza2 2078男款背带短裤-二版-YS2078MO | M | 胡美英 | 319273 | 359270 | 2026-02-04 16:21:36 | 5 | 2026-03-22 17:35:35.781725 |
| MY26011700029902 | B3L Bozza2 2078男款背带短裤-二版-YS2078MO | S | 胡美英 | 319273 | 359270 | 2026-02-04 16:21:36 | 4 | 2026-03-22 17:35:35.780194 |
| MY26011700029901 | B3L Bozza2 2078男款背带短裤-二版-YS2078MO | XS | 胡美英 | 319273 | 359270 | 2026-02-04 16:21:36 | 1 | 2026-03-22 17:35:35.778635 |
| RX25112200219905 | LBCC-25AIR-Black女款背带短裤-二版-YS2151WAO | XL | 袁日仙 | 307288 | 359271 | 2026-02-04 16:22:22 | 1 | 2026-03-22 17:35:35.777058 |
| RX25112200219904 | LBCC-25AIR-Black女款背带短裤-二版-YS2151WAO | L | 袁日仙 | 307288 | 359271 | 2026-02-04 16:22:22 | 5 | 2026-03-22 17:35:35.775354 |
| RX25112200219903 | LBCC-25AIR-Black女款背带短裤-二版-YS2151WAO | M | 袁日仙 | 307288 | 359271 | 2026-02-04 16:22:22 | 21 | 2026-03-22 17:35:35.773664 |
| RX25112200219902 | LBCC-25AIR-Black女款背带短裤-二版-YS2151WAO | S | 袁日仙 | 307288 | 359271 | 2026-02-04 16:22:22 | 15 | 2026-03-22 17:35:35.772159 |
| RX25112200219901 | LBCC-25AIR-Black女款背带短裤-二版-YS2151WAO | XS | 袁日仙 | 307288 | 359271 | 2026-02-04 16:22:22 | 14 | 2026-03-22 17:35:35.770620 |
| ZT26012100179901 | Fit4-2 sport女款短上衣-头版-YS9409WO | XS | 曾亭 | 320381 | 359272 | 2026-02-04 16:22:44 | 1 | 2026-03-22 17:35:35.769126 |
| LF25072400239903 | MILES-PINK MILES男款短上衣-YS8008M | M | 罗兰方 | 319003 | 359273 | 2026-02-04 16:23:06 | 1 | 2026-03-22 17:35:35.767508 |
| LF25072400239902 | MILES-PINK MILES男款短上衣-YS8008M | S | 罗兰方 | 319003 | 359273 | 2026-02-04 16:23:06 | 1 | 2026-03-22 17:35:35.765947 |
| BH26011700069903 | LBW 26 CC女款长上衣-头版-YS9640WPAO | M | 凌碧红 | 320245 | 359274 | 2026-02-04 16:25:55 | 1 | 2026-03-22 17:35:35.764409 |
| YL26012100039904 | SYLBS 2026 TYG男款短上衣-头版-YS9640MY | L | 甘雅玲 | 320643 | 359275 | 2026-02-04 16:26:18 | 1 | 2026-03-22 17:35:35.762865 |
| YL26012100039903 | SYLBS 2026 TYG男款短上衣-头版-YS9640MY | M | 甘雅玲 | 320643 | 359275 | 2026-02-04 16:26:18 | 1 | 2026-03-22 17:35:35.761359 |
| YL26012100039902 | SYLBS 2026 TYG男款短上衣-头版-YS9640MY | S | 甘雅玲 | 320643 | 359275 | 2026-02-04 16:26:18 | 5 | 2026-03-22 17:35:35.759831 |
| YL26012100039901 | SYLBS 2026 TYG男款短上衣-头版-YS9640MY | XS | 甘雅玲 | 320643 | 359275 | 2026-02-04 16:26:18 | 7 | 2026-03-22 17:35:35.758263 |