{"id":595,"date":"2022-11-15T14:38:08","date_gmt":"2022-11-15T14:38:08","guid":{"rendered":"https:\/\/stoneedge.com\/kb\/?post_type=ht_kb&#038;p=595"},"modified":"2022-11-16T16:28:03","modified_gmt":"2022-11-16T16:28:03","slug":"import-cost-price-and-weight","status":"publish","type":"ht_kb","link":"https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/","title":{"rendered":"Import Cost, Price and Weight"},"content":{"rendered":"<h2>Overview<\/h2>\n<ul>\n<li class=\"CopyofBulletedList\">Several types of data can be imported through the\u00a0<i>Import Data<\/i> screen, such as Product (Inventory), Customer, or Supplier records. Product cost and price information can also be imported via this screen.<\/li>\n<li class=\"BulletedList\">Data can be imported from:\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li class=\"p\">A tab or comma-delimited text file (Preferred)<\/li>\n<li class=\"p\">A table in a Microsoft Access database<\/li>\n<li class=\"p\">Any other format (e.g., an Excel spreadsheet or FoxPro table) can link to an Access database. For information on linking data in external tables to Access, please see MS Access documentation.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li class=\"BulletedList\">When importing data from a text file, if the data contains commas, the file should be saved as a tab-delimited file, not a CSV.<\/li>\n<li class=\"BulletedList\">Quotes should not be present in text files, whether it is a CSV or tab-delimited file, or you will encounter errors.<\/li>\n<\/ul>\n<ul>\n<li class=\"BulletedList\">To access this screen go to one of the following areas:<\/li>\n<\/ul>\n<p><em><strong>Main Menu &gt; Manage My Inventory &gt; Import My Inventory &#8211; File<\/strong><\/em><\/p>\n<p><em><strong>Main Menu &gt; Manage My Inventory &gt; Import Cost, Price &amp; Weight<\/strong><\/em><\/p>\n<p><em><strong>Main Menu &gt; Manage My Inventory &gt; Import My Suppliers<\/strong><\/em><\/p>\n<p><em><strong>Main Menu &gt; Manage My Customers &gt; Import My Customers &#8211; File<\/strong><\/em><\/p>\n<ul>\n<li class=\"BulletedList\">The user is led through the steps to import the various data types by a series of screens.<\/li>\n<li class=\"BulletedList\">This topic discusses the process of importing product cost, price, and weight information.<\/li>\n<\/ul>\n<h2>Description of the Screens<\/h2>\n<div>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-2325 \" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Cost-Price-and-Weight.png\" alt=\"\" width=\"770\" height=\"498\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Cost-Price-and-Weight.png 946w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Cost-Price-and-Weight-300x194.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Cost-Price-and-Weight-768x497.png 768w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Cost-Price-and-Weight-50x32.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Cost-Price-and-Weight-60x39.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Cost-Price-and-Weight-100x65.png 100w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><\/p>\n<p><i>Import Cost, Price, and Weight: Select the File to Import tab<\/i><\/p>\n<\/div>\n<h3>Select File to Import Tab<\/h3>\n<h4>Import Radio Button<\/h4>\n<ul>\n<li class=\"BulletedList\">The Cost, Price &amp; Weight radio button is selected by default<\/li>\n<\/ul>\n<h4>File to import from (.mdb or text file) Field<\/h4>\n<ul>\n<li class=\"BulletedList\">Enter the path to the file containing the product information<\/li>\n<li class=\"BulletedList\">The program displays up to 50 fields in the file and the first 100 records at the bottom of the screen<\/li>\n<\/ul>\n<h4>Folder Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Select this button to navigate to the location of the file containing the product information<\/li>\n<\/ul>\n<h4>Restore from Backup Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Select this button to restore from a previous backup, if one was created at the last step of the process<\/li>\n<\/ul>\n<h4>Start Over Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Returns to the <strong>Select File to Import<\/strong>\u00a0tab<\/li>\n<\/ul>\n<h4>Next Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Select this button when ready to proceed to the <strong>Import Options<\/strong>\u00a0tab<\/li>\n<\/ul>\n<h3>Import Options Tab<\/h3>\n<div>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-2326 \" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Data-Screen.png\" alt=\"\" width=\"771\" height=\"498\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Data-Screen.png 940w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Data-Screen-300x194.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Data-Screen-768x496.png 768w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Data-Screen-50x32.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Data-Screen-60x39.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Data-Screen-100x65.png 100w\" sizes=\"(max-width: 771px) 100vw, 771px\" \/><\/p>\n<p><i>Import Data screen: Import Options tab for importing Cost, Price, &amp; Weight information<\/i><\/p>\n<\/div>\n<h4>Field Delimiter Radio Buttons<\/h4>\n<h5>Comma Radio Button<\/h5>\n<ul>\n<li class=\"BulletedList\">Select this button if commas separate the fields in the input file<\/li>\n<\/ul>\n<h5>Tab Radio Button<\/h5>\n<ul>\n<li class=\"BulletedList\">Select this button if a tab separates the fields in the input file<\/li>\n<\/ul>\n<h5>Other Field<\/h5>\n<ul>\n<li class=\"BulletedList\">Enter the character used to separate the fields in the input file<\/li>\n<\/ul>\n<h4>First Row Contains Field Names Check Box<\/h4>\n<ul>\n<li class=\"BulletedList\">Select this box if the first row in the input file contains a header record with field names<\/li>\n<\/ul>\n<h4>Assign Supplier Drop-down List<\/h4>\n<ul>\n<li class=\"BulletedList\">Select a supplier to assign to product records that do not already contain a Supplier ID or Supplier Name value<\/li>\n<li class=\"BulletedList\">This Supplier automatically becomes the Primary Supplier of the product<\/li>\n<\/ul>\n<h4>Add New Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Click this button to add a new supplier record &#8220;on the fly.&#8221;<\/li>\n<\/ul>\n<h4>Data in Text File or Database Table<\/h4>\n<ul>\n<li class=\"BulletedList\">This section displays up to fifty fields and the first one hundred records of data in the input file.<\/li>\n<\/ul>\n<h4>Start Over Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Returns to the Select File to Import tab<\/li>\n<\/ul>\n<h4>Back Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Returns to the previous tab<\/li>\n<\/ul>\n<h4>Next Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Select this button when ready to proceed to the <strong>Cost, Price &amp; Weight<\/strong>\u00a0tab<\/li>\n<\/ul>\n<h3>Cost, Price &amp; Weight Tab<\/h3>\n<div>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-2327 \" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Cost-Price-And-Weight-Tab.png\" alt=\"\" width=\"770\" height=\"502\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Cost-Price-And-Weight-Tab.png 947w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Cost-Price-And-Weight-Tab-300x195.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Cost-Price-And-Weight-Tab-768x500.png 768w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Cost-Price-And-Weight-Tab-50x33.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Cost-Price-And-Weight-Tab-60x39.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Cost-Price-And-Weight-Tab-100x65.png 100w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><\/p>\n<\/div>\n<h4>Match Items On (select one):<\/h4>\n<ul>\n<li class=\"BulletedList\">Choose whether to match product records between the files based on the <strong>Local SKU<\/strong> or <strong>Item Name<\/strong> fields.<\/li>\n<li class=\"BulletedList\">\u00a0<strong>Local SKU<\/strong>\u00a0is the best choice because SKUs must be unique, whereas products may share the same name.<\/li>\n<li class=\"BulletedList\">Clear the field that is not used.<\/li>\n<\/ul>\n<h4>Match Suppliers On:<\/h4>\n<ul>\n<li class=\"BulletedList\">Select <strong>Supplier ID<\/strong>\u00a0and\/or\u00a0<strong>Supplier Name<\/strong>\u00a0<i>OR<\/i>\u00a0leave these fields blank and\u00a0use the\u00a0<strong>Supplier <\/strong>specified on the previous tab instead.<\/li>\n<li class=\"BulletedList\"><strong>Supplier ID<\/strong>s in the external file must be numeric, and they must be the identical <strong>Supplier ID<\/strong>s\u00a0that exist in\u00a0<span style=\"font-size: small;\">OMS.<\/span><\/li>\n<\/ul>\n<h4>Fields to Update<\/h4>\n<ul>\n<li class=\"BulletedList\">Select or clear the values in these drop-down lists to control which fields are updated.<\/li>\n<li class=\"BulletedList\">The possible choices are <strong>Your Cost<\/strong> (Supplier&#8217;s\u00a0unit cost field),\u00a0P<strong>ublished Wt.<\/strong>,\u00a0<strong>Actual Weight<\/strong>,<strong>\u00a0Regular Price<\/strong>,\u00a0<strong>Sale Price<\/strong>, or\u00a0<strong>Supplier&#8217;s SKU.<\/strong><\/li>\n<\/ul>\n<h4>Data in Text File or Database Table<\/h4>\n<ul>\n<li class=\"BulletedList\">This section displays up to fifty fields and the first one hundred records of data in the input file (not labeled as such).<\/li>\n<\/ul>\n<h4>Start Over Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Returns to the <strong>Select File to Import<\/strong> tab.<\/li>\n<\/ul>\n<h4>Back Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Returns to the previous tab.<\/li>\n<\/ul>\n<h4>Next Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Select this button when ready to proceed to the second page of the <strong>Finish and Import<\/strong> tab.<\/li>\n<\/ul>\n<h3>Finish and Import Tab<\/h3>\n<div>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-2328 \" src=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Finish-and-Import.png\" alt=\"\" width=\"771\" height=\"502\" srcset=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Finish-and-Import.png 944w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Finish-and-Import-300x195.png 300w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Finish-and-Import-768x500.png 768w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Finish-and-Import-50x33.png 50w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Finish-and-Import-60x39.png 60w, https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Finish-and-Import-100x65.png 100w\" sizes=\"(max-width: 771px) 100vw, 771px\" \/><\/p>\n<\/div>\n<h4>Backup Before Importing Check Box<\/h4>\n<ul>\n<li class=\"BulletedList\">Select this box to make a backup copy of the affected tables before the import is started<\/li>\n<\/ul>\n<h4>Test Data Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Select this button to have the program check for errors before starting the import process<\/li>\n<\/ul>\n<h4>Begin Import Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Select this button to start the import process<\/li>\n<\/ul>\n<h4>Start Over Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Returns to the <strong>Select File to Import<\/strong>\u00a0tab<\/li>\n<\/ul>\n<h4>Back Button<\/h4>\n<ul>\n<li class=\"BulletedList\">Returns to the previous tab<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Overview Several types of data can be imported through the\u00a0Import Data screen, such as Product (Inventory), Customer, or Supplier records. Product cost and price information can also be imported via this screen. Data can be imported from: A tab or comma-delimited text file (Preferred) A table in a Microsoft Access&#8230;<\/p>\n","protected":false},"author":2,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[72],"ht-kb-tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Import Cost, Price and Weight - Stone Edge Order Manager<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import Cost, Price and Weight - Stone Edge Order Manager\" \/>\n<meta property=\"og:description\" content=\"Overview Several types of data can be imported through the\u00a0Import Data screen, such as Product (Inventory), Customer, or Supplier records. Product cost and price information can also be imported via this screen. Data can be imported from: A tab or comma-delimited text file (Preferred) A table in a Microsoft Access...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/\" \/>\n<meta property=\"og:site_name\" content=\"Stone Edge Order Manager\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-16T16:28:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Cost-Price-and-Weight.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/\",\"url\":\"https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/\",\"name\":\"Import Cost, Price and Weight - Stone Edge Order Manager\",\"isPartOf\":{\"@id\":\"https:\/\/stoneedge.com\/kb\/#website\"},\"datePublished\":\"2022-11-15T14:38:08+00:00\",\"dateModified\":\"2022-11-16T16:28:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/stoneedge.com\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import Cost, Price and Weight\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/stoneedge.com\/kb\/#website\",\"url\":\"https:\/\/stoneedge.com\/kb\/\",\"name\":\"Stone Edge Order Manager\",\"description\":\"Documentation for the Stone Edge Order Manager\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/stoneedge.com\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import Cost, Price and Weight - Stone Edge Order Manager","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/","og_locale":"en_US","og_type":"article","og_title":"Import Cost, Price and Weight - Stone Edge Order Manager","og_description":"Overview Several types of data can be imported through the\u00a0Import Data screen, such as Product (Inventory), Customer, or Supplier records. Product cost and price information can also be imported via this screen. Data can be imported from: A tab or comma-delimited text file (Preferred) A table in a Microsoft Access...","og_url":"https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/","og_site_name":"Stone Edge Order Manager","article_modified_time":"2022-11-16T16:28:03+00:00","og_image":[{"url":"https:\/\/stoneedge.com\/kb\/wp-content\/uploads\/2019\/04\/Import-Cost-Price-and-Weight.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/","url":"https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/","name":"Import Cost, Price and Weight - Stone Edge Order Manager","isPartOf":{"@id":"https:\/\/stoneedge.com\/kb\/#website"},"datePublished":"2022-11-15T14:38:08+00:00","dateModified":"2022-11-16T16:28:03+00:00","breadcrumb":{"@id":"https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/stoneedge.com\/kb\/articles\/import-cost-price-and-weight\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/stoneedge.com\/kb\/"},{"@type":"ListItem","position":2,"name":"Import Cost, Price and Weight"}]},{"@type":"WebSite","@id":"https:\/\/stoneedge.com\/kb\/#website","url":"https:\/\/stoneedge.com\/kb\/","name":"Stone Edge Order Manager","description":"Documentation for the Stone Edge Order Manager","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/stoneedge.com\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/595"}],"collection":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/comments?post=595"}],"version-history":[{"count":6,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/595\/revisions"}],"predecessor-version":[{"id":2797,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/595\/revisions\/2797"}],"wp:attachment":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/media?parent=595"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=595"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}