Total Products
–
Active items in catalogue
In Stock
–
Available to order
Categories
–
Product categories
With Images
–
Products with photos
Vyapar Sync Status
Checking…
Quick Actions
Common admin tasks
Sync History
Last 10 sync operations
| Time | Status | Source File | Products | Message |
|---|---|---|---|---|
| Loading… | ||||
Manual Sync
Trigger an immediate sync from Google Drive
ℹ️
The sync server must be running on port 8081. Start it with:
python3 sync/sync_server.py --serve
Automatic Sync Schedule
Choose when the system automatically fetches the latest Vyapar backup from Google Drive
2:00 AM
Recommended
6:00 AM
Early morning
9:00 AM
Shop opening
10:00 PM
After closing
How Automatic Sync Works
The sync process runs automatically every day
1
At the scheduled time, the sync server wakes up and connects to your Google Drive folder
2
It finds the latest
.vyb backup file (sorted by date in filename)3
Downloads the file, extracts the SQLite database inside it
4
Reads all active products, prices, stock levels, and images
5
Writes the new
products.js and products.json files6
Website automatically shows the updated catalogue on next page load
Google Drive Configuration
Connect your Vyapar backup folder
☁️
Vyapar automatically backs up to Google Drive. Make sure "Auto Backup" is enabled in Vyapar Settings → Backup → Google Drive.
From the URL: drive.google.com/drive/folders/THIS_PART
From the share link: drive.google.com/file/d/THIS_PART/view — update this each time you export a new backup from Vyapar
How to Update the Product Catalogue
Follow these steps every time you want to sync new products from Vyapar
1
Export from Vyapar: Open Vyapar on your phone or PC. Go to Settings → Backup → Backup Now. This creates a new
.vyb file and uploads it to Google Drive automatically.2
Find the new file: Open Google Drive on your computer. Open the Vyapar folder. You will see the new backup file with today's date in the filename.
3
Copy the File ID: Right-click the latest
.vyb file → click "Get link". The link looks like: drive.google.com/file/d/FILE_ID/view. Copy the FILE_ID part.4
Paste it above: Paste the File ID into the "Latest .vyb File ID" field above and click Save Drive Config.
5
Run the sync: Click the "Sync Now" button at the top of this page (or go to Dashboard → Sync Vyapar Now). The website will update within 30 seconds.
6
Verify: Go back to the website and check that the new products appear. The "Synced just now" badge in the topbar confirms success.
💡
The Folder ID (
18COmhlzYkMZl5GSNvclgE1rEy2B-Bnaf) never changes. You only need to update the File ID each time you do a new backup.
Running the Sync Server
The sync server must run on your hosting server
⚠️
The sync server requires Python 3.8+ and the
schedule package. Run it on your VPS or shared hosting with cron.
# Install dependencies
pip3 install schedule# Run sync once (test)
python3 sync/sync_server.py --sync-now# Run as background server (daily auto-sync)
nohup python3 sync/sync_server.py --serve --port 8081 &
# Or add to crontab (runs at 2 AM daily)
0 2 * * * python3 /path/to/ranjit-electronics/sync/sync_server.py --sync-now
Site Controls
Toggle site-wide features
Site Enabled
When disabled, visitors see a "We'll be back soon" maintenance page
Online Ordering Enabled
When disabled, a banner shows asking customers to WhatsApp instead
Show Out-of-Stock Items
When disabled, out-of-stock products are hidden from the catalogue
Repair Section Visible
When disabled, the Repair section and Repair button are hidden from the website
Shop Information
Update your shop details shown on the website
Used for WhatsApp order links. Format: 919800000000
WhatsApp Integration
Configure WhatsApp order and enquiry messages
Include country code, no + or spaces. Example: 919800000000
Use {items} for the cart items list and {total} for the order total
Test WhatsApp Link
Send a test message to verify your number is correct