XML Product import Woocommerce

Hi Timothy,

Do you continue to get the "index file not found error message" , if so this is to do with the preview data, could you please go back to the "1. select file" step and re download/upload the xml file, this should refresh the index cache.

So that i can get an idea of the strucutre and setup of your importer are you able to attach a copy of your importer by going to Tools > Import WP > Settings / Tools > Import / Export > and attach the exported importer file to this ticket, along with a sample of the xml you are using.

For reference a good example of importing product categories and images can be found in this documentation (even tho the example is csv): https://www.importwp.com/docs/import-woocommerce-products-from-csv-xml/

James

Thank you for sending over the information (i have attached my generated sample.

Based on the exported importer and sample data i ran into some issues with your setup.

1. Product ID field , this field is used if you are referencing the wordpress product ID which is numeric, in your example this is: CNVELD-1001-0313 , which when the importer tries to use to find the product it causes errors. Normally WooCommerce uses the SKU, which you have set to {/UPC} in the example: 184709000000.

If you want to continue using the Product ID field as your thats fine, but if you want to use the sku field, under the permissions step of the importer set the Unique identifier field to _sku

2. Product Gallery - Empty he repeater node field, Emtpy the base_node field

3. Categories - Remove Category_1, Category_2, and Category_1 custom field rows, and instead add them to the taxonomy rows, selecting the Taxonomy as "Product categories", and setting the terms to "{/Category_1},{/Category_2},{/Category_3}" , as you can see each term is seperated by a comma.

These are the screenshots i meant to attach (showing unique fields on permissions, taxonomy setup, Product Gallery, and imported example record.

How was the importer ran?

From Tools>WP Import>importers

It has not moved but the products that were imported look gook

If it was manually run then you need to keep the page running it open

Ok, I was wondering if my pc going to sleep had anything to do with it.

Should I just rerun it and keep the window open?

yes that sounds like it may have caused it to stop.

if it does stop again, you could schedule the importer then it would be ran in the background using the wordpress cron, this works best if you have the wordpress cron hooked into the servers task scheduler and running every 5 minutes.

It looks like it is running well now. Thanks again..

The only issue is that my status field has OOS for Out of stock. How can I compensate for this by using the data to trigger the status?

To map your stock data you need to use a custom method, by adding this code to your websites.

function iwphd_stock_map($input = '')

{

    switch ($input) {

        case 'In Stock':

            return 'instock';

        case '':

            return 'onbackorder';

            break;

        case 'OOS':

            return 'outofstock';

            break;

    }

}

And using it in the importer by setting the stock status field to:

[iwphd_stock_map("{/Stock_Info}")]

This will change the value "In Stock" to the woocommerce "instock", and "OOS" to the woocommerce "outofstock"

WOW... Thanks a Million!!!!