Skip to main content

Import MS CRM Product Catalog : Step by Step Part 1

Hi,

Imagine you are working on a project where the client's business has hundreds of products such as a Telecommunication company. When you ask for a list of products they deal with, they give you lengthy brocures with rates, tariffs etc. How would you go about transforming those flashy brochures into MS CRM Products with different categories, product lines, price bundles etc.

Here I describe a step by step technique to import your whole Product Catalog that includes Units, Unit Groups, Products and Pricelists.

> Gather a list of all possible categories, types, map those into one or more MS CRM fields on Product entity : example  Product Type, Subject etc.

* Subject can be really useful in terms of grouping products for Knowledge base articles and Cases are you would generate Cases for select Product; and Sales Literature categoriazation.

> List down those categories in a CSV file, import Sujbects, refer to one of my previous posts on this.

> List all the Unit groups and  individual Units for each unit group and transfer those into MS CRM Unit Groups and Units using Import tool.

> Create a list of Product names, codes etc. organize the details into a single CSV file and Import it.

>  Create Price lists for different currencies and special occasions like Christmas, Thanks giving day and Customer classes : Gold, Premium etc.

> Now comes a tricky part, you have the Subjects, Units and Products linked to those and different Price lists, how do you generate Price list items ??

> For this create a CSV file with fields similar to those shown below :

Product Name (lookup) | Price Amount | Price list
-----------------------------------------------------------------------------
Product 1                      |   45.56           | Rs.                
Product 1                      |   1                  |  US Dollars
Product 1                      |   0.64             |  Pound Sterling
Product 1                      |   0.8               |  US Dollars Thanks giving day Special

As you can see, you have to replicate rows for each different combination of Price amount, Price list type for the same Product.

> Once you have build this CSV file in the above format, Import it and your product catalogue is complete.

Drop a line if you need to contribute more to this, I will be posting a detailed article with screenshots and sample CSV files for you to try.

Comments

Anonymous said…
Can you post the example csv files, please? Thank you.
hero said…
Thanks for leaving your comment Sathish, I will keep posting useful content every now and then
Anonymous said…
what if I have more than one product with the same name?
Unknown said…
This comment has been removed by a blog administrator.
hero said…
@Sharad Jain this blog is not a platform to advertise your products.

Popular posts from this blog

CRM 2011 Useful JavaScript tidbits

http://www.powerobjects.com/blog/2011/01/14/crm-2011-useful-javascript-tidbits/ Get the value from a CRM field var varMyValue = Xrm.Page.getAttribute(“CRMFieldSchemaName”).getValue() ; Set the value of a CRM field Xrm.Page.getAttribute(“po_CRMFieldSchemaName”).setValue(‘My New Value’); Hide/Show a tab/section Xrm.Page.ui.tabs.get(5).SetVisible(false); Xrm.Page.ui.tabs.get(5).SetVisible(true); Call the onchange event of a field Xrm.Page.getAttribute(“CRMFieldSchemaName”).fireOnChange(); Get the selected value of picklist Xrm.Page.getAttribute(“CRMFieldSchemaName”).getSelectedOption().text; Set the requirement level Xrm.Page.getAttribute(“CRMFieldSchemaName”).setRequiredLevel(“none”); Xrm.Page.getAttribute(“CRMFieldSchemaName”).setRequiredLevel(“required”); Xrm.Page.getAttribute(“CRMFieldSchemaName”).setRequiredLevel(“recommended”); Set the focus to a field Xrm.Page.getControl(“CRMFieldSchemaName”).setFocus(true); Stop an on save event event.returnValue = false; Return array

Abort event through plugins

Suppose you are writing a pre -event plugin in which you compare to  old and new values and on certain condition would like to cancel the Save or  Update and stop the execution, it was simple in CRM 3 with an Abort() method while in CRM 4, you have to manually raise and throw a  Invalid-Plugin-Exception, while this gives a dirty error message on your MSCRM screen, you can make it better by entering you own Message explaining why the record could not be saved: throw new InvalidPluginExecutionException("Execution has been stopped due to this reason");

Using MS CRM Calendar in your custom ASP .NET pages *** Not fully Supported Customisations ***

Hi, Have you been creating custom pages in line with MS CRM for creating , viewing and updating entity records ? Have you placed controls such as Date picker Lookup on your custom page and have tried in vein to make those look like MS CRM ? I found a way to use the same MS CRM calendar control as it appears in the application... For getting this calendar on your asp .net page, follow the steps below: 1) Create a copy of the date.js javascript file located in your-server/crmsite-folder/_static/_controls/datetime folder, give the copy some name like date_myapp.js. 2) Open the following .js files from different sub folders in side the  your-server/crmsite-folder/_static      folder :       Global.js       encodedecode.js       xmlutil.js       util.js       remotecommand.js              Copy and whole content of each file one by one and keep pasting the same to the end of your date_myapp.js file. 3) Now open any CRM entity record page, for example a new Account crea