Mastering Odoo Product Routes: An Ultimate Guide to Seamless Bulk Import via Excel

---

Navigating product logistics in an ERP system like Odoo can be complex, especially when dealing with a vast product catalog. Manually assigning or updating product routes for hundreds or even thousands of items is not only tedious but also prone to errors. Imagine the time lost and the potential for misrouted inventory!

Fortunately, Odoo offers powerful tools to streamline this process. This comprehensive guide will walk you through the essential steps to perform a bulk Odoo import product routes operation using a simple Excel sheet. Based on the insights from this helpful video tutorial: Odoo Product Master Import Made Easy, we’ll empower you to update your product logistics paths with unparalleled efficiency and accuracy.

Why Efficient Route Management is Crucial for Your Business

Product routes in Odoo define how products move through your supply chain—whether they are bought, manufactured, drop-shipped, or resupplied from a specific warehouse. Correctly configured routes are fundamental for:

• Optimized Inventory Flow: Ensuring products are always in the right place at the right time, minimizing stockouts and overstock.
• Streamlined Operations: Automating procurement and manufacturing processes, reducing manual intervention.
• Cost Reduction: Preventing unnecessary freight, storage, and handling costs associated with inefficient logistics.
• Enhanced Customer Satisfaction: Faster order fulfillment and more accurate delivery estimates.
• Scalability: Enabling your business to grow without being bogged down by manual data management.

For businesses with dynamic product portfolios or frequent changes in supply chain strategies, the ability to execute an Odoo import product routes in bulk is not just a convenience—it’s a strategic necessity.

The Power of Bulk Odoo Import Product Routes

Manual updates might suffice for a handful of products, but when you’re managing a large inventory or undergoing a significant operational shift (like opening a new warehouse or introducing a new drop-shipping partner), bulk operations become indispensable. The Excel import feature in Odoo transforms a daunting task into a manageable one, allowing for precise and rapid updates to your entire product master data. This method is particularly useful when you need to:

• Migrate existing product data from a legacy system.
• Apply new supply chain rules to a large category of products.
• Correct widespread route misconfigurations.
• Rapidly onboard new product lines with predefined logistics paths.

Now, let’s dive into the step-by-step process to master this powerful feature.

Pre-requisites Before You Begin

Before you start your Odoo import product routes journey, ensure you have:

• Odoo Access: Administrator or equivalent rights to perform data exports and imports, and access to Odoo Studio if needed.
• Understanding of Odoo Routes: Familiarity with the different types of product routes available in your Odoo instance (e.g., Buy, Manufacture, Drop Ship, Resupply from Warehouse).
• Basic Excel Skills: Ability to open, edit, and save .xlsx or .csv files.

Step-by-Step Guide: Mastering Odoo Import Product Routes via Excel

This process is designed to be straightforward, leveraging Odoo’s robust import functionality.

Step 1: Prepare Your Odoo Environment & Create a Sample Product

The first critical step for a successful Odoo import product routes is to create a “golden” sample product. This product will serve as your template, providing an accurate representation of all possible routes and their exact naming conventions as Odoo expects them.

1. Log in to Odoo: Access your Odoo instance.
2. Navigate to Products: Go to Inventory (or Sales/Purchase depending on your setup) > Products > Products.
3. Create a New Product: Click “Create” to add a new product. You can name it something like “SAMPLE_ROUTES_PRODUCT” or “TEMPLATE_FOR_ROUTES”.
4. Enable All Possible Routes:
   • Open the newly created sample product.
   • Go to the “Inventory” tab.
   • Under the “Routes” section, check every single route that is available in your Odoo instance. This might include “Buy,” “Manufacture,” “Drop Ship,” “Make to Order,” “Resupply from Warehouse,” etc. The goal is to ensure that when you export this product, its “Routes” field contains a comma-separated list of all active routes, which you can then copy and paste for other products.
   • Save the product.

By enabling all routes on this sample product, you guarantee that your exported file will contain the exact string format for each route, crucial for a smooth Odoo import product routes operation.

Step 2: Export Existing Product Data with Routes

Now that your sample product is ready, you need to export your existing product data. This export will serve as your working template for updating product routes in bulk.

1. Go to Product List View: Navigate back to Inventory > Products > Products.
2. Select Products to Export: You can either select specific products using the checkboxes or, if you want to update all products, simply proceed without selecting any.
3. Initiate Export: From the “Action” menu (the gear icon or the “Action” button, depending on your Odoo version), select “Export.”
4. Configure Export Fields:
   • Choose “I want to update data (import-compatible export).” This ensures Odoo exports fields in a format suitable for re-importing, particularly including the crucial External ID (often just ID).
   • In the “Fields to Export” list, you must select the ID field. This is Odoo’s unique identifier for each record and is absolutely essential for mapping updates back to the correct products.
   • Crucially, find and select the “Routes” field. If you don’t see “Routes” in the list of available fields:
     • Use Odoo Studio: Temporarily open Odoo Studio (developer mode might be required). Go to the product form view, and ensure the “Routes” field is visible on the form. Sometimes, a field might be hidden from the default view and thus not available for export until it’s made visible. Once visible, it should appear in the export list. Remember to disable Studio afterward if you don’t need it.
   • Select any other fields you might need for reference (e.g., “Product Name,” “Internal Reference”).
5. Download the File: Click “Export” to download your Excel file (e.g., .xlsx).

This exported file is your foundation for the bulk Odoo import product routes process.

Step 3: Understand and Manipulate Your Excel File

Open the downloaded Excel file. You’ll typically see columns for ID (External ID), Product Name, and Routes, along with any other fields you chose to export.

1. Locate the ‘Routes’ Column: This column contains the current routes assigned to each product. You’ll notice that multiple routes for a single product are separated by commas (e.g., “Buy, Manufacture, Resupply from Warehouse”). This comma-separated format is key.
2. Identify the ‘ID’ Column: This column is paramount. Do NOT modify the values in this column. Odoo uses these unique External IDs to match the rows in your Excel file to existing products in your database during import.
3. Update Routes for Products:
   • Reference Your Sample Product: Find the row corresponding to your “SAMPLE_ROUTES_PRODUCT” (or whatever you named it). Its “Routes” column will contain the comma-separated string of all available routes (e.g., “Buy, Manufacture, Drop Ship, Resupply from Warehouse”).
   • Copy & Paste Strategy: For each product you want to update:
     • Decide which routes it should have.
     • Copy the precise, comma-separated route string from your sample product, or manually type the exact routes you want, ensuring they are separated by commas and there are no leading/trailing spaces around the commas (e.g., Buy, Drop Ship, not Buy , Drop Ship).
     • Paste this string into the “Routes” column for the target product.
   • Examples:
     • To set a product to only “Buy” and “Resupply from Warehouse”: Buy, Resupply from Warehouse
     • To set a product to “Drop Ship”: Drop Ship
     • To remove all routes from a product: Leave the cell blank (empty string).
4. Save Your Changes: Once you’ve updated all the necessary product routes, save the Excel file.

Accuracy in this step is crucial for a successful Odoo import product routes operation. Double-check your route strings!

Step 4: Perform the Odoo Import Product Routes

With your updated Excel file ready, it’s time to import it back into Odoo.

1. Return to Odoo Product List View: Go back to Inventory > Products > Products.
2. Initiate Import: Click the “Import Records” button (often located next to the “Create” button or within the “Favorites” menu).
3. Upload Your File: Click “Upload File” and select your modified Excel file. Odoo will automatically try to detect the columns and map them.
4. Review Field Mapping:
   • Odoo should automatically map your ID column to “External ID” and your “Routes” column to “Routes”.
   • Verify these mappings are correct. If Odoo misidentifies a column, manually select the correct Odoo field from the dropdown menu for that column.
   • Make sure “External ID” is correctly mapped to your ID column. This is paramount for updating existing records rather than creating new ones.
5. Test the Import: Always click “Test” first! This crucial step simulates the import process and identifies any errors (e.g., incorrect route names, formatting issues, missing IDs) without actually committing the changes to your database.
   • If “Test” shows “Everything seems correct,” you’re good to go.
   • If there are errors, Odoo will highlight them and provide details. Go back to your Excel file, correct the issues, save, and re-upload.
6. Execute the Import: Once the test is successful, click “Import.” Odoo will now process your file and update the product routes.

Congratulations! You’ve just performed a bulk Odoo import product routes operation.

Step 5: Verify Your Import

After the import is complete, it’s vital to verify that the changes have been applied correctly.

1. Check Specific Products: Open a few of the products you updated in Odoo. Navigate to their “Inventory” tab and confirm that the routes are now set as you intended.
2. Use Odoo Filters:
   • You can use Odoo’s search bar and filters to quickly check products with specific routes. For example, search for products with “Drop Ship” route.
   • Create custom filters to group products by their new route configurations and ensure the correct products are appearing in those groups.
3. Cross-Reference with Excel: Compare the routes of a sample of updated products in Odoo with your Excel file to confirm accuracy.

This verification step ensures the integrity of your product master data and confirms the success of your Odoo import product routes initiative.

Common Pitfalls and How to Avoid Them

While the process of Odoo import product routes is powerful, a few common mistakes can lead to errors.

• Incorrect Route Format:
  • Pitfall: Routes are not separated by commas, or there are extra spaces (e.g., “Buy ,Manufacture” instead of “Buy,Manufacture”).
  • Solution: Always use the comma-separated format derived from your sample product. Trim extra spaces.
• Missing External IDs:
  • Pitfall: The ID column is missing or incorrect, leading Odoo to create new products instead of updating existing ones, or failing the import entirely.
  • Solution: Always perform an “import-compatible export” to get the correct ID‘s. Do not change these IDs in your Excel file.
• Invisible Fields:
  • Pitfall: The “Routes” field isn’t visible in the export options.
  • Solution: Use Odoo Studio to make the field visible on the product form view temporarily.
• Not Testing Before Full Import:
  • Pitfall: Importing a large file without testing, leading to widespread data corruption.
  • Solution: Always use the “Test” button before committing the full import. It’s your best friend!

Advanced Tips for Odoo Import Product Routes

Take your route management to the next level with these expert tips:

• Leverage Odoo Studio for Custom Routes: If your business has unique logistics paths not covered by standard Odoo routes, you can define custom routes within Odoo’s Inventory Configuration. Once created, they will behave like standard routes and can be included in your export/import process.
• Data Cleaning Best Practices: Before a major Odoo import product routes operation, consider reviewing your existing product data for inconsistencies. Clean data ensures a smoother import and more reliable operations down the line.
• Integrate with Other Product Data Imports: Product routes are often part of a larger product master data import. If you’re importing new products or updating other product details (like sales prices or inventory levels), you can include the “Routes” column in that same import file, provided all fields are correctly mapped. This reduces the number of separate import operations.
• Backup Your Database (if possible): For very large or critical imports, if you have the capability, performing a database backup before the import can provide an extra layer of security in case something goes wrong.

Conclusion

Mastering the bulk Odoo import product routes via Excel is a powerful skill that can significantly enhance your Odoo experience and streamline your supply chain operations. By following this step-by-step guide, you can efficiently update product logistics paths, optimize inventory flow, and free up valuable time for more strategic tasks.

Embrace the efficiency that Odoo’s import functionalities offer. Whether you’re a seasoned Odoo user or just starting, this trick will undoubtedly ease your product master data management journey. For more insights and tips on optimizing your Odoo setup, explore our other articles, such as Streamlining Your Odoo Inventory Management or Optimizing Odoo Manufacturing Orders.

Do you have questions or encountered a specific challenge with Odoo import product routes? Share your thoughts and experiences in the comments below!