ProductCart Shopping Cart Software Forums : Bulk Update SKU https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 19:25:16 +0000 Wed, 05 Jan 2011 15:00:49 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=4244 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Bulk Update SKU : well, as I say, a client just...]]> https://forum.productcart.com/bulk-update-sku_topic4244_post16536.html#16536 Author: Greg Dinger
Subject: 4244
Posted: 05-January-2011 at 3:00pm

well, as I say, a client just did that using a query. I didn't get into the details of how they did that but he works for Microsoft and is very technical.  Before he did it himself we had planned on building a tool that would use a spreadsheet - somewhat similar to what you are attempting.  Then he knocked it out and didn't need our help.
 
If you would like such a tool created please contact me directly via my site, or any of the other developers on EI's partner page.
]]> Wed, 05 Jan 2011 15:00:49 +0000 https://forum.productcart.com/bulk-update-sku_topic4244_post16536.html#16536 <![CDATA[Bulk Update SKU : if bulk updating sku&#039;s doesn&#039;t...]]> https://forum.productcart.com/bulk-update-sku_topic4244_post16535.html#16535 Author: oroking
Subject: 4244
Posted: 05-January-2011 at 2:43pm

if bulk updating sku's doesn't work in CSV, is there any other way to do so? i have about 5,000 sku's that i need to update. i'm hoping there's a way to batch update it instead of doing it one by one via the control panel. please advise. thanks!]]> Wed, 05 Jan 2011 14:43:44 +0000 https://forum.productcart.com/bulk-update-sku_topic4244_post16535.html#16535 <![CDATA[Bulk Update SKU : I&#039;d have to test but I don&#039;t...]]> https://forum.productcart.com/bulk-update-sku_topic4244_post16534.html#16534 Author: Greg Dinger
Subject: 4244
Posted: 05-January-2011 at 2:39pm

I'd have to test but I don't think that works that way.  If I recall correctly it's actually the SKU that is the key by which all other fields are updated, and I don't think SKU can be altered via CSV import.
 
Perhaps EI will offer confirmation one way or the other.
 
I have a client who just went through a similar revamping of SKU numbers.  I think he used a direct query to pull that off.  If you need such assistance you might want to engage a developer.
]]> Wed, 05 Jan 2011 14:39:25 +0000 https://forum.productcart.com/bulk-update-sku_topic4244_post16534.html#16534 <![CDATA[Bulk Update SKU : thanks for the response, greg....]]> https://forum.productcart.com/bulk-update-sku_topic4244_post16532.html#16532 Author: oroking
Subject: 4244
Posted: 05-January-2011 at 2:29pm

thanks for the response, greg. i just added the newsku column in my csv file because that would be the source of my "new sku" update. what i'm trying to do in step 2 (map fields) of the product import wizard is to map the sku column in the csv to the sku field in the database and also to map the newsku column in the csv to update the sku field in the database. this doesn't seem to work.

is it possible to bulk update the sku using a csv? if so, please advise. thanks!]]> Wed, 05 Jan 2011 14:29:15 +0000 https://forum.productcart.com/bulk-update-sku_topic4244_post16532.html#16532 <![CDATA[Bulk Update SKU : the documentation for importing...]]> https://forum.productcart.com/bulk-update-sku_topic4244_post16531.html#16531 Author: Greg Dinger
Subject: 4244
Posted: 05-January-2011 at 2:20pm

the documentation for importing products is in the WIKI:
http://wiki.earlyimpact.com/productcart/products_import
 
Could you point us to where you find a reference to "newsku" and how that might be a supported action with the documentation?  I don't recall ever seeing that option.
 
Also, it's not necessary to cross-post the same topic in mulltiple forum categories please.
]]> Wed, 05 Jan 2011 14:20:38 +0000 https://forum.productcart.com/bulk-update-sku_topic4244_post16531.html#16531 <![CDATA[Bulk Update SKU : I&#039;ve tried updating items...]]> https://forum.productcart.com/bulk-update-sku_topic4244_post16530.html#16530 Author: oroking
Subject: 4244
Posted: 05-January-2011 at 2:05pm

I've tried updating items via a CSV file using the product import wizard. My concern now is I want to bulk update the SKU's of my products. I don't seem to make it work using a CSV. Here's what I currently have in my CSV file:

SKU     NEWSKU
1-1     001-01

I want to map the NEWSKU to the SKU field in the database but I'm getting this error message: "Some of the mapping instructions are overlapping. Please make sure that the database fields are mapped uniquely."

Please advise how to go about this procedure of bulk updating the product SKU's using a CSV file. Hoping for your response soon. Thanks! ]]> Wed, 05 Jan 2011 14:05:14 +0000 https://forum.productcart.com/bulk-update-sku_topic4244_post16530.html#16530