到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT25123000919905 | Momentous 26抓绒护臂-头版-YS9935MO | XL | 曾亭 | 315368 | 351332 | 2026-01-13 11:10:40 | 1 | 2026-03-22 17:35:50.191038 |
| ZT25123000889904 | Momentous 26 LW男款T恤-头版-YS9068MT | L | 曾亭 | 315368 | 351332 | 2026-01-13 11:10:40 | 3 | 2026-03-22 17:35:50.189435 |
| ZT25123000889903 | Momentous 26 LW男款T恤-头版-YS9068MT | M | 曾亭 | 315368 | 351332 | 2026-01-13 11:10:40 | 2 | 2026-03-22 17:35:50.187905 |
| MJ25123000059906 | TCHACO SONANGOL26 Zipper男款POLO衫-头版-YS9450MCO | 2XL | 庄镘洁 | 315411 | 351333 | 2026-01-13 11:11:22 | 2 | 2026-03-22 17:35:50.186258 |
| MJ25123000059905 | TCHACO SONANGOL26 Zipper男款POLO衫-头版-YS9450MCO | XL | 庄镘洁 | 315411 | 351333 | 2026-01-13 11:11:22 | 2 | 2026-03-22 17:35:50.184651 |
| MJ25123000059904 | TCHACO SONANGOL26 Zipper男款POLO衫-头版-YS9450MCO | L | 庄镘洁 | 315411 | 351333 | 2026-01-13 11:11:22 | 2 | 2026-03-22 17:35:50.183041 |
| MJ25123000059903 | TCHACO SONANGOL26 Zipper男款POLO衫-头版-YS9450MCO | M | 庄镘洁 | 315411 | 351333 | 2026-01-13 11:11:22 | 2 | 2026-03-22 17:35:50.181388 |
| ZT25123000139902 | Picky 26 Tri女款短上衣-头版-YS9730WDO | S | 曾亭 | 314757 | 351334 | 2026-01-13 11:12:27 | 1 | 2026-03-22 17:35:50.179657 |
| ZT25123000819908 | Form 26 Grey男款短上衣-头版-YS9409MEKO | 4XL | 曾亭 | 315336 | 351335 | 2026-01-13 11:12:59 | 1 | 2026-03-22 17:35:50.177975 |
| ZT25123000819904 | Form 26 Grey男款短上衣-头版-YS9409MEKO | L | 曾亭 | 315336 | 351335 | 2026-01-13 11:12:59 | 1 | 2026-03-22 17:35:50.176302 |
| ZT25123000659904 | Form 25抓绒护腿-头版-YS9967MO | L | 曾亭 | 315329 | 351336 | 2026-01-13 11:13:29 | 1 | 2026-03-22 17:35:50.174533 |
| ZT25123000639908 | Form 26 Tri男款三铁背心-头版-YS9730MO | 4XL | 曾亭 | 315329 | 351336 | 2026-01-13 11:13:29 | 1 | 2026-03-22 17:35:50.172825 |
| ZT25123000639905 | Form 26 Tri男款三铁背心-头版-YS9730MO | XL | 曾亭 | 315329 | 351336 | 2026-01-13 11:13:29 | 1 | 2026-03-22 17:35:50.170925 |
| ZT25123000599903 | Form 26男款短上衣-头版-YS9409MEKO | M | 曾亭 | 315257 | 351351 | 2026-01-13 11:14:20 | 1 | 2026-03-22 17:35:50.169034 |
| ZT25123000599902 | Form 26男款短上衣-头版-YS9409MEKO | S | 曾亭 | 315257 | 351351 | 2026-01-13 11:14:20 | 1 | 2026-03-22 17:35:50.167381 |
| WT25121300129906 | 5Q-Green男款短上衣-头版-YS9470MCR | 2XL | 黄婉婷 | 310976 | 351352 | 2026-01-13 11:14:59 | 2 | 2026-03-22 17:35:50.165704 |
| WT25121300129905 | 5Q-Green男款短上衣-头版-YS9470MCR | XL | 黄婉婷 | 310976 | 351352 | 2026-01-13 11:14:59 | 3 | 2026-03-22 17:35:50.164159 |
| WT25121300129904 | 5Q-Green男款短上衣-头版-YS9470MCR | L | 黄婉婷 | 310976 | 351352 | 2026-01-13 11:14:59 | 5 | 2026-03-22 17:35:50.162509 |
| WT25121300129903 | 5Q-Green男款短上衣-头版-YS9470MCR | M | 黄婉婷 | 310976 | 351352 | 2026-01-13 11:14:59 | 5 | 2026-03-22 17:35:50.160696 |
| WT25121300129902 | 5Q-Green男款短上衣-头版-YS9470MCR | S | 黄婉婷 | 310976 | 351352 | 2026-01-13 11:14:59 | 6 | 2026-03-22 17:35:50.159020 |