Joint Systems Posted November 5, 2019 Share Posted November 5, 2019 (edited) 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. Link to comment Share on other sites More sharing options...
musicmaster Posted November 6, 2019 Share Posted November 6, 2019 Just wondering: is it having problems with the dashes in the ids? Link to comment Share on other sites More sharing options...
Joint Systems Posted November 6, 2019 Author Share Posted November 6, 2019 Are dashes a problem? Will try taking them out. These are manufacturers part numbers, will leave the dashes in the names. Link to comment Share on other sites More sharing options...
musicmaster Posted November 6, 2019 Share Posted November 6, 2019 You have the reference code field for such info. 1 Link to comment Share on other sites More sharing options...
Joint Systems Posted November 6, 2019 Author Share Posted November 6, 2019 Took out the dashes using excel general replacement, same result. Link to comment Share on other sites More sharing options...
zen Posted November 7, 2019 Share Posted November 7, 2019 Can you provide the csv your are trying to import, so I can test also on the same conditions ? 1 Link to comment Share on other sites More sharing options...
Joint Systems Posted November 7, 2019 Author Share Posted November 7, 2019 Attached. Dewalt Sept 2019 active 1-500.csv Link to comment Share on other sites More sharing options...
Joint Systems Posted November 7, 2019 Author Share Posted November 7, 2019 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 Link to comment Share on other sites More sharing options...
zen Posted November 7, 2019 Share Posted November 7, 2019 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. Link to comment Share on other sites More sharing options...
Joint Systems Posted November 7, 2019 Author Share Posted November 7, 2019 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 Link to comment Share on other sites More sharing options...
musicmaster Posted November 7, 2019 Share Posted November 7, 2019 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!) Link to comment Share on other sites More sharing options...
colorful-ant Posted November 9, 2019 Share Posted November 9, 2019 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. Link to comment Share on other sites More sharing options...
Joint Systems Posted November 16, 2019 Author Share Posted November 16, 2019 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. Link to comment Share on other sites More sharing options...
datakick Posted November 16, 2019 Share Posted November 16, 2019 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 Link to comment Share on other sites More sharing options...
Joint Systems Posted November 20, 2019 Author Share Posted November 20, 2019 (edited) 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 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now