Support is online

product availability for non existing products #8438

Open kostas7 opened this topic Thursday, 04 August 2016 ยท 5 replies
Author

Hello,
is there a way to set all products availability to 0 If the products are not in the .xml import file?
Thanks.
Best Regards
Kostas

Support

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.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

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.

Support

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

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

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

Support

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.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Log in to reply to this topic.