I made 4 new fields for the script but I managed to only import 357 out of 360 into SQL. I discovered that the 3 missing data had "100%" for one of the new fields (savings), whereas the ones with 99.99%, 54.20%, 12.00%, etc was successfully imported into the SQL. I'm using varchar 255 for the savings field. How do I import the remaining data with "100%" into SQL?
Thanks in advance
I figured this out. The price was 0. I had to change it to 0.00 in the feeds for it to be accepted.
Thanks
Hi,
That's a strange one! I presume that you haven't include the normalise() call in the code to import your new fields, as this would block the "." - so that can't be causing the problem. Can you verify that there are no other 100% records successfully imported, and that the 3 non-imported records haven't failed on one of the required fields check (unique product name, buy URL and price)?
If that doesn't shed any light you're welcome to email me over a copy of your modified admin/import.php and i'll check it over for you - reply to your reg code or forum registration email is the easiest way to get me...
Cheers,
David.