How do I edit product ID number?

[robertwebsite]

How do I edit the product ID # ?

I am having layout issues in my custom showcase b/c I need to change the product ID # on a couple products.

[kobra]

ID is not editable and only you see it

What issue are you having?

[robertwebsite]

Thanks for the response.

My custom slider at the top has 10 items that refer to items 140 to 150. I accidentally deleted 2 of those items, 149 and 150. The slider cannot be changed to reference different ID #'s. When I go to create new products the ID's are already in the 250's. How do I create a 149 and 150 again ?

[kobra]

You can not from any interface

If you know wbout the cross indexing in the DB for cats, products, etc one could edit the tables to re-establish them

Might be a lot easier to determine the slider code

As to why it started at 140 & not some other sequence

[robertwebsite]

Thanks again Kobra.

Know any good articles or urls for doing the db tables edit ?

[kobra]

Know any good articles or urls for doing the db tables edit ?

Quite frankly, if you have to ask, you probably should not be attempting this

Trying to tutor the complexities of the relationships in the ZenCart DB structure is far beyond the forum venue

So now that I have warned you and you will most likely make an attempt anyway

Do not do this in a live install, make a DB backup copy in case things go wrong

Get a good code editor that can handle a large sql file size

And review the table/record structure making note of the indexes

Make your alterations and try it

Remember if is crashes you have a backup

[gjh42]

I believe Ajeh posted the steps and tables/fields to look at, not long ago...