到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| 1191111709904 | 凌云黑灰短袖连体衣 | L | 何咏凯 | 323071 | 360135 | 2026-02-06 18:29:38 | 5 | 2026-03-22 17:35:33.500634 |
| 1191111709903 | 凌云黑灰短袖连体衣 | M | 何咏凯 | 323071 | 360135 | 2026-02-06 18:29:38 | 8 | 2026-03-22 17:35:33.499098 |
| 1191111709902 | 凌云黑灰短袖连体衣 | S | 何咏凯 | 323071 | 360135 | 2026-02-06 18:29:38 | 5 | 2026-03-22 17:35:33.497503 |
| RX26012100129906 | LBCC-26 PRO RC Pewter男款背带短裤-头版-YS9134MKEO | 2XL | 袁日仙 | 320629 | 360225 | 2026-02-07 10:36:53 | 1 | 2026-03-22 17:35:33.495273 |
| 1261110679907 | 数码绽放米灰短上衣 | 3XL | 林树 | 316488 | 360212 | 2026-03-17 15:20:00 | 30 | 2026-03-22 17:35:33.495082 |
| 1261110679906 | 数码绽放米灰短上衣 | 2XL | 林树 | 316488 | 360212 | 2026-03-17 15:20:00 | 30 | 2026-03-22 17:35:33.495080 |
| 1261110679905 | 数码绽放米灰短上衣 | XL | 林树 | 316488 | 360212 | 2026-03-17 15:20:00 | 70 | 2026-03-22 17:35:33.495079 |
| 1261110679904 | 数码绽放米灰短上衣 | L | 林树 | 316488 | 360212 | 2026-03-17 15:20:00 | 70 | 2026-03-22 17:35:33.495077 |
| 1261110679903 | 数码绽放米灰短上衣 | M | 林树 | 316488 | 360212 | 2026-03-17 15:20:00 | 70 | 2026-03-22 17:35:33.495075 |
| 1261110679902 | 数码绽放米灰短上衣 | S | 林树 | 316488 | 360212 | 2026-03-17 15:20:00 | 30 | 2026-03-22 17:35:33.495074 |
| 1261220209906 | 新动黑色女款背带短裤 | 2XL | 林树 | 321524 | 360211 | 2026-03-18 17:00:00 | 30 | 2026-03-22 17:35:33.495072 |
| 1261220209905 | 新动黑色女款背带短裤 | XL | 林树 | 321524 | 360211 | 2026-03-18 17:00:00 | 30 | 2026-03-22 17:35:33.495071 |
| 1261220209904 | 新动黑色女款背带短裤 | L | 林树 | 321524 | 360211 | 2026-03-18 17:00:00 | 65 | 2026-03-22 17:35:33.495069 |
| 1261220209903 | 新动黑色女款背带短裤 | M | 林树 | 321524 | 360211 | 2026-03-18 17:00:00 | 100 | 2026-03-22 17:35:33.495054 |
| 1261220209902 | 新动黑色女款背带短裤 | S | 林树 | 321524 | 360211 | 2026-03-18 17:00:00 | 100 | 2026-03-22 17:35:33.495053 |
| 1261220209901 | 新动黑色女款背带短裤 | XS | 林树 | 321524 | 360211 | 2026-03-18 17:00:00 | 30 | 2026-03-22 17:35:33.495049 |
| RX26012100129905 | LBCC-26 PRO RC Pewter男款背带短裤-头版-YS9134MKEO | XL | 袁日仙 | 320629 | 360225 | 2026-02-07 10:36:53 | 10 | 2026-03-22 17:35:33.482436 |
| RX26012100129904 | LBCC-26 PRO RC Pewter男款背带短裤-头版-YS9134MKEO | L | 袁日仙 | 320629 | 360225 | 2026-02-07 10:36:53 | 19 | 2026-03-22 17:35:33.480856 |
| RX26012100129903 | LBCC-26 PRO RC Pewter男款背带短裤-头版-YS9134MKEO | M | 袁日仙 | 320629 | 360225 | 2026-02-07 10:36:53 | 32 | 2026-03-22 17:35:33.479082 |
| RX26012100129902 | LBCC-26 PRO RC Pewter男款背带短裤-头版-YS9134MKEO | S | 袁日仙 | 320629 | 360225 | 2026-02-07 10:36:53 | 29 | 2026-03-22 17:35:33.477511 |