HI
I'm Sorry, I really try by myself to make it work...and found solution...
I want to export, all my product (to check taxes)
and it's not working. No data have been found for the selection made.
and my csv have no extension... it's nameofmyfile, not nameofmyfile.csv
so, I have a joomla 3.5.1 virtuemart 3.0.14(multilangual) and csvi pro 6.5.5
I also have a debug log.
I have only 4 fields
1 product_sku
2 product_tax
3 product_tax_id
4 product_name
and i need help...waiting to understand and change this to go online...
thanks for support
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
here'S my log...thanks for helping me
The logfile is not attached, make sure the logfile is zipped before you upload it.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
Hello Rosalie,
Can you post the debug log of the import and also the sample file you tried to import?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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 importdocument 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.
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.