到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| 1231220169907 | 轻骑枣红女款背带超短裤 | 3XL | 黄婉婷 | 313556 | 355893 | 2026-01-26 10:34:57 | 15 | 2026-03-22 17:35:43.076411 |
| 1231220169906 | 轻骑枣红女款背带超短裤 | 2XL | 黄婉婷 | 313556 | 355893 | 2026-01-26 10:34:57 | 15 | 2026-03-22 17:35:43.074419 |
| 1231220169905 | 轻骑枣红女款背带超短裤 | XL | 黄婉婷 | 313556 | 355893 | 2026-01-26 10:34:57 | 15 | 2026-03-22 17:35:43.072852 |
| 1231220199907 | 轻骑深灰女款背带超短裤 | 3XL | 黄婉婷 | 313556 | 355893 | 2026-01-26 10:34:57 | 15 | 2026-03-22 17:35:43.071267 |
| 1231220199906 | 轻骑深灰女款背带超短裤 | 2XL | 黄婉婷 | 313556 | 355893 | 2026-01-26 10:34:57 | 15 | 2026-03-22 17:35:43.069685 |
| 1231220199905 | 轻骑深灰女款背带超短裤 | XL | 黄婉婷 | 313556 | 355893 | 2026-01-26 10:34:57 | 15 | 2026-03-22 17:35:43.068079 |
| 1231120459906 | 凌霄咖啡色抓绒长上衣 | 2XL | 黄婉婷 | 314083 | 355894 | 2026-01-26 10:35:22 | 10 | 2026-03-22 17:35:43.066488 |
| 1231120459907 | 凌霄咖啡色抓绒长上衣 | 3XL | 黄婉婷 | 314083 | 355894 | 2026-01-26 10:35:22 | 10 | 2026-03-22 17:35:43.064538 |
| 1231120459905 | 凌霄咖啡色抓绒长上衣 | XL | 黄婉婷 | 314083 | 355894 | 2026-01-26 10:35:22 | 10 | 2026-03-22 17:35:43.062875 |
| 1231600799907 | 2023-WEDNESDAY(深红)内搭背心 | 3XL | 黄婉婷 | 316533 | 355895 | 2026-01-26 10:36:04 | 3 | 2026-03-22 17:35:43.061305 |
| 1231600799906 | 2023-WEDNESDAY(深红)内搭背心 | 2XL | 黄婉婷 | 316533 | 355895 | 2026-01-26 10:36:04 | 3 | 2026-03-22 17:35:43.059636 |
| 1231600799905 | 2023-WEDNESDAY(深红)内搭背心 | XL | 黄婉婷 | 316533 | 355895 | 2026-01-26 10:36:04 | 2 | 2026-03-22 17:35:43.058029 |
| 1231600799904 | 2023-WEDNESDAY(深红)内搭背心 | L | 黄婉婷 | 316533 | 355895 | 2026-01-26 10:36:04 | 2 | 2026-03-22 17:35:43.056146 |
| RX26010700779906 | LBCC-26 TEMPO Sienna男款短上衣-二版-YS9042MAO | 2XL | 袁日仙 | 317945 | 355908 | 2026-01-26 11:06:12 | 1 | 2026-03-22 17:35:43.054342 |
| RX26010700779905 | LBCC-26 TEMPO Sienna男款短上衣-二版-YS9042MAO | XL | 袁日仙 | 317945 | 355908 | 2026-01-26 11:06:12 | 6 | 2026-03-22 17:35:43.052358 |
| RX26010700779904 | LBCC-26 TEMPO Sienna男款短上衣-二版-YS9042MAO | L | 袁日仙 | 317945 | 355908 | 2026-01-26 11:06:12 | 9 | 2026-03-22 17:35:42.998307 |
| RX26010700779903 | LBCC-26 TEMPO Sienna男款短上衣-二版-YS9042MAO | M | 袁日仙 | 317945 | 355908 | 2026-01-26 11:06:12 | 9 | 2026-03-22 17:35:42.996692 |
| RX26010700779902 | LBCC-26 TEMPO Sienna男款短上衣-二版-YS9042MAO | S | 袁日仙 | 317945 | 355908 | 2026-01-26 11:06:12 | 4 | 2026-03-22 17:35:42.995119 |
| RX26010700779901 | LBCC-26 TEMPO Sienna男款短上衣-二版-YS9042MAO | XS | 袁日仙 | 317945 | 355908 | 2026-01-26 11:06:12 | 2 | 2026-03-22 17:35:42.993452 |
| RX26010700749905 | LBCC-26 TEMPO Green女款短上衣-三版-YS9051WO | XL | 袁日仙 | 317945 | 355908 | 2026-01-26 11:06:12 | 2 | 2026-03-22 17:35:42.991921 |