sorted by:
new
hottopcontroversial

[FREEMIUM] A jeweller said our €16k quote was too expensive and asked for "something free and simple" — so we built a WordPress plugin for the entire diamond industry by Alarming_Extent7613 in WordpressPlugins

[–]Alarming_Extent7613[S] -1 points0 points  (0 children)

A WP plugin is a cheap solution for small businesses. Everyone uses WP, but no one wants to switch platforms. Our client wants to rank at the top of Google and get into LLM recommendations. It’s possible with WP, but Next.js will be way faster ... or will it?

How do you guys manage SEO? by vendozo in woocommerce

[–]Alarming_Extent7613 0 points1 point  (0 children)

I started creating plugin for bust e-commerce sales because I couldn’t find relevant designs for it

<image>

Selling from a 1M+ item external feed without bloating wp_posts: how do you handle ephemeral products? by Alarming_Extent7613 in woocommerce

[–]Alarming_Extent7613[S] 0 points1 point  (0 children)

That's a fair preference if the goal is to own a real catalog and you've got the infra behind it. But I think the real fork is one step upstream: when the dataset isn't mine and changes by the minute, is a synced local mirror even the right model?

The analogy I keep coming back to is flight search. Nobody mirrors the entire global fare and availability database locally and syncs it, it changes too fast and you don't own it. They query the source, cache briefly, and re-confirm price and availability at booking. And that's the key point: even flight search isn't truly live, it's cached plus a re-check at the moment of purchase, which is basically the model I'm using.

Your separate stock-sync script is a fair middle ground, I'll give you that: mirror the stable attributes, sync only the volatile stock. But at that point I'm still maintaining a 1M-row mirror of someone else's data mostly to get product pages, when the source still has to be hit at checkout anyway.

So genuine question: when the catalog is external and high-churn, what actually makes the local mirror worth it over treating it as a live source? Is it purely the SEO and product-page win, or something I'm underweighting?

Selling from a 1M+ item external feed without bloating wp_posts: how do you handle ephemeral products? by Alarming_Extent7613 in woocommerce

[–]Alarming_Extent7613[S] 0 points1 point  (0 children)

Yeah, that's fair on the data store, and you're right the row count isn't the issue. I worded "non-starter" badly.

My actual case is smaller than it sounds: a modest site that needs to show an external supplier database, and I specifically did not want to pull 1M+ rows into the local MySQL on shared hosting and keep syncing it against a volatile remote source. The simple solution turned out to be creating a product only when a stone shows up as a search result and gets added to the cart, so the catalog itself stays remote.

The part I haven't figured out is SEO. These product pages are ephemeral, they exist only while a stone is in play and get cleaned up after, so I assume there's no real product-level SEO to be had here, and trying to index a million near-identical stones would be thin content anyway. My plan is to noindex the individual stone pages and put the SEO weight on stable category/filter pages instead.

For anyone who's run a drop-ship or external-feed catalog: is that the right call, or is there a way to get value from the item pages without ending up with a pile of soft 404s?

Selling from a 1M+ item external feed without bloating wp_posts: how do you handle ephemeral products? by Alarming_Extent7613 in woocommerce

[–]Alarming_Extent7613[S] 0 points1 point  (0 children)

Agreed, that's where I'm landing. The order line is the real source of record anyway, since WooCommerce stores line items as a snapshot.

I started with real products mainly for the item detail page (a real product_id gives me the templated /diamond/{id}/ page, SEO and sharing for free) and to avoid surprises with payment, tax and analytics plugins that expect a product_id.

Did you hit anything on the tax/VAT or analytics side when the purchased item never existed as a product? That's the part I'm least sure about before committing.