到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| RX26011000189904 | NSBT男款短上衣-头版-YS9410MB | L | 袁日仙 | 317634 | 356532 | 2026-01-27 18:11:21 | 1 | 2026-03-22 17:35:41.552409 |
| RX26011400029903 | CUPCKE-26black pink-test女款短袖连体衣-头版-YS9229WXV | M | 袁日仙 | 320151 | 356534 | 2026-01-27 18:17:02 | 1 | 2026-03-22 17:35:41.499498 |
| DQ25071500029902 | RV-BLACK女款运动裙裤-YS9357WA | S | 吕丹琪 | 320153 | 356535 | 2026-01-27 18:18:57 | 1 | 2026-03-22 17:35:41.497955 |
| DQ25071500029901 | RV-BLACK女款运动裙裤-YS9357WA | XS | 吕丹琪 | 320153 | 356535 | 2026-01-27 18:18:57 | 1 | 2026-03-22 17:35:41.496364 |
| DQ25103100029902 | RV-LIGHTPINK女款短裤-头版-YS9190WBO | S | 吕丹琪 | 320153 | 356535 | 2026-01-27 18:18:57 | 1 | 2026-03-22 17:35:41.494819 |
| DQ25103100029901 | RV-LIGHTPINK女款短裤-头版-YS9190WBO | XS | 吕丹琪 | 320153 | 356535 | 2026-01-27 18:18:57 | 1 | 2026-03-22 17:35:41.493276 |
| DQ25103100039902 | RV-PINK女款短裤-头版-YS9190WBO | S | 吕丹琪 | 320153 | 356535 | 2026-01-27 18:18:57 | 1 | 2026-03-22 17:35:41.491730 |
| DQ25103100039901 | RV-PINK女款短裤-头版-YS9190WBO | XS | 吕丹琪 | 320153 | 356535 | 2026-01-27 18:18:57 | 1 | 2026-03-22 17:35:41.490191 |
| DZ261200089901 | 東京熱車隊 2025女款长上衣 | XS | 何佳欣 | 315795 | 356664 | 2026-01-28 11:30:44 | 1 | 2026-03-22 17:35:41.488407 |
| DZ261200089902 | 東京熱車隊 2025女款长上衣 | S | 何佳欣 | 315795 | 356664 | 2026-01-28 11:30:44 | 1 | 2026-03-22 17:35:41.486884 |
| DZ261100159906 | TRCC 2026男款短上衣 | 2XL | 何佳欣 | 315809 | 356665 | 2026-01-28 11:31:31 | 2 | 2026-03-22 17:35:41.485329 |
| DZ261100159905 | TRCC 2026男款短上衣 | XL | 何佳欣 | 315809 | 356665 | 2026-01-28 11:31:31 | 5 | 2026-03-22 17:35:41.483826 |
| DZ261100159904 | TRCC 2026男款短上衣 | L | 何佳欣 | 315809 | 356665 | 2026-01-28 11:31:31 | 9 | 2026-03-22 17:35:41.482266 |
| DZ261100159903 | TRCC 2026男款短上衣 | M | 何佳欣 | 315809 | 356665 | 2026-01-28 11:31:31 | 8 | 2026-03-22 17:35:41.480728 |
| DZ261100159902 | TRCC 2026男款短上衣 | S | 何佳欣 | 315809 | 356665 | 2026-01-28 11:31:31 | 8 | 2026-03-22 17:35:41.479238 |
| DZ261100159901 | TRCC 2026男款短上衣 | XS | 何佳欣 | 315809 | 356665 | 2026-01-28 11:31:31 | 2 | 2026-03-22 17:35:41.477665 |
| 1231111389905 | 行者EVO蓝色短上衣 | XL | 黄婉婷 | 313439 | 356666 | 2026-01-28 11:32:01 | 20 | 2026-03-22 17:35:41.476158 |
| 1231111389907 | 行者EVO蓝色短上衣 | 3XL | 黄婉婷 | 313439 | 356666 | 2026-01-28 11:32:01 | 20 | 2026-03-22 17:35:41.474606 |
| 1231111389906 | 行者EVO蓝色短上衣 | 2XL | 黄婉婷 | 313439 | 356666 | 2026-01-28 11:32:01 | 20 | 2026-03-22 17:35:41.473016 |
| 1231110039907 | 行者EVO黑色短上衣 | 3XL | 黄婉婷 | 313439 | 356666 | 2026-01-28 11:32:01 | 20 | 2026-03-22 17:35:41.471364 |