Strange categorie ID

Hi Ubertheme,
 
When I create a new subcategorie it is suddenly a really high number. It goes from 262 to 887. Seems a bit strange to me.
Kind Regards

7 answers

Profile photo of Mall Staff 184060.00 $tone October 22, 2019
Public

Hi Mark van Altena,

When I create a new subcategorie it is suddenly a really high number. It goes from 262 to 887. Seems a bit strange to me.

Please help to provide with more details about the issue you mentioned? Did you refer to the category’s ID value?

Regards,
Mall.

#1
Profile photo of Mark van Altena 2060.00 $tone October 22, 2019
Public

Hi Mall,
 
I mean indeed the category’s id value.
The last time I made a category it got ID 262 and yesterday I made 2 new category’s and they got 887 and 888.
 
Kind Regards

#2
Profile photo of Mall Staff 184060.00 $tone October 22, 2019
Public

Hi there,

The last time I made a category it got ID 262 and yesterday I made 2 new category’s and they got 887 and 888.

So, that is normal. It seems you did reset several times in step #4 of our migration tool after the last time you mentioned? 

For your information, the category’s ID is automatically defined by MySQL depending on the value of ‘AUTO_INCREMENT’ setting in the table ‘catalog_category_entity’, like in this screenshot: https://prnt.sc/pmkxyd. It helps to avoid IDs conflict (duplicated IDs) when a new data record is added to that table.
 
Regards,
Mall.
 

#3
Profile photo of Mall Staff 184060.00 $tone October 22, 2019
Public

Hi Mark van Altena,

We did not reset step #4 several times.

So, how many categories are there in your M2 site now?
Also, as explained in my previous reply, it relates to the database table settings and the working rule of MySQL, not our migration tool though.

Regards,
Mall.

#5
Profile photo of ubdev Staff 98150.00 $tone October 22, 2019
Public

Hi Mark van Altena,
Glad that you figured it out at your end. 
Please get back to us here in case you have any additional question.
Regards,
Ubertheme team

#7

Please login or Register to Submit Answer

Written By

Comments