Tuesday, 27 June 2017

How to import products with their initial inventory ?

In some cases we need to import products with their inventory. 

There are several ways to do this,

- We can do manually add products and their
- for each product qty we can create stock moves either manually or import CSV to record stock moves
- or anything else

The easiest way to do is import inventory adjustment.

for the simple way first create inventory adjustment add few products and then export that inventory adjustment(just for export template).

Now you can delete that inventory adjustment. And in exported csv you can add your products and qty.

That's it ,

now you can import that csv and you can find your all products are in inventory adjustment with qty.

You can validate that inventory to post stock moves.

Here attached sample csv which you can import easily, => Click Here

Video : https://youtu.be/K1UrDPjpJr4


Use of different location type in Odoo

Vendor Location: Virtual location representing the source location for products coming from your vendors

- This is the locaction you can set on your vendor, may this will be generic or supplier specific.
- This location will be considered when you are purchase something, in your incoming recipt "Source Location Zone".

View: Virtual location used to create a hierarchical structures for your warehouse, aggregating its child locations ; can't directly contain products

Internal Location: Physical locations inside your own warehouses,

- They can be the loading and unloading area of your warehouse, a shelf or a department, etc.

Customer Location: Virtual location representing the destination location for products sent to your customers

Inventory Loss: Virtual location serving as counterpart for inventory operations used to correct stock levels (Physical inventories)

Procurement: Virtual location serving as temporary counterpart for procurement operations when the source (vendor or production) is not known yet. This location should be empty when the procurement scheduler has finished running.

Production: Virtual counterpart location for production operations: this location consumes the raw material and produces finished products

Transit Location: Counterpart location that should be used in inter-companies or inter-warehouses operations

The Virtual Locations are places that do not exist, but in which products can be placed when they are not physically in an inventory yet (or anymore). They come in handy when you want to place lost products out of your stock (in the Inventory loss), or when you want to take into account products that are on their way to your warehouse (Procurements).
(source from : odoo)