到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| WT26012100229904 | AC-ONG ON ONG女款T恤-头版-YS9068WEAO | L | 黄婉婷 | 320373 | 358461 | 2026-02-02 14:33:38 | 4 | 2026-03-22 17:35:37.598158 |
| WT26012100229903 | AC-ONG ON ONG女款T恤-头版-YS9068WEAO | M | 黄婉婷 | 320373 | 358461 | 2026-02-02 14:33:38 | 8 | 2026-03-22 17:35:37.596623 |
| WT26012100229902 | AC-ONG ON ONG女款T恤-头版-YS9068WEAO | S | 黄婉婷 | 320373 | 358461 | 2026-02-02 14:33:38 | 3 | 2026-03-22 17:35:37.595113 |
| MY26011700039906 | B3L Bozza2男款短上衣-二版-YS9781MO | 2XL | 胡美英 | 319273 | 358462 | 2026-02-02 14:34:13 | 3 | 2026-03-22 17:35:37.593424 |
| MY26011700039905 | B3L Bozza2男款短上衣-二版-YS9781MO | XL | 胡美英 | 319273 | 358462 | 2026-02-02 14:34:13 | 5 | 2026-03-22 17:35:37.591896 |
| MY26011700039904 | B3L Bozza2男款短上衣-二版-YS9781MO | L | 胡美英 | 319273 | 358462 | 2026-02-02 14:34:13 | 10 | 2026-03-22 17:35:37.590229 |
| MY26011700039903 | B3L Bozza2男款短上衣-二版-YS9781MO | M | 胡美英 | 319273 | 358462 | 2026-02-02 14:34:13 | 10 | 2026-03-22 17:35:37.588701 |
| MY26011700039902 | B3L Bozza2男款短上衣-二版-YS9781MO | S | 胡美英 | 319273 | 358462 | 2026-02-02 14:34:13 | 8 | 2026-03-22 17:35:37.587191 |
| MY26011700039901 | B3L Bozza2男款短上衣-二版-YS9781MO | XS | 胡美英 | 319273 | 358462 | 2026-02-02 14:34:13 | 4 | 2026-03-22 17:35:37.585647 |
| MY26011700039911 | B3L Bozza2男款短上衣-二版-YS9781MO | 2XS | 胡美英 | 319273 | 358462 | 2026-02-02 14:34:13 | 2 | 2026-03-22 17:35:37.584064 |
| WT26011000049904 | ALIAS-Jamison男款背带短裤-头版-YS2128MCO | L | 黄婉婷 | 318673 | 358463 | 2026-02-02 14:34:43 | 1 | 2026-03-22 17:35:37.582463 |
| WT26011000049903 | ALIAS-Jamison男款背带短裤-头版-YS2128MCO | M | 黄婉婷 | 318673 | 358463 | 2026-02-02 14:34:43 | 10 | 2026-03-22 17:35:37.580883 |
| RX26011400229901 | CUPCKE-Sarah Thomas-A女款短上衣-头版-YS9421WCO | XS | 袁日仙 | 319553 | 358464 | 2026-02-02 14:35:01 | 1 | 2026-03-22 17:35:37.579356 |
| DQ2406050129910 | MAPEI-A(EU)男款短上衣-CD034MVFO | 6XL | 吕丹琪 | 319902 | 358465 | 2026-02-02 14:35:36 | 2 | 2026-03-22 17:35:37.577813 |
| DQ2406050129909 | MAPEI-A(EU)男款短上衣-CD034MVFO | 5XL | 吕丹琪 | 319902 | 358465 | 2026-02-02 14:35:36 | 2 | 2026-03-22 17:35:37.576230 |
| DQ2406050129908 | MAPEI-A(EU)男款短上衣-CD034MVFO | 4XL | 吕丹琪 | 319902 | 358465 | 2026-02-02 14:35:36 | 2 | 2026-03-22 17:35:37.574585 |
| DQ2406050129907 | MAPEI-A(EU)男款短上衣-CD034MVFO | 3XL | 吕丹琪 | 319902 | 358465 | 2026-02-02 14:35:36 | 2 | 2026-03-22 17:35:37.573019 |
| DQ2406050069910 | BANESTO-A 1996(EU)男款短上衣-CD034MVFO | 6XL | 吕丹琪 | 319902 | 358465 | 2026-02-02 14:35:36 | 4 | 2026-03-22 17:35:37.571455 |
| DQ2406050069909 | BANESTO-A 1996(EU)男款短上衣-CD034MVFO | 5XL | 吕丹琪 | 319902 | 358465 | 2026-02-02 14:35:36 | 4 | 2026-03-22 17:35:37.569872 |
| DQ2406050069908 | BANESTO-A 1996(EU)男款短上衣-CD034MVFO | 4XL | 吕丹琪 | 319902 | 358465 | 2026-02-02 14:35:36 | 4 | 2026-03-22 17:35:37.568302 |