{"id":119,"date":"2009-04-30T05:23:00","date_gmt":"2009-04-30T05:23:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=119"},"modified":"2024-11-19T05:21:41","modified_gmt":"2024-11-19T05:21:41","slug":"greytrix-sage-crmcrm-com-product-import","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/","title":{"rendered":"Greytrix Sage CRM\/CRM.com \u2013 Product Import"},"content":{"rendered":"

SageCRM apart from being an excellent web based CRM also offers other features like data upload. This option enables a user to import data from a flat file into company, person and address entities of SageCRM.<\/p>\n

But one other thing that is most frequently imported in SageCRM is the product import. Since there was no viable solution available in the market Greytrix decided that it was about time that we developed one. Greytrix came up with an add-on that could import data from an excel spreadsheet into the product entity of Sage CRM.
\n\"\"<\/a>
\nhttp:\/\/greytrix.com\/product-114-Greytrix_Sage_CRM_Product_Import.htm<\/a>
\nTechnically speaking the product entity in any CRM is not the easiest of the entities to import data into due to the pricing structure. Each product has multiple pricing lists and each price list has multiple UOMs (Unit of Measure). Hence the product price is a combination of UOM and PriceList. Hence what you see on the CRM screen is a matrix of the UOMs and PriceLists.
\nAnother challenge was to make the utility compatible with SageCRM.com i.e. the hosted environment; Greytrix chose the SageCRM web services since it works with the hosted and on premise versions of SageCRM.
\nGreytrix also provided the users with a excel template. The users are supposed to put in all the products in the excel sheet as per the format specified and the utility would migrate the data from the excel sheet into SageCRM product entity along with the pricing. The routine will check of the product already exists on the basis of product code. If the product is found then it will be updated.
\nI am sure that all companies will not have the same product and pricing structure. Hence if you have a product and pricing structure that is different from what is provided with the setup then the developers at Greytrix would be willing to make changes to the product to suite your requirement.<\/p>\n","protected":false},"excerpt":{"rendered":"

SageCRM apart from being an excellent web based CRM also offers other features like data upload. This option enables a user to import data from a flat file into company, person and address entities of SageCRM. But one other thing that is most frequently imported in SageCRM is the product import. Since there was no\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[332],"tags":[1107,1238,1357,1393,1435,1799,1800,1821,2140,2378,2503],"class_list":["post-119","post","type-post","status-publish","format-standard","hentry","category-sage-crm","tag-excel","tag-gumu","tag-hosted","tag-import","tag-integration","tag-pricelists","tag-pricing","tag-products","tag-sage-crm-com","tag-synchronize","tag-uom"],"yoast_head":"\nGreytrix Sage CRM\/CRM.com \u2013 Product Import - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Greytrix Sage CRM\/CRM.com \u2013 Product Import - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"SageCRM apart from being an excellent web based CRM also offers other features like data upload. This option enables a user to import data from a flat file into company, person and address entities of SageCRM. But one other thing that is most frequently imported in SageCRM is the product import. Since there was no\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2009-04-30T05:23:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-19T05:21:41+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2009\/04\/Productimport.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/\",\"name\":\"Greytrix Sage CRM\/CRM.com \u2013 Product Import - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2009\/04\/Productimport.jpg\",\"datePublished\":\"2009-04-30T05:23:00+00:00\",\"dateModified\":\"2024-11-19T05:21:41+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2009\/04\/Productimport.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2009\/04\/Productimport.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Greytrix Sage CRM\/CRM.com \u2013 Product Import\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Greytrix Sage CRM\/CRM.com \u2013 Product Import - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/","og_locale":"en_US","og_type":"article","og_title":"Greytrix Sage CRM\/CRM.com \u2013 Product Import - Sage CRM \u2013 Tips, Tricks and Components","og_description":"SageCRM apart from being an excellent web based CRM also offers other features like data upload. This option enables a user to import data from a flat file into company, person and address entities of SageCRM. But one other thing that is most frequently imported in SageCRM is the product import. Since there was no\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2009-04-30T05:23:00+00:00","article_modified_time":"2024-11-19T05:21:41+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2009\/04\/Productimport.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/","name":"Greytrix Sage CRM\/CRM.com \u2013 Product Import - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2009\/04\/Productimport.jpg","datePublished":"2009-04-30T05:23:00+00:00","dateModified":"2024-11-19T05:21:41+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2009\/04\/Productimport.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2009\/04\/Productimport.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/04\/30\/greytrix-sage-crmcrm-com-product-import\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Greytrix Sage CRM\/CRM.com \u2013 Product Import"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=119"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/119\/revisions"}],"predecessor-version":[{"id":28918,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/119\/revisions\/28918"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}