{"id":15259,"date":"2019-10-02T08:00:14","date_gmt":"2019-10-02T13:00:14","guid":{"rendered":"http:\/\/www.btmglobal.com\/?p=15259"},"modified":"2020-12-28T10:48:21","modified_gmt":"2020-12-28T16:48:21","slug":"six-ways-manufacturers-can-make-erp-data-migration-easier","status":"publish","type":"post","link":"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/","title":{"rendered":"Six Ways Manufacturers can Make ERP Data Migration Easier"},"content":{"rendered":"

Six Ways Manufacturers can Make ERP Data Migration Easier<\/h1>\n
\"\"

ArMand Nelson, Director of Strategy<\/p><\/div>\n

Managing and maintaining quality data is an ongoing battle, and one that most manufacturers aren’t excited about taking on. It’s tedious and time-consuming to make sure every field is correct, each duplicate is removed and every record is up to date.<\/p>\n

But when it’s time to switch to a new ERP, data quality has to be a top priority. One of the biggest impacts a manufacturer can have on the efficiency and speed of an ERP project is cleaning up data before the work kicks off, because cleaning it up during the actual implementation will only add time and cost to the project.<\/p>\n

You know your data and your current ERP system, so it\u2019s best to clean data up there. Here are a few tips on where to prioritize your efforts.<\/p>\n

Pick your approach <\/strong>There are two approaches to data clean-up: Extract everything and put it in a spreadsheet to clean and re-import, or have a developer write scripts to update the data within the ERP. The “right” approach depends on your in-house expertise and comfort level.<\/p>\n

Be consistent <\/strong>Ensure consistency in upper and lowercase letters, make sure everything is spelled correctly, and make sure fields like addresses and descriptions are completely filled out.<\/p>\n

Know what the data should <\/em>be <\/strong>To get your data in good shape, it would help to know what it should look like in the new ERP system and downstream systems. \u00a0What are the field lengths? Do you need to remove special characters? Have you purged duplicate customers, vendors and items so you\u2019re not migrating bad data?<\/p>\n

Don\u2019t convert everything at once! <\/strong>There’s a tendency to convert everything and deal with it later, but that can cause big complications down the road. Purge the records and data you don’t need and keep only the data that’s necessary. Or, if you’re not sure whether you’ll need it, you can convert the data at a later phase, or keep the old system for a while in case you need to access the older data.<\/p>\n

Find the orphans a home <\/strong>Look for orphan records and delete them. Someone might have created a shipment against an order but didn’t receive anything on the shipment and didn’t delete it. You can also consider changing delete parameters to help delete data you do not want to convert, or use scripts to identify the orphan data, validate it and delete the records.<\/p>\n

Test, test and test <\/strong>Start in a test environment and then graduate to running a small number of records in production to make sure everything works as expected. And of course, always have a back-up you can restore.<\/p>\n

Cleaning up data is a big undertaking and it’s important to maintain the quality you worked so hard to get. Train users thoroughly on the new system, put gates in place to keep users from creating bad data, and set up rules to safeguard the data as much as possible. If you don’t have the in-house resources to get your data in order, or if you need help prioritizing what to do and when, talk with your ERP’s system integrator (SI) for the project. Your SI can give you guidance and best practices each step of the way.<\/p>\n","protected":false},"excerpt":{"rendered":"

Six Ways Manufacturers can Make ERP Data Migration Easier Managing and maintaining quality data is an ongoing battle, and one that most manufacturers aren’t excited about taking on. It’s tedious and time-consuming to make sure every field is correct, each duplicate is removed and every record is up to date. But when it’s time to […]<\/p>\n","protected":false},"author":1,"featured_media":15262,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44,47],"tags":[],"yoast_head":"\nSix Ways Manufacturers can Make ERP Data Migration Easier - BTM Global<\/title>\n<meta name=\"description\" content=\"When it's time to switch to a new manufacturing ERP, data quality is a top priority. Get tips to prioritize your ERP efforts.\" \/>\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.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Six Ways Manufacturers can Make ERP Data Migration Easier - BTM Global\" \/>\n<meta property=\"og:description\" content=\"When it's time to switch to a new manufacturing ERP, data quality is a top priority. Get tips to prioritize your ERP efforts.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/\" \/>\n<meta property=\"og:site_name\" content=\"BTM Global\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/BTMGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-02T13:00:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-28T16:48:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.btmglobal.com\/wp-content\/uploads\/2019\/09\/ArMand-Nelson.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"225\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"btm-it-contact@btmgcs.com\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"btm-it-contact@btmgcs.com\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/\"},\"author\":{\"name\":\"btm-it-contact@btmgcs.com\",\"@id\":\"https:\/\/www.btmglobal.com\/#\/schema\/person\/d43317069627ad45260882cde9939b1e\"},\"headline\":\"Six Ways Manufacturers can Make ERP Data Migration Easier\",\"datePublished\":\"2019-10-02T13:00:14+00:00\",\"dateModified\":\"2020-12-28T16:48:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/\"},\"wordCount\":568,\"publisher\":{\"@id\":\"https:\/\/www.btmglobal.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.btmglobal.com\/wp-content\/uploads\/2019\/09\/ArMand-Nelson.jpg\",\"articleSection\":[\"People\",\"Point of View\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/\",\"url\":\"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/\",\"name\":\"Six Ways Manufacturers can Make ERP Data Migration Easier - BTM Global\",\"isPartOf\":{\"@id\":\"https:\/\/www.btmglobal.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.btmglobal.com\/wp-content\/uploads\/2019\/09\/ArMand-Nelson.jpg\",\"datePublished\":\"2019-10-02T13:00:14+00:00\",\"dateModified\":\"2020-12-28T16:48:21+00:00\",\"description\":\"When it's time to switch to a new manufacturing ERP, data quality is a top priority. Get tips to prioritize your ERP efforts.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/#primaryimage\",\"url\":\"https:\/\/www.btmglobal.com\/wp-content\/uploads\/2019\/09\/ArMand-Nelson.jpg\",\"contentUrl\":\"https:\/\/www.btmglobal.com\/wp-content\/uploads\/2019\/09\/ArMand-Nelson.jpg\",\"width\":300,\"height\":225},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.btmglobal.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Six Ways Manufacturers can Make ERP Data Migration Easier\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.btmglobal.com\/#website\",\"url\":\"https:\/\/www.btmglobal.com\/\",\"name\":\"BTM Global\",\"description\":\"Retail System Integration & Development Services\",\"publisher\":{\"@id\":\"https:\/\/www.btmglobal.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.btmglobal.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.btmglobal.com\/#organization\",\"name\":\"BTM Global\",\"url\":\"https:\/\/www.btmglobal.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.btmglobal.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.btmglobal.com\/wp-content\/uploads\/2024\/03\/btm_retina_logo-3.png\",\"contentUrl\":\"https:\/\/www.btmglobal.com\/wp-content\/uploads\/2024\/03\/btm_retina_logo-3.png\",\"width\":367,\"height\":185,\"caption\":\"BTM Global\"},\"image\":{\"@id\":\"https:\/\/www.btmglobal.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/BTMGlobal\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.btmglobal.com\/#\/schema\/person\/d43317069627ad45260882cde9939b1e\",\"name\":\"btm-it-contact@btmgcs.com\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.btmglobal.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a9443d7a3f2145f83e9cac6cce79c6c7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a9443d7a3f2145f83e9cac6cce79c6c7?s=96&d=mm&r=g\",\"caption\":\"btm-it-contact@btmgcs.com\"},\"url\":\"https:\/\/www.btmglobal.com\/author\/btm-it-contactbtmgcs-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Six Ways Manufacturers can Make ERP Data Migration Easier - BTM Global","description":"When it's time to switch to a new manufacturing ERP, data quality is a top priority. Get tips to prioritize your ERP efforts.","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.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/","og_locale":"en_US","og_type":"article","og_title":"Six Ways Manufacturers can Make ERP Data Migration Easier - BTM Global","og_description":"When it's time to switch to a new manufacturing ERP, data quality is a top priority. Get tips to prioritize your ERP efforts.","og_url":"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/","og_site_name":"BTM Global","article_publisher":"https:\/\/www.facebook.com\/BTMGlobal\/","article_published_time":"2019-10-02T13:00:14+00:00","article_modified_time":"2020-12-28T16:48:21+00:00","og_image":[{"width":300,"height":225,"url":"https:\/\/www.btmglobal.com\/wp-content\/uploads\/2019\/09\/ArMand-Nelson.jpg","type":"image\/jpeg"}],"author":"btm-it-contact@btmgcs.com","twitter_card":"summary_large_image","twitter_misc":{"Written by":"btm-it-contact@btmgcs.com","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/#article","isPartOf":{"@id":"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/"},"author":{"name":"btm-it-contact@btmgcs.com","@id":"https:\/\/www.btmglobal.com\/#\/schema\/person\/d43317069627ad45260882cde9939b1e"},"headline":"Six Ways Manufacturers can Make ERP Data Migration Easier","datePublished":"2019-10-02T13:00:14+00:00","dateModified":"2020-12-28T16:48:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/"},"wordCount":568,"publisher":{"@id":"https:\/\/www.btmglobal.com\/#organization"},"image":{"@id":"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/#primaryimage"},"thumbnailUrl":"https:\/\/www.btmglobal.com\/wp-content\/uploads\/2019\/09\/ArMand-Nelson.jpg","articleSection":["People","Point of View"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/","url":"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/","name":"Six Ways Manufacturers can Make ERP Data Migration Easier - BTM Global","isPartOf":{"@id":"https:\/\/www.btmglobal.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/#primaryimage"},"image":{"@id":"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/#primaryimage"},"thumbnailUrl":"https:\/\/www.btmglobal.com\/wp-content\/uploads\/2019\/09\/ArMand-Nelson.jpg","datePublished":"2019-10-02T13:00:14+00:00","dateModified":"2020-12-28T16:48:21+00:00","description":"When it's time to switch to a new manufacturing ERP, data quality is a top priority. Get tips to prioritize your ERP efforts.","breadcrumb":{"@id":"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/#primaryimage","url":"https:\/\/www.btmglobal.com\/wp-content\/uploads\/2019\/09\/ArMand-Nelson.jpg","contentUrl":"https:\/\/www.btmglobal.com\/wp-content\/uploads\/2019\/09\/ArMand-Nelson.jpg","width":300,"height":225},{"@type":"BreadcrumbList","@id":"https:\/\/www.btmglobal.com\/six-ways-manufacturers-can-make-erp-data-migration-easier\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.btmglobal.com\/"},{"@type":"ListItem","position":2,"name":"Six Ways Manufacturers can Make ERP Data Migration Easier"}]},{"@type":"WebSite","@id":"https:\/\/www.btmglobal.com\/#website","url":"https:\/\/www.btmglobal.com\/","name":"BTM Global","description":"Retail System Integration & Development Services","publisher":{"@id":"https:\/\/www.btmglobal.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.btmglobal.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.btmglobal.com\/#organization","name":"BTM Global","url":"https:\/\/www.btmglobal.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.btmglobal.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.btmglobal.com\/wp-content\/uploads\/2024\/03\/btm_retina_logo-3.png","contentUrl":"https:\/\/www.btmglobal.com\/wp-content\/uploads\/2024\/03\/btm_retina_logo-3.png","width":367,"height":185,"caption":"BTM Global"},"image":{"@id":"https:\/\/www.btmglobal.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/BTMGlobal\/"]},{"@type":"Person","@id":"https:\/\/www.btmglobal.com\/#\/schema\/person\/d43317069627ad45260882cde9939b1e","name":"btm-it-contact@btmgcs.com","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.btmglobal.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a9443d7a3f2145f83e9cac6cce79c6c7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a9443d7a3f2145f83e9cac6cce79c6c7?s=96&d=mm&r=g","caption":"btm-it-contact@btmgcs.com"},"url":"https:\/\/www.btmglobal.com\/author\/btm-it-contactbtmgcs-com\/"}]}},"_links":{"self":[{"href":"https:\/\/www.btmglobal.com\/wp-json\/wp\/v2\/posts\/15259"}],"collection":[{"href":"https:\/\/www.btmglobal.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.btmglobal.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.btmglobal.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.btmglobal.com\/wp-json\/wp\/v2\/comments?post=15259"}],"version-history":[{"count":0,"href":"https:\/\/www.btmglobal.com\/wp-json\/wp\/v2\/posts\/15259\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.btmglobal.com\/wp-json\/wp\/v2\/media\/15262"}],"wp:attachment":[{"href":"https:\/\/www.btmglobal.com\/wp-json\/wp\/v2\/media?parent=15259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.btmglobal.com\/wp-json\/wp\/v2\/categories?post=15259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.btmglobal.com\/wp-json\/wp\/v2\/tags?post=15259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}