Jump to content

Welcome, Guest!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

Joint Systems

CSV 1.1 import error

Recommended Posts

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?  

 

 

error importing.PNG

error rewrite link.PNG

Edited by Joint Systems
Additional info.

Share this post


Link to post
Share on other sites

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

  • Like 1

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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!) 

Share this post


Link to post
Share on other sites
On 11/7/2019 at 1:31 PM, Joint Systems said:

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.

Share this post


Link to post
Share on other sites

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.    

Share this post


Link to post
Share on other sites
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 

 

Share this post


Link to post
Share on other sites

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.  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.  

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...