How to modify product from database?

[Webgaict]

Hello, would it be possible to modify a product from database, description, images, category and prices?

If it is possible how?

On which tables should I go to act?

Thanks for help!

 

[selectshop.at]

What exactly do you want to make ? It is only one modification, or do you want to use it for to maintain data ?

For to maintain data you can:

1) use csv import

PS 1.7. http://doc.prestashop.com/display/PS17/Import

PS 1.6. http://doc.prestashop.com/display/PS16/Import+CSV

2) webservice

PS 1.7. http://doc.prestashop.com/display/PS17/Webservice

PS 1.6. http://doc.prestashop.com/display/PS16/Webservice+Parameters

3) Another possibility is to use a tool like Presta Store Manager.

 

[Webgaict]

Hello, I have prestashop 1.7.5 and a blocked product with 3500 combinations, and I would like to at least modify the images and the price. Or if there is a solution to unlock the product?

[selectshop.at]

For to modify only prices and images I will go via csv. You had success to add this huge quantity of combinations ? If not you should run on dedicated server. Otherwise you will be not successful. See here same question just answered few minutes ago:

 

[Webgaict]

To insert this product I did it first in local all the combinations entered and deleted those that I did not need, once imported the product in the online store, it does not allow me to modify it. From csv, however, the product is not updated but another one is generated.

[Webgaict]

 

I just need to insert the images for this product.

Could you help me?

Thanks!

[selectshop.at]

For to insert the images, you need at first to know the id of the product. Otherwise you will have the effect you are having: a new product is inserted into database. For to know the ID of the products, use the export function on BO product list. On right top you will find the function. Export ID, product-title/name. with both you will be able to map the images to the products and import them. Before you make big changes into database, always make a back-up before.

Docu for csv import I've added some post before. Take a look into that.

PS: you images must be accessible by URL, so load them to your server on a temporary folder and add than the URL/temporaryfolder/imagename.jpg to the line of the product you are changing the image.

[Webgaict]

 

Hi, I entered the images via csv, but how can I change the default category? I tried to insert it from csv but it is not modified.

Thanks for help!

[selectshop.at]

16 minutes ago, Webgaict said:

 

Hi, I entered the images via csv, but how can I change the default category? I tried to insert it from csv but it is not modified.

Thanks for help!

By the same way. If you are using sub-categories than you should separate them with a separator. Docu for import csv you will find here: https://support.prestashop.com/hc/en-us/articles/115000646112-8-4-Importing-products

[selectshop.at]

On the import function you can download csv samples. Take a look into them. As separators you can use ; or |

[Webgaict]

 

Hi, can I add related products in the csv file?

[Webgaict]

 

However the product has only one category but does not become the default. The "Home" category always remains