1. soura123
  2. RO CSVI
  3. Wednesday, 18 February 2026
  4.  Subscribe via email
i found a but when the option to unpublish before import is set to yes all products stay to unpublished on the latest version of csvi
Accepted Answer
Accepted Answer Pending Moderation
Hello,
As per the debug log products in import file are set to published. See query from debug log and check published field in the query set to 1


UPDATE `vsh026_virtuemart_products` SET `virtuemart_product_id`='19485',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`='',`product_mpn`='',`product_weight`=NULL,`product_weight_uom`='G',`product_length`=NULL,`product_width`=NULL,`product_height`=NULL,`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`product_stockhandle`='0',`low_stock_notification`='0',`product_available_date`='2026-02-18 00:00:00',`product_availability`='Διαθέσιμο από 4 έως 6 ημέρες',`product_special`='0',`product_discontinued`='0',`product_sales`='0',`product_unit`='G',`product_packaging`=NULL,`product_params`='min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|shared_stock=0|product_box=\"\"|',`product_canon_category_id`='0',`hits`='0',`intnotes`='',`metarobot`='index, follow',`metaauthor`='',`layout`='default',`published`='1',`pordering`='0',`has_categories`='1',`has_manufacturers`='1',`has_medias`='1',`has_prices`='1',`has_shoppergroups`='0',`created_on`='2026-02-18 06:32:12',`created_by`='62',`modified_on`='2026-02-18 15:11:29',`modified_by`='62',`locked_on`=NULL,`locked_by`='0' WHERE `product_sku` = '65.094.0040403'


when i run th eimport with the option to yes it published the unpublished items the the option did
when i enable the option they stay unpublish

I am not able to follow the issue here. Can you explain?

Also I would recommend to update to RO CSVI 9.5.2 version and check the import. There were some important fixes included with this version. They are not related to Unpublished before import option but still would ask to update and check the import.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.