ProductCart Shopping Cart Software Forums : Batch SKU Update

ProductCart Shopping Cart Software Forums : Batch SKU Update https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 05:52:04 +0000 Thu, 20 May 2010 15:03:51 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3725 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Batch SKU Update : Hi Whizz, What type of database...]]> https://forum.productcart.com/batch-sku-update_topic3725_post14461.html#14461 Author: RedLeafDev
Subject: 3725
Posted: 20-May-2010 at 3:03pm

Hi Whizz,

What type of database are you using Access / SQL 2000 / SQL 2005? If you are on SQL and you need to do this on a scheduled basis (where it checks for a file, if it finds a file it does a update and sends a sucessful/failed report) then your best tools will be DTS or SSIS and scheduled tasks. Are you familiar with those? If not we can help, please contact me directly if you are interested in an estimate for that.

If this is a one time thing - then DTS is still your best tool - just save it in case you ever need it again...

Amy

]]> Thu, 20 May 2010 15:03:51 +0000 https://forum.productcart.com/batch-sku-update_topic3725_post14461.html#14461 <![CDATA[Batch SKU Update : We need a script to batch update...]]> https://forum.productcart.com/batch-sku-update_topic3725_post14460.html#14460 Author: whizzinpc
Subject: 3725
Posted: 19-May-2010 at 6:47pm

We need a script to batch update SKU's via CSV import. Vendors/Suppliers change and sometimes SKU's need to be updated... Its easier to just map them in excel and import based on Product ID.
]]> Wed, 19 May 2010 18:47:45 +0000 https://forum.productcart.com/batch-sku-update_topic3725_post14460.html#14460