|
Batch SKU Update |
Post Reply 
|
| Author | |
whizzinpc 
Newbie 
Joined: 17-January-2006 Location: California Status: Offline Points: 20 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Batch SKU UpdatePosted: 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.
|
|
 |
|
|
RedLeafDev
Certified ProductCart Developers 
Joined: 12-January-2010 Location: Portsmouth, NH Status: Offline Points: 28 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options