Reading list Switch to dark mode

    Odoo Advance Stock Inventory Import

    Updated 22 May 2020

    INTRODUCTION

    Inventory or stock is the products owned by a company for the eventual purpose of resale. Inventory management is a systematic approach to the procurement, storage and sale of inventories both raw material and finished goods.

    The main concept of inventory is to manage the right stock, at the right size, in the right position, at the right time at the right cost as well as the right place. Moreover, Inventory management helps you to integrate your entire business and; provide automation to the manual tasks. It takes a lot of time and efforts to update the quantity of the products in inventory. Odoo advance stock inventory import makes it simple for you with just a few steps. This feature of Odoo allows you to update the inventory of multiple products through single CSV/XLS file.

    Odoo advance stock inventory import allows you to just put simple headers in the file, with concerned information under the headers; and the system will automatically update the inventory of the mentioned products when the file is validated in the Odoo. The new quantity of a modified product is the sum of the old quantity in hand and the quantity of the product mentioned in the file.

    Noteworthy Points

    Please use same header title in the CSV/XLS file as given below to export the respective field.

    Importing Products

    • Product_external_id: For Product External ID
    • Product_id: For Product ID
    • product_code: For Product Internal Reference
    • product_barcode: For Product Barcode

    Importing Warehouse Location

    • location_external_id : For Location External ID
    • location_id: For Location ID
    • location_name: For Location Name

    Importing Lot Numbers

    • lot_external_id : For Lot/Serial Number External ID
    • lot_id: For Lot/Serial Number ID
    • lot_name: For Lot/Serial Number Name

    Importing Quantities

    • quantity: For Quantity

    FEATURES

    1. The module Facilitates updating the product stock through a CSV/XLS file.
    2. The Odoo user needs to enter the header titles below in the file and the information is added to the Odoo when the file is upload in Odoo.
    3. The Odoo admin just needs to import the new quantities of the products through a relevant CSV/XLS file.
    4. The quantity of each product noted in the CSV/XLS file is added to the present quantity in hand for the respective product in the Odoo. Thus, the new stock becomes the total of the two numbers.

    INSTALLATION

    1. Once you purchase the App from Webkul store, you will receive the link to download the zip file of the module.
    2. Extract the file on your system after the download finishes. You will be able to see a folder named- ‘advance_inventory_import’.
    3. Copy and paste this folder inside your Odoo Add-Ons path.
    4. Now, open the Odoo App and click on the Settings menu. Here, click on Activate the Developer Mode.
    5. Then, open on Apps menu and click on ‘Update Modules List’.
    6. In the search bar, remove all the filters and search ‘advance_inventory_import’.
    7. You will be able to see the module in the search result. Click on ‘Install’ to install it.

    WORKFLOW

    1. Firstly login to the odoo database and go to the inventory module.
    inventory module
    1. Go to the master data tab and then select inventory import.
    inventory import
    1. Fill all the necessary details and then upload CSV/XLS file to import inventory.
    upload CSV/XLS file
    1. Click on the import button to import the inventory.
    import the inventory
    1. Click on the continue inventory tab and then validate the inventory.
    validate inventory
    validate inventory import
    1. Inventory is sucessfully validated.
    Successfully validated inventory in Odoo Advance Stock Inventory Import
    1. Go to the operations tab and click on the inventory adjustments.
    inventory adjustments
    1. Check the inventory adjustments.
    check validated inventory in Odoo Advance Stock Inventory Import

    NEED HELP?

    Hope you find the guide helpful! Please feel free to share your feedback in the comments below.

    Searching for an experienced
    Odoo Company ?
    Find out More

    However, if you still have any issues/queries regarding the module then please raise a ticket at https://webkul.uvdesk.com/en/customer/create-ticket/

    For any doubt contact us at [email protected]

    Thanks for paying attention!!

    Current Product Version - 1.0.0

    Supported Framework Version - Odoo V13, V12

    . . .

    Leave a Comment

    Your email address will not be published. Required fields are marked*


    Be the first to comment.

    Back to Top

    Message Sent!

    If you have more details or questions, you can reply to the received confirmation email.

    Back to Home