到货库存导入(采购入库 Excel)
系统会从 Excel 中抓取:款式编号(清洗为SKU)、款式SKU、颜色及规格(提取尺码)、数量、商品名称、运营仓库、采购单号、入仓单号、采购员、入库日期。
库存汇总
| 产品SKU | 中文名 | 尺码 | 采购员 | 采购单号 | 入仓单号 | 入库日期 | 当前库存 | 更新时间 |
|---|---|---|---|---|---|---|---|---|
| MJ26012100139903 | TCHACO INTERCLUBE男款POLO衫-头版-YS9450MO | M | 庄镘洁 | 320646 | 358382 | 2026-02-02 10:58:38 | 6 | 2026-03-22 17:35:37.997321 |
| MJ26012100109905 | TCHACO MAIANGA男款跑步背心-头版-YS9787MXO | XL | 庄镘洁 | 320646 | 358382 | 2026-02-02 10:58:38 | 3 | 2026-03-22 17:35:37.995692 |
| MJ26012100109904 | TCHACO MAIANGA男款跑步背心-头版-YS9787MXO | L | 庄镘洁 | 320646 | 358382 | 2026-02-02 10:58:38 | 5 | 2026-03-22 17:35:37.994130 |
| MJ26012100109903 | TCHACO MAIANGA男款跑步背心-头版-YS9787MXO | M | 庄镘洁 | 320646 | 358382 | 2026-02-02 10:58:38 | 4 | 2026-03-22 17:35:37.992425 |
| MJ26012100109902 | TCHACO MAIANGA男款跑步背心-头版-YS9787MXO | S | 庄镘洁 | 320646 | 358382 | 2026-02-02 10:58:38 | 3 | 2026-03-22 17:35:37.990837 |
| LF25110500039904 | PD-PEDAL男款背带短裤-头版-YS2029M | L | 罗兰方 | 319930 | 358383 | 2026-02-02 10:58:59 | 1 | 2026-03-22 17:35:37.989224 |
| LF25110500039903 | PD-PEDAL男款背带短裤-头版-YS2029M | M | 罗兰方 | 319930 | 358383 | 2026-02-02 10:58:59 | 2 | 2026-03-22 17:35:37.987686 |
| LF25110500039902 | PD-PEDAL男款背带短裤-头版-YS2029M | S | 罗兰方 | 319930 | 358383 | 2026-02-02 10:58:59 | 2 | 2026-03-22 17:35:37.986173 |
| LF25110500039901 | PD-PEDAL男款背带短裤-头版-YS2029M | XS | 罗兰方 | 319930 | 358383 | 2026-02-02 10:58:59 | 1 | 2026-03-22 17:35:37.984601 |
| ZT26012100269902 | LA MOZ Black女款背带短裤-头版-YS9163WO | S | 曾亭 | 319716 | 358384 | 2026-02-02 10:59:22 | 2 | 2026-03-22 17:35:37.982987 |
| RX25120100079905 | LBCC-SS25女款背带短裤-三版-YS9115WDBO | XL | 袁日仙 | 309627 | 358385 | 2026-02-02 10:59:49 | 2 | 2026-03-22 17:35:37.981431 |
| RX25120100079904 | LBCC-SS25女款背带短裤-三版-YS9115WDBO | L | 袁日仙 | 309627 | 358385 | 2026-02-02 10:59:49 | 10 | 2026-03-22 17:35:37.979907 |
| RX25120100079903 | LBCC-SS25女款背带短裤-三版-YS9115WDBO | M | 袁日仙 | 309627 | 358385 | 2026-02-02 10:59:49 | 23 | 2026-03-22 17:35:37.978316 |
| RX25120100079902 | LBCC-SS25女款背带短裤-三版-YS9115WDBO | S | 袁日仙 | 309627 | 358385 | 2026-02-02 10:59:49 | 14 | 2026-03-22 17:35:37.976788 |
| RX25120100079901 | LBCC-SS25女款背带短裤-三版-YS9115WDBO | XS | 袁日仙 | 309627 | 358385 | 2026-02-02 10:59:49 | 12 | 2026-03-22 17:35:37.975158 |
| ZT26012100279905 | LA MOZ Black Cargo男款三铁短裤-头版-YS9163MDEO | XL | 曾亭 | 320633 | 358386 | 2026-02-02 11:00:15 | 1 | 2026-03-22 17:35:37.973550 |
| ZT26012100279903 | LA MOZ Black Cargo男款三铁短裤-头版-YS9163MDEO | M | 曾亭 | 320633 | 358386 | 2026-02-02 11:00:15 | 1 | 2026-03-22 17:35:37.972022 |
| ZT26012100279902 | LA MOZ Black Cargo男款三铁短裤-头版-YS9163MDEO | S | 曾亭 | 320633 | 358386 | 2026-02-02 11:00:15 | 1 | 2026-03-22 17:35:37.970486 |
| ZT26010700129907 | BH 26 white Primo男款短上衣-头版-YS9470MYBO | 3XL | 曾亭 | 319638 | 358387 | 2026-02-02 11:00:39 | 2 | 2026-03-22 17:35:37.968983 |
| ZT26010700129906 | BH 26 white Primo男款短上衣-头版-YS9470MYBO | 2XL | 曾亭 | 319638 | 358387 | 2026-02-02 11:00:39 | 1 | 2026-03-22 17:35:37.967320 |