Can we reset the Products ID #?

[natebc]

Hello,

 

We are upload a net set of Products  and would like to  reset the ID Number to 0 or 1. Dose any one know how this can be done?

 

Nathan

[natebc]

Hi,

 

You will need to delete these tables and create them again:

 

ps_product,    ps_product_lang,     ps_product_shop  

 

and if you need to upload  features and attributes you will to deleate related tables to attributes and features also.

 

Hi ndiaga,

 

Is that in the  MySQL® Databases and/or how can the tables?

 

Nathan

[natebc]

You can do it via PhpMyadmin yes  MySQL® Databases .

You know how to work with  Databases I guess?

 

I have found:

pssw_product_shop pssw_product_lang, pssw_product_shop is the right one?

Edited June 10, 2017 by natebc (see edit history)

[Rhobur]

Or you can delete all your products and reupload them with the IDs starting from 1 and specified in the import CSV file.

Of course, Force ID set in the import preferences.