Skip to main content
Back to projects
Internal tool2025

1C Inventory Restocker

Excel-driven inventory sync from 1C to Shopify

Tech stack

  • Excel
  • 1C
  • Shopify API
  • Albato-ready

Reads Excel exports from 1C accounting and syncs stock levels directly into Shopify. Designed for Albato automation hand-off when continuous sync becomes the priority.

Gallery

Highlights

  • Reads native 1C Excel exports
  • Idempotent stock updates
  • Albato hand-off ready

My case study

The restocker bridges accounting reality and storefront availability. It uses the company’s existing 1C export workflow, then turns it into safe Shopify inventory updates.

Native accounting export input
1C Excel
Idempotent stock update flow
Safe sync
Prepared for continuous automation
Albato-ready

The challenge

Stock lived in 1C while the online store needed accurate availability. Manual transfer created delays and could easily introduce wrong inventory numbers.

What I built

I built a parser and synchronization flow that reads the Excel export, normalizes the product data, maps it to Shopify inventory, and applies updates safely.

Business outcome

The business can refresh inventory with less manual work and has a clear path toward a fully automated ERP-to-Shopify stock pipeline.

Related services