Jump to content
PCQUATRO

Update products with CSV

Recommended Posts

Posted (edited)

Hi i´m new to prestashop, i´m trying to implement a shop for my small business and i came across some important restrictions that i need to sort out in order to mantain the shop.

Using prestashop 1.7.6.1

So, my main problem is related to updating all the products (about 4000) price and stock, regulary by using a CSV file, i can easely import products from a CSV to add them to the database, but i´m not geting how to just update some fields, can someone give me a hint on how to do it???

Another problem is, when i import the products to the database the product tag is imported but every search i do in the front end returns nothing, for that to work i need to open eatch product and just save it, than it activates the tags, and the search works, the problem is opening and saving 4000 products, anybody knows how to work arround this?

Best regards

Edited by PCQUATRO (see edit history)

Share this post


Link to post
Share on other sites
Posted (edited)

Hello

Ok, i solved the first problem...

1 - Creating a CSV file downloaded from prestashop import function

 2 - Filling it with data, and import products using the options use reference as key and force all reference numbers

3 - Creat another CSV with a Reference# field and the other fields that i need to update, fill it with the changed, import it using the options use reference as key and force all reference numbers.

And "it just works"...

The second problem (the product TAG´s  are imported but not activated until i save the products in the prestashop backoffice) still persists, it might be a bug, maybe i need to report it in another thread!!!

Best Regards

Edited by PCQUATRO (see edit history)

Share this post


Link to post
Share on other sites
Posted (edited)

Hello again

Ok, i found the solution to the second problem, you need to go to Store Settings -> Search -> Recreate Index.

And "it just works"...

Best Regards

Edited by PCQUATRO (see edit history)

Share this post


Link to post
Share on other sites
12 hours ago, PCQUATRO said:

Hello again

Ok, i found the solution to the second problem, you need to go to Store Settings -> Search -> Recreate Index.

And "it just works"...

Best Regards

You might want to check this, simple solution should work for you.

 

Share this post


Link to post
Share on other sites
On 8/30/2019 at 3:49 PM, WisQQ said:

You might want to check this, simple solution should work for you.

 

Thanks friend i managed to update the the stocks and prices easily by creating an access database that creates the CSV´s for me, than i just need to upload them from prestashop backoffice...

Best Regards

Edited by PCQUATRO (see edit history)

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.

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