Ask the Community
Groups
Product import fails when using Import data function. - Connect IT Community | Kaseya
<main> <article class="userContent"> <div> <p> Issue: </p> <p>Data import fails when importing products to BMS using <strong>Admin > Import data.</strong></p> <p><em><strong>Error message:</strong></em> Products Product Name is required!. Products Product Number is required!</p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/CLZ5MVDTV6E8/blobid0.png" alt="blobid0.png" width="500" height="300" class="embedImage-img importedEmbed-img"></img></p> <p><em><strong>Cause:</strong></em> When you copy-paste or import data from databases or other file formats, the column formats get modified. To fix this make use of <strong>Text to Columns </strong>in excel and re-try the import. </p> <p> Solution: </p> <p>Select a Column to convert. On the <strong>Data</strong> tab, click <strong>Text to Columns</strong>. This opens the Convert Text to columns Wizard. Choose the following options. </p> <p>Step 1: Select <strong>Delimited</strong>, Click Next </p> <p>Step 2: Select <strong>Tab </strong>as the delimiter, Click Next</p> <p>Step 3: In Column data format, select <strong>Text. </strong>Click <strong>Finish </strong> </p> <p>Use the above steps on the following columns and attempt to import the products again.</p> <table border="1"><tbody><tr><td><strong>Product Name</strong></td> <td><strong>Product Number</strong></td> <td><strong>Product UPC</strong></td> <td scope="rowgroup"><strong>SKU</strong></td> <td><strong>Vendor Part number</strong></td> </tr></tbody></table><p> </p> </div> </article> </main>