到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| MJ26022800099902 | RADA GCT 2026男款短上衣-头版-YS9640MZDO | S | 庄镘洁 | 327079 | 373417 | 2026-03-17 10:28:41 | 1 | 2026-03-22 17:35:22.457705 |
| RX25120300189905 | BNECC Club 2022-C男款短上衣-二版-YS9408MY | XL | 袁日仙 | 327672 | 373420 | 2026-03-17 10:30:18 | 2 | 2026-03-22 17:35:22.454629 |
| RX25120300189904 | BNECC Club 2022-C男款短上衣-二版-YS9408MY | L | 袁日仙 | 327672 | 373420 | 2026-03-17 10:30:18 | 4 | 2026-03-22 17:35:22.452932 |
| MJ26022800049907 | RADA Major 2026男款短上衣-头版-YS9640MZDO | 3XL | 庄镘洁 | 327541 | 373421 | 2026-03-17 10:30:48 | 2 | 2026-03-22 17:35:22.450282 |
| MJ26022800049906 | RADA Major 2026男款短上衣-头版-YS9640MZDO | 2XL | 庄镘洁 | 327541 | 373421 | 2026-03-17 10:30:48 | 5 | 2026-03-22 17:35:22.397266 |
| MJ26022800049905 | RADA Major 2026男款短上衣-头版-YS9640MZDO | XL | 庄镘洁 | 327541 | 373421 | 2026-03-17 10:30:48 | 2 | 2026-03-22 17:35:22.395671 |
| MJ26022800049904 | RADA Major 2026男款短上衣-头版-YS9640MZDO | L | 庄镘洁 | 327541 | 373421 | 2026-03-17 10:30:48 | 1 | 2026-03-22 17:35:22.394118 |
| MJ26022800049903 | RADA Major 2026男款短上衣-头版-YS9640MZDO | M | 庄镘洁 | 327541 | 373421 | 2026-03-17 10:30:48 | 1 | 2026-03-22 17:35:22.392407 |
| MJ26030400059906 | TCHACO EXXONMOBIL26男款POLO衫-头版-YS9450MO | 2XL | 庄镘洁 | 328664 | 373426 | 2026-03-17 10:31:37 | 20 | 2026-03-22 17:35:22.389261 |
| MJ26030400059905 | TCHACO EXXONMOBIL26男款POLO衫-头版-YS9450MO | XL | 庄镘洁 | 328664 | 373426 | 2026-03-17 10:31:37 | 25 | 2026-03-22 17:35:22.387665 |
| MJ26030400059904 | TCHACO EXXONMOBIL26男款POLO衫-头版-YS9450MO | L | 庄镘洁 | 328664 | 373426 | 2026-03-17 10:31:37 | 25 | 2026-03-22 17:35:22.385961 |
| MJ26030400059903 | TCHACO EXXONMOBIL26男款POLO衫-头版-YS9450MO | M | 庄镘洁 | 328664 | 373426 | 2026-03-17 10:31:37 | 20 | 2026-03-22 17:35:22.384371 |
| MJ26030400059902 | TCHACO EXXONMOBIL26男款POLO衫-头版-YS9450MO | S | 庄镘洁 | 328664 | 373426 | 2026-03-17 10:31:37 | 10 | 2026-03-22 17:35:22.382491 |
| YL26013100029906 | NCRC Green男款长上衣-头版-YS8228MA | 2XL | 甘雅玲 | 332103 | 373433 | 2026-03-17 10:35:53 | 2 | 2026-03-22 17:35:22.378557 |
| YL26013100029905 | NCRC Green男款长上衣-头版-YS8228MA | XL | 甘雅玲 | 332103 | 373433 | 2026-03-17 10:35:53 | 5 | 2026-03-22 17:35:22.376585 |
| YL26013100029904 | NCRC Green男款长上衣-头版-YS8228MA | L | 甘雅玲 | 332103 | 373433 | 2026-03-17 10:35:53 | 6 | 2026-03-22 17:35:22.374577 |
| YL26013100029903 | NCRC Green男款长上衣-头版-YS8228MA | M | 甘雅玲 | 332103 | 373433 | 2026-03-17 10:35:53 | 6 | 2026-03-22 17:35:22.372620 |
| YL26013100029902 | NCRC Green男款长上衣-头版-YS8228MA | S | 甘雅玲 | 332103 | 373433 | 2026-03-17 10:35:53 | 4 | 2026-03-22 17:35:22.370612 |
| YL26013100029901 | NCRC Green男款长上衣-头版-YS8228MA | XS | 甘雅玲 | 332103 | 373433 | 2026-03-17 10:35:53 | 2 | 2026-03-22 17:35:22.368586 |
| 1261110679909 | 数码绽放米灰短上衣 | 5XL | 林树 | 316489 | 373576 | 2026-03-17 15:20:00 | 20 | 2026-03-22 17:35:22.366527 |