ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Suggestions
  New Posts New Posts RSS Feed - Batch SKU Update
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Batch SKU Update

 Post Reply Post Reply
whizzinpc View Drop Down

Joined: 17-January-2006
Location: California
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote whizzinpc Quote  Post ReplyReply Direct Link To This Post Topic: Batch SKU Update
    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.
Back to Top
RedLeafDev View Drop Down
Certified ProductCart Developers
Certified ProductCart Developers

Joined: 12-January-2010
Location: Portsmouth, NH
Status: Offline
Points: 28
Post Options Post Options   Thanks (0) Thanks(0)   Quote RedLeafDev Quote  Post ReplyReply Direct Link To This Post 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...

Red Leaf Development

Certified ProductCart Developers
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.043 seconds.