# DB03002: Invalid Data Type

## What This Means[​](#what-this-means "Direct link to What This Means")

The data type doesn't match what the database expects. For example, text was provided where a number was expected.

## Common Causes[​](#common-causes "Direct link to Common Causes")

* **User input error** — Entering text in a numeric field
* **Import issues** — Imported data has wrong format
* **Data corruption** — Values corrupted during transfer
* **Plugin conflict** — Another plugin modified data types

## How to Fix[​](#how-to-fix "Direct link to How to Fix")

### 1. Check Your Input[​](#1-check-your-input "Direct link to 1. Check Your Input")

Review the data you're entering:

* **Prices** — Should be numbers (e.g., `19.99`)
* **Quantities** — Should be whole numbers (e.g., `5`)
* **IDs** — Should be numeric

### 2. Clear and Re-enter[​](#2-clear-and-re-enter "Direct link to 2. Clear and Re-enter")

If data was corrupted:

* Clear the field
* Enter the value again manually
* Avoid copy-pasting from external sources

### 3. Check Source Data[​](#3-check-source-data "Direct link to 3. Check Source Data")

If syncing from WooCommerce:

* Check the data in WordPress Admin
* Look for incorrectly formatted fields
* Fix data at the source

### 4. Re-sync Data[​](#4-re-sync-data "Direct link to 4. Re-sync Data")

Get fresh data from the server:

* Clear local cache
* Sync data again
* Check if the issue resolves

### 5. Check for Plugin Conflicts[​](#5-check-for-plugin-conflicts "Direct link to 5. Check for Plugin Conflicts")

If using other WooCommerce plugins:

* They may modify data in unexpected ways
* Temporarily disable to test
* Report incompatibilities

## Common Examples[​](#common-examples "Direct link to Common Examples")

| Field      | Expected | Invalid           |
| ---------- | -------- | ----------------- |
| Price      | `19.99`  | `$19.99`          |
| Quantity   | `5`      | `five`            |
| SKU        | `ABC123` | — (any format OK) |
| Product ID | `42`     | `product-42`      |

## Related Errors[​](#related-errors "Direct link to Related Errors")

* [DB03003](/error-codes/DB03003.md) — Missing Required Field
* [API03003](/error-codes/API03003.md) — Invalid Parameter Value