Suggestions - Batch SKU Update

Print Page | Close Window

Batch SKU Update

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Suggestions
Forum Description: ProductCart Suggestions
URL: https://forum.productcart.com/forum_posts.asp?TID=3725
Printed Date: 21-November-2024 at 11:12am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Batch SKU Update

Posted By: whizzinpc
Subject: Batch SKU Update
Date 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.

Replies:

Posted By: RedLeafDev
Date 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

-------------
http://www.redleafdevelopment.com" rel="nofollow - Red Leaf Development

Certified ProductCart Developers

www.redleafdevelopment.com