到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| BH26031100069903 | WT CTC 26铁三男款短裤-头版-YS9262MKRO | M | 凌碧红 | 332876 | 375084 | 2026-03-19 17:59:38 | 1 | 2026-03-22 17:35:20.867040 |
| BH26031100039903 | WT CTC 26女款慢跑背心-头版-YS9346WE | M | 凌碧红 | 332876 | 375084 | 2026-03-19 17:59:38 | 1 | 2026-03-22 17:35:20.865204 |
| BH26031100049903 | WT CTC 26男款慢跑背心-头版-YS9347MHO | M | 凌碧红 | 332876 | 375084 | 2026-03-19 17:59:38 | 1 | 2026-03-22 17:35:20.863308 |
| BH26031100029904 | WT CTC 26男款防风背心-头版-YS9658MAO | L | 凌碧红 | 332876 | 375084 | 2026-03-19 17:59:38 | 1 | 2026-03-22 17:35:20.861585 |
| BH26031100059903 | WT CTC Black Mitte 26男款长上衣-头版-YS9681MHO | M | 凌碧红 | 332876 | 375084 | 2026-03-19 17:59:38 | 1 | 2026-03-22 17:35:20.860017 |
| BH26031100019903 | WT CTC Black Mitte 26女款T恤-头版-YS9681WO | M | 凌碧红 | 332876 | 375084 | 2026-03-19 17:59:38 | 1 | 2026-03-22 17:35:20.858456 |
| YY25022100179904 | WT CTC PRO Supreme男款背带短裤-YS2129MO | L | 凌碧红 | 332878 | 375093 | 2026-03-19 18:05:14 | 1 | 2026-03-22 17:35:20.855329 |
| JN25051000069902 | MR融光女款跑步背心-YS8112W | S | 胡美英 | 332879 | 375096 | 2026-03-19 18:07:08 | 1 | 2026-03-22 17:35:20.853542 |
| JN26031400049900 | bob4runner purple魔术头巾-头版-YS9946A | F | 陈锦娜 | 332880 | 375098 | 2026-03-19 18:08:47 | 1 | 2026-03-22 17:35:20.851647 |
| JN26031400029900 | bob4runner purple头围-头版-YS4016 | F | 陈锦娜 | 332880 | 375098 | 2026-03-19 18:08:47 | 1 | 2026-03-22 17:35:20.799964 |
| JN26031400039900 | bob4runner green魔术头巾-头版-YS9946A | F | 陈锦娜 | 332880 | 375098 | 2026-03-19 18:08:47 | 1 | 2026-03-22 17:35:20.798173 |
| JN26031400019900 | bob4runner green头围-头版-YS4016 | F | 陈锦娜 | 332880 | 375098 | 2026-03-19 18:08:47 | 1 | 2026-03-22 17:35:20.796505 |
| DZ261100689903 | HERO_26 工作T恤 | M | 何佳欣 | 332881 | 375104 | 2026-03-19 18:10:58 | 1 | 2026-03-22 17:35:20.794786 |
| ZT26020900139906 | Clash Names LW男款T恤-头版-YS9068MT | 2XL | 曾亭 | 326230 | 375242 | 2026-03-20 09:18:57 | 2 | 2026-03-22 17:35:20.793268 |
| ZT26020900139905 | Clash Names LW男款T恤-头版-YS9068MT | XL | 曾亭 | 326230 | 375242 | 2026-03-20 09:18:57 | 5 | 2026-03-22 17:35:20.791714 |
| ZT26020900139904 | Clash Names LW男款T恤-头版-YS9068MT | L | 曾亭 | 326230 | 375242 | 2026-03-20 09:18:57 | 38 | 2026-03-22 17:35:20.790129 |
| ZT26020900139903 | Clash Names LW男款T恤-头版-YS9068MT | M | 曾亭 | 326230 | 375242 | 2026-03-20 09:18:57 | 50 | 2026-03-22 17:35:20.788586 |
| ZT26020900139902 | Clash Names LW男款T恤-头版-YS9068MT | S | 曾亭 | 326230 | 375242 | 2026-03-20 09:18:57 | 45 | 2026-03-22 17:35:20.786780 |
| ZT26020900139901 | Clash Names LW男款T恤-头版-YS9068MT | XS | 曾亭 | 326230 | 375242 | 2026-03-20 09:18:57 | 10 | 2026-03-22 17:35:20.785207 |
| ZT26020900129905 | Clash RWB LW男款T恤-头版-YS9068MT | XL | 曾亭 | 326230 | 375242 | 2026-03-20 09:18:57 | 15 | 2026-03-22 17:35:20.783644 |