{"id":1156,"date":"2019-01-09T09:02:08","date_gmt":"2019-01-09T02:02:08","guid":{"rendered":"https:\/\/www.support.skybizglobal.com\/?p=1156"},"modified":"2019-01-09T09:02:49","modified_gmt":"2019-01-09T02:02:49","slug":"export-and-import-cash-sales-from-counter-to-server","status":"publish","type":"post","link":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/export-and-import-cash-sales-from-counter-to-server\/","title":{"rendered":"Export and Import Cash Sales from Counter to Server"},"content":{"rendered":"<p><strong><span style=\"color: #3366ff;\">Below are Guideline(s) on How to Import or Export Cash Sales from POS data to Server data<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Step 1:<\/span> <span style=\"color: #3366ff;\"><strong>Create a new\/blank data<\/strong><\/span>,<span style=\"color: #000000;\">this data will be use as bridge on exporting and importing.<\/span><\/p>\n<p><span style=\"color: #000000;\">Step 2: Login on POS\/counter database<\/span><\/p>\n<p><a href=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales4.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1162\" src=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales4.jpg\" alt=\"\" width=\"1345\" height=\"795\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales4.jpg 1345w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales4-300x177.jpg 300w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales4-768x454.jpg 768w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales4-1024x605.jpg 1024w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales4-150x89.jpg 150w\" sizes=\"auto, (max-width: 1345px) 100vw, 1345px\" \/><\/a><\/p>\n<p><span style=\"color: #000000;\">Step 3: Go to System &gt;&gt; Database Manager &gt;&gt; Export,Import,Purging Default Value Setting<\/span><\/p>\n<p><a href=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1160\" src=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales.jpg\" alt=\"\" width=\"1367\" height=\"827\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales.jpg 1367w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales-300x181.jpg 300w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales-768x465.jpg 768w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales-1024x619.jpg 1024w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales-150x91.jpg 150w\" sizes=\"auto, (max-width: 1367px) 100vw, 1367px\" \/><\/a><\/p>\n<p><span style=\"color: #000000;\">Step 4: On Export and Import Screen <\/span><\/p>\n<ol>\n<li><span style=\"color: #000000;\">Choose Export Selection<\/span><\/li>\n<li><span style=\"color: #000000;\">Screen Name select <strong><span style=\"color: #3366ff;\">Cash Sales<\/span>\u00a0<\/strong>then adjust date between and Refresh<\/span><\/li>\n<li><span style=\"color: #000000;\">Right Click to Tick All<\/span><\/li>\n<li><span style=\"color: #000000;\">Choose the bridge database (the new database that you created earlier)\u00a0<\/span><\/li>\n<li><span style=\"color: #000000;\">Process Export<\/span><\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1159\" src=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales1.jpg\" alt=\"\" width=\"1309\" height=\"805\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales1.jpg 1309w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales1-300x184.jpg 300w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales1-768x472.jpg 768w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales1-1024x630.jpg 1024w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales1-150x92.jpg 150w\" sizes=\"auto, (max-width: 1309px) 100vw, 1309px\" \/><\/a><\/p>\n<p><span style=\"color: #000000;\">Step 4: Login on Main Database<\/span><\/p>\n<p><a href=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales5.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1161\" src=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales5.jpg\" alt=\"\" width=\"1389\" height=\"813\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales5.jpg 1389w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales5-300x176.jpg 300w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales5-768x450.jpg 768w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales5-1024x599.jpg 1024w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales5-150x88.jpg 150w\" sizes=\"auto, (max-width: 1389px) 100vw, 1389px\" \/><\/a><\/p>\n<p><span style=\"color: #000000;\">Step 5: On Export and Import Screen<\/span><\/p>\n<ol>\n<li><span style=\"color: #000000;\">Select Import Selection &gt; Screen Name choose Cash Sales<\/span><\/li>\n<li><span style=\"color: #000000;\">Import from Database &gt; Select the\u00a0the bridge database (the database where you exported the sales from POS)\u00a0<\/span><\/li>\n<li><span style=\"color: #000000;\">Click Remove Data To Be Import to show the transactions you want to Import<\/span><\/li>\n<li><span style=\"color: #000000;\">Process Import<\/span><\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1158\" src=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales2.jpg\" alt=\"\" width=\"1159\" height=\"783\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales2.jpg 1159w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales2-300x203.jpg 300w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales2-768x519.jpg 768w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales2-1024x692.jpg 1024w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales2-150x101.jpg 150w\" sizes=\"auto, (max-width: 1159px) 100vw, 1159px\" \/><\/a><\/p>\n<p><span style=\"color: #000000;\">Step 6: Go to Cash Sales to check the Imported transactions<\/span><\/p>\n<p><a href=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales3.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1157\" src=\"https:\/\/www.support.skybizglobal.com\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales3.jpg\" alt=\"\" width=\"1519\" height=\"839\" srcset=\"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales3.jpg 1519w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales3-300x166.jpg 300w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales3-768x424.jpg 768w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales3-1024x566.jpg 1024w, https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-content\/uploads\/2019\/01\/kb_exportimport_cashsales3-150x83.jpg 150w\" sizes=\"auto, (max-width: 1519px) 100vw, 1519px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Below are Guideline(s) on How to Import or Export Cash Sales from POS data to Server data Step 1: Create a new\/blank data,this data will be use as bridge on exporting and importing. Step 2: Login on POS\/counter database Step 3: Go to System &gt;&gt; Database Manager &gt;&gt; Export,Import,Purging Default Value Setting Step 4: On ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/export-and-import-cash-sales-from-counter-to-server\/\" 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],"tags":[],"class_list":["post-1156","post","type-post","status-publish","format-standard","hentry","category-pos-retail"],"_links":{"self":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/posts\/1156","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=1156"}],"version-history":[{"count":2,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/posts\/1156\/revisions"}],"predecessor-version":[{"id":1164,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/posts\/1156\/revisions\/1164"}],"wp:attachment":[{"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/media?parent=1156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/categories?post=1156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aisupport.skybizglobal.com\/skybizoffline\/wp-json\/wp\/v2\/tags?post=1156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}