Jump to content

How to modify product from database?


Recommended Posts

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.


Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.


Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...