Changing SKU

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi,
I need to do a batch change of all my SKU#
Is there a way to do this thru excel?
Since the SKU is the identifier, I can't find a way to do this when using Import Product and updating.
I need to add SH- in front of all of SKU, and I have about 22k products.

If there is please let me know the steps.
I'd hate to have to do this one by one...

Thanks!

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
TruSake Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 04-November-2009 Status: Offline Points: 15	Post Options Post Reply Quote TruSake Report Post Thanks(0) Quote Reply Topic: Changing SKU Posted: 06-October-2015 at 9:40am
	Hi, I need to do a batch change of all my SKU# Is there a way to do this thru excel? Since the SKU is the identifier, I can't find a way to do this when using Import Product and updating. I need to add SH- in front of all of SKU, and I have about 22k products. If there is please let me know the steps. I'd hate to have to do this one by one... Thanks!

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 06-October-2015 at 10:31am
	I don't think you can do that with the import tool. if you have a developer, I would probably have them write a program to help with the process.