到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| YL26011000049907 | MM Southside男款慢跑背心-头版-YS555MDT | 3XL | 甘雅玲 | 318227 | 355478 | 2026-01-24 16:16:20 | 1 | 2026-03-22 17:35:43.378967 |
| YL26011000049905 | MM Southside男款慢跑背心-头版-YS555MDT | XL | 甘雅玲 | 318227 | 355478 | 2026-01-24 16:16:20 | 6 | 2026-03-22 17:35:43.377411 |
| YL26011000049904 | MM Southside男款慢跑背心-头版-YS555MDT | L | 甘雅玲 | 318227 | 355478 | 2026-01-24 16:16:20 | 11 | 2026-03-22 17:35:43.375815 |
| YL26011000049903 | MM Southside男款慢跑背心-头版-YS555MDT | M | 甘雅玲 | 318227 | 355478 | 2026-01-24 16:16:20 | 3 | 2026-03-22 17:35:43.374251 |
| YL26011000049902 | MM Southside男款慢跑背心-头版-YS555MDT | S | 甘雅玲 | 318227 | 355478 | 2026-01-24 16:16:20 | 2 | 2026-03-22 17:35:43.372629 |
| ZT26011000829905 | MUMU Maroon 26男款背带短裤-头版-YS9153MZP | XL | 曾亭 | 318315 | 355479 | 2026-01-24 16:16:45 | 3 | 2026-03-22 17:35:43.371042 |
| ZT26011000829904 | MUMU Maroon 26男款背带短裤-头版-YS9153MZP | L | 曾亭 | 318315 | 355479 | 2026-01-24 16:16:45 | 7 | 2026-03-22 17:35:43.369409 |
| ZT26011000829903 | MUMU Maroon 26男款背带短裤-头版-YS9153MZP | M | 曾亭 | 318315 | 355479 | 2026-01-24 16:16:45 | 5 | 2026-03-22 17:35:43.367899 |
| ZT26011000819904 | Elite black white女款短裤-二版-YS9121W | L | 曾亭 | 318314 | 355480 | 2026-01-24 16:17:39 | 6 | 2026-03-22 17:35:43.366282 |
| ZT26011000819902 | Elite black white女款短裤-二版-YS9121W | S | 曾亭 | 318314 | 355480 | 2026-01-24 16:17:39 | 6 | 2026-03-22 17:35:43.364772 |
| ZT26011000819901 | Elite black white女款短裤-二版-YS9121W | XS | 曾亭 | 318314 | 355480 | 2026-01-24 16:17:39 | 3 | 2026-03-22 17:35:43.363251 |
| ZT2411050249901 | MUMU Winter24抓绒护臂-YS9935MO | XS | 曾亭 | 319258 | 355481 | 2026-01-24 16:18:07 | 9 | 2026-03-22 17:35:43.361662 |
| RX26011700059905 | CUPCKE-Respect男款T恤-头版-YS9068MDQT | XL | 袁日仙 | 319259 | 355489 | 2026-01-24 16:20:54 | 1 | 2026-03-22 17:35:43.360093 |
| RX26011700059904 | CUPCKE-Respect男款T恤-头版-YS9068MDQT | L | 袁日仙 | 319259 | 355489 | 2026-01-24 16:20:54 | 1 | 2026-03-22 17:35:43.356544 |
| RX26011700059903 | CUPCKE-Respect男款T恤-头版-YS9068MDQT | M | 袁日仙 | 319259 | 355489 | 2026-01-24 16:20:54 | 1 | 2026-03-22 17:35:43.354842 |
| RX26011700049904 | CUPCKE-Respect女款T恤-头版-YS9087WO | L | 袁日仙 | 319259 | 355489 | 2026-01-24 16:20:54 | 2 | 2026-03-22 17:35:43.353095 |
| RX26011700039903 | CUPCKE-Respect男款慢跑背心-头版-YS555MAFO | M | 袁日仙 | 319259 | 355489 | 2026-01-24 16:20:54 | 1 | 2026-03-22 17:35:43.350486 |
| RX26011700029904 | CUPCKE-Respect女款慢跑背心-头版-YS9457WAFO | L | 袁日仙 | 319259 | 355489 | 2026-01-24 16:20:54 | 1 | 2026-03-22 17:35:43.302205 |
| ZT25123001209903 | Momentous 26 Primo stars男款短上衣-头版-YS9470MYBO | M | 曾亭 | 315571 | 355503 | 2026-01-24 16:29:00 | 1 | 2026-03-22 17:35:43.300680 |
| 1231110099907 | 朝暮淡黄女款短上衣 | 3XL | 黄婉婷 | 313562 | 355538 | 2026-01-24 17:12:26 | 15 | 2026-03-22 17:35:43.299166 |