{"id":1108,"date":"2019-01-04T09:31:09","date_gmt":"2019-01-04T02:31:09","guid":{"rendered":"https:\/\/www.support.skybizglobal.com\/?p=1108"},"modified":"2019-07-22T16:42:18","modified_gmt":"2019-07-22T09:42:18","slug":"import-pricing-matrix-from-excel-to-mysql","status":"publish","type":"post","link":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/import-pricing-matrix-from-excel-to-mysql\/","title":{"rendered":"Import Pricing Matrix from Excel to MySQL"},"content":{"rendered":"<p><strong><span style=\"color: #3366ff;\">Below are Guideline(s) on How to Import Pricing Matrix from Excel to MySQL<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\"><strong>Step 1:<\/strong> Open Excel Data Conversion (Sample)2 located from MyERP &gt; Sample folder<\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>Step 2:<\/strong> Fill in all necessary data on Pricing Matrix sheet<\/span><\/p>\n<ul>\n<li><span style=\"color: #000000;\"><strong>A).<\/strong> Write your <strong>Pricing Matrix Description<\/strong><\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>B).<\/strong> You can refer on our Sample print screen,if you prefer to give discount by Item fill in <strong>ItemCode<\/strong> then the <strong>Rate<\/strong> Fill at column J (Pct),set the limit per quantity for lower limit if your promotion is buy 5 item get 10% discount\u00a0 set 5 at Column K<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>C).<\/strong> For <strong>Criteria<\/strong> you can check from system which Criteria you prefer and fill in at column M example Discount from selling price if the promotion is 10% discount from your selling price.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>D).<\/strong> <strong>PeriodYN<\/strong> (column N) set to 1 if your promotion is valid for 1 day or few days only then key in\u00a0 the date start and date end of the promotion at column O and P<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>E).<\/strong> Status set as <strong>Active<\/strong><\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>F).<\/strong> <strong>UOMType<\/strong> if the promotion base on your base UOM set 0<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>G).<\/strong> At column <strong>T (B_ase)<\/strong> on this column set your type of Pricing you can refer at <strong>Column V<\/strong> for number selection, if the promotion is Item Based pricing then fill in 1 as per sample on print screen.<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_pricingmatrix.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1109\" src=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_pricingmatrix.jpg\" alt=\"\" width=\"1927\" height=\"1037\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_pricingmatrix.jpg 1927w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_pricingmatrix-300x161.jpg 300w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_pricingmatrix-768x413.jpg 768w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_pricingmatrix-1024x551.jpg 1024w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_pricingmatrix-150x81.jpg 150w\" sizes=\"auto, (max-width: 1927px) 100vw, 1927px\" \/><\/a><\/p>\n<p><span style=\"color: #000000;\"><strong>Step 3:<\/strong> <strong>Import Pricing Matrix to Excel\u00a0<\/strong><\/span><\/p>\n<ul>\n<li><span style=\"color: #000000;\">Open <strong>SkySyn<\/strong> &gt;<strong> File<\/strong> &gt;<strong> Excel to MySQL2<\/strong><\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_import-pricing-matrix.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1111\" src=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_import-pricing-matrix.jpg\" alt=\"\" width=\"1211\" height=\"859\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_import-pricing-matrix.jpg 1211w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_import-pricing-matrix-300x213.jpg 300w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_import-pricing-matrix-768x545.jpg 768w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_import-pricing-matrix-1024x726.jpg 1024w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_import-pricing-matrix-150x106.jpg 150w\" sizes=\"auto, (max-width: 1211px) 100vw, 1211px\" \/><\/a><\/p>\n<p><span style=\"color: #000000;\"><strong>Step 4:<\/strong> Select <strong>Database Name<\/strong> &gt;&gt; Select Excel File by Clicking File Location &gt;&gt; Click Show Excel Sheet &gt;&gt; <strong>Tick PricingMatrix<\/strong> &gt;&gt; <strong>Convert<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_import-pricing-matrix1.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1110\" src=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_import-pricing-matrix1.jpg\" alt=\"\" width=\"1245\" height=\"831\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_import-pricing-matrix1.jpg 1245w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_import-pricing-matrix1-300x200.jpg 300w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_import-pricing-matrix1-768x513.jpg 768w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_import-pricing-matrix1-1024x683.jpg 1024w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_import-pricing-matrix1-150x100.jpg 150w\" sizes=\"auto, (max-width: 1245px) 100vw, 1245px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Below are Guideline(s) on How to Import Pricing Matrix from Excel to MySQL Step 1: Open Excel Data Conversion (Sample)2 located from MyERP &gt; Sample folder Step 2: Fill in all necessary data on Pricing Matrix sheet A). Write your Pricing Matrix Description B). You can refer on our Sample print screen,if you prefer to ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/import-pricing-matrix-from-excel-to-mysql\/\" title=\"read more...\">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":[14,11],"tags":[],"class_list":["post-1108","post","type-post","status-publish","format-standard","hentry","category-pos-retail","category-skybiz-syn"],"_links":{"self":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/posts\/1108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/comments?post=1108"}],"version-history":[{"count":11,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/posts\/1108\/revisions"}],"predecessor-version":[{"id":2162,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/posts\/1108\/revisions\/2162"}],"wp:attachment":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/media?parent=1108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/categories?post=1108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/tags?post=1108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}