到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT26020400079902 | LETS RUN护臂-头版-YS9964FO | S | 曾亭 | 324985 | 361129 | 2026-02-09 15:17:26 | 1 | 2026-03-22 17:35:31.468202 |
| ZT26012800159903 | Trinovate女款短裤-头版-YS9163WDO | M | 曾亭 | 324988 | 361141 | 2026-02-09 15:20:26 | 1 | 2026-03-22 17:35:31.466635 |
| ZT26012800149903 | Trinovate男款背带短裤-头版-YS2076MO | M | 曾亭 | 324988 | 361141 | 2026-02-09 15:20:26 | 1 | 2026-03-22 17:35:31.465160 |
| MJ26012400099903 | RADA JOYERO Gold男款短袖连体衣-头版-YS9251MVDO | M | 庄镘洁 | 324989 | 361144 | 2026-02-09 15:23:07 | 1 | 2026-03-22 17:35:31.463647 |
| MJ26012400089903 | RADA JOYERO White男款短袖连体衣-头版-YS9251MVDO | M | 庄镘洁 | 324989 | 361144 | 2026-02-09 15:23:07 | 1 | 2026-03-22 17:35:31.462117 |
| MJ26012400079903 | RADA JOYERO Pink男款短袖连体衣-头版-YS9251MVDO | M | 庄镘洁 | 324989 | 361144 | 2026-02-09 15:23:07 | 1 | 2026-03-22 17:35:31.460554 |
| MJ26012400069903 | RADA JOYERO Black男款短袖连体衣-头版-YS9251MVDO | M | 庄镘洁 | 324989 | 361144 | 2026-02-09 15:23:07 | 1 | 2026-03-22 17:35:31.459072 |
| MJ26012400059903 | RADA JOYERO Grey男款短袖连体衣-头版-YS9251MVDO | M | 庄镘洁 | 324989 | 361144 | 2026-02-09 15:23:07 | 1 | 2026-03-22 17:35:31.457553 |
| JN26012100139901 | INSANITY-1 Black运动文胸 | XS | 陈锦娜 | 323697 | 361175 | 2026-02-09 15:31:17 | 1 | 2026-03-22 17:35:31.456059 |
| JN26012100129901 | INSANITY Black运动文胸 | XS | 陈锦娜 | 323697 | 361175 | 2026-02-09 15:31:17 | 1 | 2026-03-22 17:35:31.454511 |
| 1261110389906 | 糖渍橙蓝女款短上衣 | 2XL | 林树 | 316438 | 361184 | 2026-02-09 15:49:00 | 10 | 2026-03-22 17:35:31.452759 |
| MJ2405220049904 | Aquasock white防水鞋套 | L | 胡美英 | 318098 | 361178 | 2026-03-10 17:54:08 | 778 | 2026-03-22 17:35:31.452600 |
| MJ2405220049903 | Aquasock white防水鞋套 | M | 胡美英 | 318098 | 361178 | 2026-03-10 17:54:08 | 2089 | 2026-03-22 17:35:31.452598 |
| MJ2405220049902 | Aquasock white防水鞋套 | S | 胡美英 | 318098 | 361178 | 2026-03-10 17:54:08 | 730 | 2026-03-22 17:35:31.452595 |
| 1261110389905 | 糖渍橙蓝女款短上衣 | XL | 林树 | 316438 | 361184 | 2026-02-09 15:49:00 | 10 | 2026-03-22 17:35:31.398189 |
| 1261110389904 | 糖渍橙蓝女款短上衣 | L | 林树 | 316438 | 361184 | 2026-02-09 15:49:00 | 20 | 2026-03-22 17:35:31.396675 |
| 1261110389903 | 糖渍橙蓝女款短上衣 | M | 林树 | 316438 | 361184 | 2026-02-09 15:49:00 | 50 | 2026-03-22 17:35:31.395187 |
| 1261110389902 | 糖渍橙蓝女款短上衣 | S | 林树 | 316438 | 361184 | 2026-02-09 15:49:00 | 50 | 2026-03-22 17:35:31.393650 |
| 1261110389901 | 糖渍橙蓝女款短上衣 | XS | 林树 | 316438 | 361184 | 2026-02-09 15:49:00 | 10 | 2026-03-22 17:35:31.392149 |
| 1261110489909 | 酌悦浅橙短上衣 | 5XL | 林树 | 316459 | 361186 | 2026-02-09 15:50:01 | 10 | 2026-03-22 17:35:31.390463 |