Update products with CSV

[PCQUATRO]

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 August 30, 2019 by PCQUATRO (see edit history)

[PCQUATRO]

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 August 30, 2019 by PCQUATRO (see edit history)

[PCQUATRO]

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 August 30, 2019 by PCQUATRO (see edit history)

[WisQQ]

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.

 

[PCQUATRO]

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 September 11, 2019 by PCQUATRO (see edit history)

[rizvi_alamdar]

My products didnt show under category page. I need to save them one by one after CSV import. Thankyou for the search related answer. Kindly if anyone about  product visibility issue under category page it will help. Thanks

[WisQQ]

8 hours ago, rizvi_alamdar said:

My products didnt show under category page. I need to save them one by one after CSV import. Thankyou for the search related answer. Kindly if anyone about  product visibility issue under category page it will help. Thanks

Are products assigned to categories in the import file?

[rizvi_alamdar]

yes, they are assigned. everytime i need to open product from backoffice and save it manually in order to show them under category page

[WisQQ]

can you post example of imported data?

[rizvi_alamdar]

sure, here is the file i am trying to upload. I am using product catalog import module for importing data files

example for forum.xlsx

[WisQQ]

1 hour ago, rizvi_alamdar said:

sure, here is the file i am trying to upload. I am using product catalog import module for importing data files

example for forum.xlsx 9.57 kB · 1 download

Okay, I tought you are using built in prestashop import. I dont know this module, but try to use category ID instead of names. It worked for default prestashop import.