Manually Assign Product ID numbers

[dwbone]

is it possible to control the product ID number when adding individual product via the product admin? (verses using bulk upload add-on)

I would like to assign specific product types to their own numerical sequence as the new product is added.

e.g. MP3s=001 to 999;

Videos=1200-1300;

T-shirts=2000-2100, etc… kind of thing.

but as is, the system automatically assigns a product ID sequentially from highest ID#/most recent product added.

hope that make sense.

Thanks

[wzp]

The Product ID numbers are actually the MySQL table index numbers. So it is not possible to manipulate or change them.

If you need to somehow identify products by SKU, maybe this will help:

https://support.tipsandtricks-hq.com/forums/topic/product-skus-and-ids

[dwbone]

Actually I just remembered, if i recall, i have manually changed id’s via myPHP, and all works well. (to be specific: I think what I did was recycled a deleted product’s id number, in order to force a previous omitted product to be “inserted” consecutive with its earlier related products.)

but the next new product added via eStore admin would be numbered a la most recent product, so organizing products by id numbers as new products are added would mean bypassing eStore for the PHP management, not ideal.

hope that means something to anyone.

I’ll check out the article

[wzp]

You do so at your own risk. Specifically, if not done carefully, you risk corrupting the correlation of index numbers between the various tables in MySQL.

[dwbone]

Indeed. it was only a last resort solution really, and I always login in to myPHP with a great deal of trepidation.

[Author]

Posts