Managing Suppliers

1. Gather supplier information: Collect names, phone numbers, and addresses from existing records
2. Prioritize active suppliers: Enter currently active vendors first
3. Use consistent naming: Decide on a naming convention (e.g., always include legal entity suffix)
4. Verify contact info: Confirm phone numbers and addresses are current before entering
5. Test in receptions: Create a test merchandise reception to ensure suppliers appear correctly

1. Click Editar on the supplier’s row
2. Update the Teléfono and/or Dirección fields
3. Click Actualizar Cambios
4. Verify the changes appear in the table

1. Edit the supplier
2. Change Nombre / Empresa to the new name
3. Add a note in Dirección about the name change: Formerly known as [Old Name] - Changed March 2026

1. Create a new supplier with the new name
2. Edit the old supplier to add [INACTIVE - REBRANDED] prefix
3. Add a reference in the address field: Now operating as [New Name]

1. Create the supplier with the information you do have
2. Use placeholder text in missing fields:
   • Teléfono: Leave blank or enter 0000000000
   • Dirección: Enter Información pendiente or TBD
3. Update the record later when you obtain complete information

1. Identify the duplicates: Look for similar names in the table
2. Choose the primary record: Select which record to keep (usually the one with more complete info)
3. Update reception records: This requires database access
   -- Update all receptions from duplicate to primary
   UPDATE registro 
   SET id_proveedor = [primary_id] 
   WHERE id_proveedor = [duplicate_id];
   
4. Delete the duplicate: Once no receptions reference it, you can delete it

“No se puede eliminar este proveedor porque tiene registros de mercancía asociados.”

1. Mark as inactive: Edit the name to [INACTIVE] Supplier Name
2. Keep the record: Retain for historical reference
3. Database-level deletion (advanced):
   -- Check which receptions reference this supplier
   SELECT * FROM registro WHERE id_proveedor = X;
   
   -- Option A: Reassign receptions to another supplier
   UPDATE registro SET id_proveedor = Y WHERE id_proveedor = X;
   
   -- Option B: Delete reception records (loses history!)
   DELETE FROM registro WHERE id_proveedor = X;
   
   -- Then delete supplier
   DELETE FROM proveedor WHERE id_proveedor = X;
   

• For international numbers, use the address field
• For extensions, add to address: Tel: 5551234567 Ext. 123
• Contact your developer to increase the field length if needed

• Pad with zeros: 555123 → 0000555123
• Or leave the field blank and put the number in the address field

1. Verify creation: Check that the supplier appears in the Proveedores table
2. Refresh the reception page: Dropdowns are populated on page load
3. Check database: Query the proveedor table to confirm the record exists
4. Clear browser cache: Try a hard refresh (Ctrl+F5 or Cmd+Shift+R)
5. Check for JavaScript errors: Open browser console (F12) and look for errors

1. Open browser console (F12)
2. Look for JavaScript errors when clicking Editar
3. Check if the supplier name or address contains special characters:
   • Quotes (" or ')
   • Backslashes (\)
   • Line breaks

• Edit the supplier by recreating it with a simpler name
• Contact your developer to improve character escaping

1. Database connection failure: Check that the database server is running
2. Character encoding issues: Ensure special characters (á, é, í, ó, ú, ñ) are handled correctly
3. Field validation: Verify nombre is not empty (it’s required)
4. Constraint violations: Check for unique constraint violations if applicable

1. Try creating a supplier with simple ASCII characters: “Test Supplier”
2. If that works, the issue is with special characters
3. Check PHP error logs for detailed error messages
4. Contact your system administrator with the error message