Resolved Only 1 Product gets exported

Hello,
Can you post your export debug log to check? To get the debug log check How to get debug information? document.

Hello,

no problem, here it comes.
Send it to you via PM

Greetings

Hello,
Thank you for sending the debug log. From what i see in your debug is that you have set Include sub categories filters to yes and CSVI is trying to export products for all the parent and child categories. Your products are assigned to categories? If the products are not exported then only possible way i could see is that they are not assigned to any category.

Hi,

thanks for the help.
How can i edit it to get all products from all categorys?
I now set include subcategorien to no and category filter to do not use
Now it get another different product but still only one product in liste.

I wonder because any product has at least one category.
Hope you can help to get a full list of all products.

Greetings

Hello,
Can you post your latest export debug log? Also can you do a VirtueMart product export with fields product_sku, category_id and category_path and send the exported CSV file? Also tell me the product_sku of the one product which was exported.

Hi Tharuna,

is send you csv export and newest log for Forum Posting
https://csvimproved.com/forum?view=topic&catid=44&id=34601

I selected Categorpath and Category ID as well, but i dont see them in Export file.

Greetings Alex

Can i post Error log here in Forum?

I dont want that to see other people.

Greetings

Note: If i change the ordering of the export products, another product gets exported, but it is always only 1 product in the list.

Greetings

Hello Alex,

I selected Categorpath and Category ID as well, but i dont see them in Export file.

Check the language set in your import template on Options tab. Could be possible that you are exporting from a wrong VirtueMart language table. But this also makes me think if your products have category assigned. When you check the product on VirtueMart page, do you see category assigned to them?

Can i post Error log here in Forum?

I dont want that to see other people.

You can send it as a private message or email it to tharuna@csvimproved.com.

Note: If i change the ordering of the export products, another product gets exported, but it is always only 1 product in the list.

Will look into your latest debug log and let you know on what i find.

Hi there,

changed the language does not work. I get an error "you dont have En Gb Database" so i changed back to german.

Yes all products have more than one categories. I can see this in frontpage.

I send you the debug report right now.

Hope you can help to solve this. I can give you login as well, because it is my test stage only.
Greetings

Hello,

I send you the debug report right now.

How did you send it? I did not get it.

Hope you can help to solve this. I can give you login as well, because it is my test stage only.

You can send the login details with Private message or email to the address as above.

Hi,

debug report via email and login via pm was send.

Greetings

Hello,
Thank you for sending debug log and the administrator access. I logged into your site and had a look at VirtueMart by going Components >> VirtueMart >> Products page and i do not see any products in there. Why is that so? If i do a product export i see only one product with SKU 753.140410.121257. Wonder where this product is coming from when there are no products on VirtuMart Products page.

Hi tharuna,

yes... you must know our virtuemart is full customs for vendors.
So any products has his own vendor and the site itself is not the vendor.

So in Product overview you have to set vendor to empty (bitte wählen) to see all products.
It is the right panel to select where the pagename stands.
Then press Go to see all products.

Hope it help.
Greetings..

Hello,
Yes that helped. I don't see any reason for your products not exporting. Can you run the below query in phpMyAdmin and check how many rows you see there? Select your database, click on SQL tab, copy and paste the below query and click Go. Don't forget to replace #_ with your table prefix before running the query. If you are finding this difficulty, do send me the phpMyAdmin details on Private message and I will check it in there.

SELECT `#__virtuemart_products`.`virtuemart_product_id`,

`#__virtuemart_products`.`product_parent_id`,

`product_sku`,

`#__virtuemart_product_categories`.`virtuemart_category_id`

FROM `#__virtuemart_products`

LEFT JOIN `#__virtuemart_product_prices` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_prices`.`virtuemart_product_id`

LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id`

LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id`

LEFT JOIN `#__virtuemart_product_categories` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_categories`.`virtuemart_product_id`

LEFT JOIN `#__virtuemart_currencies` ON `#__virtuemart_currencies`.`virtuemart_currency_id` = `#__virtuemart_product_prices`.`product_currency`

LEFT JOIN `#__virtuemart_product_shoppergroups` ON `#__virtuemart_product_shoppergroups`.`virtuemart_product_id` = `#__virtuemart_products`.`virtuemart_product_id`

GROUP BY #__virtuemart_products.virtuemart_product_id

Hello,

ok no problem, it gets me the following error:

#1055 - Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'XXX_virtuemart_product_categories.virtuemart_category_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

I removed #_ with the correct tag.

Greetings

Hello,
That error is because of using MySQL 5.7 version. Can you run the below query and check? Same as above replace the table prefix before running the query.

SELECT `#__virtuemart_products`.`virtuemart_product_id`,

`#__virtuemart_products`.`product_parent_id`,

`product_sku`,

`#__virtuemart_product_categories`.`virtuemart_category_id`

FROM `#__virtuemart_products`

LEFT JOIN `#__virtuemart_product_prices` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_prices`.`virtuemart_product_id`

LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id`

LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id`

LEFT JOIN `#__virtuemart_product_categories` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_categories`.`virtuemart_product_id`

LEFT JOIN `#__virtuemart_currencies` ON `#__virtuemart_currencies`.`virtuemart_currency_id` = `#__virtuemart_product_prices`.`product_currency`

LEFT JOIN `#__virtuemart_product_shoppergroups` ON `#__virtuemart_product_shoppergroups`.`virtuemart_product_id` = `#__virtuemart_products`.`virtuemart_product_id`

GROUP BY #__virtuemart_products.virtuemart_product_id, `#__virtuemart_products`.`product_parent_id`,

`product_sku`,

`#__virtuemart_product_categories`.`virtuemart_category_id`

Hi Tharuna,

first of all, thanks for the great support.
I now get 25 results from your query.

I Post a Screenshot here.


Greetings and thanks for help.

Hello,
You must be seeing more rows with query, the first page shows 25 rows as page display limit is 25. With the screenshot it is confirmed that export query is not having any problem in fetching the records from database but when writing to export file, it writes only one record. Two things we can check here.

1. Can you check if there is any error on your server error log? I know there is no error shown on export but we need to find why one record is being written to export file. Just wanted to check if there is any error logged in server error logs.
2. Can you also check the export with another fresh Joomla instance and only CSVI Pro installed?

Hello,
We did not hear back from you on the issue. Was your issue solved? If yes, Can you tell us how you solved it?