Connecting to Odoo Online
This guide covers connecting Pricelist Heaven to Odoo Online (SaaS) instances.
Prerequisites
- Odoo Online subscription (trial or paid)
- Administrator access to your Odoo instance
- Your database name (see Finding Your Database ID)
Step 1: Navigate to Settings
- Log in to Pricelist Heaven
- Go to Dashboard → Settings
- Select the Odoo Configuration tab
Step 2: Enter Connection Details
Fill in the following fields:
Odoo URL
Enter your full Odoo URL:
https://yourcompany.odoo.com
Tip: Don't include /web or any parameters, just the base URL.
Database Name
Enter your database name (usually the same as your subdomain):
yourcompany
Odoo Version
Select your Odoo version from the dropdown:
- Odoo 17.0
- Odoo 18.0
Not sure which version? Log in to Odoo, go to Settings → About, and check the version number.
Username
Enter your Odoo login email:
admin@yourcompany.com
Password
Enter your Odoo password.
Security Note: Your password is encrypted before storage. We recommend using a dedicated API user instead of your personal admin account.
Step 3: Test the Connection
- Click "Test Connection"
- Wait for the test to complete (usually 5-10 seconds)
- Check the result
Success ✓
If the connection succeeds, you'll see:
- Green checkmark icon
- Message: "Connection successful"
- Available languages detected from your Odoo instance
Failure ✗
If the connection fails, you'll see an error message. Common errors:
"Authentication failed"
- Check your username and password
- Ensure the account has administrator access
"Database not found"
- Verify the database name is correct
- Check that the URL is correct
"Network error"
- Check your internet connection
- Verify the Odoo URL is accessible from your browser
Step 4: Save Configuration
Once the test succeeds:
- Click "Save Configuration"
- Confirmation message will appear
- Your connection is now ready to use
Step 5: Sync Odoo References
Before importing products, sync your Odoo reference data:
- Go to Dashboard → Odoo
- Click "Sync References"
- Wait for sync to complete
This imports:
- Product categories
- Units of measure
- Tax codes
- Sales routes (if applicable)
- E-commerce categories (if Website app is installed)
Next Steps
Your Odoo connection is now configured! You can:
Troubleshooting
Issue: Two-Factor Authentication (2FA)
If your Odoo account has 2FA enabled, you need to use an API key instead of password:
- Log in to Odoo
- Go to your user profile (top-right corner)
- Select "Preferences"
- Scroll to "API Keys"
- Generate a new API key
- Use this API key as the password in Pricelist Heaven
Issue: Limited API Access
Some Odoo Online plans have API rate limits. If you experience frequent timeouts, contact Odoo support to check your API quota.
Issue: Permission Errors During Sync
Ensure your Odoo user has:
- Access to Products app
- Access to Sales app
- Permission to create/edit products
- Permission to create/edit supplier information