Ninja2000 Posted July 3, 2016 Share Posted July 3, 2016 (edited) When I use the force ID numbers option in the CSV import for my products I get the following error Property Product->link_rewrite is not valid If I turn off the option my products import just fine. I would like to use my own ID numbers if possible. I have tried with 4 products using the following ID: 4716 4712 4719 8877 Is there some special rules for ID numbers that I need to follow? Edited July 5, 2016 by Ninja2000 (see edit history) Link to comment Share on other sites More sharing options...
rocky Posted July 4, 2016 Share Posted July 4, 2016 I see nothing wrong with your product IDs. From the error message, it would seem you have specified an invalid friendly URL in your CSV file, or you haven't specified friendly URLs and there's an invalid character in a product name. Friendly URLs can only contain lowercase and uppercase letters, numbers, hyphens and underscores. Also note that you can't use accented characters unless you have enabled "Accented URL" on the Preferences > SEO & URLs tab. Link to comment Share on other sites More sharing options...
Ninja2000 Posted July 4, 2016 Author Share Posted July 4, 2016 I see nothing wrong with your product IDs. From the error message, it would seem you have specified an invalid friendly URL in your CSV file, or you haven't specified friendly URLs and there's an invalid character in a product name. Friendly URLs can only contain lowercase and uppercase letters, numbers, hyphens and underscores. Also note that you can't use accented characters unless you have enabled "Accented URL" on the Preferences > SEO & URLs tab. That is what I thought however I have only 4 products in my CSV to test and my products import fine if I turn off the Force ID option. Link to comment Share on other sites More sharing options...
rocky Posted July 4, 2016 Share Posted July 4, 2016 Perhaps the product IDs already exist in the database and they have invalid friendly URLs? That could explain why it works with "Force ID" disabled, but fails when updating existing products. I can't think of any other reason it wouldn't work. If specifying valid friendly URLs in your CSV file doesn't work, you could try looking for those IDs in the ps_product tables and deleting them so PrestaShop can create them instead of updating them. Link to comment Share on other sites More sharing options...
Ninja2000 Posted July 4, 2016 Author Share Posted July 4, 2016 Perhaps the product IDs already exist in the database and they have invalid friendly URLs? That could explain why it works with "Force ID" disabled, but fails when updating existing products. I can't think of any other reason it wouldn't work. If specifying valid friendly URLs in your CSV file doesn't work, you could try looking for those IDs in the ps_product tables and deleting them so PrestaShop can create them instead of updating them. This is just a test install of Prestashop no other products exist, I am just practising importing using CSVs so I started with just 4 products. Link to comment Share on other sites More sharing options...
Ninja2000 Posted July 4, 2016 Author Share Posted July 4, 2016 Okay when I use the force option it doesn't like the spaces in my product names for some reason, this does not happen when the force option is disabled. Link to comment Share on other sites More sharing options...
Ninja2000 Posted July 4, 2016 Author Share Posted July 4, 2016 Got it! it was the field "URL rewritten" it doesn't like spaces. Link to comment Share on other sites More sharing options...
rocky Posted July 4, 2016 Share Posted July 4, 2016 I'm happy you figured it out. Please edit your first post and add [sOLVED] to the front of the title. 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