到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| YL26012400029906 | NCRC 26-6男款T恤-头版-YS9068MKB | 2XL | 甘雅玲 | 320929 | 361517 | 2026-02-10 15:38:12 | 6 | 2026-03-22 17:35:30.894981 |
| YL26012400029905 | NCRC 26-6男款T恤-头版-YS9068MKB | XL | 甘雅玲 | 320929 | 361517 | 2026-02-10 15:38:12 | 14 | 2026-03-22 17:35:30.893355 |
| YL26012400029903 | NCRC 26-6男款T恤-头版-YS9068MKB | M | 甘雅玲 | 320929 | 361517 | 2026-02-10 15:38:12 | 25 | 2026-03-22 17:35:30.891755 |
| YL26012400029904 | NCRC 26-6男款T恤-头版-YS9068MKB | L | 甘雅玲 | 320929 | 361517 | 2026-02-10 15:38:12 | 24 | 2026-03-22 17:35:30.890110 |
| YL26012400029902 | NCRC 26-6男款T恤-头版-YS9068MKB | S | 甘雅玲 | 320929 | 361517 | 2026-02-10 15:38:12 | 9 | 2026-03-22 17:35:30.888267 |
| YL26012400029901 | NCRC 26-6男款T恤-头版-YS9068MKB | XS | 甘雅玲 | 320929 | 361517 | 2026-02-10 15:38:12 | 2 | 2026-03-22 17:35:30.886586 |
| ZT26013100629904 | PSU 26男款T恤-头版-YS9068MT | L | 曾亭 | 324535 | 361518 | 2026-02-10 15:38:37 | 2 | 2026-03-22 17:35:30.884924 |
| ZT26013100629903 | PSU 26男款T恤-头版-YS9068MT | M | 曾亭 | 324535 | 361518 | 2026-02-10 15:38:37 | 6 | 2026-03-22 17:35:30.883235 |
| ZT26013100629902 | PSU 26男款T恤-头版-YS9068MT | S | 曾亭 | 324535 | 361518 | 2026-02-10 15:38:37 | 1 | 2026-03-22 17:35:30.881533 |
| RX2404020439904 | Trizer 2024男款长上衣-YS9492MEP | L | 袁日仙 | 320897 | 361521 | 2026-02-10 15:40:03 | 2 | 2026-03-22 17:35:30.879566 |
| WT26012100079904 | RSG 2026护臂-头版-YS9964FO | L | 黄婉婷 | 320105 | 361522 | 2026-02-10 15:40:44 | 1 | 2026-03-22 17:35:30.877839 |
| WT26012100079903 | RSG 2026护臂-头版-YS9964FO | M | 黄婉婷 | 320105 | 361522 | 2026-02-10 15:40:44 | 4 | 2026-03-22 17:35:30.876184 |
| WT26012100079902 | RSG 2026护臂-头版-YS9964FO | S | 黄婉婷 | 320105 | 361522 | 2026-02-10 15:40:44 | 13 | 2026-03-22 17:35:30.874559 |
| WT26012100079901 | RSG 2026护臂-头版-YS9964FO | XS | 黄婉婷 | 320105 | 361522 | 2026-02-10 15:40:44 | 2 | 2026-03-22 17:35:30.872954 |
| LF2403040099909 | 24ASTANA男款背带短裤-CD038MD | 5XL | 刘莹滢 | 324248 | 361523 | 2026-02-10 15:41:52 | 2 | 2026-03-22 17:35:30.871069 |
| LF2403040099906 | 24ASTANA男款背带短裤-CD038MD | 2XL | 刘莹滢 | 324248 | 361523 | 2026-02-10 15:41:52 | 2 | 2026-03-22 17:35:30.869385 |
| LF2403040099905 | 24ASTANA男款背带短裤-CD038MD | XL | 刘莹滢 | 324248 | 361523 | 2026-02-10 15:41:52 | 4 | 2026-03-22 17:35:30.864548 |
| LF2403040099904 | 24ASTANA男款背带短裤-CD038MD | L | 刘莹滢 | 324248 | 361523 | 2026-02-10 15:41:52 | 5 | 2026-03-22 17:35:30.862471 |
| LF2403040099903 | 24ASTANA男款背带短裤-CD038MD | M | 刘莹滢 | 324248 | 361523 | 2026-02-10 15:41:52 | 4 | 2026-03-22 17:35:30.860776 |
| LF2403040099901 | 24ASTANA男款背带短裤-CD038MD | XS | 刘莹滢 | 324248 | 361523 | 2026-02-10 15:41:52 | 2 | 2026-03-22 17:35:30.859101 |