到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| YL26022800069912 | Trailrider yellow男款长上衣-头版-YS9492MXV | 3XS | 甘雅玲 | 329490 | 370812 | 2026-03-12 10:43:24 | 3 | 2026-03-22 17:35:24.567957 |
| YL26022800069918 | Trailrider yellow男款长上衣-头版-YS9492MXV | 4XS | 甘雅玲 | 329490 | 370812 | 2026-03-12 10:43:24 | 3 | 2026-03-22 17:35:24.566429 |
| YL26022800069919 | Trailrider yellow男款长上衣-头版-YS9492MXV | 5XS | 甘雅玲 | 329490 | 370812 | 2026-03-12 10:43:24 | 3 | 2026-03-22 17:35:24.564951 |
| YL26022800069920 | Trailrider yellow男款长上衣-头版-YS9492MXV | 6XS | 甘雅玲 | 329490 | 370812 | 2026-03-12 10:43:24 | 3 | 2026-03-22 17:35:24.563434 |
| ZT25121300229905 | PACE 25 LW男款长上衣-头版-YS9068MCDT | XL | 曾亭 | 330223 | 370813 | 2026-03-12 10:45:30 | 1 | 2026-03-22 17:35:24.561914 |
| ZT26022800399905 | Infinit 26 Yellow sport男款背带短裤-头版-YS9149MH | XL | 曾亭 | 328637 | 370814 | 2026-03-12 10:47:07 | 1 | 2026-03-22 17:35:24.560388 |
| ZT26022800399903 | Infinit 26 Yellow sport男款背带短裤-头版-YS9149MH | M | 曾亭 | 328637 | 370814 | 2026-03-12 10:47:07 | 1 | 2026-03-22 17:35:24.558807 |
| ZT26022800349904 | Infinit 26 Yellow Elite女款长上衣-头版-YS9851WO | L | 曾亭 | 328169 | 370817 | 2026-03-12 10:49:11 | 1 | 2026-03-22 17:35:24.557257 |
| ZT26022800349903 | Infinit 26 Yellow Elite女款长上衣-头版-YS9851WO | M | 曾亭 | 328169 | 370817 | 2026-03-12 10:49:11 | 1 | 2026-03-22 17:35:24.555661 |
| ZT25101700309905 | North Port男款防风背心-头版-YS9046MEO | XL | 曾亭 | 328847 | 370819 | 2026-03-12 10:49:40 | 1 | 2026-03-22 17:35:24.554071 |
| WT26022800099904 | AC-REBELDES 2026男款长上衣-头版-YS9409MBUO | L | 黄婉婷 | 328170 | 370820 | 2026-03-12 10:50:00 | 2 | 2026-03-22 17:35:24.551955 |
| WT26022800099903 | AC-REBELDES 2026男款长上衣-头版-YS9409MBUO | M | 黄婉婷 | 328170 | 370820 | 2026-03-12 10:50:00 | 1 | 2026-03-22 17:35:24.499968 |
| WT26022800099901 | AC-REBELDES 2026男款长上衣-头版-YS9409MBUO | XS | 黄婉婷 | 328170 | 370820 | 2026-03-12 10:50:00 | 2 | 2026-03-22 17:35:24.498368 |
| RX25022600219902 | Aleon-Ruedas SJM男款短袖连体衣-YS9230MKB | S | 袁日仙 | 326543 | 370822 | 2026-03-12 10:50:50 | 1 | 2026-03-22 17:35:24.496711 |
| MJ26022800109907 | TCHACO AMN男款POLO衫-头版-YS9450MO | 3XL | 庄镘洁 | 327407 | 370825 | 2026-03-12 10:51:38 | 2 | 2026-03-22 17:35:24.495197 |
| MJ26022800109906 | TCHACO AMN男款POLO衫-头版-YS9450MO | 2XL | 庄镘洁 | 327407 | 370825 | 2026-03-12 10:51:38 | 5 | 2026-03-22 17:35:24.493497 |
| MJ26022800109905 | TCHACO AMN男款POLO衫-头版-YS9450MO | XL | 庄镘洁 | 327407 | 370825 | 2026-03-12 10:51:38 | 11 | 2026-03-22 17:35:24.491797 |
| MJ26022800109904 | TCHACO AMN男款POLO衫-头版-YS9450MO | L | 庄镘洁 | 327407 | 370825 | 2026-03-12 10:51:38 | 8 | 2026-03-22 17:35:24.490156 |
| MJ26022800109903 | TCHACO AMN男款POLO衫-头版-YS9450MO | M | 庄镘洁 | 327407 | 370825 | 2026-03-12 10:51:38 | 6 | 2026-03-22 17:35:24.488589 |
| MJ26022800109902 | TCHACO AMN男款POLO衫-头版-YS9450MO | S | 庄镘洁 | 327407 | 370825 | 2026-03-12 10:51:38 | 4 | 2026-03-22 17:35:24.486730 |