到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| DQ2404220269907 | BMC-A 2013 (EU)男款短上衣-CD034MVFO | 3XL | 吕丹琪 | 319902 | 358340 | 2026-02-02 10:45:06 | 5 | 2026-03-22 17:35:38.295459 |
| MY26011400129905 | ENSO white 8112W女款跑步背心-头版-YS8112WO | XL | 胡美英 | 319738 | 358341 | 2026-02-02 10:45:34 | 1 | 2026-03-22 17:35:38.293855 |
| MY26011400129904 | ENSO white 8112W女款跑步背心-头版-YS8112WO | L | 胡美英 | 319738 | 358341 | 2026-02-02 10:45:34 | 2 | 2026-03-22 17:35:38.292221 |
| MY26011400129903 | ENSO white 8112W女款跑步背心-头版-YS8112WO | M | 胡美英 | 319738 | 358341 | 2026-02-02 10:45:34 | 2 | 2026-03-22 17:35:38.290588 |
| MY26011400129902 | ENSO white 8112W女款跑步背心-头版-YS8112WO | S | 胡美英 | 319738 | 358341 | 2026-02-02 10:45:34 | 5 | 2026-03-22 17:35:38.288967 |
| MY26011400129901 | ENSO white 8112W女款跑步背心-头版-YS8112WO | XS | 胡美英 | 319738 | 358341 | 2026-02-02 10:45:34 | 5 | 2026-03-22 17:35:38.287193 |
| RX26010700239904 | raw-26Liquid-A w女款短上衣-头版-YS9640WKBO | L | 袁日仙 | 316014 | 358342 | 2026-02-02 10:46:11 | 8 | 2026-03-22 17:35:38.285179 |
| RX26010700239903 | raw-26Liquid-A w女款短上衣-头版-YS9640WKBO | M | 袁日仙 | 316014 | 358342 | 2026-02-02 10:46:11 | 16 | 2026-03-22 17:35:38.283358 |
| RX26010700239902 | raw-26Liquid-A w女款短上衣-头版-YS9640WKBO | S | 袁日仙 | 316014 | 358342 | 2026-02-02 10:46:11 | 22 | 2026-03-22 17:35:38.281576 |
| RX26010700209905 | raw-24black男款背带短裤-二版-YS2057MAEO | XL | 袁日仙 | 316014 | 358342 | 2026-02-02 10:46:11 | 6 | 2026-03-22 17:35:38.279690 |
| RX26010700209904 | raw-24black男款背带短裤-二版-YS2057MAEO | L | 袁日仙 | 316014 | 358342 | 2026-02-02 10:46:11 | 12 | 2026-03-22 17:35:38.277713 |
| RX26010700209903 | raw-24black男款背带短裤-二版-YS2057MAEO | M | 袁日仙 | 316014 | 358342 | 2026-02-02 10:46:11 | 12 | 2026-03-22 17:35:38.275766 |
| RX26010700209902 | raw-24black男款背带短裤-二版-YS2057MAEO | S | 袁日仙 | 316014 | 358342 | 2026-02-02 10:46:11 | 8 | 2026-03-22 17:35:38.273892 |
| DQ2406050029908 | MOLTENI-A(EU)男款短上衣-CD034MVFO | 4XL | 吕丹琪 | 321985 | 358343 | 2026-02-02 10:47:01 | 2 | 2026-03-22 17:35:38.271935 |
| DQ2406050029907 | MOLTENI-A(EU)男款短上衣-CD034MVFO | 3XL | 吕丹琪 | 321985 | 358343 | 2026-02-02 10:47:01 | 2 | 2026-03-22 17:35:38.269924 |
| DQ200410039906 | SLOVENIA 2020(EU)短上衣 | 2XL | 吕丹琪 | 321985 | 358343 | 2026-02-02 10:47:01 | 30 | 2026-03-22 17:35:38.267951 |
| DQ200410039905 | SLOVENIA 2020(EU)短上衣 | XL | 吕丹琪 | 321985 | 358343 | 2026-02-02 10:47:01 | 40 | 2026-03-22 17:35:38.265969 |
| DQ200410039904 | SLOVENIA 2020(EU)短上衣 | L | 吕丹琪 | 321985 | 358343 | 2026-02-02 10:47:01 | 45 | 2026-03-22 17:35:38.264221 |
| DQ200410039903 | SLOVENIA 2020(EU)短上衣 | M | 吕丹琪 | 321985 | 358343 | 2026-02-02 10:47:01 | 10 | 2026-03-22 17:35:38.262270 |
| DQ200410039902 | SLOVENIA 2020(EU)短上衣 | S | 吕丹琪 | 321985 | 358343 | 2026-02-02 10:47:01 | 8 | 2026-03-22 17:35:38.260296 |