Resolved product availability for non existing products

Hello Kostas,
There is no direct way of doing this as CSVI needs product_sku to update a record. One option is, you can set "Unpublish products before import" to Yes in template settings, this will unpublish all the products before doing the import and when you import the XML file, the product_skus in the XML file will be published. Note that all other products will remain unpublished. Another option is, you can export all the product_skus, set product_availability to 0 and do an import so all product's availability will become 0. Now when you import the XML file, the products with availability will be updated.

Hello Tharuna,
"One option is, you can set "Unpublish products before import" to Yes in template settings"
Not all of my import templates have this option.
Do you know how to included it in import templates?
Thanks.
Best Regards,
Kostas.

Hello Kostas,
Since you spoke about products i thought it was VirtueMart product import. Can you tell me which import you are using?

Hello Tharuna,
I use virtuemat product import but probably I do some mistake with settings.
My template use this fields.
Ordering Field name
0 product_currency
1 product_sku
6 product_price
9 product_in_stock
Thanks.
Best regards.
Kostas

Hello Kostas,
The "Unpublish before import" option is not related to your template fields, Go to templates page, click on your import template name, on Options tab look for "Unpublish before import" option and set it to yes. If you dont see it click on Advanced button on top right corner to see it.