| Author |
Bulk Update of Pricing increases
|
|
|
| Situation:
I have a delimited text file with pricing updates for all products. Need a
way to update the catalog in a bulk fashion.
Is there a way to do this with Commerce Server 2002?
Any input is much appreciated.
| |
| Sudha Raghavan [MSFT] 2006-02-08, 5:54 pm |
| There is no bulk update API in CS 2002. We have added this new feature in
Commerce Server 2006.
To bulk updates prices in CS2002, you could create a Virtual Catalog and
add pricing rules to the different products to get newer prices.
Thanks
Sudha
--------------------
Thread-Topic: Bulk Update of Pricing increases
thread-index: AcYs2j2MQYElxj+zSBSvjyMnK9rNcw==
X-WBNR-Posting-Host: 65.43.79.65
From: "=?Utf-8?B?TWF0dA==?=" <Matt@discussions.microsoft.com>
Subject: Bulk Update of Pricing increases
Date: Wed, 8 Feb 2006 10:05:27 -0800
Lines: 7
Message-ID: <F66B8BED-A8F1-40CA-AB1E-659713E2D270@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.catalog
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.catalog:5981
X-Tomcat-NG: microsoft.public.commerceserver.catalog
Situation:
I have a delimited text file with pricing updates for all products. Need a
way to update the catalog in a bulk fashion.
Is there a way to do this with Commerce Server 2002?
Any input is much appreciated.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2005 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Have a Commerce Server “How To” question? Help is a click away at our
Chats, Newsgroups and Web logs
Chats (2nd Wednesday of the month from 11 to Noon):
http://www.msdn.microsoft.com/chats/
Public newsgroups:
http://www.microsoft.com/technet/co...r/commerce.mspx
Web logs and community:
http://www.microsoft.com/commercese...ty/default.mspx
Other resources:
http://www.microsoft.com/technet/pr...02/default.mspx
| |
| Jeff Lynch 2006-02-09, 8:49 pm |
| I've done something similar in the past using a custom stored procedure and
SQL DTS. I'd recommend testing this very carefully on a development server
first however.
--
Jeff Lynch
"Ramblings From A [Microsoft] Connected Universe"
http://codebetter.com/blogs/jeff.lynch
"Matt" <Matt@discussions.microsoft.com> wrote in message
news:F66B8BED-A8F1-40CA-AB1E-659713E2D270@microsoft.com...
> Situation:
> I have a delimited text file with pricing updates for all products. Need
> a
> way to update the catalog in a bulk fashion.
>
> Is there a way to do this with Commerce Server 2002?
>
> Any input is much appreciated.
| |
|
| It is very possible to update products from a comma seperated list just
using the Commerce Server API you could probably create a WinForms app
to do this.
Loop through the records in your CSV file and use them to pull out the
Product SKU. Use this to call the Commerce Server API to pull out the
product you wish to edit and then update the price on that product.
If you prefer a more remote approach and you are not too worried about
how long the update takes or you don't have that many records. Commerce
Server 2002 Feature Pack 1 exposes a Catalog Manager webservice, there
is an API that marshals this webservice that a Winforms app called the
Catalog Manager uses. You can update your product prices using this
webservice, I have done this in the past, the benefits of this approach
is that your product price updates can happen away from server ie
remotely from an app that communicate with it over web services.
As you are going to the API you need not worry about your database
schema changing however there is an impact on speed because you are
effectivly pulling out each product record via the API and updating it,
while a SQL DTS approach is much faster.
|
|
|
|