Joint Systems Posted November 5, 2019 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.
musicmaster Posted November 6, 2019 Posted November 6, 2019 Just wondering: is it having problems with the dashes in the ids?
Joint Systems Posted November 6, 2019 Author 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.
musicmaster Posted November 6, 2019 Posted November 6, 2019 You have the reference code field for such info. 1
Joint Systems Posted November 6, 2019 Author Posted November 6, 2019 Took out the dashes using excel general replacement, same result.
zen Posted November 7, 2019 Posted November 7, 2019 Can you provide the csv your are trying to import, so I can test also on the same conditions ? 1
Joint Systems Posted November 7, 2019 Author Posted November 7, 2019 Attached. Dewalt Sept 2019 active 1-500.csv
Joint Systems Posted November 7, 2019 Author 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
zen Posted November 7, 2019 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.
Joint Systems Posted November 7, 2019 Author 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
musicmaster Posted November 7, 2019 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!)
colorful-ant Posted November 9, 2019 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.
Joint Systems Posted November 16, 2019 Author 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.
datakick Posted November 16, 2019 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
Joint Systems Posted November 20, 2019 Author 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
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