• Import Lot/Serial Picking From CSV/Excel File
  • Join us and help disrupt the enterprise market!

  • Home

  • Import Lot/Serial Picking From CSV/Excel File

    Join us and help disrupt the enterprise market!

  • Home
  • About Module


    This module imports lot/serial picking from CSV/Excel files in a single click. You can transfer a lot/serial pickings from one location to other locations. When you transfer lot/serial picking, you have the option to create a lot/serial on the destination location. You can import custom fields from CSV or Excel.





    Features


    • 1) Easy to import lot/serial picking from CSV/Excel file.
    • 2) You can transfer a lot/serial pickings from one to other locations.
    • 3) Easy to import custom fields.
    • 4) This module saves your important time.

    Versions


    • v15.0
    • v14.0
    • v13.0
    • v12.0

    Installations


    1) You will receive the link to download the zip file of the module please download it.

    2) Extract the zip file, you will see a folder named ‘sh_import_lot_serial_picking’.

    3) Copy and paste this folder inside your Odoo Addons path / Custom Addons Path.

    4) Now, open the odoo as Developer Mode.

    5) Go to Apps menu and click on ‘Update Modules List’, Press Update Button.

    6) In the search bar, search ‘sh_import_lot_serial_picking’.

    7) Click on ‘Install’ to install it.

    Workflow


    Tick the group "Imports Lot/Serial Picking".

    Import Lot Picking From CSV/Excel Workflow

    Select "By Lots" in product 1.

    The product 1 on hand qty is 0(Zero) now.

    Product 1 demand qty is 10(Ten) and our done qty is 0(Zero). So we import lot/serial using the smart button that button is given besides "Done QTY".

    After pressing that button this wizard opens, press the "Import Lot/Serial" button.

    Select the import file type, choose the file type & select lot/serial type, and press the "Apply" button.

    Success message looks like below.

    After successfully imported picking our done qty is now equal to demand qty. Press the smart button that is given besides "Done QTY" to see detailed operations.

    After pressing that button this wizard opens, you can see an imported lot/serial pickings here after press the "Confirm" button.

    Now we press the "Validate" button and our stage is changed from ready to done.

    Lot/Serial Numbers list view with imported lot/serial picking.

    Now the product 1 on hand qty is changed.

    Import Serial Picking From CSV/Excel Workflow

    Select "By Unique Serial Number" in product 2 and the on-hand qty is 0(Zero) now.

    Select the import file type, choose the file type & select lot/serial type, and press the "Apply" button.

    Success message looks like below. If you choose the "Lot" in the lot/serial type and your product traceability is the Serial then it generates an alert for that and also If you choose the "Serial" in the lot/serial type and your product traceability is a Lot then it generates an alert.

    Detailed operation wizard with the imported lot/serial picking.

    Lot/Serial Numbers list view with imported lot/serial picking.

    Now the product 2 on hand qty is changed.

    Transfer Lot/Serial Picking Workflow

    Select source and destination location, our product 1 qty demand is 5(five) and done qty is 0(Zero).

    Press the "Import Lot/Serial" button to import lot/serial picking.

    Select the import file type, choose the file type & select lot/serial type, and press the "Apply" button. When you transfer lot/serial picking, you have the option to create a lot/serial on the destination location.

    After imported lot/serial pickings we validate the pickings.

    Now we go to the "Locations" menu, select location & see current stock from the "Current Stock" smart button.

    The "Current Stock" list view looks like this.

    Your CSV/Excel format looks like below.

    Your CSV/Excel format looks like below.

    Support

    You will get free support and assistance in case of any issues