- Importing and updating Products in MS CRM...
- Posted by Onkar on December 15th, 2006
We are speaking to one of our clients on MS CRM implementation.
However we are stumped on one issue.
They have more than two thousand products and the price of these
products changes as frequently as once in a month.
Using DMF, we can import the products one off but how about updating
the prices at least once in a month.
Is there any user friendly utility available for MS CRM that can be
used by our client to import Products information on regular basis?
May be that someone will suggest SCRIBE but it is too pricey.
Any help is appreciated.
- Posted by Alexander Baskakov on December 15th, 2006
Hi, Onkar.
We had the same situation, and even worse. We have several prices from
300-400 vendors each of which consists of ten to twenty thousand products.
And the prices changes happen every day of 3 or 4 of vendors.
The only one choice you have is to develop a program.
In our case it is Windows Service which automatically imports large amounts
of products from Excel files received from vendors.
Using .Net and Crm Sdk it is simple to create such WS.
Best regards,
Alexander Baskakov
"Onkar" wrote:
- Posted by Sam - Inogic on December 16th, 2006
Hi Onkar,
Alexander is right and it is logical to write a utility usign CRM SDK to
import products on a regular basis. In fact, for you it maybe easier to
write a simple application to do it manually because you are not going to do
it very regularily than building a Windows Service to do it automatically.
We have done it a couple of times and have a component utility for the same.
If you can provide the sample excel sheet, we can come back to you with what
minor changes we may have to do to release a version for you. It should not
be too difficult as far as our experience goes to make it compatible with
different kind of imports. I am assuming that your products and its prices
are stored in some easily readable format like excel or csv as well as the
product name etc can match with the clients CRM.
HTH,
Sam
_______________
Inogic
Innovative Logic
Innovative solutions for your SME ERP/CRM products
E-mail: crm@inogic.com
Web: www.inogic.com
--------------------------
"Onkar" <budc57@yahoo.com> wrote in message
news:1166162667.441312.91580@f1g2000cwa.googlegrou ps.com...
- Posted by Onkar on December 18th, 2006
Thank you guys.
I agree. We need to write a script to import products in to MSCRM.
Sam - Inogic wrote:
- Posted by Sam on January 5th, 2007
Hi Eksteen,
Our script can be modified to allow importation into a new price list
and other things too.
Can you just send a sample of your existing excel sheet/price list at
crm@inogic.com and definitely we can inform you about the pricing of
the script. Your programmer can modify it further to suit your needs as
we always provide source code for our components.
Will wait for your email!
Sam
_______________
Inogic
Innovative Logic
Innovative solutions for your SME ERP/CRM products
E-mail: crm@inogic.com
Web: www.inogic.com
--------------------------
On Jan 4, 10:26 pm, Eksteen <Ekst...@discussions.microsoft.com> wrote: