Get in touch

I'm always excited to take on new projects and collaborate with innovative minds.

Phone Number

+92 305 9971189

Based in

Lahore, Pakistan · remote

Social

Shopify

Shopify inventory sync for a multi-brand operation

A Shopify store is one channel. When the same SKU also sells on Walmart, Amazon, and a second Shopify brand, the number in Shopify admin stops being the number in the warehouse. Hector is the system that holds the warehouse quantity and pushes a consistent picture back out.

Report corrections that used to be pulled from separate tools now come out of Hector in one click.

From the production system, not a projected figure.

Where the count drifts

Staff were copying an order out of Shopify, then updating a sheet, then updating the shipping tool. Each copy was a chance for the stock figure to disagree with the shelf. Two brands, RetroFam and Retro vGames, shared products. One brand's sale had to reduce stock the other brand could still sell.

The fix is a master catalog: base products, kits, and a marketplace listing mapped back to the same SKU. Shopify is a sales channel into that catalog, not the place the quantity lives.

What sync actually does

Orders from both Shopify stores land in the same order queue as Walmart, Amazon, WooCommerce, Newegg, Temu, eBay, and manual orders. Fulfillment events update a pre-computed record for that order. Stock movement is written to a ledger, so a cycle count has something to compare against.

During the cutover the old inventory module stayed live next to the new one. New work shipped only in the new module, so the floor did not stop while the data moved.

What changed

Three to four people were doing this order work by hand. The same flow now runs with one person. Hector processes 200 to 300 orders a day across the marketplaces. This was built as a full-stack engineer at Retrovgames. The platform is theirs.