Categories
View Replies (8)

Resolved Import different prices for different shopper groups

  1. jabba84
    jabba84
  2. RO CSVI
  3. Friday, 22 September 2017
  4.  Subscribe via email
Hello! I've set up an import for virtuemart (basic virtuemart) and works very well. This is the actual structure:

product_sku,product_name,product_s_desc,category_path,product_price,published,product_special,file_url,product_weight,product_weight_uom

Now the client asked me to improve the catalog, so i need to add those fields:

VAT
SECONDARY CATEGORY
PRICE FOR SHOPPER GROUP

I have 5 VAT with these IDs:
1. 2%
2. 5%
3. 10%
4. 13%
5. 22%

Questions are:

1) how do i change my CVS structure? product_price is the price without tax? Or is the final price? What's the difference with product_basePriceWithoutTax or product_priceWithoutTax ? And this is the default value? For the default shopper group?
2) The VAT is added with product_tax or taxamount ? And i have to put the ID or value?
3) Now the category separator is # , how do i set the 2nd category? So a product is placed in category 1 and category 2? Like the images with | ?
4) How do i add the price for a second shopper group?

Thank you very much!
0
Responses (8)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
1) how do i change my CVS structure? product_price is the price without tax? Or is the final price? What's the difference with product_basePriceWithoutTax or product_priceWithoutTax ? And this is the default value? For the default shopper group?

All the prices stored in VirtueMart are excluding tax, you need to import product_price and product_tax to get tax added to your price and along with shopper_group_name. Have a look at VirtueMart Product import document.
Also not sure where you see the fields product_basePriceWithoutTax and product_priceWithoutTax, can you tell me where you get these fields from? As much as i can tell pricewithouttax is field supported only used in CSVI export.

2) The VAT is added with product_tax or taxamount ? And i have to put the ID or value?

VAT is added to product_tax, you can set the value to your product_tax as 5% or 10%.

3) Now the category separator is # , how do i set the 2nd category? So a product is placed in category 1 and category 2? Like the images with | ?

You can import multiple categories like category1|category2|category3 same like images.

4) How do i add the price for a second shopper group?

You can have multiple shopper groups separated by | like shoppergroup1|shoppergroup2|shoppergroup3 for a price in VirtueMart product import but if you are looking at importing multiple price for multiple shopper group then you need to use VirtueMart price import.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
jabba84
jabba84
Accepted Answer Pending Moderation
Hello and thank you for your answer!


All the prices stored in VirtueMart are excluding tax, you need to import product_price and product_tax to get tax added to your price and along with shopper_group_name. Have a look at VirtueMart Product import document.


So, for example i have to do this:

product_sku,product_price,product_tax
123,10,20%

and it set the VAT tax as 20%. Do i have to create it before or it is created automatically as i import the products?

See attachment: Cattura.JPG

20% will go in the red box. But how do i keep the blue box empty: like "apply no rules"?

Also not sure where you see the fields product_basePriceWithoutTax and product_priceWithoutTax, can you tell me where you get these fields from? As much as i can tell pricewithouttax is field supported only used in CSVI export.


You are right, i found them in maintenance -> aviable field but were under the export label. My mistake



You can have multiple shopper groups separated by | like shoppergroup1|shoppergroup2|shoppergroup3 for a price in VirtueMart product import but if you are looking at importing multiple price for multiple shopper group then you need to use VirtueMart price import.


So i have to add an additional line for each product. I can create a product import and then a price import?
Something like:

product_sku,product_name,product_s_desc,category_path
123,"name","desc","category"

then

product_sku,product_price,product_tax,shopper_group_name
123,20,22%,"group A"
123,10,22%,"group B"

in the same CSV prize file.
Is this correct?

Thank you again!
Attachments (1)
Cattura.JPG Cattura.JPG
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
So, for example i have to do this:

product_sku,product_price,product_tax
123,10,20%

and it set the VAT tax as 20%. Do i have to create it before or it is created automatically as i import the products?

Yes, your example looks correct for product tax. If you don't have the tax created CSVI will create it automatically during import.

20% will go in the red box. But how do i keep the blue box empty: like "apply no rules"?

If you don't include product_discount field in your import this will be default set to "apply no rules"

So i have to add an additional line for each product. I can create a product import and then a price import?

Yes, you can do that.


Something like:

product_sku,product_name,product_s_desc,category_path
123,"name","desc","category"

then

product_sku,product_price,product_tax,shopper_group_name
123,20,22%,"group A"
123,10,22%,"group B"

in the same CSV prize file.
Is this correct?

Yes at first glance the CSV file looks good. If you have any issues during import you can post your import debug log and we can check it for you. To know on how to get the debug log check the blue box on top of this page.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
jabba84
jabba84
Accepted Answer Pending Moderation
Thank you very much!
I'll let you know,
Gianluca
  1. more than a month ago
  2. RO CSVI
  3. # 4
jabba84
jabba84
Accepted Answer Pending Moderation
Hello! I've made everythig we talked about and it's all ok. I can import different prices for different groups.
Only think i can't understand is how VAT works.
In "PRICE IMPORT" template there is no product_tax, which is only in the "PRODUCT IMPORT" template.
It means that i have to add the VAT in product CSV and only the prices in the prices CSV?
I've seen that in the "PRICE IMPORT" template is presente a price_tax_id but don't know how it works.. i do need to create the VAT values in advance and write the ID in the CSV?
Thank you!
Gianluca
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Gianluca,

It means that i have to add the VAT in product CSV and only the prices in the prices CSV?
With multiple prices that is a little difficult. As you said, you can use the product_tax_id field.

i do need to create the VAT values in advance and write the ID in the CSV?
The tax rates are already in your shop right? Usually a country has no more than 2 or 3 different tax rates. In Italy I believe it is 22% for luxury products. If you go to Products -> Taxes and Calculation Rules you can find your tax rates there. The ID is in the last column, that is the ID you can use.

Let me know if that helps.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
jabba84
jabba84
Accepted Answer Pending Moderation
It works, thank you!
Now I still have a problem with "apply no rules".. if i don't put the filed at all the products remains with "apply generic rules" which uses all the possibile rules and discount (and this is stupid from Virtuemart itself..). Is there a way to force the "apply no rules"?
Thank you!
Gianluca
  1. more than a month ago
  2. RO CSVI
  3. # 7
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Now I still have a problem with "apply no rules".. if i don't put the filed at all the products remains with "apply generic rules" which uses all the possibile rules and discount (and this is stupid from Virtuemart itself..). Is there a way to force the "apply no rules"?

You need to set product_discount_id field to '-1' in your import file. That is the value VirtueMart saves for Apply no rules option.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!