automatic product model in product.php

[derer]

Hello can somebody help me with this script? I neet to set the product model to have it same as product ID because when I would like to export data by easy populate. I need to have set product_model and I didn´t write it in products!! So when I export data now in import I can hear only no model in field. Does anybody know how set automatic product model number? Thank you michal

[derer]

the file is in: admin/product.php

[DrByte]

before you do an export, go to Admin->Tools->SQL Patch

paste this in the window and click submit:

update products set products_model = products_id;

That will set the model number to the product ID number for *all* products, wiping out *all* previous model number information.

[odessey1]

I need the product ID to be changed to match the Model number.
The model numbers are all unique.

What would be the direction for this?

[gjh42]

Can't do that. The product ids are automatically generated by the database, and are used for a host of other DB coordination.