TL;DR — Quick Summary
Fix errors when importing or updating price lists in CONTPAQi Comercial: incorrect file format, duplicate keys, and bulk price update issues resolved step by step.
Error Importing or Updating Price Lists in CONTPAQi Comercial
Managing price lists is one of the most frequent operations for businesses with multiple clients, geographic zones, or distribution channels. CONTPAQi Comercial supports up to 20 lists, but bulk imports via external files often produce errors when the format isn’t precise.
Prerequisites
- CONTPAQi Comercial with administrator access.
- Product catalog previously set up.
- CSV file with the correct import layout.
Import File Format
| Column | Field | Example | Required |
|---|---|---|---|
| A | Product Key | PROD001 | ✅ Yes |
| B | List Number | 1 (1 to 20) | ✅ Yes |
| C | Unit Price | 549.99 | ✅ Yes |
| D | Currency (optional) | 1 (Peso) / 2 (Dollar) | ❌ No |
Important: The file must NOT have headers. The first row must be data.
Common Errors and Solutions
1. “File Structure Error”
The CSV layout doesn’t match the SDK’s expectations.
Solution:
- Verify the separator is a comma (
,), not a semicolon (;). Excel on computers with Mexican regional settings uses;by default. - Open the file with Notepad to confirm the actual separator.
- If using Excel, save as CSV (comma delimited), not CSV UTF-8.
2. “Product Key Not Found”
The keys in the file don’t match the CONTPAQi catalog.
Solution:
- Export the product catalog first from CONTPAQi: Catalogs > Products > Export.
- Compare your file’s keys with the exported catalog.
- Keys are case-sensitive:
PROD001≠prod001in CONTPAQi. - Remove leading or trailing whitespace from keys.
3. “List Number Out of Range”
The price list number is 0, negative, or greater than 20.
Solution:
- Use values from 1 to 20 exclusively.
- Check for rows with an empty list field (interpreted as 0).
- If you need more than 20 lists, consider complementary commercial schemes.
4. Prices Import as $0.00
The file’s numeric format isn’t compatible.
Solution:
- Use period (
.) as decimal separator:549.99, not549,99. - Don’t include currency signs (
$), thousands separators, or spaces in the price field. - Verify the column isn’t formatted as text in Excel (change to Number).
Quick Diagnostic Table
| Error | Probable Cause | Solution |
|---|---|---|
| ”Incorrect file structure” | Wrong separator (; instead of ,) | Save as comma-delimited CSV |
| ”Key not found” | Non-existent key or whitespace | Validate against exported catalog |
| ”List out of range” | List number > 20 or empty | Use values 1-20 |
| Prices at $0.00 | Decimal format with comma | Use period decimal: 549.99 |
| ”Access denied” | No administrator permissions | Run as system administrator |
| Partial import without errors | Interleaved empty rows | Remove empty rows from file |
Prevention
| Action | Benefit |
|---|---|
| Create a standard CSV template | Avoid recurring format errors |
| Back up lists before importing | Ability to revert unwanted changes |
| Use export as base file | Guarantee key compatibility |
| Document each list’s number | Avoid overwriting active lists |