CSV 1.1 import error

[Joint Systems]

I was trying to import some 500 products.  Verification was 100%.  When it got to the beginning of the import it stopped with 5 products errors out of 500.  Do not know what is wrong with products as there is no reason given.  Note at the bottom of the import the links for the same five products were rewritten.  Nothing was imported, had the same issues with Prestashop 1.7+.   I deleted the 5 items that were reported  as errors, they tried to import again.  Same 100  verified then 5 more errors appeared, deleted those. Tried to reimport, got 5 more errors?  

 

 

Edited November 5, 2019 by Joint Systems
Additional info.

[musicmaster]

Just wondering: is it having problems with the dashes in the ids?

[Joint Systems]

Are dashes a problem?  Will try taking them out.  These are manufacturers part numbers, will leave the dashes in the names. 

[musicmaster]

You have the reference code field for such info. 

[Joint Systems]

Took out the dashes using excel general replacement, same result.

 

[zen]

Can you provide the csv your are trying to import, so I can test also on the same conditions ?

[Joint Systems]

Attached.

Dewalt Sept 2019 active 1-500.csv

[Joint Systems]

Here are the last two entries on the error log.

7-Nov-2019 09:20:41 US/Eastern] PHP Notice:  Trying to get property of non-object in /home/usenginescorp/public_html/usengines.net/cache/smarty/compile/28/f0/06/28f006dfbde8c07fbc26ecff8a4accb616092e8b_0.file.category.tpl.php on line 106
[07-Nov-2019 09:21:11 US/Eastern] PHP Notice:  Undefined index: subcategories in /home/usenginescorp/public_html/usengines.net/cache/smarty/compile/28/f0/06/28f006dfbde8c07fbc26ecff8a4accb616092e8b_0.file.category.tpl.php on line 106
[07-Nov-2019 09:21:11 US/Eastern] PHP Notice:  Trying to get property of non-object in /home/usenginescorp/public_html/usengines.net/cache/smarty/compile/28/f0/06/28f006dfbde8c07fbc26ecff8a4accb616092e8b_0.file.category.tpl.php on line 106

[zen]

I got the file you posted.. can you also give the mapping for import you setup ?

Because there is many fields to map correctly, it takes time just for testing ... thanks for provindig this too.

[Joint Systems]

Mapping sent in PM.

Here are the last two entries on the error log.

7-Nov-2019 09:20:41 US/Eastern] PHP Notice:  Trying to get property of non-object in /home/usenginescorp/public_html/usengines.net/cache/smarty/compile/28/f0/06/28f006dfbde8c07fbc26ecff8a4accb616092e8b_0.file.category.tpl.php on line 106
[07-Nov-2019 09:21:11 US/Eastern] PHP Notice:  Undefined index: subcategories in /home/usenginescorp/public_html/usengines.net/cache/smarty/compile/28/f0/06/28f006dfbde8c07fbc26ecff8a4accb616092e8b_0.file.category.tpl.php on line 106
[07-Nov-2019 09:21:11 US/Eastern] PHP Notice:  Trying to get property of non-object in /home/usenginescorp/public_html/usengines.net/cache/smarty/compile/28/f0/06/28f006dfbde8c07fbc26ecff8a4accb616092e8b_0.file.category.tpl.php on line 106

[musicmaster]

54 minutes ago, Joint Systems said:

Here are the last two entries on the error log.

7-Nov-2019 09:20:41 US/Eastern] PHP Notice:  Trying to get property of non-object in /home/usenginescorp/public_html/usengines.net/cache/smarty/compile/28/f0/06/28f006dfbde8c07fbc26ecff8a4accb616092e8b_0.file.category.tpl.php on line 106
[07-Nov-2019 09:21:11 US/Eastern] PHP Notice:  Undefined index: subcategories in /home/usenginescorp/public_html/usengines.net/cache/smarty/compile/28/f0/06/28f006dfbde8c07fbc26ecff8a4accb616092e8b_0.file.category.tpl.php on line 106
[07-Nov-2019 09:21:11 US/Eastern] PHP Notice:  Trying to get property of non-object in /home/usenginescorp/public_html/usengines.net/cache/smarty/compile/28/f0/06/28f006dfbde8c07fbc26ecff8a4accb616092e8b_0.file.category.tpl.php on line 106

We don't know what template you are using and so we don't know your category.tpl file so it is impossible to say what goes wrong. You should open those cache files and look at the indicated line what goes wrong. Then you should look in the category.tpl of your template for the same line (this is at a different line number!) 

[colorful-ant]

On 11/7/2019 at 1:31 PM, Joint Systems said:

Attached.

Dewalt Sept 2019 active 1-500.csv 44.31 kB · 3 downloads

Personally, I do not like this version / format with a comma.
I only use csv with semicolon separated fields.
with Excell or e.g. OpenOffice I have a better overview and can also find an error faster, if there should be problems during the import and that does not happen often.

[Joint Systems]

The price sheets from the manufacturers come with the coma used as a separator.  With PS I always had to change the ;  to a comma, with TB you don't.   On the other had PS seemed to learn or defaulted to products where as TB defaults to categories.  It would seem that product imports would be the most common use rather than categories?  I use excel from office 2016 to edit the price files.   Usually the errors are caused by letters or ineligible characters used for the part numbers but in this case I don't know what is causing the errors as the IDs do not seem to have obvious problems?  

Ended up using a simple numerical excel series which imports easily but causes products when the ID is changed with each price sheet.    

[datakick]

22 minutes ago, Joint Systems said:

I don't know what is causing the errors as the IDs do not seem to have obvious problems?  

If you are trying to use value 7100640000 as a product primary key then the mysql will probably complain - id_product column is defined as unsigned int, which can store max value = 4294967295 

 

[Joint Systems]

That is really interesting about the max  csv value as it makes the use of thousands of part names invalid for import as well as all upc and ean numbers.  The price sheets from the manufacturers come with the coma used as a separator. Are - a problem, and what afffect to they  have on the max size?   TB also works with xslx files which seem to be  more for giving.

With PS I always had to change the ;  to a comma, with TB you don't.   On the other had PS seemed to learn or default to products where as TB defaults to categories.  It would seem that product imports would be the most common use rather than categories?  I use excel from office 2016 to edit the price files.   Usually the errors are caused by letters or ineligible characters used for the part numbers but in this case I don't know what is causing the errors as the IDs do not seem to have obvious problems?  

Ended up using a simple numerical excel series which imports easily but causes products when the ID is changed with each price sheet.  If you use an Excel simple number series for the ID the import process works very well.  Was able to import over 32000 items in one batch.  

Edited December 21, 2020 by Joint Systems
Addition.-updated