到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DZ251104279907 | 惠骑2025-2男款短上衣 | 3XL | 何佳欣 | 326672 | 367170 | 2026-03-06 11:24:34 | 1 | 2026-03-22 17:35:27.591484 |
| DZ251104279906 | 惠骑2025-2男款短上衣 | 2XL | 何佳欣 | 326672 | 367170 | 2026-03-06 11:24:34 | 1 | 2026-03-22 17:35:27.589979 |
| DZ251104279904 | 惠骑2025-2男款短上衣 | L | 何佳欣 | 326672 | 367170 | 2026-03-06 11:24:34 | 1 | 2026-03-22 17:35:27.588271 |
| DZ251104279903 | 惠骑2025-2男款短上衣 | M | 何佳欣 | 326672 | 367170 | 2026-03-06 11:24:34 | 2 | 2026-03-22 17:35:27.586215 |
| DZ251104279902 | 惠骑2025-2男款短上衣 | S | 何佳欣 | 326672 | 367170 | 2026-03-06 11:24:34 | 2 | 2026-03-22 17:35:27.584533 |
| DZ251104179902 | 赤道单车2025-白紫女款短上衣 | S | 何佳欣 | 326681 | 367172 | 2026-03-06 11:25:14 | 1 | 2026-03-22 17:35:27.582875 |
| DZ251103719907 | 赤道单车2025-白紫短上衣 | 3XL | 何佳欣 | 326681 | 367172 | 2026-03-06 11:25:14 | 1 | 2026-03-22 17:35:27.581035 |
| DZ251103719906 | 赤道单车2025-白紫短上衣 | 2XL | 何佳欣 | 326681 | 367172 | 2026-03-06 11:25:14 | 1 | 2026-03-22 17:35:27.579296 |
| DZ251103719904 | 赤道单车2025-白紫短上衣 | L | 何佳欣 | 326681 | 367172 | 2026-03-06 11:25:14 | 2 | 2026-03-22 17:35:27.577606 |
| DZ251103719903 | 赤道单车2025-白紫短上衣 | M | 何佳欣 | 326681 | 367172 | 2026-03-06 11:25:14 | 4 | 2026-03-22 17:35:27.576076 |
| 1231220019904 | 速风(黑色)背带短裤 | L | 何佳欣 | 323425 | 367173 | 2026-03-06 11:25:48 | 8 | 2026-03-22 17:35:27.569309 |
| 1231220019903 | 速风(黑色)背带短裤 | M | 何佳欣 | 323425 | 367173 | 2026-03-06 11:25:48 | 6 | 2026-03-22 17:35:27.567764 |
| 1231220019902 | 速风(黑色)背带短裤 | S | 何佳欣 | 323425 | 367173 | 2026-03-06 11:25:48 | 6 | 2026-03-22 17:35:27.566215 |
| YY26020900029900 | Blackmile-AKROS接筒袜-头版-YS9940EC | F | 刘莹滢 | 326561 | 367174 | 2026-03-06 11:26:15 | 62 | 2026-03-22 17:35:27.564682 |
| BH26020400249911 | Vector TRPH Pink 26男款短上衣-头版-YS9699MLK | 2XS | 凌碧红 | 325091 | 367175 | 2026-03-06 11:27:00 | 1 | 2026-03-22 17:35:27.563129 |
| BH26020900019905 | WT HCE White IRI男款T恤-头版-YS9681MO | XL | 凌碧红 | 326399 | 367176 | 2026-03-06 11:27:23 | 1 | 2026-03-22 17:35:27.561334 |
| BH26020900019904 | WT HCE White IRI男款T恤-头版-YS9681MO | L | 凌碧红 | 326399 | 367176 | 2026-03-06 11:27:23 | 5 | 2026-03-22 17:35:27.559703 |
| BH26020900019903 | WT HCE White IRI男款T恤-头版-YS9681MO | M | 凌碧红 | 326399 | 367176 | 2026-03-06 11:27:23 | 4 | 2026-03-22 17:35:27.557668 |
| RX26020900059906 | GC-Chemchamp 26 new男款抓绒长上衣-头版-YS9057MCUO | 2XL | 袁日仙 | 326420 | 367178 | 2026-03-06 11:28:14 | 1 | 2026-03-22 17:35:27.555400 |
| RX26020900059905 | GC-Chemchamp 26 new男款抓绒长上衣-头版-YS9057MCUO | XL | 袁日仙 | 326420 | 367178 | 2026-03-06 11:28:14 | 2 | 2026-03-22 17:35:27.552934 |