Resolved export vm product prices

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.

Hi Roland,

Got it, but what field is for price+vat? or in't this possible to change.
Need to export product prices and change to new and import again.

Regards,

Pas

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?
I get all prices without tax in 'salesprice' except 1 (exprement with different shopper group)
Also exported tax id to check differences but these are the same.

Any suggestions...

regards, Pas

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.

Thanks, ill check the settings.
Is it possible to add a new shopper group for all products with different prices using csvi?

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

Thanks,

Pas

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.

Still having trouble exporting the product prices.
I'm using this setting for products in vm.(1)
Set export fields (2)
Result csv (3)

What am I doing wrong?

Thanks,
Pas

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?

Aha, seems the previous import did work
All products have added prices for additional shoppergroups, that's why my csv is wrong.
How can I delete all prices for additional groups?

The price in my csv is wrong see product (looks like rounded without decimals)

Regards,

Pas

Price issue is fixed,

added this to my template settings:
Field Delimiter "
Text Enclosure ; (this was empty)

Now price shows as 4,09 (price without vat)

Also this shows right:

shopper_group_name (empty = default/available for all?)


shopper_group_name_price (default shopper group)
*

Is it possible to delete all other shopper groups and their prices?

Regards,
Pas

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.

Hi Roland,

This will delete all prices, did an export with all products just to be sure to keep a backup
But is it possible to delete just the additional prices?
Right now I have many products with these extra prices and they are not published in the shop.
See screen (vm_prices)

Thanks in advance,
Pas

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.

Hi Roland,

Works fine all additional price are deleted.
BUT when I import the prices it skips the btw setting (vat)
What should I use to set this to my setting?
can I export this also? and how? attached my export test but no tax or tax amount
How should the import look like?

Thanks,
Pas

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.

Hi,
What should be filled in: "product_tax" and "calc_kind" , "BTW" and "21" ?
attached my vat setting.
Was reading this info about calculation:
https://www.csvimproved.com/support/import/203-virtuemart/938-import-virtuemart-calculation-rules

Regards,
Pas

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

Get this error on import:
Duplicate entry '446' for key 'PRIMARY' SQL=UPDATE `glua_virtuemart_products` SET `virtuemart_product_id`='446',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`='',`product_mpn`='',`product_weight`='255.0000',`product_weight_uom`='G',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='4',`product_ordered`='4',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='0',`pordering`='0',`created_on`='2015-03-07 14:07:07',`created_by`='981',`modified_on`='2016-03-02 14:03:50',`modified_by`='977',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='OLP003'
CSVI Pro 6.5.3 | Copyright (C) 2006 - 2016 RolandD Cyber Produksi

Using producit import with this fields:
1 product_sku
2 product_price
3 calc_kind
4 product_tax

Regards, Pas