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 recognized by WebManager ensures a smooth and accurate data importāsaving time and minimizing errors.
Edit Data Mappings
Follow the steps below to create or modify data mappings within WebManager:
Step 1
Navigate to Manage Data
Step 2
Select Data Mappings
Step 3
Click the pencil icon ā next to your mapping you wish to edit
Step 4
Compare your template headers to the corresponding RepZio columns, and make any necessary updates
š¹ Note: While the system refers to them as RepZio Columns, the mapped data applies across the entire digital platformāincluding RepZio, B2B Direct, and ShopZio.
Step 5
Click Save Mapping
Step 6
Proceed to upload your file
š” Tip: Keeping your data mappings up to date ensures a more streamlined import process and helps prevent field mismatches.
Delete Data Mappings
Removing outdated or unused mappings can help reduce confusion and avoid mapping errors during future imports.
Step 1
Click on 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
To ensure accurate and efficient data imports, keep the following best practices in mind when working with data mappings in WebManager:
š¹ Use clear and consistent column headers
Make sure your column names are descriptive and consistent across your templates. This makes it easier to map them to the correct RepZio columns.
š¹ Double-check required fields
Before uploading, verify that all required fields (such as ItemID, Product Name, and Price) are present and correctly mapped. Missing or mismatched required fields may result in import errors.
š¹ Avoid duplicate mappings
Each column should only be mapped once. Duplicate mappings can cause data conflicts or override values unintentionally.
š¹ Maintain clean data formats
Ensure that your data does not contain extra spaces, special characters, or inconsistent formatting (e.g., text in numeric fields). Clean data helps the system process your upload more smoothly.
š¹ Save and reuse successful mappings
Once you've created a mapping that works well, save it for future use. This ensures consistency and reduces time spent remapping for future uploads.
š¹ Regularly review and remove outdated mappings
Over time, templates may change. Deleting unused or outdated mappings helps prevent confusion and potential errors during import.
š¹ Test with a small dataset
When using a new template or mapping, test your upload with a small sample file first. This allows you to catch and correct issues before importing a full dataset.
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 process. To ensure all your data is used correctly, make sure each relevant column is mapped to a corresponding WebManager (RepZio) field.
Q: Can I create multiple data mappings for different templates?
A: Yes. You can create and save multiple mappings to accommodate different templates or use cases. Be sure to give each mapping a clear, descriptive name so itās easy to select the right one later.
Q: Why does the system say āRepZio Columnsā if Iām using ShopZio or B2B Direct?
A: The system refers to them as RepZio Columns, but these mappings apply across the entire digital platform, including ShopZio, B2B Direct, and the RepZio app.
Q: Can I change a data mapping after Iāve saved it?
A: Yes, you can click the pencil icon next to any saved mapping to update or revise your column assignments at any time.
Q: I accidentally 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 youāve already uploaded data with incorrect mappings, you may need to re-upload the corrected file using the proper mapping.
Q: Are there any columns that must be mapped for a successful import?
A: Yes, certain fieldsālike ItemID, Item Name, Category,Price, and IsDeletedāare typically required for the system to process your file correctly.
Q: Can I download a list of available RepZio columns for mapping reference?
A: While thereās no automatic export, you can view all available columns when editing or creating a new mapping. For reference, you might also consider downloading the Import Products Template, which includes the standard column structure.