到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| ZT26011000809907 | Elite black 24女款背带短裤-二版-YS9113WAB | 3XL | 曾亭 | 318255 | 354113 | 2026-01-20 16:50:08 | 2 | 2026-03-22 17:35:46.063459 |
| ZT26011000809906 | Elite black 24女款背带短裤-二版-YS9113WAB | 2XL | 曾亭 | 318255 | 354113 | 2026-01-20 16:50:08 | 2 | 2026-03-22 17:35:46.061933 |
| ZT26011000809904 | Elite black 24女款背带短裤-二版-YS9113WAB | L | 曾亭 | 318255 | 354113 | 2026-01-20 16:50:08 | 1 | 2026-03-22 17:35:46.060332 |
| ZT26011000809903 | Elite black 24女款背带短裤-二版-YS9113WAB | M | 曾亭 | 318255 | 354113 | 2026-01-20 16:50:08 | 5 | 2026-03-22 17:35:46.058758 |
| ZT26011000809902 | Elite black 24女款背带短裤-二版-YS9113WAB | S | 曾亭 | 318255 | 354113 | 2026-01-20 16:50:08 | 2 | 2026-03-22 17:35:46.057227 |
| ZT26011000809901 | Elite black 24女款背带短裤-二版-YS9113WAB | XS | 曾亭 | 318255 | 354113 | 2026-01-20 16:50:08 | 3 | 2026-03-22 17:35:46.055616 |
| ZT26011400159904 | Elite black white 40女款背带短裤-头版-YS9113WAB | L | 曾亭 | 318344 | 354115 | 2026-01-20 16:50:46 | 1 | 2026-03-22 17:35:46.054025 |
| ZT26011400149903 | Elite black white 40男款背带短裤-头版-YS9153MZP | M | 曾亭 | 318344 | 354115 | 2026-01-20 16:50:46 | 1 | 2026-03-22 17:35:46.052340 |
| WT25122000049906 | No Straight Path-2025男款跑步短裤-三版-YS2195MD | 2XL | 黄婉婷 | 318349 | 354116 | 2026-01-20 16:51:08 | 5 | 2026-03-22 17:35:45.999354 |
| WT25122000049905 | No Straight Path-2025男款跑步短裤-三版-YS2195MD | XL | 黄婉婷 | 318349 | 354116 | 2026-01-20 16:51:08 | 10 | 2026-03-22 17:35:45.997581 |
| WT25122000049904 | No Straight Path-2025男款跑步短裤-三版-YS2195MD | L | 黄婉婷 | 318349 | 354116 | 2026-01-20 16:51:08 | 20 | 2026-03-22 17:35:45.995837 |
| WT25122000049903 | No Straight Path-2025男款跑步短裤-三版-YS2195MD | M | 黄婉婷 | 318349 | 354116 | 2026-01-20 16:51:08 | 25 | 2026-03-22 17:35:45.994174 |
| WT25122000049902 | No Straight Path-2025男款跑步短裤-三版-YS2195MD | S | 黄婉婷 | 318349 | 354116 | 2026-01-20 16:51:08 | 10 | 2026-03-22 17:35:45.991999 |
| DZ261100099918 | W12-PRO SHORT JERSEY NCYU26男款短上衣 | 4XS | 黄瑞辉 | 318351 | 354119 | 2026-01-20 16:54:11 | 1 | 2026-03-22 17:35:45.990307 |
| 1231111459907 | 行者EVO蓝灰女款短上衣 | 3XL | 黄婉婷 | 313439 | 354124 | 2026-01-20 17:04:36 | 15 | 2026-03-22 17:35:45.988727 |
| 1231111459906 | 行者EVO蓝灰女款短上衣 | 2XL | 黄婉婷 | 313439 | 354124 | 2026-01-20 17:04:36 | 15 | 2026-03-22 17:35:45.987180 |
| 1231111459905 | 行者EVO蓝灰女款短上衣 | XL | 黄婉婷 | 313439 | 354124 | 2026-01-20 17:04:36 | 15 | 2026-03-22 17:35:45.985473 |
| ZT26010700449905 | BB Femme女款短上衣-头版-YS9640WRO | XL | 曾亭 | 317120 | 354127 | 2026-01-20 17:07:38 | 8 | 2026-03-22 17:35:45.983924 |
| ZT26010700449904 | BB Femme女款短上衣-头版-YS9640WRO | L | 曾亭 | 317120 | 354127 | 2026-01-20 17:07:38 | 8 | 2026-03-22 17:35:45.982332 |
| ZT26010700449903 | BB Femme女款短上衣-头版-YS9640WRO | M | 曾亭 | 317120 | 354127 | 2026-01-20 17:07:38 | 7 | 2026-03-22 17:35:45.980702 |