Issue No. 01 · August 2026● Two client slots openOlongapo City · PH · GMT+8
The Shopify Freelance QuarterlyVol. I₱ / $ / £

De Vera

Shopify Virtual AssistantStore SpecialistEst. 2026
Two years inside Shopify support. What it taught me about where stores actually break.The interview · p.04
The six jobs I take off a founder's plate every week.Services · p.02
From an empty admin to a live storefront in one build.Case study · p.03
Why your page speed problem is not the app you think it is.Feature · p.03
JD Joshua De Vera · Shopify VA & store specialist
From the editor

I'm Joshua. I take the Shopify work off your plate: theme edits, product data, daily orders, page speed, search. Two years inside Shopify's technical merchant support, now freelance.

Book a free consult Read the case studies
jshmdevera@gmail.com

The Contents

Services · p.02
01

Theme & store build

Full storefronts from an empty admin, or precise edits to the theme you already run. Written into the theme in Liquid, not bolted on with another app.

LiquidHorizonOS 2.0PageFly
p.02
02

Catalog & product data

Bulk imports, variant clean-up and structured attributes for brand, format and origin, plus the collections and filters that sit on top of them.

MatrixifyMetafieldsMetaobjects
p.02
03

Daily store operations

Orders, inventory levels, refunds and the customer inbox. The unglamorous daily work that keeps a store trustworthy.

OrdersInventoryInbox
p.02
04

Speed & Core Web Vitals

Find what's actually slowing the page down, then fix it in the theme. Images, render-blocking scripts, layout shift, and the apps quietly costing conversions.

LCPINPCLS
p.03
05

SEO & AI search visibility

On-page SEO plus the newer job: being the store that AI Overviews, ChatGPT and Perplexity actually cite. Schema, structure, copy for humans first.

JSON-LDAEOGEO
p.03
06

Automation & integrations

Shopify Flow for the repetitive work, payment gateways and checkout configured properly, third-party apps wired to talk to each other.

Shopify FlowManyChatCheckout
p.03

The Features

Case studies · p.03
Full build · Horizon theme
01

Taste Culinary Food

A Philippine café-ingredient distributor moving off the shop floor and onto Shopify. Built from an empty admin: custom Liquid templates across product, collection and landing pages, dedicated brand pages for Catcher Gourmet, Toschi and Cafetto, payment gateways and checkout configured, metafields structuring every product attribute, and a browser-based inventory reconciliation tool written in JavaScript.

LiquidMetafieldsMatrixifyShopify FlowCheckout
Read the full story
Ongoing · Theme & audit
02

Adahlia Boutique

A UK modern-luxury womenswear label. Ongoing theme development and a rolling audit programme delivered through a GitHub-connected deploy pipeline, holding a single design system consistent across every section of the storefront while the catalogue keeps changing beneath it.

Theme devGit deployDesign systemAudits
Read the full story
Placeholder
Replace with a real client quote once you have one in writing.
Client name · Company

The Interview

About · p.04
JDJoshua De Vera · Olongapo City

From April 2024 to April 2026 I worked inside Shopify as technical merchant support, front line for merchants worldwide. Themes, apps, payments, checkout, DNS, domains, gateway failures. When something broke, it landed in my queue.

That job taught me where stores actually break, and it's almost never where the owner thinks it is. Now I do the fixing directly, freelance, for founders and small teams who need someone who can read Liquid and answer a customer email in the same afternoon.

Before Shopify I spent two years in high-volume data processing and a year coordinating patient care, which is where the catalog discipline and the tolerance for a busy inbox come from. I studied Information Technology at Gordon College in Olongapo City, where I still work from.

I use Claude Code and AI-assisted workflows throughout, which makes the turnaround faster than the rate would suggest. Everything I ship is documented, so you are never locked into me.

Shopify AdminLiquidJavaScriptHTML / CSSMatrixifyShopify FlowMetafieldsMetaobjectsSearch & DiscoveryPageFlyManyChatCore Web VitalsJSON-LD
Free 30-minute consult

Tell me
what's stuck

Bring the store URL and whatever's been annoying you. Worst case you leave with a straight answer and a plan you could hand to anyone.

jshmdevera@gmail.com+63 976 148 2996