到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25122000309902 | Lemmonaid Sunset女款背带短裤-头版-YS9113WZ | S | 曾亭 | 313043 | 353130 | 2026-01-17 17:26:36 | 1 | 2026-03-22 17:35:47.599496 |
| ZT25122000299904 | Lemmonaid Sunset Cargo男款背带短裤-头版-YS9153MGB | L | 曾亭 | 313043 | 353130 | 2026-01-17 17:26:36 | 1 | 2026-03-22 17:35:47.597923 |
| ZT26010700369904 | ELEVEN 26 Elite男款背带长裤-头版-YS2040MCO | L | 曾亭 | 316862 | 353131 | 2026-01-17 17:26:55 | 4 | 2026-03-22 17:35:47.596330 |
| DZ211400189904 | Hero经典款-3-2022黑色防风背心 | L | 黄伟懿 | 313434 | 353141 | 2026-01-17 17:50:13 | 1 | 2026-03-22 17:35:47.594679 |
| DZ211400189902 | Hero经典款-3-2022黑色防风背心 | S | 黄伟懿 | 313434 | 353141 | 2026-01-17 17:50:13 | 1 | 2026-03-22 17:35:47.593084 |
| DZ211400189901 | Hero经典款-3-2022黑色防风背心 | XS | 黄伟懿 | 313434 | 353141 | 2026-01-17 17:50:13 | 3 | 2026-03-22 17:35:47.591504 |
| RX25112200179905 | LBCC-BAROUDEUR 25Sand男款背带短裤-二版-YS9134MIBO | XL | 袁日仙 | 306464 | 353143 | 2026-01-17 17:51:51 | 15 | 2026-03-22 17:35:47.589851 |
| RX25112200179904 | LBCC-BAROUDEUR 25Sand男款背带短裤-二版-YS9134MIBO | L | 袁日仙 | 306464 | 353143 | 2026-01-17 17:51:51 | 31 | 2026-03-22 17:35:47.588225 |
| RX25112200179903 | LBCC-BAROUDEUR 25Sand男款背带短裤-二版-YS9134MIBO | M | 袁日仙 | 306464 | 353143 | 2026-01-17 17:51:51 | 39 | 2026-03-22 17:35:47.586559 |
| RX25112200179902 | LBCC-BAROUDEUR 25Sand男款背带短裤-二版-YS9134MIBO | S | 袁日仙 | 306464 | 353143 | 2026-01-17 17:51:51 | 28 | 2026-03-22 17:35:47.585017 |
| RX25112200179901 | LBCC-BAROUDEUR 25Sand男款背带短裤-二版-YS9134MIBO | XS | 袁日仙 | 306464 | 353143 | 2026-01-17 17:51:51 | 13 | 2026-03-22 17:35:47.583403 |
| RX25112200179911 | LBCC-BAROUDEUR 25Sand男款背带短裤-二版-YS9134MIBO | 2XS | 袁日仙 | 306464 | 353143 | 2026-01-17 17:51:51 | 2 | 2026-03-22 17:35:47.581816 |
| RX25112200139905 | LBCC-BAROUDEUR 25Sand女款背带短裤-二版-YS9115WDCO | XL | 袁日仙 | 306464 | 353143 | 2026-01-17 17:51:51 | 7 | 2026-03-22 17:35:47.580102 |
| RX25112200139904 | LBCC-BAROUDEUR 25Sand女款背带短裤-二版-YS9115WDCO | L | 袁日仙 | 306464 | 353143 | 2026-01-17 17:51:51 | 41 | 2026-03-22 17:35:47.578138 |
| RX25112200139903 | LBCC-BAROUDEUR 25Sand女款背带短裤-二版-YS9115WDCO | M | 袁日仙 | 306464 | 353143 | 2026-01-17 17:51:51 | 87 | 2026-03-22 17:35:47.576567 |
| RX25112200139902 | LBCC-BAROUDEUR 25Sand女款背带短裤-二版-YS9115WDCO | S | 袁日仙 | 306464 | 353143 | 2026-01-17 17:51:51 | 97 | 2026-03-22 17:35:47.574984 |
| RX25112200139901 | LBCC-BAROUDEUR 25Sand女款背带短裤-二版-YS9115WDCO | XS | 袁日仙 | 306464 | 353143 | 2026-01-17 17:51:51 | 60 | 2026-03-22 17:35:47.573380 |
| RX25112200139911 | LBCC-BAROUDEUR 25Sand女款背带短裤-二版-YS9115WDCO | 2XS | 袁日仙 | 306464 | 353143 | 2026-01-17 17:51:51 | 8 | 2026-03-22 17:35:47.571764 |
| LF26011000089903 | MB-DARK BROWN女款短上衣-头版-YS9640WED | M | 罗兰方 | 317689 | 353145 | 2026-01-17 17:53:33 | 1 | 2026-03-22 17:35:47.570161 |
| ZT26011400019904 | Ale Speed男款短上衣-三版-YS9842MQAO | L | 曾亭 | 317690 | 353147 | 2026-01-17 17:54:30 | 1 | 2026-03-22 17:35:47.568564 |