到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| YY25122200089906 | MUK0972男款短上衣-头版-CD034MVNO | 2XL | 刘莹滢 | 314142 | 349083 | 2026-01-06 15:50:51 | 1 | 2026-03-22 17:35:53.487529 |
| YY25122200089905 | MUK0972男款短上衣-头版-CD034MVNO | XL | 刘莹滢 | 314142 | 349083 | 2026-01-06 15:50:51 | 1 | 2026-03-22 17:35:53.485991 |
| YY25122200089904 | MUK0972男款短上衣-头版-CD034MVNO | L | 刘莹滢 | 314142 | 349083 | 2026-01-06 15:50:51 | 2 | 2026-03-22 17:35:53.484432 |
| YY25122200089903 | MUK0972男款短上衣-头版-CD034MVNO | M | 刘莹滢 | 314142 | 349083 | 2026-01-06 15:50:51 | 1 | 2026-03-22 17:35:53.482763 |
| YY25122200089902 | MUK0972男款短上衣-头版-CD034MVNO | S | 刘莹滢 | 314142 | 349083 | 2026-01-06 15:50:51 | 1 | 2026-03-22 17:35:53.481126 |
| YY25122200089901 | MUK0972男款短上衣-头版-CD034MVNO | XS | 刘莹滢 | 314142 | 349083 | 2026-01-06 15:50:51 | 1 | 2026-03-22 17:35:53.479541 |
| ZT25122200059904 | TriRig 26 LW男款短上衣-头版-YS9409MEKO | L | 曾亭 | 313662 | 349086 | 2026-01-06 15:52:19 | 2 | 2026-03-22 17:35:53.477977 |
| ZT25122200039905 | TriRig 26男款短上衣-头版-YS9409MEKO | XL | 曾亭 | 313662 | 349086 | 2026-01-06 15:52:19 | 1 | 2026-03-22 17:35:53.476432 |
| ZT25122200039904 | TriRig 26男款短上衣-头版-YS9409MEKO | L | 曾亭 | 313662 | 349086 | 2026-01-06 15:52:19 | 1 | 2026-03-22 17:35:53.474841 |
| ZT25122200319905 | TriRig 26 Pro男款背带短裤-头版-YS2025MXF | XL | 曾亭 | 313296 | 349088 | 2026-01-06 15:52:50 | 1 | 2026-03-22 17:35:53.473204 |
| ZT25122200319904 | TriRig 26 Pro男款背带短裤-头版-YS2025MXF | L | 曾亭 | 313296 | 349088 | 2026-01-06 15:52:50 | 2 | 2026-03-22 17:35:53.471463 |
| ZT25122200319903 | TriRig 26 Pro男款背带短裤-头版-YS2025MXF | M | 曾亭 | 313296 | 349088 | 2026-01-06 15:52:50 | 1 | 2026-03-22 17:35:53.469782 |
| RX25051600039902 | SG-Goats&Gorillas男款防风背心-YS9826MDO | S | 袁日仙 | 309013 | 349089 | 2026-01-06 15:53:14 | 1 | 2026-03-22 17:35:53.467712 |
| DZ251107019905 | 杜卡迪HRC男款短上衣 | XL | 彭子菲 | 315038 | 349155 | 2026-01-06 17:42:47 | 1 | 2026-03-22 17:35:53.466041 |
| 1261110209909 | 无界普蓝短上衣 | 5XL | 林树 | 285898 | 349157 | 2026-01-06 17:43:00 | 5 | 2026-03-22 17:35:53.464515 |
| 1261110209908 | 无界普蓝短上衣 | 4XL | 林树 | 285898 | 349157 | 2026-01-06 17:43:00 | 5 | 2026-03-22 17:35:53.463021 |
| 1261110209906 | 无界普蓝短上衣 | 2XL | 林树 | 285898 | 349157 | 2026-01-06 17:43:00 | 10 | 2026-03-22 17:35:53.461460 |
| 1261110209907 | 无界普蓝短上衣 | 3XL | 林树 | 285898 | 349157 | 2026-01-06 17:44:00 | 10 | 2026-03-22 17:35:53.461371 |
| 1261110209905 | 无界普蓝短上衣 | XL | 林树 | 285898 | 349157 | 2026-01-06 17:43:00 | 20 | 2026-03-22 17:35:53.458840 |
| 1261110209904 | 无界普蓝短上衣 | L | 林树 | 285898 | 349157 | 2026-01-06 17:43:00 | 20 | 2026-03-22 17:35:53.457293 |