The import function must be suited for mysql 5.x
Make a correct CSV import function:
Example import csv file:
"Title" "Category" "Address" "City" "State" "Country" "Zip" "Telephone" "Website"
"Safori Living" "Australia" "Unit 14-133 Lennox Street" "Richmond" "Australia" "VIC 3121" "6139421399" "[login to view URL]"
"Sobo Sang Gmbh" "Austria" "Praterstrasse 10-10" "Vienna" "Austria" "A-1220 " "+43(0)11234" "[login to view URL]"
1. Check if Title exist, if exist, replace instead insert.
2. When category doesn't exist, create category first.