{"id":1481,"date":"2022-04-22T12:22:41","date_gmt":"2022-04-22T12:22:41","guid":{"rendered":"https:\/\/www.smartsaleerp.com\/helpdesk\/?post_type=ht_kb&#038;p=1481"},"modified":"2022-08-22T10:39:28","modified_gmt":"2022-08-22T10:39:28","slug":"how-to-add-inventory-using-spreadsheet","status":"publish","type":"ht_kb","link":"https:\/\/www.smartsaleerp.com\/helpdesk\/knowledge-base\/how-to-add-inventory-using-spreadsheet\/","title":{"rendered":"HOW TO ADD INVENTORY USING SPREADSHEET"},"content":{"rendered":"<ol>\n<li>Click on SmartSale POS, move the mouse to Product and Services and then click on Prepare Stock.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/1-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1482 size-full\" src=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/1-5-e1650629729999.png\" alt=\"\" width=\"522\" height=\"382\" srcset=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/1-5-e1650629729999.png 522w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/1-5-e1650629729999-200x146.png 200w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/1-5-e1650629729999-50x37.png 50w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/1-5-e1650629729999-60x44.png 60w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/1-5-e1650629729999-100x73.png 100w\" sizes=\"auto, (max-width: 522px) 100vw, 522px\" \/><\/a><\/p>\n<ol start=\"2\">\n<li>Click on Load File to upload the file containing the products information.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/2-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1483\" src=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/2-5.png\" alt=\"\" width=\"169\" height=\"201\" srcset=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/2-5.png 169w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/2-5-42x50.png 42w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/2-5-50x60.png 50w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/2-5-84x100.png 84w\" sizes=\"auto, (max-width: 169px) 100vw, 169px\" \/><\/a><\/p>\n<ol start=\"3\">\n<li>Navigate to the location of the file and click on it<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/3-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1484\" src=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/3-5.png\" alt=\"\" width=\"594\" height=\"230\" srcset=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/3-5.png 594w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/3-5-200x77.png 200w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/3-5-50x19.png 50w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/3-5-60x23.png 60w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/3-5-100x39.png 100w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><\/a><\/p>\n<ol start=\"4\">\n<li>Click the drop-down menu for each column on the first row and select the most suitable header for that column.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/4-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1485 size-full\" src=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/4-5-e1650629830924.png\" alt=\"\" width=\"539\" height=\"423\" srcset=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/4-5-e1650629830924.png 539w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/4-5-e1650629830924-200x157.png 200w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/4-5-e1650629830924-50x39.png 50w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/4-5-e1650629830924-60x47.png 60w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/4-5-e1650629830924-100x78.png 100w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/a><\/p>\n<ol start=\"5\">\n<li>Click on the top most left corner to select the whole table.<a href=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/5-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1487\" src=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/5-5.png\" alt=\"\" width=\"242\" height=\"268\" srcset=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/5-5.png 242w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/5-5-181x200.png 181w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/5-5-45x50.png 45w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/5-5-54x60.png 54w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/5-5-90x100.png 90w\" sizes=\"auto, (max-width: 242px) 100vw, 242px\" \/><\/a><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol start=\"6\">\n<li>Right click anywhere on the select area and click on receive to add items to inventory.<a href=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/6-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1488 size-full\" src=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/6-1-e1650630114332.png\" alt=\"\" width=\"539\" height=\"382\" srcset=\"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/6-1-e1650630114332.png 539w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/6-1-e1650630114332-200x142.png 200w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/6-1-e1650630114332-50x35.png 50w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/6-1-e1650630114332-60x43.png 60w, https:\/\/www.smartsaleerp.com\/helpdesk\/wp-content\/uploads\/2022\/04\/6-1-e1650630114332-100x71.png 100w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/a><iframe loading=\"lazy\" title=\"How to add products to inventory using spreadsheet\" width=\"643\" height=\"362\" src=\"https:\/\/www.youtube.com\/embed\/tH1No5_Ny68?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Click on SmartSale POS, move the mouse to Product and Services and then click on Prepare Stock. Click on Load File to upload the file containing the products information. Navigate to the location of the file and click on it Click the drop-down menu for each column on the first&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[3],"ht-kb-tag":[93,92,94],"class_list":["post-1481","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-how-to-guides","ht_kb_tag-add-inventory-using-spreadsheet","ht_kb_tag-inventory","ht_kb_tag-spreadsheet"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-json\/wp\/v2\/ht-kb\/1481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-json\/wp\/v2\/comments?post=1481"}],"version-history":[{"count":1,"href":"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-json\/wp\/v2\/ht-kb\/1481\/revisions"}],"predecessor-version":[{"id":1489,"href":"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-json\/wp\/v2\/ht-kb\/1481\/revisions\/1489"}],"wp:attachment":[{"href":"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-json\/wp\/v2\/media?parent=1481"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-json\/wp\/v2\/ht-kb-category?post=1481"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.smartsaleerp.com\/helpdesk\/wp-json\/wp\/v2\/ht-kb-tag?post=1481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}