Jacques, find the responses below:
cyberSFere wrote:
Anyway, I still have some questions :
1- marking the field "is deleted" to 1, the product will be deleted from the table. Is that true ? It would be very convenient when doing mass updates with 3 possibilities : deleting, adding or updating ;
Marking the delete field to 1 does not delete the product from the table. A product that is deleted from the admin panel is marked as deleted and the admin has to run a query manually to delete the products from the table which are marked as deleted.
cyberSFere wrote:2- I hope that we can choose the Id field for the Category table and that it is not generated automatically. Actually, we have our own Id's for the categories and we need to control the links between categories and subcategories ;
It is not recommended to choose the ID field although you can. For your purpose there is a field named display ID which serves the purpose. I also have a bookshopp and I use it like the parent category is marked as 1 then all subcategories of that are 1-100, next block starts from 100-199. This will also help organize them in the admin panel.
cyberSFere wrote:3- concerning the pictures, I didn't find the way to import them at the same time we import other item datas. We can stock all the pictures in a folder but what to do after knowing that nopCommerce needs to process each one to generate a mini-picture (as far as I understood it) ?
There is no easy way out of the box for bulk uploading images which is a real pain but many people have found a few workarounds. You can search the forum for terms like bulk upload. One such post to get started is
https://www.nopcommerce.com/boards/t/5070/bulk-image-upload.aspx