export vm product prices #8046

Hello Pascal,

What template (csv / vm) to choose to get these fields.

Look at the Visual Available Fields for Product pricing.

Is there a manual for this.

There is no specific manual for these 3 fields, but there is a manual on how to create a template.

You said it yourself already, export product. So you will need to create a template with the operation to export VirtueMart Products.

Hello Pas,

The salesprice field is the price including tax for export and price_with_tax for import. You must also include the product_tax on import otherwise CSVI can't calculate the price excluding tax.

hmm, is this price incl. tax related to shopper group?

That depends on your settings in the template. There is a Customer shopper group option in which you can set the shopper group used for price calculations.

CSVI doesn't calculate the prices itself, VirtueMart does that but CSVI does pass on the shopper group to calculate the prices for. If no shopper group is chosen, it will be calculated as a non-logged in visitor.

If your prices all have the same tax rate, you could also multiply the base price with the tax rate in the spreadsheet.

Hello,

Is it possible to add a new shopper group for all products with different prices using csvi?

You can do this using Virtuemart price import

My guess:
Export products shoppergroup x
Change shoppergroup name and prices in excel
Upload csv

You can do this but dont forget to add fields product_price_new and shopper_group_name_new in your import file to change shoppergroup and product price. This is explained in the above linked documentation.

Hello,
The shopper_group_name in your Virtuemart setting seems to be different from the one seen in your CSV file. Do you have filters set for the export? Whats is the price you see in CSV file for the product you have shown in Virtuemart settings?

Hello Pas,

You can delete all product prices via the Maintenance menu. Choose VirtueMart first and then delete prices in the second dropdown.

Hello Pas,
Please note that Roland's solution will delete all prices and clean up the price table and not any specific shopper group prices, You can clean up the prices and do a fresh import.

Hello Pas,

But is it possible to delete just the additional prices?

That is possible but not via the maintenance menu. You will need to do a price import (not a product import) and use the price_delete field. The documentation at Import VirtueMart prices has a section on how to delete prices.

Hello Pas,

What should I use to set this to my setting?

The field product_tax is what you need to import with your products and in addition the calc_kind field if your tax rule is not of the kind Tax. This way CSVI can find your calculation rule for tax. Alternatively you can use the product_tax_id but then you need to make sure yourself the database ID is correct so this is not recommended but it is an option.

Hello Pas,
Your product_tax should be 21 and calc_kind will be 'VatTax'.

Hello Pas,

This error means that you have more than one product SKU called OLP003. Each SKU must be unique, so check which one (or others) is/are obsolete and remove those.

The primary key 446 is assigned to another product apparantly.

Hello Pas,

guess i'm almost their...

Sure am :)

But this adds a new price for same shoppergroup but without BTW (tax) set??

Without the debug log I can't tell why that does that.

Note "Shopper_group_name" on my export is blank?

That is the shopper group for the product, the shopper group for the price is called shopper_group_name_price. Perhaps you used the wrong field?

Are you using shopper groups for products?

Hello Pas,

I will need to have the debug log to understand what is going on. Only thing that is for sure, is that CSVI isn't finding your existing price. We just need to find out why that is.

As for the shopper group 'Voor iedereen beschikbaar', this is the default group for everybody I think. So the * should be fine.

Hello Pas,

Will ask you again for the debug log of the import that creates the tax rule. Without it I can't give you any feedback as I can't see what is going on.

Also the 'Shopper_group_name' is blank if I export again.

Going to ask you again as well: Are you using shopper groups for products?

What should I do to change price the right way, without adding new?

If you only use a single price per product, your template is fine. Before you ask why it is creating a new price instead of updating it, that is because it can't find the existing price and we need to see why that is.

If you are using multiple prices per product with different shopper groups, you will need another template for the price import.

Hope that is clear.

Hello Pas,

This should be used if all works right.
1 group for all users (particulier)
2 group for business (winkeliers) with different prices after login.

Ok, this clears up a lot and is exactly what I wrote in my previous message, you will need another template for importing prices. You cannot manage multiple prices with the product import. The product import only deals with a single price for a product.

The debug log doesn't show adding any new prices but it is also much longer than the one product you posted here. The SKU OLM009 is not in the debug log. Regardless of that, first you need to make an import template for the product prices. How to do that and what is needed is explained in the Import VirtueMart prices document. There is also an example for using multiple shopper groups and how to change prices.

So my suggestion is to create this import template, test it out with 1 product and see how it goes. If it doesn't do what you want, post the debug log and the file you tried and we can take it from there.

Hello Pas,

The template you created looks fine. The issue is with your shopper groups, you are using the wrong name. You will notice that after the import the shopper group on the price is different. Your first price has a shopper group of -default- and your second price has a shopper group set to Voor iedereen beschikbaar. With 2 different shopper group names, CSVI will add the price instead of updating the existing one. If you want to update the existing one, you will have to set the shopper group to -default-.

Also Price import can't set 'VAT' or 'shopper_group_name_price'? Right?

If you look at the list of available fields for the price import you will see there is the product_tax_id field. This you can use for linking the tax rule. You will need to use the ID value for that. This is the value in the ID column on the Taxes & Calculation rules page.

As for the shopper_group_name_price, no this field is not available as it is just called shopper_group_name because you are already doing prices. This field is ignored in your import file because it doesn't exist.

Hello,

Last issue;
I set a new shoppergroup 'winkeliers'
No prices are set to any product yet, can I simply use above import without mentioning a product_price and change 'shopper_group_name' to 'winkeliers'?

If you are trying to update product price, you need to use shopper_group_name_new field to set to a new shoppergroup. If its new price import you can use shopper_group_name field.

Hello Pas,

Let's get one thing cleared up, are you trying to set the shopper group on the product or on the price?

Hello Pas,

OK, we are talking about the shopper group for prices. One thing you need to know, you will have to use the price import for handling multiple prices but that is clear I believe.

You are adding a new price for the "Winkeliers" so there is no need for the product_price_new field. You said you had no luck getting it to work but didn't mention what is going wrong or posted the debug log. So it is nearly impossible to guess what is going wrong.

The other idea I have is that you may be wanting to change the existing price with a new shopper group and a new price but that isn't clear either.

Can you elaborate in more detail of what you are trying to achieve?

Hello Pas,

Only question is; how do I setup my csv file to 'add' a 'new price' for shoppergroup 'winkeliers'?

That is clear.

Don't know if I should use 'shopper_group_name_new', 'product_price_new' because the price is not set yet.

You don't need these fields because you are adding a new price.

The fields you can user are:
"product_sku";"shopper_group_name";"product_currency";"product_price";"product_tax_id"

That should be enough to add a new price for a new shopper group.