到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| 1261220079906 | 闪特黑粉背带短裤 | 2XL | 林树 | 316473 | 359235 | 2026-03-07 10:28:00 | 35 | 2026-03-22 17:35:35.958223 |
| 1261220079905 | 闪特黑粉背带短裤 | XL | 林树 | 316473 | 359235 | 2026-03-07 10:28:00 | 60 | 2026-03-22 17:35:35.958222 |
| 1261220079904 | 闪特黑粉背带短裤 | L | 林树 | 316473 | 359235 | 2026-03-07 10:28:00 | 60 | 2026-03-22 17:35:35.958220 |
| 1261220079903 | 闪特黑粉背带短裤 | M | 林树 | 316473 | 359235 | 2026-03-07 10:28:00 | 60 | 2026-03-22 17:35:35.958218 |
| 1261220079902 | 闪特黑粉背带短裤 | S | 林树 | 316473 | 359235 | 2026-03-07 10:28:00 | 35 | 2026-03-22 17:35:35.958215 |
| DZ251000909905 | 织纹黑武士 2025短袖连体衣 | XL | 何佳欣 | 318174 | 359253 | 2026-02-04 16:11:10 | 1 | 2026-03-22 17:35:35.951147 |
| DZ251000909904 | 织纹黑武士 2025短袖连体衣 | L | 何佳欣 | 318174 | 359253 | 2026-02-04 16:11:10 | 3 | 2026-03-22 17:35:35.899690 |
| 1231600879900 | 2023-WEEKEND(黑色)小布帽 | F | 黄婉婷 | 316951 | 359254 | 2026-02-04 16:12:31 | 8 | 2026-03-22 17:35:35.898154 |
| WT26011400019902 | Rackd Armidillo女款背带短裤-头版-YS9163WO | S | 黄婉婷 | 319002 | 359255 | 2026-02-04 16:13:00 | 1 | 2026-03-22 17:35:35.896521 |
| ZT26011700499904 | BH 26 blue Speed男款短上衣-头版-YS9842MEO | L | 曾亭 | 320074 | 359257 | 2026-02-04 16:13:23 | 1 | 2026-03-22 17:35:35.895003 |
| RX2412200089905 | LBCC-25AIR-Black男款背带短裤-YS2151MO | XL | 袁日仙 | 307288 | 359259 | 2026-02-04 16:13:49 | 4 | 2026-03-22 17:35:35.893469 |
| RX2412200089904 | LBCC-25AIR-Black男款背带短裤-YS2151MO | L | 袁日仙 | 307288 | 359259 | 2026-02-04 16:13:49 | 12 | 2026-03-22 17:35:35.891671 |
| RX2412200089903 | LBCC-25AIR-Black男款背带短裤-YS2151MO | M | 袁日仙 | 307288 | 359259 | 2026-02-04 16:13:49 | 16 | 2026-03-22 17:35:35.889705 |
| RX2412200089902 | LBCC-25AIR-Black男款背带短裤-YS2151MO | S | 袁日仙 | 307288 | 359259 | 2026-02-04 16:13:49 | 16 | 2026-03-22 17:35:35.888221 |
| DQ2404220199906 | LIQUIGAS 2012 (EU)男款短上衣-CD034MVO | 2XL | 吕丹琪 | 319902 | 359260 | 2026-02-04 16:14:18 | 8 | 2026-03-22 17:35:35.886558 |
| DQ2404220199905 | LIQUIGAS 2012 (EU)男款短上衣-CD034MVO | XL | 吕丹琪 | 319902 | 359260 | 2026-02-04 16:14:18 | 20 | 2026-03-22 17:35:35.884973 |
| DQ2404220199904 | LIQUIGAS 2012 (EU)男款短上衣-CD034MVO | L | 吕丹琪 | 319902 | 359260 | 2026-02-04 16:14:18 | 20 | 2026-03-22 17:35:35.883432 |
| DQ2404220199903 | LIQUIGAS 2012 (EU)男款短上衣-CD034MVO | M | 吕丹琪 | 319902 | 359260 | 2026-02-04 16:14:18 | 8 | 2026-03-22 17:35:35.881904 |
| DQ2406050139906 | MAPEI (EU)男款短上衣-CD034MVO | 2XL | 吕丹琪 | 319902 | 359260 | 2026-02-04 16:14:18 | 5 | 2026-03-22 17:35:35.879975 |
| DQ2406050139905 | MAPEI (EU)男款短上衣-CD034MVO | XL | 吕丹琪 | 319902 | 359260 | 2026-02-04 16:14:18 | 10 | 2026-03-22 17:35:35.878400 |