SQL Error in Import

JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '40,41,42,43,44,45,46,47,48)' at line 1 SQL=DELETE FROM saj_hikashop_price WHERE price_product_id IN (38,,40,41,42,43,44,45,46,47,48)

2 commas - '(38,,40,...)'

Looks like a sanity check is needed when generating the SQL.

Will investigate my CSV file later to find out why this is happening - and if necessary produce a test case for you.

You can replace the line : by the line: in the fil administrator/components/com_hikashop/helpers/import.php to fix the problem.
Now, that means that some data is not consistant for some reason so you might be missing some data somewhere...

Looking at the table data saw where I needed to tidyup.

Problem caused by newlines in the CSV file product_description field.
Removed those then import worked OK.

Thanks.

It should work with new lines in the description as long as the field is double quoted :
product_code,product_description
test,"my desc
on several lines"