<h1 class="title">Stock Picking From XLS</h1> <p>This allows to make internal transfers from an excel file, with the following structure</p> <table class="docutils"> <colgroup> <col width="23%" /> <col width="38%" /> <col width="28%" /> <col width="11%" /> </colgroup> <thead valign="bottom"> <tr><th class="head">SKU</th> <th class="head">NAME</th> <th class="head">DESCRIPTION</th> <th class="head">QTY</th> </tr> </thead> <tbody valign="top"> <tr><td>IN1010201</td> <td>Blue Cheese XXX</td> <td>ADJUSTMENT</td> <td>1</td> </tr> <tr><td>IN1010301</td> <td>Barbacue beef</td> <td>CHECK</td> <td>20</td> </tr> </tbody> </table> <p>The &quot;SKU&quot; must match as default_code field in products. The values you put at column &quot;NAME&quot; are not taken in account by the transfer. &quot;QUANTITY&quot; is the quantity in the product unit set at the product record.</p> <a name="installation"></a> <h2>Installation</h2> <p>Multiple warehouses must be checked in inventory configuration. Install the module. Once installed, go to inventory board and choose a picking of type 'internal'. You will see a place in the header of the picking where you can upload the excel file. Inmmediatly, the products will be injected in the move lines. Then you can save the picking, and follow the natural flow in Odoo.</p> <img alt="Operations configuration Graphic" src="/picking_from_xls/static/description/stock_operation.png" style="width: 600px;" /> <a name="negative-values-in-quantity"></a> <h3>Negative values in quantity</h3> <p>This addon does not support negative values, so, if you want to use it to adjust inventory, you must create two types of internal operations, for example: 1) from WH to adjustment (to decrement stock) 2) from adjustment to WH (to increment stock)</p> <a name="dependencies"></a> <h3>Dependencies</h3> <a name="known-issues-roadmap"></a> <h2>Known issues / Roadmap</h2> <a name="credits"></a> <h2>Credits</h2> <p>Blanco Martín &amp; Asociados - Odoo Silver Partner 2018.</p> <a name="contributors"></a> <h3>Contributors</h3> <ul class="simple"> <li>BMyA Developement Task Force: &lt;<a class="reference external" href="mailto:dev&#64;blancomartin.cl">dev&#64;blancomartin.cl</a>&gt;</li> <li>Daniel Blanco &lt;<a class="reference external" href="mailto:daniel&#64;blancomartin.cl">daniel&#64;blancomartin.cl</a>&gt;</li> </ul> <a name="maintainer"></a> <h2>Maintainer</h2> <p>Blanco Martín &amp; Asociados - Odoo Silver Partner 2018.</p> <a class="reference external image-reference" href="https://blancomartin.cl"><img alt="Blanco Martin y Asociados' logo" src="https://blancomartin.cl/logo.png" /></a> <p>This module is maintained by Blanco Martín &amp; Asociados.</p> <p>To contribute to this module, please visit <a class="reference external" href="https://blancomartin.cl">https://blancomartin.cl</a>.</p> <a name="license"></a> <h3>License</h3> <p>This program is free software: you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.</p> <p>You should have received a copy of the GNU Affero General Public License along with this program. If not, see <a class="reference external" href="http://www.gnu.org/licenses/">http://www.gnu.org/licenses/</a>.</p>