到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| LF26011700129909 | 25FLYERS-2男款跑步背心-头版-CY114MO | 5XL | 罗兰方 | 320212 | 358909 | 2026-02-03 16:36:40 | 1 | 2026-03-22 17:35:36.656179 |
| LF26011700129908 | 25FLYERS-2男款跑步背心-头版-CY114MO | 4XL | 罗兰方 | 320212 | 358909 | 2026-02-03 16:36:40 | 2 | 2026-03-22 17:35:36.654419 |
| LF26011700129907 | 25FLYERS-2男款跑步背心-头版-CY114MO | 3XL | 罗兰方 | 320212 | 358909 | 2026-02-03 16:36:40 | 1 | 2026-03-22 17:35:36.652704 |
| LF26011700129906 | 25FLYERS-2男款跑步背心-头版-CY114MO | 2XL | 罗兰方 | 320212 | 358909 | 2026-02-03 16:36:40 | 4 | 2026-03-22 17:35:36.599505 |
| LF26011700129905 | 25FLYERS-2男款跑步背心-头版-CY114MO | XL | 罗兰方 | 320212 | 358909 | 2026-02-03 16:36:40 | 8 | 2026-03-22 17:35:36.597994 |
| LF26011700129904 | 25FLYERS-2男款跑步背心-头版-CY114MO | L | 罗兰方 | 320212 | 358909 | 2026-02-03 16:36:40 | 10 | 2026-03-22 17:35:36.596451 |
| LF26011700129903 | 25FLYERS-2男款跑步背心-头版-CY114MO | M | 罗兰方 | 320212 | 358909 | 2026-02-03 16:36:40 | 2 | 2026-03-22 17:35:36.594926 |
| LF26011700129902 | 25FLYERS-2男款跑步背心-头版-CY114MO | S | 罗兰方 | 320212 | 358909 | 2026-02-03 16:36:40 | 5 | 2026-03-22 17:35:36.593347 |
| LF26011700129901 | 25FLYERS-2男款跑步背心-头版-CY114MO | XS | 罗兰方 | 320212 | 358909 | 2026-02-03 16:36:40 | 2 | 2026-03-22 17:35:36.591493 |
| RX26012100149905 | JarneVos男款跑步T恤-头版-CY116M | XL | 袁日仙 | 320644 | 358910 | 2026-02-03 16:37:04 | 2 | 2026-03-22 17:35:36.589956 |
| JN26011000099904 | PW BHY white女款短袖连体衣-头版-YS9251WKCO | L | 陈锦娜 | 318323 | 358913 | 2026-02-03 16:37:34 | 1 | 2026-03-22 17:35:36.588393 |
| ZT26011700409901 | BH 26 blue女款短袖连体衣-头版-YS9212MJF | XS | 曾亭 | 320066 | 358915 | 2026-02-03 16:38:16 | 1 | 2026-03-22 17:35:36.586753 |
| RX26011700129908 | CUPCKE-Suzanne Theobald女款短袖连体衣-头版-YS9229WXZO | 4XL | 袁日仙 | 319264 | 358917 | 2026-02-03 16:38:56 | 1 | 2026-03-22 17:35:36.585197 |
| MJ26011700049904 | ALD Catalyst男款背带短裤-头版-YS2076MHO | L | 庄镘洁 | 319785 | 358919 | 2026-02-03 16:39:32 | 3 | 2026-03-22 17:35:36.583610 |
| MJ26011700049903 | ALD Catalyst男款背带短裤-头版-YS2076MHO | M | 庄镘洁 | 319785 | 358919 | 2026-02-03 16:39:32 | 8 | 2026-03-22 17:35:36.582077 |
| MJ26011700049902 | ALD Catalyst男款背带短裤-头版-YS2076MHO | S | 庄镘洁 | 319785 | 358919 | 2026-02-03 16:39:32 | 8 | 2026-03-22 17:35:36.580545 |
| MJ26012400389906 | TCHACO FADA男款POLO衫-头版-YS9450MO | 2XL | 庄镘洁 | 322192 | 358920 | 2026-02-03 16:40:03 | 3 | 2026-03-22 17:35:36.579040 |
| MJ26012400389905 | TCHACO FADA男款POLO衫-头版-YS9450MO | XL | 庄镘洁 | 322192 | 358920 | 2026-02-03 16:40:03 | 15 | 2026-03-22 17:35:36.577510 |
| MJ26012400389904 | TCHACO FADA男款POLO衫-头版-YS9450MO | L | 庄镘洁 | 322192 | 358920 | 2026-02-03 16:40:03 | 11 | 2026-03-22 17:35:36.576000 |
| MJ26012400389903 | TCHACO FADA男款POLO衫-头版-YS9450MO | M | 庄镘洁 | 322192 | 358920 | 2026-02-03 16:40:03 | 8 | 2026-03-22 17:35:36.574446 |