{"id":865,"date":"2022-12-15T17:46:24","date_gmt":"2022-12-15T14:46:24","guid":{"rendered":"https:\/\/ainurpos.com\/help\/?post_type=ht_kb&#038;p=865"},"modified":"2023-08-18T21:00:38","modified_gmt":"2023-08-18T18:00:38","slug":"importing-a-product-from-excel-to-ainurpos","status":"publish","type":"ht_kb","link":"https:\/\/ainurpos.com\/help\/knowledge\/importing-a-product-from-excel-to-ainurpos\/","title":{"rendered":"Importing a product from Excel to AinurPOS"},"content":{"rendered":"\n<p class=\"has-black-color has-text-color wp-block-paragraph\">In AinurPOS, you can import goods from Excel spreadsheets, catalogs, and other documents. <\/p>\n\n\n\n<p class=\"has-black-color has-text-color wp-block-paragraph\">Go to the &#171;Catalog&#187; section and click &#171;Import goods&#187;. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"176\" src=\"https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image3-39.png\" alt=\"\" class=\"wp-image-2055\" srcset=\"https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image3-39.png 1024w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image3-39-300x52.png 300w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image3-39-768x132.png 768w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image3-39-50x9.png 50w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image3-39-60x10.png 60w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image3-39-100x17.png 100w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-black-color has-text-color wp-block-paragraph\">Copy the products from your spreadsheet (Excel, Word, Google Docs, PDF, etc.) or just from the spreadsheet from the supplier&#8217;s website by pressing Ctrl+C. Back in AinurPOS, press Ctrl-V. All products will be loaded. <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img decoding=\"async\" src=\"https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image5-25.png\" alt=\"\" class=\"wp-image-2056\" style=\"height:700px\" height=\"700\" srcset=\"https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image5-25.png 735w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image5-25-215x300.png 215w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image5-25-36x50.png 36w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image5-25-43x60.png 43w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image5-25-72x100.png 72w\" sizes=\"(max-width: 735px) 100vw, 735px\" \/><\/figure>\n\n\n\n<p class=\"has-black-color has-text-color wp-block-paragraph\">Select column names from the drop-down list. You can download the following data: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Name. The name of the product or service is a <strong>required column<\/strong>. <\/li>\n\n\n\n<li>Group. You can immediately upload products and services to the desired group or subgroup. To do this, specify the full path in the cell with the separation &#171;\/&#187;. If the group exists, the product will be created in it. If there is no group, it will be created.<\/li>\n\n\n\n<li>Type. You can upload products and services from Excel to AinurPOS. The following values can be used to indicate the type:\n<ul class=\"wp-block-list\">\n<li><strong>The product <\/strong>can be specified with the words: product, p, inventory, inv, i, 1 \u2014 without taking into account the case and signs.<\/li>\n\n\n\n<li><strong>Service<\/strong>: service, service, serv, s, 0 <\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Description. Description of the product or service.<\/li>\n\n\n\n<li>Barcode. You can upload one or more barcodes to the product. Multiple barcodes are separated by a comma or a space.<\/li>\n\n\n\n<li>SKU.<\/li>\n\n\n\n<li>Categories. If the item has several categories, use &#171;,&#187; as the separator.<\/li>\n\n\n\n<li>Unit of measurement.<\/li>\n\n\n\n<li>The sale price. The base selling price. Attention! In all columns with prices, all symbols except numeric ones are automatically discarded. The separator of the integer and fractional parts can be &#171;,&#187; and &#171;.&#187;.<\/li>\n\n\n\n<li>Discount.<\/li>\n\n\n\n<li>Purchase price.<\/li>\n\n\n\n<li>Country.<\/li>\n\n\n\n<li>VAT.<\/li>\n\n\n\n<li>Minimum stock.<\/li>\n\n\n\n<li>Weight goods. The product is marked by weight, if there is at least some value in the cell. Empty cell or 0 \u2014 the product is not weighted.<\/li>\n\n\n\n<li>The product is at a free price. The product is marked as being sold at a free price, if there is at least some value in the cell. Empty cell or 0 \u2014 the product cannot be sold at a free price.<\/li>\n\n\n\n<li>The supplier. <strong>Important!<\/strong> If no supplier is found by name, a new one will be created. The name of the supplier is case\u2014sensitive. I.e., &#171;Supplier&#187; and &#171;SUPPLIER&#187; are different counterparties.<\/li>\n\n\n\n<li>Expiration date. The date value is entered in the format: DD\/MM\/YYYY or DD.MM.YYYY<\/li>\n\n\n\n<li>Prices in each store. If the sale price in another store differs from the base, they can be set in separate columns.<\/li>\n\n\n\n<li>Stock in the store. To enter the initial balances, you must specify them in the columns &#171;Number in &#171;Store Name&#187;. After the import is completed, the registration documents for each store will be created. <strong>Important!<\/strong> In order for the cost price in AinurPOS to be correct, you need to specify the purchase price in the accounting documents. Thus, if you specify balances when importing, make sure that the &#171;Purchase Price&#187; column is set and matched. <\/li>\n<\/ul>\n\n\n\n<p class=\"has-black-color has-text-color wp-block-paragraph\">If necessary, you can edit the values in the cells by double-clicking on the cells. <\/p>\n\n\n\n<p class=\"has-black-color has-text-color wp-block-paragraph\">If you need to delete a row, for example, if the table header has been copied, you need to click the corresponding trash icon. <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"758\" height=\"164\" src=\"https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image4-32.png\" alt=\"\" class=\"wp-image-2057\" srcset=\"https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image4-32.png 758w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image4-32-300x65.png 300w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image4-32-50x11.png 50w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image4-32-60x13.png 60w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image4-32-100x22.png 100w\" sizes=\"auto, (max-width: 758px) 100vw, 758px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading has-black-color has-text-color\"><strong>Updating product data<\/strong> <\/h3>\n\n\n\n<p class=\"has-black-color has-text-color wp-block-paragraph\">In AinurPOS, there are three possible scenarios for working with the import of goods from Excel. <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"774\" height=\"422\" src=\"https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image7-14.png\" alt=\"\" class=\"wp-image-2058\" srcset=\"https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image7-14.png 774w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image7-14-300x164.png 300w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image7-14-768x419.png 768w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image7-14-50x27.png 50w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image7-14-60x33.png 60w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image7-14-100x55.png 100w\" sizes=\"auto, (max-width: 774px) 100vw, 774px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<ol class=\"wp-block-list\">\n<li><strong><strong>Create and update.<\/strong> <\/strong>This mode is suitable for most cases. It will be created if the system does not find the imported product in your product database. If the product is found, it will be updated.<\/li>\n\n\n\n<li><strong><strong>Only create<\/strong>. <\/strong>Only new products are processed. Existing ones in the database are ignored. If you have received a price list or invoice from a supplier and you need to add only new product items from it, choose this scenario.<\/li>\n\n\n\n<li><strong><strong>Update only.<\/strong> <\/strong>The scenario is when from the entire price list, you need to update data only on products from your database. In this case, only existing products will be processed. No new ones will be created. <\/li>\n<\/ol>\n<\/ol>\n\n\n\n<p class=\"has-black-color has-text-color wp-block-paragraph\">In order to separate the new products that need to be created from the products that need to be updated during import, six matching methods are used. <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"958\" height=\"674\" src=\"https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image6-23.png\" alt=\"\" class=\"wp-image-2060\" srcset=\"https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image6-23.png 958w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image6-23-300x211.png 300w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image6-23-768x540.png 768w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image6-23-50x35.png 50w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image6-23-60x42.png 60w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image6-23-100x70.png 100w\" sizes=\"auto, (max-width: 958px) 100vw, 958px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<ul class=\"wp-block-list\">\n<li>Automatically. If there is at least one product in the database that matches at least one of the matching parameters, it will be updated. If there are several such products, then one of them will be updated. <\/li>\n\n\n\n<li>By ID. You can unload goods from AinurPOS. By selecting &#171;Download to Excel&#187; All columns&#187;. The resulting file will contain a column <strong>&#171;Product ID&#187;<\/strong>. This method is more accurate because the matching takes place by a unique code. <\/li>\n\n\n\n<li>By product code. A five-digit digital product code in AinurPOS.<\/li>\n\n\n\n<li>By name. <strong>Attention!<\/strong> The exact name of the goods is compared. Symbols, spaces, and the case of letters affect the comparison. Thus, &#171;Cheese&#187; and &#171;cheese&#187; are different cheeses.<\/li>\n\n\n\n<li>According to the SKU.<\/li>\n\n\n\n<li>By barcode. If the product has several barcodes, the comparison takes place for any of them.<\/li>\n<\/ul>\n<\/ul>\n\n\n\n<p class=\"has-black-color has-text-color wp-block-paragraph\">Automatic search works by default. If at least one value matches the data in the table: ID, product code, name, SKU, or barcode \u2014 such a product is considered to exist. <\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"has-black-color has-text-color wp-block-paragraph\"><strong>Important<\/strong>! After clicking the <strong>Import<\/strong> button, the process of searching and matching products begins. The duration of this process directly depends on the quantity of imported goods and goods in the database. In some cases, the browser may automatically issue alert messages about the need to refresh or close the page, because it believes that the page is frozen. We recommend waiting for the process to complete. <\/p>\n\n\n\n<p class=\"has-black-color has-text-color wp-block-paragraph\">To speed up the process, we also recommend choosing not automatic matching, but matching by a specific field. <\/p>\n<\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"has-black-color has-text-color wp-block-paragraph\"><strong><strong>Hack<\/strong>! <\/strong>If for some reason, you do not need to update existing positions, but need to create duplicates of them, you can choose the method of matching by ID and specify an empty column for it. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"346\" src=\"https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image1-63-1024x346.png\" alt=\"\" class=\"wp-image-2061\" srcset=\"https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image1-63-1024x346.png 1024w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image1-63-300x101.png 300w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image1-63-768x259.png 768w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image1-63-50x17.png 50w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image1-63-60x20.png 60w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image1-63-100x34.png 100w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image1-63.png 1250w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/blockquote>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Processing empty cells<\/strong> <\/h4>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"229\" src=\"https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image2-50.png\" alt=\"\" class=\"wp-image-2062\" srcset=\"https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image2-50.png 1024w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image2-50-300x67.png 300w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image2-50-768x172.png 768w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image2-50-50x11.png 50w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image2-50-60x13.png 60w, https:\/\/ainurpos.com\/help\/wp-content\/uploads\/2023\/08\/image2-50-100x22.png 100w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-black-color has-text-color wp-block-paragraph\">If you have empty cells in the imported table, the import will ignore them by default. If you need to erase some data from the product in the database, turn on the<strong> Erase data if the cell is empty.<\/strong> <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"has-black-color has-text-color wp-block-paragraph\">A few important notes on the work of import when updating data on the catalog:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<ol class=\"wp-block-list\">\n<li>The name is a required column. The name can only be changed. It cannot be erased.<\/li>\n\n\n\n<li>When updating product data, all values of the matched columns <strong>are overwritten<\/strong>. If the product had several barcodes, and in the import the cell contains only one barcode, then as a result of the import the product will have only one barcode. The data is not supplemented.<\/li>\n\n\n\n<li>Data such as the <strong>Product Code, Product ID, and Product Type <\/strong>are ignored and not overwritten when updating the data.<\/li>\n\n\n\n<li>Each time an existing product is imported, stock adjustment documents will be created. As a result, the balances will be summed up with the current ones.<\/li>\n\n\n\n<li>The groups are not edited. I.e., if you imported the product to &#171;Alpha&#187;, then by making a new import to &#171;Betta&#187; you will have two groups in the database: &#171;Alpha&#187; and &#171;Betta&#187;. After the second import, the product will simply be moved to the Betta group.<\/li>\n\n\n\n<li>You cannot undo changes made via import from Excel. <\/li>\n<\/ol>\n<\/ol>\n\n\n\n<p class=\"has-black-color has-text-color wp-block-paragraph\">Thus, you can quickly edit and add data about goods and services, and change prices and discounts, as well as stock, adjust goods. <\/p>\n\n\n\n<p class=\"has-black-color has-text-color wp-block-paragraph\">You can check the added products in the Catalog section. If, for some reason, the data is not displayed, update the page.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to import goods from Excel to AinurPOS\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/X4NJA7H9weA?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>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In AinurPOS, you can import goods from Excel spreadsheets, catalogs, and other documents. Go to the &#171;Catalog&#187; section and click &#171;Import goods&#187;. Copy the products from your spreadsheet (Excel, Word, Google Docs, PDF, etc.) or just from the spreadsheet from the supplier&#8217;s website by pressing Ctrl+C. Back in AinurPOS, press&#8230;<\/p>\n","protected":false},"author":5,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[29],"ht-kb-tag":[],"class_list":["post-865","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-inventory-management"],"_links":{"self":[{"href":"https:\/\/ainurpos.com\/help\/wp-json\/wp\/v2\/ht-kb\/865","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ainurpos.com\/help\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/ainurpos.com\/help\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/ainurpos.com\/help\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/ainurpos.com\/help\/wp-json\/wp\/v2\/comments?post=865"}],"version-history":[{"count":5,"href":"https:\/\/ainurpos.com\/help\/wp-json\/wp\/v2\/ht-kb\/865\/revisions"}],"predecessor-version":[{"id":2063,"href":"https:\/\/ainurpos.com\/help\/wp-json\/wp\/v2\/ht-kb\/865\/revisions\/2063"}],"wp:attachment":[{"href":"https:\/\/ainurpos.com\/help\/wp-json\/wp\/v2\/media?parent=865"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/ainurpos.com\/help\/wp-json\/wp\/v2\/ht-kb-category?post=865"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/ainurpos.com\/help\/wp-json\/wp\/v2\/ht-kb-tag?post=865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}