Data mapping is the process of aligning and connecting data fields from one system or template to another. When uploading your own file or using a custom template, mapping your columns to those recognised by WebManager ensures a smooth, accurate import—saving time and reducing errors.
✏️ Edit Data Mappings
Follow these steps to create or modify data mappings in WebManager:
Step 1
Go to Manage Data.
Step 2
Select Data Mappings.
Step 3
Click the pencil icon ✎ next to the mapping you want to edit.
Step 4
Compare your template headers to the corresponding RepZio Columns, and make any needed updates.
🔹 Note: While the system refers to them as “RepZio Columns,” the mappings apply across all connected platforms—RepZio, B2B Direct, and ShopZio.
Step 5
Click Save Mapping.
Step 6
Proceed to upload your file.
💡 Tip: Keeping your data mappings current helps prevent import issues and field mismatches.
🗑️ Delete Data Mappings
Removing outdated or unused mappings can help reduce confusion and ensure accuracy during future imports.
Step 1
Navigate to Manage Data.
Step 2
Click on Data Mappings.
Step 3
Click the trash can icon 🗑️ next to the mapping you want to delete, then confirm by clicking Delete.
✅ Best Practices for Data Mapping
Keep these best practices in mind to ensure successful data imports:
🔹 Use clear and consistent column headers
Descriptive, standardized column names make it easier to match them to the correct RepZio fields.
🔹 Double-check required fields
Verify that all required fields—such as ItemID, Product Name, and Price—are present and correctly mapped. Missing or misaligned fields can cause import errors.
🔹 Avoid duplicate mappings
Each column should only be mapped once. Duplicates can lead to data conflicts or overwrite values.
🔹 Maintain clean data formats
Ensure your data is free of extra spaces, special characters, or inconsistent formatting (like text in number fields). Clean data imports more reliably.
🔹 Save and reuse successful mappings
Once you've created a mapping that works well, save it for future use to maintain consistency and save time.
🔹 Regularly review and remove outdated mappings
Templates evolve—removing unused mappings prevents errors and clutter.
🔹 Test with a small dataset
Trying a small sample file first helps you identify issues before committing to a full upload.
❓ FREQUENTLY ASKED QUESTIONS (FAQS)
Q. What happens if I don’t map all the columns in my file?
A. Any unmapped columns will be ignored during the import. To ensure your data is imported completely and correctly, map every relevant column.
Q. Can I create multiple data mappings for different templates?
A. Yes. You can create and save multiple mappings for different file formats or use cases. Use clear, descriptive names to easily identify them later.
Q. Why does the system say “RepZio Columns” if I’m using ShopZio or B2B Direct?
A. These mappings apply across the entire platform—including RepZio, ShopZio, and B2B Direct—even though they’re labeled “RepZio Columns.”
Q. Can I edit a data mapping after I’ve saved it?
A. Absolutely. Just click the ✎ pencil icon next to the saved mapping to make changes.
Q. I mapped a column incorrectly. What should I do?
A. You can either edit the existing mapping or delete it and create a new one. If incorrect data was already uploaded, re-upload the file using the corrected mapping.
Q. Are there any required columns for a successful import?
A. Yes. Required fields often include ItemID, Item Name, Category, Price, and IsDeleted. Missing these can prevent a successful upload.
Q. Can I download a list of available RepZio columns?
A. Not directly, but when editing or creating a mapping, you can view all available fields. You can also download the Import Products Template as a reference.
Q. What if my template has extra fields that aren’t needed?
A. No problem—just leave those fields unmapped. They’ll be skipped during import.
Q. Can I duplicate a successful mapping for a new template?
A. There's no built-in “duplicate” feature, but you can create a new mapping by replicating the settings from a successful one manually.