到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DZ261100099903 | W12-PRO SHORT JERSEY NCYU26男款短上衣 | M | 黄瑞辉 | 323431 | 370782 | 2026-03-12 10:34:42 | 2 | 2026-03-22 17:35:24.781119 |
| DZ261100099902 | W12-PRO SHORT JERSEY NCYU26男款短上衣 | S | 黄瑞辉 | 323431 | 370782 | 2026-03-12 10:34:42 | 2 | 2026-03-22 17:35:24.779223 |
| DZ261100099901 | W12-PRO SHORT JERSEY NCYU26男款短上衣 | XS | 黄瑞辉 | 323431 | 370782 | 2026-03-12 10:34:42 | 6 | 2026-03-22 17:35:24.777328 |
| DZ261100099911 | W12-PRO SHORT JERSEY NCYU26男款短上衣 | 2XS | 黄瑞辉 | 323431 | 370782 | 2026-03-12 10:34:42 | 1 | 2026-03-22 17:35:24.775472 |
| RX25112900579904 | CUPCKE-LasVegasTriClub男款POLO衫-二版-YS648MO | L | 袁日仙 | 329682 | 370784 | 2026-03-12 10:38:02 | 1 | 2026-03-22 17:35:24.773538 |
| DZ262200059911 | W-BIB EVO YRCT 26粉色男款背带短裤 | 2XS | 黄瑞辉 | 326475 | 370783 | 2026-03-19 15:44:02 | 3 | 2026-03-22 17:35:24.773324 |
| DZ252200739911 | W-BIB EVO YRCT 26灰色男款背带短裤 | 2XS | 黄瑞辉 | 326475 | 370783 | 2026-03-20 15:53:21 | 4 | 2026-03-22 17:35:24.773321 |
| RX25112900579902 | CUPCKE-LasVegasTriClub男款POLO衫-二版-YS648MO | S | 袁日仙 | 329682 | 370784 | 2026-03-12 10:38:02 | 1 | 2026-03-22 17:35:24.769559 |
| RX26030400319901 | CUPCKE-25LasVegasTriClub女款慢跑背心-二版-YS9457WAFO | XS | 袁日仙 | 329682 | 370784 | 2026-03-12 10:38:02 | 1 | 2026-03-22 17:35:24.768039 |
| YL26012400219906 | NCRC 2026 PRO Blue男款慢跑背心-头版-YS9347MHC | 2XL | 甘雅玲 | 322854 | 370785 | 2026-03-12 10:38:54 | 2 | 2026-03-22 17:35:24.766432 |
| YL26012400219905 | NCRC 2026 PRO Blue男款慢跑背心-头版-YS9347MHC | XL | 甘雅玲 | 322854 | 370785 | 2026-03-12 10:38:54 | 7 | 2026-03-22 17:35:24.764894 |
| YL26012400219904 | NCRC 2026 PRO Blue男款慢跑背心-头版-YS9347MHC | L | 甘雅玲 | 322854 | 370785 | 2026-03-12 10:38:54 | 14 | 2026-03-22 17:35:24.763163 |
| YL26012400219903 | NCRC 2026 PRO Blue男款慢跑背心-头版-YS9347MHC | M | 甘雅玲 | 322854 | 370785 | 2026-03-12 10:38:54 | 16 | 2026-03-22 17:35:24.761505 |
| YL26012400219902 | NCRC 2026 PRO Blue男款慢跑背心-头版-YS9347MHC | S | 甘雅玲 | 322854 | 370785 | 2026-03-12 10:38:54 | 9 | 2026-03-22 17:35:24.759974 |
| YL26012400219901 | NCRC 2026 PRO Blue男款慢跑背心-头版-YS9347MHC | XS | 甘雅玲 | 322854 | 370785 | 2026-03-12 10:38:54 | 2 | 2026-03-22 17:35:24.758391 |
| YL26012400199906 | NCRC 2026 PRO Black男款慢跑背心-头版-YS9347MHC | 2XL | 甘雅玲 | 322854 | 370785 | 2026-03-12 10:38:54 | 2 | 2026-03-22 17:35:24.756856 |
| YL26012400199905 | NCRC 2026 PRO Black男款慢跑背心-头版-YS9347MHC | XL | 甘雅玲 | 322854 | 370785 | 2026-03-12 10:38:54 | 7 | 2026-03-22 17:35:24.755231 |
| YL26012400199904 | NCRC 2026 PRO Black男款慢跑背心-头版-YS9347MHC | L | 甘雅玲 | 322854 | 370785 | 2026-03-12 10:38:54 | 14 | 2026-03-22 17:35:24.753289 |
| YL26012400199903 | NCRC 2026 PRO Black男款慢跑背心-头版-YS9347MHC | M | 甘雅玲 | 322854 | 370785 | 2026-03-12 10:38:54 | 16 | 2026-03-22 17:35:24.750583 |
| YL26012400199902 | NCRC 2026 PRO Black男款慢跑背心-头版-YS9347MHC | S | 甘雅玲 | 322854 | 370785 | 2026-03-12 10:38:54 | 9 | 2026-03-22 17:35:24.697698 |