How do I import a JSON or XML code in WordPress?

  • I wonder if you can help me?

    I am busy creating a computer parts online store using WooCommerce and Elementor, and the computer parts wholesaler that I am going to order the parts from sent me this code that you will find attached below to be able to import the products from them without having to enter the products manually.

    REFURNS.ISON	
RL	ps://rctdatafeed.azurewebsites.net	Description
api/9d47eda8-86f4-4829-81c4-3bb2ee4feaed/v1/Products	Returns all the products.
api/9d47eda8-86f4-4829-81c4-3bb2ee4feaed/v1/Products/{code}	Returns a product by product code.
api/9d47eda8-86f4-4829-81c4-3bb2ee4feaed/v1/Products/productlineRproductLine	Returns all products by product line.
api/9d47eda8-86f4-482981c4-3bb2ee4feaed/v1/Products/onhand	Returns all products with on hand greater than zero.
api/9d47eda8-86f4-4829411c4-3bb2ee4feaed/v1/Products/imag&{code}	Returns all image details for specified product code.
api/ef5b9ala-ebe3-4634-bef8-3e0ce689ce3e/vVProducis/modifiedthisweek	Returns all products modified this week.
api/9d47eda8-86f4-4829-81c4-3bb2ee4feaed/v1/Products/modifiedthismonth	Returns all products modified this month.

RETURNS XML	
URL https://rctdatafeed.azurewebsites.net	Description
/xml/9d47eda8-86f4-482943fc4-3bb2ee4feaed/v1/Producis	Returns all the products.
/xml/9d47edaft-86f4-482943fc4-3bb2ee4feaed/v1/Products/{code}	Returns a product by product code.
/xml/9d47eda8-86f4-4829431c4-3bb2ee4feaed/v1/Products/productlinefiproductLine	Returns all products by product line.
/xml/9d47eda8-86f4-4829431c4-3bb2ee4feaed/v1/Products/onhand	Returns all products with on hand greater than zero.
/xml/9d47eda8-86f4-4829431c4-3bb2ee4feaed/v1/Products/images/{code}	Returns all image details for specified product code.
/xml/9d47eda8-86f4-4829431c4-3bb2ee4feaed/v1/Producis/modifiedthisweek	Returns all products modified this week.
/xml/9d47eda8-86f4-4829431c4-3bb2ee4feaed/v1/Producis/modifiedthismonth	Returns all products modified this month.

    But I don’t know how to add this code to my website.

    Please can you help me with this?

    I will really appreciate it, Thank You.

    • This topic was modified 2 years, 8 months ago by Yui.
    • This topic was modified 2 years, 8 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic
Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator bcworkz

    (@bcworkz)

    I think you’ll have better luck finding XML import tools. There are a number of plugins available. The key is finding one that will put the imported data where WooCommerce can utilize it. WP All Import is commonly recommended, but I’ve no experience with it myself.

    If no existing plugin will work for you, you may have to custom develop your own import plugin. PHP can readily parse either format, so the key again is placing data where WooCommerce can utilize it. This requires a good understanding of WooCommerce data structure.

    Thread Starter Soteres Joannou

    (@soteres-joannou)

    But how do I import the code shown above into an XML file?

    Thanks.

    Moderator bcworkz

    (@bcworkz)

    Oh, so those links send raw XML data? I thought they were like a file download. I obviously didn’t try any of them. My bad, sorry.

    You could do it manually by copy/pasting returned data into an empty file. You could automate it by using WP_HTTP object methods to fetch data and PHP’s file handling functions to write to a file that one of the import plugins can utilize for import. The entire process could be scheduled as a recurring event to run every x number of days if need be. Such automation would likely involve some custom coding. I’m unaware of any plugin that would do everything turnkey.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How do I import a JSON or XML code in WordPress?’ is closed to new replies.

Tags