📋 Inventory
📡 FTP / UNI
📧 Email Alerts
Signed in as —
🚪 Sign Out
Loading inventory
Updated daily at 9am & 9pm
Status
Size
Color
Clarity
Fluorescence
Shape
More
BGM
Parcel List
Ct. Min
Ct. Max
Certificate
Location
Depth% Min
Depth% Max
Table% Min
Table% Max
Ratio Min
Ratio Max
Measure 1 Min
Measure 1 Max
Measure 2 Min
Measure 2 Max
Measure 3 Min
Measure 3 Max
Memo Days Filter
Loading…
◆ ◆ ◆ PROCESSING INVENTORY

📡 FTP / UNI Platform

Push your inventory to UNI's SFTP server in their CSV format. Pushes happen automatically twice daily, or on-demand here.

SFTP Host
Port
Username
Password
Remote Path
PHP Bridge URL (the SFTP push relay on your domain)
Auto-push every X hours (1, 2, 4, 6, 8, or 12) — independent from 8am/8pm reconciliation
Price markup % — applied to List $/Ct before pushing (e.g., 10 = +10%, -5 = −5%, 0 = no change)
Upload statuses

📧 Memo Alert Emails

Get an email listing clients with stones on memo for too long. Set the frequency below — daily, weekly, or any interval.

Alert after X days
Send email every X days (1 = daily)
Alert email addresses (comma separated)
Web App URL (from Apps Script deploy)

👥 Manage Users

Add, remove, and manage access to the BY-NY Stock System.

New username
Password
Role
Existing Users
Login Activity
Change My Password
New password

🌍 OriginMark Stories

Loading…

Read-only mirror of the OriginMark portal. Data syncs daily at 7am.

⚠ Validate Data

Choose a tab and click Run validation.

Runs validation rules from the spec against the OriginMark dataset. Nothing is rejected or modified — issues are surfaced as flags, exportable as an XLSX.

Not yet run.
No validation has been run yet. Click "Run Cert validation" above.

🛒 Retailers

Manage retailer accounts and stone assignments. Retailers log in at www.originmark.info/customers/

Username Display Name Email Markup Last Login Active Actions
Retailer Login Activity

📬 Retailer Requests

Cart submissions from retailers. Mark as Quoted or Closed when handled.

🌐 External OM Stock

Load vendor stock files (.xlsx / .csv), map their columns to internal fields, and browse them alongside your own inventory. External stones are tagged with the file name as their location.

Upload Vendor Stock
📄
Drag & drop a vendor stock file here, or click to browse
.xlsx or .csv — the file name becomes the vendor / location name
🗺 Optional: drop a mapping Excel here (vendor column → internal field)
Loaded Vendor Files

🔌 Vendor Connections

SFTP login and folder for each vendor. The daily pull fetches every enabled vendor from here — add as many as you need. Passwords are stored on the server and never shown back.

Add a vendor connection
Vendor id (short, no spaces)
Display label
Host
Port
Username
Password
Folder
Enabled
Configured vendors
Loading…

🏷 Vendor Import

Import vendor stone lists and assign each stone a permanent YBD-format parcel name. The registry (keyed on GIA cert) preserves the two-way vendor ↔ YBD mapping. Names are assigned once — re-imports always resolve to the existing name.

New vendors
Pulls from the FTP right now and lists files from vendors not yet recognized. Map & import one to recognize it — after that its files flow automatically.
Vendor & settings
▾
Manual vendor inventory
▾
External Inventory on Server
— what every machine sees under Source → External
Loading…
Registry Browser
🛒 My Bag
Your bag is empty
Filter