Resolved export vm product prices

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.

Hi Roland guess i'm almost their...
Duplicate sku are because of 2 shoppergroups.
Removed these and uploaded this test;
product_sku product_price product_tax calc_kind
OLM009 5,37 21 VatTax

But this adds a new price for same shoppergroup but without BTW (tax) set??
What should I add to update product price.

Using this on product import:
"product_sku";"shopper_group_name";"product_currency";"product_price";"product_price_new";"product_tax";"calc_kind"

Note "Shopper_group_name" on my export is blank? should I leave it blank on import or use *

Thanks, Pas

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?

Man this is confusing....

I'm using this on price import to change current price:
product_sku shopper_group_name product_price product_currency product_price_new
OLM009 * 4,92 EUR 5,37

This adds a new price to my product
My vm product setting looks like this (attached);
What should I use to change the price to group 'Voor iedereen beschikbaar'

Thanks for your patience.

Pas

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.

Hi Roland,

Shopper_group_name_price it is!!

My templates right now:

VM Product export:
1 product_sku
2 category_name
3 product_name
4 product_price
5 shopper_group_name
6 shopper_group_name_price
7 taxamount
8 product_tax_id


VM Product import:
1 product_sku
2 product_price
3 shopper_group_name
4 product_currency
5 shopper_group_name_price
6 product_tax
7 calc_kind

Works without errors but this adds a new BTW (VAT) 'CSVI created tax rule'
Also the 'Shopper_group_name' is blank if I export again.
See screens.
What should I do to change price the right way, without adding new?

Thanks, Pas

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.

Hi Roland,

Attached the logs (export and import)
I'm added a user group but not using this. (screen)
This should be used if all works right.
1 group for all users (particulier)
2 group for business (winkeliers) with different prices after login.
Hope this helps a bit.

Thanks,
Pas

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.

Roland,

I did create a new shopper group in vm settings, but no product or price is set!
Also Price import can't set 'VAT' or 'shopper_group_name_price'? Right?

My export is this:
1 product_sku
2 category_name
3 product_name
4 product_price
5 shopper_group_name
6 shopper_group_name_price
7 taxamount
8 product_tax_id

Right now I created a new template vm price import;
1 product_sku
2 product_price
4 shopper_group_name
5 product_currency
6 product_price_new

Attached the product price on export and after import.
The csv files (export and import)
Also attached the log files. Going nuts.

Regards,
Pas

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.

Hi Roland,

Got it! Work perfect, done in minutes
My import looks like this;
product_sku, product_price, shopper_group_name, product_currency, product_price_new, product_tax_id

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'?

Thanks,

Pascal

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.

Thanks, tried different options but without success.
product setting is as screen 1
shoppergroup 'Winkeliers' is configured.
Setup csv (screen2) to add the new price for 'Winkeliers' group.

What am i doing wrong.....

Thanks, Pas

Hello Pas,

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

Hi Roland,

It should look like this, so add a price for shoppergroup 'winkeliers'.

Regards,

Pas

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?

Hi Roland,

I'm using price import template.
Only question is; how do I setup my csv file to 'add' a 'new price' for shoppergroup 'winkeliers'?
Right now only 1 price is set so I want to add a new price.
The support info is about: change, update or delete prices...
Don't know if I should use 'shopper_group_name_new', 'product_price_new' because the price is not set yet.

Hope this helps a bit, can send log files but my tests just changes current price and shoppergroup so guess this makes it even more confusing.

Regards,
Pas

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.

Hi Roland,
Yes it's working!!! Thanks for your patience!

Regards,
Pas