CSV Editing Tips

Editing CSV files is a powerful way to manage data in bulk within Xada. Whether you are working with products, options, additions, or suppliers, following best practices will help you avoid errors and ensure successful imports.

General Best Practices

Work on a Copy

Always keep a backup of your original export before making changes.

  • Prevents accidental data loss
  • Allows you to revert if something goes wrong

Keep the File Format Correct

  • Save files as .csv (UTF-8)
  • Avoid converting to other formats (e.g. .xlsx ) when uploading
  • Ensure delimiters (commas) are preserved

Do Not Remove Required Columns

Even if you are not editing certain fields:

  • Keep all required columns in place
  • Xada uses headers to map data correctly

Removing columns can result in:

  • Failed imports
  • Incorrect data mapping

Understanding IDs (Critical)

Always Retain ID Columns

Fields such as:

  • Product ID
  • Xada ID (for options/additions)

must not be modified or deleted when updating existing records.

Why this matters:

  • IDs tell Xada which records to update
  • Removing them will create new records instead of updating existing ones

When to Leave IDs Blank

  • Leave IDs blank only when creating new records
  • Xada will generate IDs automatically

Clean and Validate Your Data

Watch for Hidden Characters

  • Remove trailing spaces
  • Avoid line breaks within cells
  • Clean special characters where possible

These can cause:

  • Matching issues (e.g. SKUs not recognised)
  • Import errors

Use Consistent Naming

  • Standardise naming across rows
  • Avoid duplicates with slight variations

Example:

  • “Pad Print” vs “Pad Printing” → choose one

Consistency improves:

  • Storefront clarity
  • Rule accuracy
  • Long-term maintainability

Use Find and Replace

Leverage tools in Excel or Google Sheets:

  • Bulk rename values
  • Standardise labels
  • Clean inconsistent data

This is especially useful for options and additions.

Be Careful with Pricing Fields

  • Treat supplier pricing as original data
  • Avoid manually editing pricing unless necessary

Best practice:

  • Use rules to manage pricing and markups

This ensures:

  • Consistency across products
  • Easier updates in the future

Work with Smaller Data Sets

When possible:

  • Filter your export before editing
  • Focus only on relevant products

This helps:

  • Reduce errors
  • Improve performance
  • Make validation easier

Test Before Full Imports

Before uploading large changes:

  • Test with a small dataset
  • Confirm results in Xada
  • Then proceed with full import

Review Import Results

After uploading:

  • Check import status (Completed / Failed)
  • Review details via the View button
  • Validate changes in Xada

Do not assume all changes were applied successfully.

Avoid Overusing CSV for Ongoing Management

CSV editing is powerful but should not be your primary tool for continuous updates.

Use CSV for:

  • Initial setup
  • Data cleanup
  • One-off bulk updates

Use Rules for:

  • Automation
  • Ongoing logic (pricing, activation, categorisation)

Summary

Following these CSV editing tips will help you:

  • Avoid import errors
  • Maintain clean and consistent data
  • Ensure updates apply correctly
  • Reduce manual rework

A disciplined approach to CSV editing, combined with rule-based automation, will keep your Xada catalogue accurate, scalable, and easy to manage.