Clone Sheet - Have Your Business Data on Your Device

About Clone Sheet

Clone Sheet is a powerful tool that creates a clone of your Selldone store data into an SQL database, enabling advanced analytics, custom integrations, and business intelligence.

SQL Database

Store your business data in MariaDB or MySQL for seamless integration with other systems.

AI Automation

Leverage your data for machine learning models and AI-powered business insights.

Data Migration

Easily migrate your business data to other systems or create backups.

Custom Analytics

Build custom reports and dashboards using your preferred BI tools.

Key Features

Clone Sheet provides everything you need to work with your business data locally.

Clone store data from Selldone into a structured SQL database
Support for both MariaDB and MySQL databases
Simple setup process with guided configuration
User-friendly interface for data synchronization
Integration with data visualization tools
Secure token-based authentication with Selldone API

Getting Started

Follow these simple steps to set up Clone Sheet and start working with your business data.

Database Setup

To use Clone Sheet, you first need to set up a MariaDB or MySQL database on your local machine or server.

Download MariaDB

// Windows, macOS, or Linux

                    # Follow the installer instructions

                    # Create a database user (optional)

                    # Make sure the database service is running

Clone Project

Clone the repository to your local machine and install the required dependencies.

// Using HTTPS

                    git clone https://github.com/selldone/clone-sheet.git

                    cd clone-sheet

                    npm install

// Using SSH

git clone [email protected]:selldone/clone-sheet.git
cd clone-sheet
npm install

Installation & Setup

Run the setup script to configure your database connection. This will create the necessary tables and initialize your environment.

                    node setup.js

                    npm start

The server will run on http://localhost:3010 or another available port.

Using Clone Sheet

After setting up Clone Sheet, you can start connecting to your Selldone store and syncing data.

Create Access Token

Click on the Create Access Token button, which will redirect you to Selldone. Select your shop, copy the Access Token and Shop ID, and enter them in the form.

Click Save & Connect to establish the connection.

Sync Data

Once connected, you'll see available data sources. Select which data you want to sync and initiate the synchronization process.

Explore Data

After synchronization, you can access and explore your cloned data in the Explorer tab.

Visualize with NocoDB (Optional)

You can visualize your cloned data using NocoDB, an open-source database browser.

                    docker run -d \

                    --name noco \

                    -v "$(pwd)"/nocodb:/usr/app/data/ \

                    -p 8080:8080 \

                    nocodb/nocodb:latest

Open NocoDB at http://localhost:8080 and set the SQL host to host.docker.internal and port 3306.

Why Clone Your Data Locally?

Having your business data on your device opens up numerous possibilities for customization, analysis, and integration.

Category	Use Cases
Advanced Analytics	Connect to Power BI, Tableau, or Google Data Studio for custom dashboards Execute complex SQL queries to uncover hidden business trends Perform cohort analysis and customer lifetime value calculations
Custom Automation	Create sophisticated marketing campaigns based on purchase patterns Build personalized discount strategies for different customer segments Set up alerts and actions based on inventory or sales thresholds
AI Integration	Feed your sales data to AI models for demand forecasting Create recommendation engines based on purchase history Develop ML models to predict customer churn and product popularity
Data Security	Keep a secure backup of your business data Control access to sensitive information Implement your own security protocols on top of Selldone's
Integration	Connect your store data with your ERP or CRM systems Build custom middleware solutions for specific business needs Integrate with third-party services not directly supported by Selldone