到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| WT26011000119903 | RSG 2026TT半指手套-YS17033 | M | 黄婉婷 | 318080 | 359282 | 2026-02-04 16:30:12 | 1 | 2026-03-22 17:35:35.671792 |
| ZT26011700069903 | OTBG男款长上衣-二版-YS9068MDY | M | 曾亭 | 319593 | 359304 | 2026-02-04 17:18:36 | 40 | 2026-03-22 17:35:35.670183 |
| ZT26011700069904 | OTBG男款长上衣-二版-YS9068MDY | L | 曾亭 | 319593 | 359304 | 2026-03-19 17:42:19 | 40 | 2026-03-22 17:35:35.670087 |
| ZT26011700139902 | BikeMS 26女款背带短裤-头版-YS2025WQ | S | 曾亭 | 319263 | 359305 | 2026-02-04 17:19:41 | 1 | 2026-03-22 17:35:35.666789 |
| ZT26011700069902 | OTBG男款长上衣-二版-YS9068MDY | S | 曾亭 | 319593 | 359304 | 2026-03-19 17:42:19 | 70 | 2026-03-22 17:35:35.666623 |
| DQ2404220149910 | GARMIN-A 2012 (EU)男款短上衣-CD034MVFO | 6XL | 吕丹琪 | 319902 | 359306 | 2026-02-04 17:20:07 | 2 | 2026-03-22 17:35:35.664133 |
| DQ2404220149909 | GARMIN-A 2012 (EU)男款短上衣-CD034MVFO | 5XL | 吕丹琪 | 319902 | 359306 | 2026-02-04 17:20:07 | 2 | 2026-03-22 17:35:35.662399 |
| DQ2404220149908 | GARMIN-A 2012 (EU)男款短上衣-CD034MVFO | 4XL | 吕丹琪 | 319902 | 359306 | 2026-02-04 17:20:07 | 2 | 2026-03-22 17:35:35.660824 |
| DQ2404220149907 | GARMIN-A 2012 (EU)男款短上衣-CD034MVFO | 3XL | 吕丹琪 | 319902 | 359306 | 2026-02-04 17:20:07 | 5 | 2026-03-22 17:35:35.659246 |
| DQ26011700099910 | QUICKSTEP-A 2026(EU)男款短上衣-头版-CD034MVFO | 6XL | 吕丹琪 | 320076 | 359307 | 2026-02-04 17:20:36 | 5 | 2026-03-22 17:35:35.657593 |
| DQ26011700099909 | QUICKSTEP-A 2026(EU)男款短上衣-头版-CD034MVFO | 5XL | 吕丹琪 | 320076 | 359307 | 2026-02-04 17:20:36 | 5 | 2026-03-22 17:35:35.656032 |
| DQ26011700099908 | QUICKSTEP-A 2026(EU)男款短上衣-头版-CD034MVFO | 4XL | 吕丹琪 | 320076 | 359307 | 2026-02-04 17:20:36 | 5 | 2026-03-22 17:35:35.654359 |
| DQ26011700099907 | QUICKSTEP-A 2026(EU)男款短上衣-头版-CD034MVFO | 3XL | 吕丹琪 | 320076 | 359307 | 2026-02-04 17:20:36 | 5 | 2026-03-22 17:35:35.652695 |
| RX26010700669908 | stelvio-SC童装抓绒长上衣-三版-YS8098MBO | 4XL | 袁日仙 | 317941 | 359308 | 2026-02-04 17:20:57 | 4 | 2026-03-22 17:35:35.600568 |
| RX26010700669907 | stelvio-SC童装抓绒长上衣-三版-YS8098MBO | 3XL | 袁日仙 | 317941 | 359308 | 2026-02-04 17:20:57 | 8 | 2026-03-22 17:35:35.598966 |
| RX26010700669906 | stelvio-SC童装抓绒长上衣-三版-YS8098MBO | 2XL | 袁日仙 | 317941 | 359308 | 2026-02-04 17:20:57 | 10 | 2026-03-22 17:35:35.597323 |
| RX26010700669905 | stelvio-SC童装抓绒长上衣-三版-YS8098MBO | XL | 袁日仙 | 317941 | 359308 | 2026-02-04 17:20:57 | 4 | 2026-03-22 17:35:35.595687 |
| RX26012400129906 | EMERALD 2026男款背带短裤-头版-YS9163MCO | 2XL | 袁日仙 | 322185 | 359309 | 2026-02-04 17:21:25 | 2 | 2026-03-22 17:35:35.594052 |
| RX26012400129905 | EMERALD 2026男款背带短裤-头版-YS9163MCO | XL | 袁日仙 | 322185 | 359309 | 2026-02-04 17:21:25 | 10 | 2026-03-22 17:35:35.592423 |
| RX26012400129904 | EMERALD 2026男款背带短裤-头版-YS9163MCO | L | 袁日仙 | 322185 | 359309 | 2026-02-04 17:21:25 | 21 | 2026-03-22 17:35:35.590769 |