photographer Posted July 21, 2015 Share Posted July 21, 2015 (edited) I have been trying for the past two days to update my product prices through csv. I used to update product prices easily. But I can´t manage to get it to work now. I have a csv with only three columns, ID, NAME and PRICE (tax included) I have tried ticking force ID´s and leaving it blank, and the result is always the same. After mapping columns and pressing okay, i get sent back to the CVS import page without any warnings, errors, or messages. I can add new products, I just can get it to change the existing ones. I get a feeling that this is done so that people purchase an paid module. Please help me understand what is happening. I am digging through files to find the user name and password for the domain so that I can enable error reporting (though I don´t remember the excact file I must edit to achieve this). Anyhow I appreciate any help of any kind in this situation , and do apologize if it is the wrong area to post this. Thanks. Edited July 23, 2015 by photographer (see edit history) Link to comment Share on other sites More sharing options...
gonebdg - webindoshop.com Posted July 21, 2015 Share Posted July 21, 2015 What is your prestashop version ?Please go to B.O > Advanced Parameters > Configuration InformationCopy-paste all info in "Server information " blockAre you update your prestashop recently ? Link to comment Share on other sites More sharing options...
photographer Posted July 21, 2015 Author Share Posted July 21, 2015 What is your prestashop version ? Please go to B.O > Advanced Parameters > Configuration Information Copy-paste all info in "Server information " block Are you update your prestashop recently ? I am isun 1.6.0.6, here is config info: InformaciónUtilice esta información al reportar errores o problemas en el foro Información del servidorInformación del servidor: Linux #1 SMP Thu Dec 18 06:49:17 EST 2014 x86_64 Versión del servidor web: Apache/2.4.12 Versión de PHP: 5.4.37 Límite de memoria: 64M Tiempo Máximo de ejecución: 120 Configuración de la base de datosVersión de MySQL: 5.5.41-cll-lve Motor MySQL: InnoDB Prefijo de las tablas: ps_ Información de la tiendaVersión de PrestaShop: 1.6.0.6 Enlace de su tienda: http://vidaom.com/vidaom/ Tema actual: default_estilo Configuración de emailModo de envío de emails: Utiliza la función email() de PHP Sus datosNavegador utilizado: Mozilla/5.0 (Windows NT 6.1; rv:39.0) Gecko/20100101 Firefox/39.0 Compruebe su configuraciónParámetros requeridos: ok Parámetros opcionales: ok I couldnt chabge my working directory to root. About a year ago, when I tried, I got errors. so I left it there where it lies now. It may be time to try it again, and see if I dont get the same 500 error. Could that be an issue? the fat that it is not in root directory? THX. Link to comment Share on other sites More sharing options...
gonebdg - webindoshop.com Posted July 21, 2015 Share Posted July 21, 2015 (edited) ..................... I have a csv with only three columns, ID, NAME and PRICE (tax included) I have tried ticking force ID´s and leaving it blank, and the result is always the same. After mapping columns and pressing okay, i get sent back to the CVS import page without any warnings, errors, or messages. ..................... When mapping your csv file, the column data should be like this : ID -> ID Name -> Name PRICE -> Price tax included I'm not sure what you mean about "I have tried ticking force ID´s and leaving it blank ... " If you want to update product price, then "Force all ID numbers" option should be set to "YES" and your CSV file should contains Product ID's. Ensure the option value of "Lines to skip" is set to 1 because your CSV file have a header [ ID | NAME | PRICE ] Finally you can proceed to "Import CSV data". Edited July 21, 2015 by gonebdg - webindoshop.com (see edit history) Link to comment Share on other sites More sharing options...
photographer Posted July 21, 2015 Author Share Posted July 21, 2015 When mapping your csv file, the column data should be like this : ID -> ID Name -> Name PRICE -> Price tax included YES, that is exactly how it is. I have a configuration already saved so I can load it directly. I have checked that the mapping is always correct. I also Include all IDs. I'm not sure what you mean about "I have tried ticking force ID´s and leaving it blank ... " If you want to update product price, then "Force all ID numbers" option should be set to "YES" and your CSV file should contains Product ID's. I mean that I have tried with forcing all IDS yes and no. I am running out of options. Though I am aware the coorect format is Force all ids YES. I will enable error reporting to see what is happening. Link to comment Share on other sites More sharing options...
photographer Posted July 22, 2015 Author Share Posted July 22, 2015 Weird. I turned on DEV mode, and I get no errors. I am a loss. If I need to grant access to BO i will, but this is bunkers! Link to comment Share on other sites More sharing options...
gonebdg - webindoshop.com Posted July 22, 2015 Share Posted July 22, 2015 I guess there is something wrong within your products database.What is the previous version of your Prestashop before updated into v.1.6.0.6 ? Please select one active product for testing purpose, make a note about its product ID.Go to B.O > Advanced Parameters > SQL ManagerCreate and run following SQL queries (in this example id_product = 1):SQL query Name : getProductDataSQL query : SELECT id_product, id_shop_default, price, wholesale_price FROM ps_product WHERE id_product = 1 SQL query Name : getProductShopDataSQL query : SELECT id_product, id_shop, price, wholesale_price FROM ps_product_shop WHERE id_product = 1 copy-paste the SQL query result in here (pre-update-price).Then try to update the price of selected product with CSV importRun again the SQL queries above.copy-paste the SQL query result in here (post-update-price). Link to comment Share on other sites More sharing options...
photographer Posted July 22, 2015 Author Share Posted July 22, 2015 I got the message, will find time to update the post as per your requirements in the afternoon. Thanks for the reply. Link to comment Share on other sites More sharing options...
photographer Posted July 22, 2015 Author Share Posted July 22, 2015 I did What you told me to, here are the results. Pre-update: getProductData: id_product id_shop_default price wholesale_price 1200 1 0.000000 0.000000 getProductShopData: id_product id_shop price wholesale_price 1200 1 0.000000 0.000000 Post update: getProductData: id_product id_shop_default price wholesale_price 1200 1 200.000000 0.000000 getProductShopData: id_product id_shop price wholesale_price 1200 1 200.000000 0.000000 As you can see the prace was updated!!! ALAS! Here is what happened: I tried updating prices with a dollar symbol included. I was fool not to check that all my prices were in the '$price' form. I want to thank you all for the support that led me to realize that it was a mistake from my part that was causing the problem. Thanks for the support and have a good day! Link to comment Share on other sites More sharing options...
gonebdg - webindoshop.com Posted July 23, 2015 Share Posted July 23, 2015 Great ... you're finally found the causes and solved the problem, no need to buy and use paid module Don't forget to edit this thread title, append prefix [solved] Link to comment Share on other sites More sharing options...
Guest locen Posted January 25, 2016 Share Posted January 25, 2016 Hi, me too have problem ith importing products. I check columns, i click button ".CSV IMPORT" then i show this image Then when i go to products it doesn't show me product imported. The strange fact is that it functions until 2minutes ago. Please help me Link to comment Share on other sites More sharing options...
ioan1iuga Posted January 25, 2016 Share Posted January 25, 2016 Does anyone have a solution for this issue? I have the exact same problem. Everything works out just fine, the .csv is succssfully imported, but no products appear in the products' list or in the shop. It's not possible to have to insert manually thousands of products. There has to be a way to solve this fetching issue. Link to comment Share on other sites More sharing options...
ioan1iuga Posted January 28, 2016 Share Posted January 28, 2016 Please!!! Someone reply!!!! I just noticed that not only the products are not updated after csv import, but some of the existing products in the shop are also overridden by products in the .csv file. How is this even possible? Does anyone know what I should do in this situation? It is absolutely nerve racking, as I have to keep deleting products. Thanks in advance. Link to comment Share on other sites More sharing options...
Guest locen Posted January 28, 2016 Share Posted January 28, 2016 What are your setting in csv import? Link to comment Share on other sites More sharing options...
ioan1iuga Posted February 3, 2016 Share Posted February 3, 2016 Hello, Thank you for your reply. I didn't receive a notification, which is why my answer comes so late. I tried different methods. I did it with the `Force all ID numbers` option enabled and disabled, the option `use product reference as key` enabled and disabled and so on. The message I get is always the same: that the transfer has been successful (in green). However, none of the products are actually imported. From what I can understand, the system cannot fetch the products I am trying to import, which I wouldn't know how to solve. Any suggestion is highly appreciated. Link to comment Share on other sites More sharing options...
Guest locen Posted February 3, 2016 Share Posted February 3, 2016 My problem when I saw succesfull update was that i had alredy imported product with the same ID. It provabilly that you have some product with the same id you want to import Link to comment Share on other sites More sharing options...
ioan1iuga Posted February 3, 2016 Share Posted February 3, 2016 I will try to change the IDs with some that don't exist in the product's list and I will let you know what happened. Thank you! Link to comment Share on other sites More sharing options...
ioan1iuga Posted February 3, 2016 Share Posted February 3, 2016 Thank you again Iocen, It worked. I changed all the IDs and the product list is updated. Link to comment Share on other sites More sharing options...
mmsh Posted February 25, 2016 Share Posted February 25, 2016 (edited) Hello... so please explain better: are you saying that's impossible to UPDATE existing products? OR, If you're forced to autoincrement the ID's ... do you need to UPDATE creating new IDs and before deleting the existing ones by option? but this is unbelievable... 'cause it may create issues with 1) changed friendly urls 2) sitemap to Google & co. 3) shopping feed to sales channels... are you sure that it doesn't update the existing products? Thanks Edited February 25, 2016 by mmsh (see edit history) Link to comment Share on other sites More sharing options...
Guest locen Posted February 25, 2016 Share Posted February 25, 2016 (edited) It update products that exist already in shop Edited February 25, 2016 by locen (see edit history) Link to comment Share on other sites More sharing options...
mmsh Posted February 25, 2016 Share Posted February 25, 2016 e.g. I would like to update images for some products only... ID, reference, name, Image URLs ...are not enough? Link to comment Share on other sites More sharing options...
mmsh Posted February 25, 2016 Share Posted February 25, 2016 It update products that exist already in shop ok, but I don't want to change product id ... is possible? If I create a .csv with id, reference, name, Image URLs does it work without changing product id? 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