Wix Sync : Tool to Sync CMS Collections Across Multiple Wix Sites

Demo of Wix CMS Sync Tool

One of my flagship projects is WixSync, a powerful tool designed to synchronize collections between two different Wix sites. This page will give you an in-depth look at the challenges, solutions, and impact of this tool, demonstrating my expertise and dedication to providing high-quality, efficient solutions for complex problems.

The Problem

Managing multiple websites with large amounts of data can be a daunting task. One of my clients faced this exact challenge.

With hundreds of Wix sites under their management, each containing thousands of records from multiple brands, maintaining consistent and up-to-date data across all sites was nearly impossible.

Every time a new product was added or updated on one site, it had to be manually replicated across all others. This process was not only time-consuming and inefficient but also prone to errors, leading to data inconsistencies across the network.

The Solution: WixSync

To address this problem, I developed WixSync, a tool that allows seamless synchronization of collections between two Wix sites.

WixSync simplifies the data management process by enabling users to select a master site, from which data is synchronized to a child site, ensuring consistency and accuracy across multiple platforms.

Key Features of WixSync

  • Master-Child Site Selection: Users can easily select a master site and a child site for synchronization.
  • Collection Selection and Comparison: Users can choose specific collections to sync. WixSync compares the collections between the two sites, highlighting structural differences.
  • Automatic Structure Alignment: If the structures do not match, WixSync offers options to create missing collections or fields in the child site, aligning it with the master site.
  • Data Transfer: Once the structures are aligned, WixSync transfers all records from the master site to the child site.
  • Real-Time Progress Tracking: Users can monitor the synchronization process in real time, ensuring transparency and efficiency.

Impact of WixSync

WixSync has significantly improved the efficiency of my client’s operations. With the ability to transfer 15-20 collections, each containing 3000-5000 records, in just 5-10 minutes, the client can now update hundreds of websites effortlessly.

The difference report feature provides a clear view of structural discrepancies, reducing the risk of errors that come with manual comparisons.

Building the Solution

The development of WixSync began with thorough research.

Initially, I explored existing solutions within the Wix ecosystem, such as CSV downloads and uploads. However, these methods proved to be inefficient and error-prone.

Further investigation revealed that sharing collections between Wix sites was not possible, as confirmed by the Wix support team.

Undeterred, I turned to the Wix REST API, which provided the necessary functionality to programmatically sync collections. After building a proof of concept and conducting various experiments, I developed the final version of WixSync.

Creating an Easy User Experience

WixSync is designed with user experience in mind. The tool features a step-by-step guided process, ensuring users can easily navigate through each phase of synchronization. Here’s a breakdown of the user journey:

  1. API Key Entry: Users start by entering their account API keys.
  2. Site Selection: On the sync page, users select the master site and the child site.
  3. Structural Report: Users receive a report detailing structural differences, with action buttons for copying collection structures or fields to the child site.
  4. Confirmation Screen: Users confirm the data transfer process.
  5. Real-Time Progress: Users can track the progress of each collection’s synchronization in real-time.

Technologies Used

The development of WixSync involved a combination of powerful technologies, including:

  • PHP: Server-side scripting for backend development.
  • MySQL: Database management.
  • REST: API integration for seamless data transfer.
  • Tailwind CSS: For creating a responsive and user-friendly interface.
  • Bootstrap Icons: For intuitive and visually appealing UI elements.

Are you struggling with data management across multiple Wix sites?

Do you need a reliable, efficient, and error-free solution? WixSync is here to help. Contact me today to learn more about how WixSync can streamline your data synchronization processes and elevate your business operations.