Bulk Character Strip from Product Model Field

[mach9]

I have some 500 products where the v_products_model field needs to be changed. Currently all of this particular type of product is pre-fixed with "XOAR-XXXXXXX", I need to strip the "A" from each of these particular products setting the v_products_model field to "XOR-XXXXXXX".

I hope there is an sql command line that can be run on the database to do this, can anyone help please.

Thanks

[jlizotte]

If you're using Apsona or Easy Populate...this is easy.

1. Export your products to the CSV in either mod.
2. Open the spreadsheet in Open Office or Excel
3. Use the "Find & Replace" function to find "XOAR" and replace with "XOR"
4. Save as CSV, then re-upload.
5. Using Apsona, choose "update product info" when importing. (I don't use EP, so I don't know the specific option, but it should be similar.

I hope that helps.

John

[jlizotte]

Mach,

I hit "enter" too soon. I just thought of something. I think I read somewhere in one of these posts that Apsona and EP might "key" or "index" from the model number field. If this is the case, you may run into issues with what I posted above.

Best to wait until someone with more experience pipes up My way might cause you more problems than you need. I've used the search & replace alot without problems, but never on model number.

Cheers.

John

[jlizotte]

Mach,
I was right (wrong)! Don't use my method. Lol. You'll end up with 500 new items.

I found this thread, though, that might interest you:
http://www.zen-cart.com/forum/showthread.php?t=183306

J