get external url from database

  • Resolved perg

    (@perg)


    7 years, 7 months ago

    Hi.

    I would like to export the fifu_external_url to an external product-search service (using WP ALL IMPORT) to store in db.

    WHen looking at the value in wp_postmeta.fifu_image_url i dont see the external url, but only the internal url.

    1)
    Wow can i run a query fetching the true external url for a certain Woocommerce product?

    2)
    Also, is is possible to use the external url without redirect, instead of the internal “fake” url in woocommerce?. On category/archive pages for example.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter perg

    (@perg)

    7 years, 7 months ago

    I clarification, what i also really want to do is to set the external URL in

    wp_postmeta.fifu_image_url

    Which currently only get the internal url.

    If i overwrite the value with external url, i get he desired result.

    —- Fetching fifu_image_url for a specific product—-
    SELECT meta_value FROM wp_postmeta where post_id = {$id} and meta_key = ‘fifu_image_url’ LIMIT 1

    Plugin Author fifu.app

    (@marceljm)

    7 years, 7 months ago

    Hey, @perg.

    The custom field “fifu_external_url” doesn’t exist. Do you mean “fifu_image_url”?

    How does that “external product-search service” work?

    Plugin Author fifu.app

    (@marceljm)

    7 years, 4 months ago

    Hi, @perg.

    Once there was no answer in 2 months, I’m closing this topic. You can contact me again if you have other issues.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘get external url from database’ is closed to new replies.