Accounting Software Connected to Shopify and WooCommerce

2024-06-01

Warehouse, delivery notes, and stock. All synced between accounting and the store.

Built a two-way integration between an accounting system and the ecommerce store. Stock levels, delivery notes, and warehouse data are queried, verified, and synced automatically. No manual cross-referencing.

The challenge

Running an ecommerce store alongside an accounting system means two separate data sources that are constantly out of sync: stock levels, incoming deliveries, and order records all live in different places. Reconciling them manually is slow, error-prone, and requires someone to context-switch between two systems multiple times a day. The goal was to connect them through their APIs so the accounting system and the store always reflect the same reality.

Approach

• Connected to the accounting software via its REST API: authenticated, scoped, and rate-limit aware
• Warehouse stock queries automated: pull current quantities per SKU from the accounting system on demand
• Delivery note creation automated: generate dobavnice (delivery notes) from structured inputs without opening the accounting UI
• Stock sync logic built: compare accounting warehouse quantities against live Shopify/WooCommerce inventory and flag discrepancies
• Audit scripts built for full inventory reconciliation. Outputs a structured report of what matches and what doesn't.
• All operations logged to output files for traceability

Results

• 2 — systems connected: accounting and ecommerce store
• 0 — manual cross-referencing between systems
• Full — delivery note creation automated via API
• Real-time — stock discrepancy detection across both systems

Tools used

Python, REST API, Shopify API, WooCommerce API, Workflow Automation