We designed an app built into the Shopify admin, in Spanish, that Tiko Doco’s own team uses without leaving their store or asking for technical help.
Brand import. The ERP report is uploaded and the app creates the brands as the store’s own content, generates and publishes an automated collection for each one, uploads the logos and assigns the brand to each product in three places at once: vendor, brand field and tag. Matching is done by reference against each variant’s SKU.
Technical specs import. The second ERP report fills in each product’s details. It’s an awkward format —it splits long lines across several rows, sometimes mid-word— so the processor stitches them back together before reading them. 41,151 rows produce 28,818 products, 9,155 of them with attributes.
Mandatory preview. No import writes anything until someone has seen the counters and the reports of what’s going to happen and confirms it. Nobody is ever one click away from overwriting 20,000 product pages.
Automatic catalog review. Every 30 minutes the app goes through the whole store and switches to draft whatever the ERP doesn’t filter: out of stock, no image or a price of 0. When a product is fit for sale again, it republishes it —only if the app was the one that took it down, so it never touches drafts someone created by hand. It was delivered switched off: until the merchant turns it on, each run calculates and reports without changing anything, so the real scope can be seen before letting it act.
It’s built on Remix and React with Shopify’s Polaris design system, against the GraphQL Admin API with bulk operations, and with more than 100 automated tests on the logic that decides what gets written and what doesn’t.