Error

[Dicheto2302]

Hello,
I am using this plugin, but i am getting this error in admin panel after clicking import:
We catched some errors during import, please check foc logs!

Errors count - 1

How to see the log?

[RTechSn]

I would like to know where i can read the log too. OpenCart logs page is empty.

[dicheto]

Yesss... No answer at all...the project must be discounted!

[RTechSn]

Well, looks like we have to fix the issue ourselves.
Open \model\extension\module\foc_common.php and find the function called writeLog.
Add the following code after $this->log->write($msg);

$date = new DateTime('now', new DateTimeZone('Europe/Paris'));
$date = $date->format("y:m:d H:m:s");    
file_put_contents("foc.log", $date . ": " . $msg . "\n", FILE_APPEND | LOCK_EX);

You can find the log file in your admin folder.

[dicheto]

Any ideas what is this error:
Error: Subquery returns more than 1 row
Error No: 1242
SELECT IFNULL((SELECT product_id FROM md_product WHERE sku LIKE "3800931053956"), 0) AS id

?

[ikenfin]

Hi! Sorry for late response, did'nt saw that there was issues.
@RTechSn log files created using standard opencart logger in DIR_LOGS/foc_csv_[export/import].txt
@dicheto this kind of error happens when there is more than one product in your DB with similar key value. From your logs it means that you have multiple products which have sku = 3800931053956. There is no real fix to this problem, because - who knows which product with duplicate key need to be chosen for update? You could use another field as key, or you can fix conflicting sku-s in you store