Jump to content

Parent category ID number too big (INT->BIGINT)


Recommended Posts

Hi, I recently faced an issue where my category IDs had very large numbers (at the edge of BIGINT). I managed to change the DB tables structure so they allow BIGINT instead of INT values for category ID and parent category ID. This brought me a step further and some categories with high ID values were imported properly. Now I'm facing an issue with subcategories since those have parent categories with very large values assigned to them and this time changing the DB structure to BIGINT doesn't help (I've changed BIGING in all ps_category* tables for id_category and id_parent to BIGINT).

Here's an example of faulty import



Rough translation:
Dresses (ID: 100007) can't be saved

Attribute Category->id_parent is not correct

Value of parent ID in this case is 89538759973248595


Keeping IDs like in the input file (with big values) is mandatory since it allows maintaining sort of automation for the future updates thus I'm enforcing values as they are in input file instead of assigning them by prestashop.

Is there any kind of parent ID value check apart of DB level which could prevent from import processing successfully? 

I'm running PS v8.1.3

Edited by Ronald.M (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...