到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| RX26022800149902 | TOC男款短上衣-头版-YS9410MBO | S | 袁日仙 | 327842 | 371510 | 2026-03-13 15:47:35 | 8 | 2026-03-22 17:35:23.758951 |
| RX26022800149901 | TOC男款短上衣-头版-YS9410MBO | XS | 袁日仙 | 327842 | 371510 | 2026-03-13 15:47:35 | 9 | 2026-03-22 17:35:23.757360 |
| RX26022800149911 | TOC男款短上衣-头版-YS9410MBO | 2XS | 袁日仙 | 327842 | 371510 | 2026-03-13 15:47:35 | 8 | 2026-03-22 17:35:23.755803 |
| YY26020900049900 | Gursh Pink男款针织袜 | F | 刘莹滢 | 331114 | 371620 | 2026-03-13 16:42:42 | 1 | 2026-03-22 17:35:23.754050 |
| ZT25121300589901 | 904Duval MTB男款短裤-二版-YS2074MO | XS | 林美霓 | 330011 | 371646 | 2026-03-13 17:09:16 | 1 | 2026-03-22 17:35:23.752081 |
| ZT2411160379901 | 904Duval LW女款短上衣-YS9409WKO | XS | 林美霓 | 330011 | 371646 | 2026-03-13 17:09:16 | 1 | 2026-03-22 17:35:23.698918 |
| ZT26030400259904 | Infinit 26 Blue男款铁三短裤-头版-YS2083MC | L | 曾亭 | 329689 | 371647 | 2026-03-13 17:09:47 | 1 | 2026-03-22 17:35:23.697357 |
| MJ26022800149907 | TCHACO SONANGOL Black男款T恤-头版-YS9681MO | 3XL | 庄镘洁 | 327737 | 371649 | 2026-03-13 17:10:17 | 1 | 2026-03-22 17:35:23.695828 |
| MJ26022800149906 | TCHACO SONANGOL Black男款T恤-头版-YS9681MO | 2XL | 庄镘洁 | 327737 | 371649 | 2026-03-13 17:10:17 | 2 | 2026-03-22 17:35:23.694269 |
| MJ26022800149905 | TCHACO SONANGOL Black男款T恤-头版-YS9681MO | XL | 庄镘洁 | 327737 | 371649 | 2026-03-13 17:10:17 | 6 | 2026-03-22 17:35:23.692690 |
| MJ26022800149904 | TCHACO SONANGOL Black男款T恤-头版-YS9681MO | L | 庄镘洁 | 327737 | 371649 | 2026-03-13 17:10:17 | 8 | 2026-03-22 17:35:23.691174 |
| MJ26022800149903 | TCHACO SONANGOL Black男款T恤-头版-YS9681MO | M | 庄镘洁 | 327737 | 371649 | 2026-03-13 17:10:17 | 3 | 2026-03-22 17:35:23.689483 |
| MJ26022800149902 | TCHACO SONANGOL Black男款T恤-头版-YS9681MO | S | 庄镘洁 | 327737 | 371649 | 2026-03-13 17:10:17 | 1 | 2026-03-22 17:35:23.687842 |
| MJ26030400079905 | TCHACO 5AM CLUB男款跑步背心-头版-YS9787MXO | XL | 庄镘洁 | 328669 | 371650 | 2026-03-13 17:10:49 | 1 | 2026-03-22 17:35:23.686264 |
| MJ26030400079904 | TCHACO 5AM CLUB男款跑步背心-头版-YS9787MXO | L | 庄镘洁 | 328669 | 371650 | 2026-03-13 17:10:49 | 13 | 2026-03-22 17:35:23.684457 |
| MJ26030400079903 | TCHACO 5AM CLUB男款跑步背心-头版-YS9787MXO | M | 庄镘洁 | 328669 | 371650 | 2026-03-13 17:10:49 | 5 | 2026-03-22 17:35:23.682693 |
| MJ26020400199903 | RADA JOEL 2026女款短上衣-头版-YS9640WXGO | M | 庄镘洁 | 325090 | 371652 | 2026-03-13 17:11:13 | 1 | 2026-03-22 17:35:23.681079 |
| MJ26020400199902 | RADA JOEL 2026女款短上衣-头版-YS9640WXGO | S | 庄镘洁 | 325090 | 371652 | 2026-03-13 17:11:13 | 3 | 2026-03-22 17:35:23.679225 |
| MJ26020400199901 | RADA JOEL 2026女款短上衣-头版-YS9640WXGO | XS | 庄镘洁 | 325090 | 371652 | 2026-03-13 17:11:13 | 2 | 2026-03-22 17:35:23.677341 |
| MJ26020400189904 | RADA JOEL 2026男款长上衣-头版-YS9640MHGO | L | 庄镘洁 | 325090 | 371652 | 2026-03-13 17:11:13 | 2 | 2026-03-22 17:35:23.675456 |