Perfect UnionOpen Dashboard

Knowledge Base

Learn how to use the Perfect Union ESL Sync System

Upload Products from Treez to Database and Opticon

1

Login to Treez Portal

  1. Navigate to your Treez dashboard
  2. Select your store location from the dropdown (e.g., "Perfect Union - Sac NorthSide")
  3. Click on Product in the left sidebar
  4. Click on Product List
Treez dashboard with Product menu
Screenshot 1: Navigate to Product → Product List in Treez portal
2

Filter Products with ESL Tag

  1. In the search box, type ESL
  2. The system will display all products tagged with "ESL"
  3. You should see the total count (e.g., "Displaying first 25 results of 36354")
Product list filtered by ESL tag
Screenshot 2: Search for "ESL" to filter products with ESL tags
3

Export Products to CSV

  1. Click on the three dots menu (⋮) in the top right corner
  2. Select CSV Export from the dropdown
  3. The CSV file will download automatically
  4. Open the CSV file in Excel or any spreadsheet application
Three dots menu with CSV Export option
Screenshot 3: Click three dots menu and select CSV Export
4

Copy Product IDs from Excel

  1. Open the downloaded CSV file in Excel
  2. The first column (Column A) contains all Product IDs
  3. Select all Product IDs in Column A (excluding header)
  4. Copy them (Ctrl+C or Cmd+C)
Excel file showing Product IDs in Column A
Screenshot 4: Excel file showing Product IDs in Column A (first column)

Example Product IDs:

1060459d-bec9-48cf-a779-9f7ae5761337 4df8b3f6-ea86-4b3f-9e0c-066f828f6d9a 3db96861-236b-4dbf-81ca-10347412aa5e ...
5

Update product-ids.json File

  1. Navigate to your project root folder
  2. Open product-ids.json file
  3. Replace the existing Product IDs with the ones you copied
  4. Save the file

File Format:

{
  "productIds": [
    "1060459d-bec9-48cf-a779-9f7ae5761337",
    "4df8b3f6-ea86-4b3f-9e0c-066f828f6d9a",
    "3db96861-236b-4dbf-81ca-10347412aa5e"
  ]
}

⚠ī¸ Important: Make sure to use proper JSON format with quotes and commas between IDs.

6

Fetch Products in Admin Panel

  1. Open the admin dashboard: http://localhost:3000/admin
  2. Click on Treez Products in the sidebar
  3. The system will automatically fetch all products from the updated product-ids.json file
  4. Verify that all your products are displayed in the table
Treez Products page showing product list
Screenshot 5: Admin dashboard showing fetched Treez products with all details
7

Upload Products to Opticon

  1. In the sidebar, click on Product Mapping
  2. Review all product data (price, barcode, name, etc.)
  3. Verify that all information is correct
  4. Click "Upload All to Opticon" button at the top
  5. Wait for all products to be uploaded (you'll see green checkmarks)
Product Mapping page with Upload All button
Screenshot 6: Product Mapping page with "Upload All to Opticon" button
8

Sync Products to Database

  1. In the sidebar, go to Change Monitor tab
  2. Click "Sync Products from Treez" button
  3. This will upload product snapshots to Supabase database
  4. Wait for sync to complete
  5. You'll see all products listed in the "Monitored Products" table
Change Monitor page with Sync button
Screenshot 7: Change Monitor page with "Sync Products from Treez" button

ℹī¸ Note: This step enables the real-time change detection system. Once synced, the system will automatically monitor these products for any changes.

9

Verify Products in Opticon

  1. Open Opticon EBS50 interface: https://ebs50.local
  2. Navigate to the Products section
  3. Verify that all uploaded products appear in the list
  4. Check that Barcode column contains Treez Product IDs (UUIDs)
  5. Verify prices, names, and categories are correct
Opticon Products list showing synced products
Screenshot 8: Opticon EBS50 Products list showing all synced products with Treez UUIDs in Barcode column

✅ Success Criteria: All products visible in Opticon with correct data. ProductId should be sequential (1, 2, 3...) and Barcode should contain Treez UUIDs.

🎉 Setup Complete!

Once all steps are completed, your system is ready for real-time synchronization:

  • Products are now being monitored automatically
  • Any price changes in Treez will sync to Opticon within 1-2 minutes
  • Background monitoring runs continuously
  • Check the Change Monitor page anytime to see sync status

📌 Next Steps

  • Test the sync by changing a price in Treez and verifying it updates in Opticon
  • Link ESL tags to products in the Opticon Base Station
  • Add more products to product-ids.json as needed
  • Monitor the Change Monitor page for real-time updates