Resolved Export virtuemart products no data

Hello Rosalie,
Can you post the debug log of the import and also the sample file you tried to import?

Hello Rosalie,

and my csv have no extension... it's nameofmyfile, not nameofmyfile.csv

In the template, you have specified the export filename. Add the .csv there to the filename.

Post the export debug log for us to check.

here'S my log...thanks for helping me

The logfile is not attached, make sure the logfile is zipped before you upload it.

i upload it again...

Hello,

It is not there again. The file shouldn't be that big. Can you try adding the zip file again?

here the zip again

Hello,

Please update to version 6.5.6 (current release) this has fixed the issue you are having with the export.

Hi rolandd

sorry to tell you...I have made the update to 6.5.6 version and it not fixing the issue

I still have an empty file with : No data has been found for the selections made

Do you want an admin to take a look? (you already have it in private message)
thanks for support

Hello Rosalie,

I have taken a look and the export has been fixed, you can export your products now. It also showed me an interesting issue as I logged in with en-GB which is not in use This is something for me to look into for the next release but not an issue as long as you log in with either Canadian French or English.

yeah i have a trouble with too many language and dont know wath to do about that!!!

thanks i will test it today!

Hi Rolandd

yes, it's work. I can export my product name - sku and taxes id

now i have update my taxes in my CSV files and I want to update on the website. I have created an import template with the same fields...

and try an import and have this error:
Duplicate entry '3692' for key 'PRIMARY' SQL=UPDATE `#__virtuemart_products` SET `virtuemart_product_id`='3692',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`='',`product_mpn`='',`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='1',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2016-04-21 13:53:11',`created_by`='68',`modified_on`='2016-04-25 15:13:36',`modified_by`='63',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='ber'

wath I do wrong?

Hello Rosalie,
The error says that you have duplicate entries in your `#__virtuemart_products` table with virtuemart_product_id 3692. If you know how to do, go to phpmyadmin, look for table `#__virtuemart_products` and on the SQL tab, paste the below query and click Go. Dont forget to replace #_ with your table prefix before running the query. How many rows do you see?

 Select * from #__virtuemart_products where virtuemart_product_id=3692

Hi

It give me only one with this product id...
Showing rows 0 - 0 (1 total, Query took 0.0119 seconds.)

Hello Rosalie,

I am afraid Tharuna made a mistake in the query. The correct query is:

Select * from #__virtuemart_products where product_sku ='ber'

. You can also see this I think when you go to the product list in VirtueMart and filter on this SKU. The SKU must be unique.

2 products with this sky...you are right it's not suppose to be like that.

thanks for support.

ok

so now i dont have anymore product in double with same sku...I try to update applicable taxes on product and it change nothing...

import is a success but when i open product to see if taxes id 1-2-5 are apply, no taxes are apply.

my fields are
1 product_sku
2 product_tax
3 product_tax_id
4 product_name

I try with the virtuemart price import exemple

I have 2 taxes and product where no taxes add to be apply (-1)

Hello Rosalie,
To use CSVI price import there are few fields which are required and based on these CSVI will insert or update a product price. You CSV file don't have those required fields and so no update has happened. Have a look at the Virtuemart product price import document to know the fields you are missing.
Also, i see that you have two fields product_sku and product_tax_id in your CSV file, generally price template is used when multiple prices for a single product needs to be inserted or updated. Since that is not your case, i think you can use Virtuemart product import template instead of price template.