Hello,
I wish to import many products with three type of % Tax.
I read that exists a component called CSV Improved butt it seems not work on Joomla 2.5.28 with last VM version (2.x).
I have this error Strict Standards: Only variables should be passed by reference in each operation I do.
Are there others ways to import/export products to/from Virtuemart?
Thanks.
CSVI works just fine on J.5.28 with VM2.6.14 (you can check with Rolandd on http://www.csvimproved.com/en/forum
The standards note is just information - you can suppress this warning, how to do that is mentioned 10s of times on this forum.
Ok. I hided warning alert.
Now, is there a tutorial to know how to import products with different tax?
The CSV I have is a list of store products with the tax in %
It is not a CSV of a previous VM export
That is a question for http://www.csvimproved.com/en/forum and the docs are on http://www.csvimproved.com/en/support/import/203-virtuemart
No. My question is exactly for this forum.
I asked if there were other ways to import this kind of products in VM with components differenti from csvi. Then, I Also asked an info about csvi.
You can code up your own import scripts or try directly importing directly thru DB management (e.g. phpmyadmin)
But at the end of it all you are trying to input data into a bog standard sql database - which csvi does best because it is already set up to do it
So effectively your question is how do I get data into a database.... not really a VM question
Quote from: GJC Web Design on January 17, 2015, 22:45:41 PM
So effectively your question is how do I get data into a database.... not really a VM question
I asked in this forum mainly to know if there are other ways besides CSVI and SQL import via phpmyadmin.
I thought existed a native function in VM or others components but apparently I do not have much choice.
So, thank you for each question ;)
what have u against csvi? It is the tool for the job....
Hi,
I make some experiments with CSVI and I've imported some test products.
Now, my only problem is to know how to apply a % tax to each price because in my csv file I have the %value of the tax and not the tax table id.
This is an example of my csv file
product_sku;product_name;product_in_stock;product_price;TAX_FIELD_???
907002998;PRODUCT TEST1;10;7,75;21
901191092;PRODUCT TEST2;20;7,49;21
906071093;PRODUCT TEST3;30;25,31;10
Please, can you tell mw how to apply tax to the produt price?
Thank you very much
This is a question for Roland at csvi, I know he supports his product extremely well - that is where to ask this question...
To ask in his forum I must to buy a subscription!
They are 15 years that I write on the forums: I never had to pay to have an answer and I've never pretended to be paid to give answers. Thank you for your free and useful support! ;)
Really? - this is new... (only paid forum support)
Roland offers a cheap 10 day subcription to the CSVI forum for those who have not already bought CSVI Pro. I think it is €9.99 and without which the forum is read only. I have noticed that it has considerably reduced the "noise" there because people tend to research their issues and try to find solutions themselves before posting.
Hmm..
The price for CSVI is great though if you need to use it
Not sure you can really ask a question relating to the commercial version of CSVI PRO unless you actually have the product
So paying to ask a question is "funny".
How quickly would VM kill this forum if people had to pay!!
The "free" version has issues with price export, but there is no way to point this out.
a solution could have been that of offer a "VIP" support with rapid answers for those who buy a subscription and a free access to post as happens in many others forums.
So, my issue is to import products which has differents tax.
If someone can/wants to help me to know how realise that is welcome! Otherwise I will have to use MySQL and phpmyadmin to do that...and in my opinion is very very strange that VM has not a native function to import products from a csv whithout to resort to a "free component but with a paid support".
Thank your for each good advice! ;)
Quote from: thebit on January 25, 2015, 17:25:55 PM
a solution could have been that of offer a "VIP" support with rapid answers for those who buy a subscription and a free access to post as happens in many others forums.
http://extensions.virtuemart.net/support here and this forum is the one for free access.
Quote from: thebit on January 25, 2015, 17:25:55 PM
So, my issue is to import products which has differents tax.
If someone can/wants to help me to know how realise that is welcome! Otherwise I will have to use MySQL and phpmyadmin to do that...and in my opinion is very very strange that VM has not a native function to import products from a csv whithout to resort to a "free component but with a paid support".
Thank your for each good advice! ;)
You need to use categories for the taxes and yes use csvi. Why not?
Quote from: Milbo on January 26, 2015, 15:06:16 PM
You need to use categories for the taxes and yes use csvi. Why not?
Because I can not understand how to do that using CSVI (it's my topic question!)
I search in csvi forum but it seems nobody had my issue
I think I solved my issue!
I createa new template of type Example Virtuemart Product Import and I added all products fields and the field product_tax_id which is the tax id that I directly obtained via phpmyadmin.
So, I added a column in my csv file with the id of tax and products importation seems works!
I hope this long topic will be useful to many desperates users as me :D