[SOLVED] How to import products with different types of Tax?

[thebit]

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.

[jenkinhill]

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.

[thebit]

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

[jenkinhill]

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

[thebit]

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.

[GJC Web Design]

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

[thebit]

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

[GJC Web Design]

what have u against csvi? It is the tool for the job....

[thebit]

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

Code Select Expand


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

[GJC Web Design]

This is a question for Roland at csvi, I know he supports his product extremely well - that is where to ask this question...

[thebit]

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!

[GJC Web Design]

Really?  - this is new... (only paid forum support)

[jenkinhill]

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.

[AH]

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.

[thebit]

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!