我需要比较两个csv文件。一个是我每天都会收到的新产品,另一个是包含所有库存产品的。通过比较sku,如果两个文件中有相同的产品,我有工具。新产品的第一个csv可能多次具有相同的sku。因此,如果有匹配,我需要将第二个csv中的Prod.ID添加到新列中第一个csv的sku中。
这就是第一个csv的样子:
ID SKU Cat Price
0 12345678 Clothes 10.00
0 12345678 Clothes 10.00
0 87654321 Bath 5.00
第二个文件看起来像这个
ID SKU Cat Price
321 12345678 Clothes 10.00
532 87654321 Bath 5.00
因此,我需要将第二个csv的ID添加到第一个csv中的每个匹配SKU中,并将其保存到一个新的csv中,以获得列表,最终看起来如下:
ID SKU Cat Price
321 12345678 Clothes 10.00
321 12345678 Clothes 10.00
532 87654321 Bath 5.00
现在我有以下代码,但我只得到一个空的updated.csv。我总共卡住了:(
$fp = fopen('updated.csv', 'w');
$csvFile1 = "firts-file.csv";
$handle1 = fopen($csvFile1, "r");
$csvFile2 = "second-file.csv";
$handle2 = fopen($csvFile2, "r");
while(($data1 = fgetcsv($handle, 20000, ";")) && ($data2 = fgetcsv($handle2, 20000, ";" ))) {
$oldID = $data1[0];
$newID = $data2[0];
if(($data1[1]) == ($data2[1])) {
fputs($fp, str_replace($oldID, $newID, "'n"));
}
}
1.csv-$result
ID SKU Cat Price
0 12345678 Clothes 10.00
0 12345678 Clothes 10.00
0 87654321 Bath 5.00
2.csv-$source
ID SKU Cat Price
321 12345678 Clothes 10.00
532 87654321 Bath 5.00
代码
<?php
$csvHandleOne = fopen('1.csv', "r");
$source = $result = array();
while($data = fgetcsv($csvHandleOne, 2048, ";")) {
$result[] = $data;
}
fclose($csvHandleOne);
$csvHandleTwo = fopen('2.csv', "r");
while($data = fgetcsv($csvHandleTwo, 2048, ";")) {
//We are interested only in SKU and ID link
$source[$data[1]] = $data[0];
}
fclose($csvHandleTwo);
$csvHandleResult = fopen('result.csv', "w");
foreach ($result as $key => $value) {
if($key && isset($source[$value[1]])) {
//SKU => ID link found in source. Set id to $result
$value[0] = $source[$value[1]];
}
fputcsv($csvHandleResult, $value, ';');
}
fclose($csvHandleResult);