Easiest way to import XML products free?

  • Resolved mamandis

    (@mamandis)


    4 years, 6 months ago

    Hello for everyone,
    spent lot of time in searching in google and this forum and did not find an answer.

    The situation is that I want to import variable products to my Woocommerce – from dropshipping company I get XML or CSV file – I tried import CSV variable products, but at the beginning I have not understood how to make a product variable if it has not any unique ID or something to connect them. Check, please, I shared CSV with one variable product.

    I try to use free plugins and for this import – I use builtin Woocommerce plugin (in a dashboard – Products -> button Import), tried to check different attributes in woo import products section – attribute name, attribute value, is a global attribute?, attribute visibility, default attribute
    .
    I checked XML file and it has an unique ID (for ex. same ID for three different colors), but Woocommerce builtin plugin does not support XML ??
    Found in forum answer for question – is there free plugin for Woocommerce to import XML?
    And there is just one answer – Convert your XML to CSV.

    Try to find a way how to do this but have not found good solution.

    Could you answer me, is there any good converter to do so – convert XML to CSV?
    Is there free plugin to import variable products from XML to Woocommerce, what its name? If not, what is cheap (max 30$) and really good XML importer?

Viewing 4 replies - 1 through 4 (of 4 total)
  • laceyrod

    (@laceyrod)

    Automattic Happiness Engineer

    Hi there,

    Thanks for reaching out.

    As I understand, you’re wanting to import variable products into your store, but you’re a little uncertain how variations will be linked to the parent variable product, is that correct?

    I would still recommend running the import via CSV file with the built-in import tool. (Products > All Products > Import). When you look at the sample CSV file, you’ll see that they are linked via SKU. The parent product is listed as a variable product type, and variations are listed as variations:

    This is how you’ll want to format your import.

    Cheers!

    Thread Starter mamandis

    (@mamandis)

    Dear @laceyrod,

    thank You for fast response.

    Yes, I am uncertain how variations will be linked to the parent variable product, couse, as you can see in my linked (attached) attachment I have different IDs and you showed me that for SKU I need to set an unique identifier (same for all variations of product) – I know this, but there is no unique identifier. Or I did not see an unique identifier?! ??

    I checked XML file, there I can find an unique identifier, but builtin Woocommerce plugin does not import XML.

    Thats why I asked you, is it possible to import products with variable attributes thru CSV somehow, or I need to use XML (CSV file size: ~8 MB, XML (same products as in CSV) – ~40 MB).

    So how to solve my problem?

    Do you know how to convert easily XML to CSV, or how to import XML (free or cheap plugin)?

    Best regards,
    @mamandis

    AJ a11n

    (@amandasjackson)

    Hi @mamandis

    Do you know how to convert easily XML to CSV, or how to import XML (free or cheap plugin)?

    Here are a few options that I found:

    https://blog.dlvrit.com/xml-to-csv/

    https://www.ads-software.com/plugins/woocommerce-xml-csv-product-import/

    Plugin Support con

    (@conschneider)

    Engineer

    Hi there,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Kind regards,

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Easiest way to import XML products free?’ is closed to new replies.