Resolved Number of pictures [virtuemart][BUG][csvi9.1]

Hello,

I tested the Export state field. If I select

- ALL: just unpublished products are displayed. (real bug)
- Unpublished: unpublished products are displayed.
- Published: only published products are displayed.

Ok, I was able to see this issue. Please load the attached patch file and check the export. Let me know on how that goes.

Hello,
Please post export debug log to check. To get the debug log see How to collect debug information? document.

I solved the problem with the non-functioning image limit myself. Set to 10:

$images = array_slice($images, 0, 10);

I found another bug. I have 2354 products in the Virtuemart database. When I export the full list of products in XML format for the Google Merchant template, or when I export from the price template, etc., I get the full list, but...

When I use the traditional export template for the Virtuemart component, Operation -> Product, export type -> CSV, Template fields -> product_sku, virtuemart_product_id
It just exports 365 products. I used the old export templates, created a new clean one - each time the export is the same.
This is not a browser cache issue.

For the time being, I will have to revert to the older version of CSVI 8.
I tested the same case on other websites – the result is similar. In some domains, the product export returned just 4 random products, even though there are hundreds of them. The export of Virtuemart products simply does not work as it should.

If you want to test this export, I can give you access to my server.

Hello,

I solved the problem with the non-functioning image limit myself. Set to 10:

Posting debug log would have helped me to find if it is a real bug. So I still request you to post the debug log to check.

When I use the traditional export template for the Virtuemart component, Operation -> Product, export type -> CSV, Template fields -> product_sku, virtuemart_product_id
It just exports 365 products. I used the old export templates, created a new clean one - each time the export is the same.
This is not a browser cache issue.

Debug log shows that you are exporting unpublished products. In export template on File tab check Export state field. That is set to Unpublished and so export gets only those products. Set this to All and save the template. Run the export and check.

Hi tharuna

Debugging only shows the end result—I don't think that adds much.

I already wrote earlier – you have an error in the forms. Some fields in these forms are simply dead – this data is not passed to the function that generates the export. If, in my case, I selected the “-ALL-” option, I should see all products – published and unpublished.

The same applies to images—if I specify that I want to display a maximum of 10 photos, it does not work—all of them are displayed.

Hello,

I already wrote earlier – you have an error in the forms. Some fields in these forms are simply dead – this data is not passed to the function that generates the export. If, in my case, I selected the “-ALL-” option, I should see all products – published and unpublished.

That is correct. All should get both published and unpublished products in export. But in the debug log posted I see query filters records with unpublished products. See the query below from debug log. It has a where condition filtering products which are unpublished. Is this the right debug log then?

SELECT `ucray_virtuemart_products`.`virtuemart_product_id`,

`ucray_virtuemart_products`.`product_parent_id`,

`ucray_virtuemart_products`.`product_sku`

FROM `ucray_virtuemart_products`

LEFT JOIN `ucray_virtuemart_product_prices` ON `ucray_virtuemart_products`.`virtuemart_product_id` = `ucray_virtuemart_product_prices`.`virtuemart_product_id`

LEFT JOIN `ucray_virtuemart_product_manufacturers` ON `ucray_virtuemart_products`.`virtuemart_product_id` = `ucray_virtuemart_product_manufacturers`.`virtuemart_product_id`

LEFT JOIN `ucray_virtuemart_manufacturers` ON `ucray_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `ucray_virtuemart_manufacturers`.`virtuemart_manufacturer_id`

LEFT JOIN `ucray_virtuemart_manufacturers_pl_pl` ON `ucray_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `ucray_virtuemart_manufacturers_pl_pl`.`virtuemart_manufacturer_id`

LEFT JOIN `ucray_virtuemart_product_categories` ON `ucray_virtuemart_products`.`virtuemart_product_id` = `ucray_virtuemart_product_categories`.`virtuemart_product_id`

LEFT JOIN `ucray_virtuemart_currencies` ON `ucray_virtuemart_currencies`.`virtuemart_currency_id` = `ucray_virtuemart_product_prices`.`product_currency`

LEFT JOIN `ucray_virtuemart_product_shoppergroups` ON `ucray_virtuemart_product_shoppergroups`.`virtuemart_product_id` = `ucray_virtuemart_products`.`virtuemart_product_id`

WHERE ucray_virtuemart_products.published = 0

GROUP BY `ucray_virtuemart_products`.`virtuemart_product_id`

ORDER BY `ucray_virtuemart_products`.`product_sku` ASC

The same applies to images—if I specify that I want to display a maximum of 10 photos, it does not work—all of them are displayed.

I requested for debug log twice and still haven't got it. May I ask if you are using file_url field or picture_url field in export? We have picture limit only on picture_url field and not on file_url field. So if you are using file_url field you will see all images displayed. I would have got these details from debug log and so have been asking for it.

I tested the Export state field. If I select

- ALL: just unpublished products are displayed. (real bug)
- Unpublished: unpublished products are displayed.
- Published: only published products are displayed.

So if you are using file_url field you will see all images displayed.

This answer resolves my doubts - Yes, I use file_url. I wanted a clean address for images — and now I understand the problem. Thanks for explaining.

Thanks—that patch solved the first problem.

There is one more thing to fix. There is a problem with prices. If products do not have prices (0 or null), an error occurs.

{"error":true,"code":0,"message":"Division by zero"}

This can be temporarily circumvented by setting a simple rule in the export template – minimum value for prices: 1

But this does not solve the problem of exporting children's products, which should inherit prices from the parent product in exports.

Kind regards,
Chris