Testing Your Connection

Before importing products, it's important to verify your Odoo connection is working correctly.

Test Connection Button

The Test Connection button performs several checks:

1. Network Connectivity: Can we reach your Odoo server?
2. Authentication: Are your credentials correct?
3. API Access: Can we make API calls?
4. Version Detection: Is your Odoo version supported?
5. Language Detection: What languages are available in your Odoo instance?

Running the Test

1. Navigate to Settings → Odoo Configuration
2. Click "Test Connection"
3. Wait for the test to complete (5-15 seconds)

Understanding Test Results

Success ✓

A successful test will show:

• Status: "Connection successful"
• Icon: Green checkmark
• Details:
  • Odoo version detected
  • Available languages listed
  • Last test date/time

Failure ✗

A failed test will show:

• Status: "Connection failed"
• Icon: Red X
• Error Message: Specific reason for failure

Common Connection Errors

"Authentication failed"

Cause: Incorrect username or password

Solution:

• Double-check your username (usually your email)
• Verify your password
• For API keys, ensure the key is correct and hasn't been revoked
• Check that the user has administrator access

"Cannot reach server"

Cause: Network connectivity issue

Solution:

• Verify the URL is correct
• Check that your Odoo instance is online (open it in a browser)
• For self-hosted: ensure your server is accessible from the internet
• Check firewall settings

"Database not found"

Cause: Incorrect database name

Solution:

• Verify the database name spelling
• For Odoo Online: usually matches your subdomain
• For self-hosted: check with your system administrator

"SSL Certificate Error"

Cause: Invalid or self-signed SSL certificate

Solution:

• Install a valid SSL certificate (Let's Encrypt is free)
• Self-signed certificates are not supported for security reasons

"API Rate Limit Exceeded"

Cause: Too many API calls in a short time

Solution:

• Wait a few minutes and try again
• For Odoo Online: check your plan's API limits
• For self-hosted: review Odoo rate limit configuration

"Odoo Version Not Supported"

Cause: Using an unsupported Odoo version

Solution:

• Verify you're using Odoo 17.0 or 18.0
• Contact support if you need support for a different version

Advanced Testing

Manual API Test

For self-hosted installations, you can manually test the API:

curl -X POST https://your-odoo-url/jsonrpc \
  -H "Content-Type: application/json" \
  -d '{
    "jsonrpc": "2.0",
    "method": "call",
    "params": {
      "service": "common",
      "method": "version"
    },
    "id": 1
  }'

Expected response:

{
  "jsonrpc": "2.0",
  "id": 1,
  "result": {
    "server_version": "18.0",
    "server_version_info": [18, 0, 0, "final", 0],
    "protocol_version": 1
  }
}

Check Odoo Logs

For self-hosted installations, check Odoo server logs:

tail -f /var/log/odoo/odoo-server.log

Look for authentication attempts and API calls from Pricelist Heaven.

Connection Health Monitoring

Pricelist Heaven automatically monitors your connection health:

• Last Successful Test: Shown in Settings
• Last Test Date: When the connection was last verified
• Connection Status: Active, Warning, or Failed

We recommend testing your connection:

• After initial setup
• After changing credentials
• When experiencing sync issues
• Monthly as a routine check

What Happens After Testing?

Once your connection test succeeds:

1. Available Languages: Detected languages are saved
2. Connection Status: Marked as "Active"
3. Ready to Sync: You can now sync Odoo references
4. Import Enabled: Product import and export are enabled

Next Step: Sync Odoo References

After a successful connection test, you should:

Sync Odoo References to import:

• Product categories
• Units of measure
• Tax codes
• Sales routes
• E-commerce categories

This ensures your pricelists can use the correct Odoo references.

Getting Help

Still experiencing connection issues?

1. Check our Troubleshooting Connection Issues guide
2. Contact support@pricelistheaven.com with:
   • Error message
   • Screenshot of test result
   • Odoo version
   • Installation type (Online or self-hosted)