Jump to content
Webgaict

How to modify product from database?

Recommended Posts

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!

 

Share this post


Link to post
Share on other sites

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.

 

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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:

 

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

 

I just need to insert the images for this product.

Could you help me?

Thanks!

Share this post


Link to post
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.

grafik.thumb.png.1ff9164d23a220df5e9e798e55baa23d.png

Share this post


Link to post
Share on other sites

 

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!

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

 

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More