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,

either,

- We can do manually by adding products and their qty
- for each product and its qty create stock moves either manually or import CSV
- or any complex way

The easiest way to do this, is import inventory adjustment through Odoo import functionality.

Here are some steps to do in smart way

- First create test inventory adjustment,
- add few products and then export that inventory adjustment(just for export template purpose).
- Just cancel/delete that inventory adjustment.

Now, in exported csv you can add your products(database ids) and qty.

That's it ,

After adding your inventory products in CSV, you can import that CSV in Odoo.

Note : At the time of validate CSV if you got any error related to products, then just select product database Id from list.

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

Video : https://youtu.be/K1UrDPjpJr4

..Thanks..

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)

New in V10

New in V10

As you all know Odoo v10 released on 3rd October, 2016.

The following are the highlights of new features added in Odoo v10.

• Event :
• Event Barcode
• Email Schedule : Easy to Followup
• Account :
• Tax Cloud
• Accounting Reports with Analytic Account
• Multi-level hierarchy in trial balance [ https://drive.google.com/file/d/0B21cUNlAdZ6gM0w1dmVIUVNEWG8/view?usp=drivesdk ]
• New CSV, CAMT bank statement import (different Modules for csv import)
• HR :
• HR Attendance (Kiosk Mode)
• Print Employee Badge
• Sign In/Out authenticate using Pin
• Timesheet Apps : usability Improvement

• POS :
• POS Serial Number
• POS Default Cash Control
• POS Restaurant : Transfer order from one table to another

• Stock:
• Option in Payment Gateway to auto confirm SO
• Out of stock warning in option
• Delivery : choose the package when clicking on put in pack
• Inventory : Can apply Quality control on picking
• Serial Number Upstream Tracebility
• Delivery Order : Add margin in % to cover lost
• Picking : Up/Down Tracebility

• Website/ Ecommerce:
• B2B/B2C
• New checkout design for address selection
• Ecommerce : Add multiple images of products
• Improved Portal Frotend view
• Easy to set website Favicon
• Ecommerce insight: Save, manage, and reuse credit cards. Authorize amount at checkout and capture at shipping.
• Ecommerce user can pay through stored card
• Easy to trace Website Orders, Invoices

• Expense :
• Accountant can direct pay the Expense
• Email Alias to direct record Expense (based on expense internal reference, system identify product and create expense accordingly)

• General / Discuss :
• history of chatter clickable (source document)
• The debug mode does not split the web assets by default
• Keyboard shortcuts detailed on the top right menu from the home page
• Easy to maintain user access (set default access to default user)
• Search date ranges quickly with the new in-between operator.
• Canned responses and /commands in discuss
• Create in one click
• Company setting of apps moved to Apps > Setting
• Any HTML type report easily edit in app view => https://drive.google.com/file/d/0B21cUNlAdZ6gWHl5NUE4b0lqc0k/view?usp=drivesdk
• Studio
• Easy to Create new Apps
• Easy to add new field in either form view or tree view
• Channge string, help message, views, reports,....

• Purchase :
• Editable PO: Easy to edit confirmed PO
• Purchase Teander : Blanket order Type

• Project:
• Project : project dashboard is now based on user's favorite
• Project : Easy to maintain Sub-Task
• Forecast : Grid : By User, By Project

• Subscription:
• Subscription dashboard by company, Tag, Contract
• Subscription : New Cohort Analysis

• Helpdesk Management
• Easy to assign tickets by different Assignation Method
• Randomly
• Manually
• Balanced
• Generate Tickets
• Email Alias
• Live Chat
• Ticket Form
• External API
• Performance
• SLA Pollicies
• Rating
• Canned Response
• Self-Service
• Forum- Help Center
• Slides- eLearning

• MRP
• PLM
• MPS
• Maintenance
• Quality
• Easy to know "Overall Equipement Effectivness"
• Unbuild Order , Scrap Products

Enjoy Odoo v10

Demo : odoo.com

Trial : odoo.com

..Enjoy..

Odoo Barcode Print

Barcode not getting printed on reports..

May have library issue follow the  following step :

Download and extract  : http://www.reportlab.com/ftp/pfbfer.zip

Create a folder named “fonts” under : (from command line)

/usr/lib/python2.7/dist-packages/reportlab/

$ cd /usr/lib/python2.7/dist-packages/reportlab/

$ sudo mkdir fonts

Move all the *.pfb files and paste into this folder (fonts) (from command line)

Go to extracted folder : $ sudo mv *.pfb /usr/lib/python2.7/dist-packages/reportlab/fonts

..Enjoy..

Odoo Barcode Interface

Odoo Barcode Interface :

..Enjoy..

Activate Debug Mode in One Click

Activate Debug Mode in just One Click!!

If you are working with Odoo instance you need to activate debug mode frequently.

Here Chrome Extension .CRX file just drag and drop in your extension list and you able to activate debug mode in One click.
(Go to Setting > Extension and simply drag and drop attached .crx file)

Click here to Download :

Debug Mode


Specially Thanks to Hitesh Trivedi. ( Blog )

Note : Limited Feature to only Odoo site.

..Enjoy..

Delivery methods configuration Odoo

Delivery Methods in Odoo

While working with different delivery methods in Odoo, If you get any issue first check following configuration.

Check Points

• Check your delivery method credential
• Check your packaging methods
• Check your Delivery Service Type
• Published on Website or not
• Production/Test Env
• Your warehouse company address (with all proper detail including phone number)
• Check product weight
• Customer Address (Shipping Address)
• Address State code are valid or not.

After checking all and if you still don't get any Delivery methods on checkout page the simple way to checking is go to backend and create Quotation with same product and customer address and check the error.

After all cases if you face still any error then simply google delivery method name + test site and enter same detail in test site if its not succeed then contact to your delivery provider for further assistance.

Hope it helps. :)

Youtube Channel : http://www.youtube.com/c/PinakinNayi

..Enjoy..