{"id":719,"date":"2018-10-01T14:12:02","date_gmt":"2018-10-01T07:12:02","guid":{"rendered":"https:\/\/www.support.skybizglobal.com\/?p=719"},"modified":"2018-10-01T14:12:02","modified_gmt":"2018-10-01T07:12:02","slug":"import-item-master-product-master-from-excel-into-skybiz-system","status":"publish","type":"post","link":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/","title":{"rendered":"Import Item Master\/Product Master from Excel into SkyBiz System"},"content":{"rendered":"

Below are guideline(s) on how to import Item\/Product Master from Excel to SkyBiz System:<\/strong><\/p>\n

Step 1: Go to Data Excel Conversion Sheet<\/strong><\/p>\n

Go to Local Disk C>>MyERP>>Sample>>Data Conversion Sample<\/strong><\/p>\n

\"\"<\/strong><\/p>\n

 <\/p>\n

Step 2:\u00a0<\/strong>Key in all data on Excel Conversion under Item Maintenance<\/strong><\/p>\n

Click “Item Maintenance” on worksheet tabs at bottom of excel >> key in all the data >> save the document<\/strong><\/p>\n

N\/B: Note that RED titles are compulsory field.<\/strong><\/p>\n

\"\"<\/strong><\/p>\n

 <\/p>\n

 <\/p>\n

Step 3: Guideline on how to key in data in excel.<\/strong><\/p>\n

As shown in the picture below, below each title has numbers and an alphabet\u00a0in bracket. This stand for the number of character and type of text you can key in each column.<\/strong><\/p>\n

For Example:<\/strong><\/p>\n

40(t) = Maximum 40 texts<\/strong><\/p>\n

1(n) = Maximum 1 number<\/strong><\/p>\n

\"\"<\/strong><\/p>\n

 <\/p>\n

 <\/p>\n

Analysis code is category of each item group, this will depends on each company on how to arrange it.\u00a0\"\"<\/strong><\/p>\n

 <\/p>\n

Please check the picture below for explanation of each short form.<\/strong><\/p>\n

\"\"<\/strong><\/p>\n

 <\/p>\n

\"\"<\/p>\n

After done, save the document and proceed to next step.<\/strong><\/p>\n

 <\/p>\n

Step 4:\u00a0<\/strong>Open SkySyn<\/strong><\/p>\n

Go to local disc C >> MyERP >> SkySyn<\/strong><\/p>\n

\"\"<\/strong><\/p>\n

 <\/p>\n

 <\/p>\n

Step 5: Go to File > Excel to MySQL2<\/strong><\/p>\n

\"\"<\/strong><\/p>\n

 <\/p>\n

 <\/p>\n

Step 6: Synchronize\u00a0Data<\/strong><\/p>\n

Select Database >>\u00a0<\/strong>Choose File Location of Data Excel Convert >>\u00a0<\/strong>Click Show Excel Sheet >>\u00a0<\/strong>Tick Item <\/strong>Maintenance >>\u00a0<\/strong>Click SQL Convert<\/strong><\/p>\n

\"\"<\/strong><\/p>\n

 <\/p>\n

 <\/p>\n

Step 7: Wait until “Process Convert Completed” message shown then press “OK”.<\/strong><\/p>\n

\"\"<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Below are guideline(s) on how to import Item\/Product Master from Excel to SkyBiz System: Step 1: Go to Data Excel Conversion Sheet Go to Local Disk C>>MyERP>>Sample>>Data Conversion Sample   Step 2:\u00a0Key in all data on Excel Conversion under Item Maintenance Click “Item Maintenance” on worksheet tabs at bottom of excel >> key in all ..<\/p>\n

<\/div>\n

Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-719","post","type-post","status-publish","format-standard","hentry","category-financial"],"yoast_head":"\nImport Item Master\/Product Master from Excel into SkyBiz System - SKYBIZ Cloud ERP Support<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import Item Master\/Product Master from Excel into SkyBiz System - SKYBIZ Cloud ERP Support\" \/>\n<meta property=\"og:description\" content=\"Below are guideline(s) on how to import Item\/Product Master from Excel to SkyBiz System: Step 1: Go to Data Excel Conversion Sheet Go to Local Disk C>>MyERP>>Sample>>Data Conversion Sample   Step 2:\u00a0Key in all data on Excel Conversion under Item Maintenance Click “Item Maintenance” on worksheet tabs at bottom of excel >> key in all ..Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/\" \/>\n<meta property=\"og:site_name\" content=\"SKYBIZ Cloud ERP Support\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-01T07:12:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/aisupport.skybizglobal.com\/ticket\/kbimage\/k_importpo1.jpg\" \/>\n<meta name=\"author\" content=\"Technical 1\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Technical 1\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/import-item-master-product-master-from-excel-into-skybiz-system\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/import-item-master-product-master-from-excel-into-skybiz-system\\\/\"},\"author\":{\"name\":\"Technical 1\",\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/#\\\/schema\\\/person\\\/fbf8363b58da4cbb4f5387de1113725c\"},\"headline\":\"Import Item Master\\\/Product Master from Excel into SkyBiz System\",\"datePublished\":\"2018-10-01T07:12:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/import-item-master-product-master-from-excel-into-skybiz-system\\\/\"},\"wordCount\":259,\"image\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/import-item-master-product-master-from-excel-into-skybiz-system\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/ticket\\\/kbimage\\\/k_importpo1.jpg\",\"articleSection\":[\"Financial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/import-item-master-product-master-from-excel-into-skybiz-system\\\/\",\"url\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/import-item-master-product-master-from-excel-into-skybiz-system\\\/\",\"name\":\"Import Item Master\\\/Product Master from Excel into SkyBiz System - SKYBIZ Cloud ERP Support\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/import-item-master-product-master-from-excel-into-skybiz-system\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/import-item-master-product-master-from-excel-into-skybiz-system\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/ticket\\\/kbimage\\\/k_importpo1.jpg\",\"datePublished\":\"2018-10-01T07:12:02+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/#\\\/schema\\\/person\\\/fbf8363b58da4cbb4f5387de1113725c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/import-item-master-product-master-from-excel-into-skybiz-system\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/import-item-master-product-master-from-excel-into-skybiz-system\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/import-item-master-product-master-from-excel-into-skybiz-system\\\/#primaryimage\",\"url\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/ticket\\\/kbimage\\\/k_importpo1.jpg\",\"contentUrl\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/ticket\\\/kbimage\\\/k_importpo1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/import-item-master-product-master-from-excel-into-skybiz-system\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import Item Master\\\/Product Master from Excel into SkyBiz System\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/#website\",\"url\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/\",\"name\":\"SKYBIZ Cloud ERP Support\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/#\\\/schema\\\/person\\\/fbf8363b58da4cbb4f5387de1113725c\",\"name\":\"Technical 1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ce674a0c926e5113604f7e88376c6daaa9444ad11c917d25ce40c79ad6602d8?s=96&d=blank&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ce674a0c926e5113604f7e88376c6daaa9444ad11c917d25ce40c79ad6602d8?s=96&d=blank&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ce674a0c926e5113604f7e88376c6daaa9444ad11c917d25ce40c79ad6602d8?s=96&d=blank&r=g\",\"caption\":\"Technical 1\"},\"url\":\"https:\\\/\\\/aisupport.skybizglobal.com\\\/skybizclouderp\\\/author\\\/technical1\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import Item Master\/Product Master from Excel into SkyBiz System - SKYBIZ Cloud ERP Support","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Import Item Master\/Product Master from Excel into SkyBiz System - SKYBIZ Cloud ERP Support","og_description":"Below are guideline(s) on how to import Item\/Product Master from Excel to SkyBiz System: Step 1: Go to Data Excel Conversion Sheet Go to Local Disk C>>MyERP>>Sample>>Data Conversion Sample   Step 2:\u00a0Key in all data on Excel Conversion under Item Maintenance Click “Item Maintenance” on worksheet tabs at bottom of excel >> key in all ..Read more","og_url":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/","og_site_name":"SKYBIZ Cloud ERP Support","article_published_time":"2018-10-01T07:12:02+00:00","og_image":[{"url":"https:\/\/aisupport.skybizglobal.com\/ticket\/kbimage\/k_importpo1.jpg","type":"","width":"","height":""}],"author":"Technical 1","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Technical 1","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/#article","isPartOf":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/"},"author":{"name":"Technical 1","@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/#\/schema\/person\/fbf8363b58da4cbb4f5387de1113725c"},"headline":"Import Item Master\/Product Master from Excel into SkyBiz System","datePublished":"2018-10-01T07:12:02+00:00","mainEntityOfPage":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/"},"wordCount":259,"image":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/#primaryimage"},"thumbnailUrl":"https:\/\/aisupport.skybizglobal.com\/ticket\/kbimage\/k_importpo1.jpg","articleSection":["Financial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/","url":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/","name":"Import Item Master\/Product Master from Excel into SkyBiz System - SKYBIZ Cloud ERP Support","isPartOf":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/#primaryimage"},"image":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/#primaryimage"},"thumbnailUrl":"https:\/\/aisupport.skybizglobal.com\/ticket\/kbimage\/k_importpo1.jpg","datePublished":"2018-10-01T07:12:02+00:00","author":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/#\/schema\/person\/fbf8363b58da4cbb4f5387de1113725c"},"breadcrumb":{"@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/#primaryimage","url":"https:\/\/aisupport.skybizglobal.com\/ticket\/kbimage\/k_importpo1.jpg","contentUrl":"https:\/\/aisupport.skybizglobal.com\/ticket\/kbimage\/k_importpo1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/import-item-master-product-master-from-excel-into-skybiz-system\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/"},{"@type":"ListItem","position":2,"name":"Import Item Master\/Product Master from Excel into SkyBiz System"}]},{"@type":"WebSite","@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/#website","url":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/","name":"SKYBIZ Cloud ERP Support","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/#\/schema\/person\/fbf8363b58da4cbb4f5387de1113725c","name":"Technical 1","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4ce674a0c926e5113604f7e88376c6daaa9444ad11c917d25ce40c79ad6602d8?s=96&d=blank&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4ce674a0c926e5113604f7e88376c6daaa9444ad11c917d25ce40c79ad6602d8?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ce674a0c926e5113604f7e88376c6daaa9444ad11c917d25ce40c79ad6602d8?s=96&d=blank&r=g","caption":"Technical 1"},"url":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/author\/technical1\/"}]}},"_links":{"self":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/posts\/719","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/comments?post=719"}],"version-history":[{"count":2,"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/posts\/719\/revisions"}],"predecessor-version":[{"id":3352,"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/posts\/719\/revisions\/3352"}],"wp:attachment":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/media?parent=719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/categories?post=719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizclouderp\/wp-json\/wp\/v2\/tags?post=719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}