OEM3

Office Experts Manage 3 is the third iteration of software created to automate processes at Office Experts Incorporated.

This group of projects automates price changes, creates shelf labels faster and automatically, and provides content to shop.officeexperts.ca.

OEM3 is intended to make these processes more reliable, easier to use, and improve website content using new data sources.

Project Features TODO List

• Authentication
• Data Sources
  • Guild
    • Price File Data
    • Inventory
    • Flyer
    • Enhanced Descriptions
  • SPRichards
    • Price File
    • Etilize Flat File Data
    • Etilize Enhanced Content
  • QuickBooks
  • Shopify
• Search
• Matching
  • Guild
  • SPR
  • Unified Items
• Exports
  • QuickBooks Flyer Changes
  • QuickBooks Price Updates
  • Shopify Sync
• Shelf Labels
  • Quick Add

Tech Stack

• TypeScript
• Backend
  • Bun (JavaScript Runtime)
  • tRPC
  • Postgres
  • Docker (hosted on Railway)
• Frontend
  • SvelteKit
  • Tailwind

Development

To install dependencies:

bun install # run in the project root, /svelte, and /server

Ensure all example.env files are updated with development values. To run in development mode:

bun run dev # note that docker compose is required to run this

Deployment

Currently, OEM3 is deployed on Railway using a docker image. To build the docker image locally:

bun run build

For a successful deployment, set all environment variables listed in the example.env files. You will also need a separate Postgres database, which can also be hosted on Railway.

License

This project is not licensed under an open-source license.