到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| 1261220049905 | 驰影黑色背带短裤 | XL | 林树 | 316461 | 370004 | 2026-03-18 10:37:00 | 99 | 2026-03-22 17:35:25.292427 |
| 1261220049904 | 驰影黑色背带短裤 | L | 林树 | 316461 | 370004 | 2026-03-18 10:37:00 | 100 | 2026-03-22 17:35:25.292425 |
| 1261220049903 | 驰影黑色背带短裤 | M | 林树 | 316461 | 370004 | 2026-03-18 10:37:00 | 96 | 2026-03-22 17:35:25.292423 |
| 1261220029902 | 驰影黑色女款背带短裤 | S | 林树 | 316461 | 370006 | 2026-03-18 17:01:00 | 18 | 2026-03-22 17:35:25.292422 |
| 1261220029901 | 驰影黑色女款背带短裤 | XS | 林树 | 316461 | 370006 | 2026-03-18 17:01:00 | 16 | 2026-03-22 17:35:25.292420 |
| 1261220019901 | 驰影深灰女款背带短裤 | XS | 林树 | 316461 | 370008 | 2026-03-19 16:58:00 | 10 | 2026-03-22 17:35:25.292417 |
| 1261220039904 | 驰影深灰背带短裤 | L | 林树 | 316461 | 370007 | 2026-03-19 17:51:00 | 9 | 2026-03-22 17:35:25.292415 |
| 1261220039903 | 驰影深灰背带短裤 | M | 林树 | 316461 | 370007 | 2026-03-19 17:51:00 | 8 | 2026-03-22 17:35:25.292411 |
| MJ2405220059902 | Aquasock black防水鞋套 | S | 胡美英 | 318098 | 370025 | 2026-03-10 17:54:08 | 241 | 2026-03-22 17:35:25.280299 |
| RX26012800259904 | EXIT21女款短上衣-头版-YS9496WAO | L | 袁日仙 | 323329 | 370028 | 2026-03-10 17:56:05 | 3 | 2026-03-22 17:35:25.274219 |
| RX26012800259903 | EXIT21女款短上衣-头版-YS9496WAO | M | 袁日仙 | 323329 | 370028 | 2026-03-10 17:56:05 | 1 | 2026-03-22 17:35:25.272675 |
| RX26012800259902 | EXIT21女款短上衣-头版-YS9496WAO | S | 袁日仙 | 323329 | 370028 | 2026-03-10 17:56:05 | 4 | 2026-03-22 17:35:25.271101 |
| MY26012800049903 | spatz CLIFF PRATT抓绒背心-头版-YS8200MB | M | 胡美英 | 323992 | 370029 | 2026-03-10 17:56:37 | 5 | 2026-03-22 17:35:25.269269 |
| MY26012800049902 | spatz CLIFF PRATT抓绒背心-头版-YS8200MB | S | 胡美英 | 323992 | 370029 | 2026-03-10 17:56:37 | 2 | 2026-03-22 17:35:25.267444 |
| MJ26022800169907 | TCHACO SONANGOL White男款T恤-头版-YS9681MO | 3XL | 庄镘洁 | 327737 | 370030 | 2026-03-10 17:57:09 | 1 | 2026-03-22 17:35:25.265618 |
| MJ26022800169906 | TCHACO SONANGOL White男款T恤-头版-YS9681MO | 2XL | 庄镘洁 | 327737 | 370030 | 2026-03-10 17:57:09 | 2 | 2026-03-22 17:35:25.263792 |
| MJ26022800169905 | TCHACO SONANGOL White男款T恤-头版-YS9681MO | XL | 庄镘洁 | 327737 | 370030 | 2026-03-10 17:57:09 | 3 | 2026-03-22 17:35:25.262210 |
| MJ26022800169904 | TCHACO SONANGOL White男款T恤-头版-YS9681MO | L | 庄镘洁 | 327737 | 370030 | 2026-03-10 17:57:09 | 5 | 2026-03-22 17:35:25.260636 |
| MJ26022800169903 | TCHACO SONANGOL White男款T恤-头版-YS9681MO | M | 庄镘洁 | 327737 | 370030 | 2026-03-10 17:57:09 | 1 | 2026-03-22 17:35:25.259136 |
| MJ26022800169902 | TCHACO SONANGOL White男款T恤-头版-YS9681MO | S | 庄镘洁 | 327737 | 370030 | 2026-03-10 17:57:09 | 1 | 2026-03-22 17:35:25.257574 |