Hi to all,
I have signed up for odoo and the latest version and have all the modules I need. What I can't seem to do is find an easy way of uploading my existing spreadsheet with all my products, prices, quantities etc.
I am sure there must be a simple way of starting from scratch with my existing information which I can then update as I make sales etc.
I have looked in the various sections of the warehouse module but can't find where to export and then import a file which lets me set my product's existing IDs, prices, quantities etc.
Would really appreciate any help.
In case you already have a file (excel for instance) with all your products, then start importing the products from your file.
this will populate your odoo database with the products and give them an id.
To do this, save your file with a csv format (UTF_8, separator= comma); then in odoo Product menu select import (in list view)
do not forget to click on Validate, this will help you check for errors.
Then you will be able to add new informations for your products (supplier, price, categories, taxes...)
First of all you need to select product " List view " (when you select list view you will see import button ). From there you can import all the products using a " product csv file "
After that you can use Inventory Adjustments for updating your initial stock, here is how you can do this:-
Create all the products for which you want to keep the stock (as stockable products). Once the required products in stock have been defined, use an initial inventory operation to put the current quantities into the system by location. Go to the menu Warehouse > Inventory Control > Inventory Adjustments to enter your initial inventory.
Give it a name (for example Initial Inventory) and select the stock location for your inventory. Note that when you select a parent location (such as Stock, which might be split into sublocations), you can also select the sub (or child) locations. You can choose between making an initial inventory for All products in that location, or for one product only. In this case, we choose the All products option. If you need your stock valuation to be done in a different period than the one that will be selected by default according to the inventory end date, enter the corresponding accounting period in the Force Valuation Period field.
In case of the initial inventory that is drawn up when you start in Odoo, no stock is available yet. Click the Start Inventory button and add each product by clicking the Add an item link. Select the corresponding stock location if it differs from the default one. Add the Real Quantity that you have in your stock for each product.
Click the Validate Inventory button to confirm the initial inventory and post it.
On the Inventory Adjustments tab, notice that the Source Location is automatically set to the virtual Inventory Loss location. Odoo always needs a source location and a destination location.
Refer this link : Initial Inventory
Hope this helps...
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/3/15, 3:13 AM|
|Seen: 786 times|
|Last updated: 4/4/15, 1:31 PM|