到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT26013100639905 | PSU 26女款T恤-头版-YS9087WT | XL | 曾亭 | 324535 | 361419 | 2026-02-10 11:34:21 | 1 | 2026-03-22 17:35:31.082087 |
| ZT26013100639903 | PSU 26女款T恤-头版-YS9087WT | M | 曾亭 | 324535 | 361419 | 2026-02-10 11:34:21 | 2 | 2026-03-22 17:35:31.080345 |
| ZT26013100639902 | PSU 26女款T恤-头版-YS9087WT | S | 曾亭 | 324535 | 361419 | 2026-02-10 11:34:21 | 2 | 2026-03-22 17:35:31.078851 |
| ZT26013100639901 | PSU 26女款T恤-头版-YS9087WT | XS | 曾亭 | 324535 | 361419 | 2026-02-10 11:34:21 | 2 | 2026-03-22 17:35:31.077321 |
| JB26012800109905 | COXX Black男款背带短裤-二版-YS2029MAHT | XL | 郑杰彬 | 325120 | 361423 | 2026-02-10 11:38:36 | 1 | 2026-03-22 17:35:31.075801 |
| JB26012800109904 | COXX Black男款背带短裤-二版-YS2029MAHT | L | 郑杰彬 | 325120 | 361423 | 2026-02-10 11:38:36 | 1 | 2026-03-22 17:35:31.074281 |
| JB26012800109903 | COXX Black男款背带短裤-二版-YS2029MAHT | M | 郑杰彬 | 325120 | 361423 | 2026-02-10 11:38:36 | 1 | 2026-03-22 17:35:31.072798 |
| JB26012800099905 | COXX White男款长上衣-二版-YS8037MG | XL | 郑杰彬 | 325120 | 361423 | 2026-02-10 11:38:36 | 1 | 2026-03-22 17:35:31.071214 |
| JB26012800099904 | COXX White男款长上衣-二版-YS8037MG | L | 郑杰彬 | 325120 | 361423 | 2026-02-10 11:38:36 | 1 | 2026-03-22 17:35:31.069687 |
| JB26012800099903 | COXX White男款长上衣-二版-YS8037MG | M | 郑杰彬 | 325120 | 361423 | 2026-02-10 11:38:36 | 1 | 2026-03-22 17:35:31.068137 |
| JB26012800139905 | COXX Blue男款短上衣-二版-YS8137MH | XL | 郑杰彬 | 325120 | 361423 | 2026-02-10 11:38:36 | 1 | 2026-03-22 17:35:31.066520 |
| JB26012800139903 | COXX Blue男款短上衣-二版-YS8137MH | M | 郑杰彬 | 325120 | 361423 | 2026-02-10 11:38:36 | 1 | 2026-03-22 17:35:31.064986 |
| JB26012800079904 | COXX Blue男款短袖连体衣-二版-YS9262MEDT | L | 郑杰彬 | 325120 | 361423 | 2026-02-10 11:38:36 | 1 | 2026-03-22 17:35:31.063465 |
| JB26012800069903 | COXX Red男款短袖连体衣-二版-YS9262MEDT | M | 郑杰彬 | 325120 | 361423 | 2026-02-10 11:38:36 | 1 | 2026-03-22 17:35:31.061911 |
| RX26011000019908 | stelvio-SC童装T恤-二版-YS296KHO | 4XL | 袁日仙 | 325122 | 361447 | 2026-02-10 13:31:46 | 2 | 2026-03-22 17:35:31.055709 |
| RX26011000019907 | stelvio-SC童装T恤-二版-YS296KHO | 3XL | 袁日仙 | 325122 | 361447 | 2026-02-10 13:31:46 | 6 | 2026-03-22 17:35:31.054089 |
| RX26011000019906 | stelvio-SC童装T恤-二版-YS296KHO | 2XL | 袁日仙 | 325122 | 361447 | 2026-02-10 13:31:46 | 10 | 2026-03-22 17:35:31.052190 |
| RX26011000019905 | stelvio-SC童装T恤-二版-YS296KHO | XL | 袁日仙 | 325122 | 361447 | 2026-02-10 13:31:46 | 6 | 2026-03-22 17:35:30.999201 |
| 1231600759907 | 2023-WEEKEND(黑色)内搭背心 | 3XL | 何佳欣 | 320391 | 361514 | 2026-02-10 15:31:06 | 3 | 2026-03-22 17:35:30.981631 |
| 1231600759906 | 2023-WEEKEND(黑色)内搭背心 | 2XL | 何佳欣 | 320391 | 361514 | 2026-02-10 15:31:06 | 5 | 2026-03-22 17:35:30.980059 |