1. pascal_pasvorm
  2. RO CSVI
  3. Monday, 17 September 2018
  4.  Subscribe via email
Hi,
Is it possible to use csvi like this:
- export categories, products, descriptions, images, etc from 2.5 joomla + virtuemart site
- update 2.5 joomla + virtumart to latest version
- remove all vm data
- import virtuemart categories, products, descriptions, images, etc to clean/empty virtuemart.
Also using custom filters and custom fields for all from breakdesign
This way I can clean up lots of old issues and use a fresh virtuemart.

Thanks in advance.
Pascal
Accepted Answer Pending Moderation
Hello Pascal,
Yes, you can use CSVI for moving your old VirtueMart data to a new version. I would suggest you to create a fresh test site with latest Joomla and VirtueMart. You can now move VirtueMart data from your old site to new site using CSVI. Once you feel everything is Ok with your test site, you can make it as a live site or move the data from fresh test site to old site after updating VirtueMart in your old site.
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
Accepted Answer Pending Moderation
Hi Tharuna,
Thats great....what would be the best way to do this?
Can I use 1 export template to get all data at once or should this be done with multiple export templates?
As mentioned using custom filters and custom fields on all products.

Hope you can tell me what the best approach is.

Regards,
Pascal
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Pascal,
You need to create one export template for each of the operation. So you would need Category export template, Manufacturer export template, Products export template , Userinfo export template and Orders export template. You can export custom fields for all in Products export operation. For custom filters you need to install CSVI Custom filters addon to export and import the custom filters.

Same goes for import, create one import template for each of the operation and use the exported file to import data back. This way you are organised with your export and import and its easy to find issues when things go wrong.
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
Accepted Answer Pending Moderation
Hi Tharuna,

Thanks, been testing with different templates, got one for categories and one for products.
Because only half of the products had sku, I also used virtuemart_product_id.

Now I only need to change the product prices to a different setup (was catalog mode, now shop)


What I have is basepricewithtax, product_override_price, product_tax_id, virtuemart_product_id
Is this enough to change this? using default shopper group and 1 currency.
Or are these also required; price_quantity_start, price_quantity_end

Thanks,
Pascal
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Pascal,
Thanks, been testing with different templates, got one for categories and one for products.
Because only half of the products had sku, I also used virtuemart_product_id.

There is nothing wrong in using virtuemart_product_id field if there is no sku. Just that we dont recommend use of fields ending with _id as they are handled by database.

What I have is basepricewithtax, product_override_price, product_tax_id, virtuemart_product_id
Is this enough to change this? using default shopper group and 1 currency.
Or are these also required; price_quantity_start, price_quantity_end

When selecting a price row from database, CSVI uses few needed fields and price_quantity_start, price_quantity_end are among them. If you don't have values stored for your product prices for price_quantity_start and price_quantity_end fields in your database then you don't really need them in your import file. CSVI uses Null value for these fields if they are not in import file.

If you are having any issue with import, post the debug log and import file to check.
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. # 5
Accepted Answer Pending Moderation
Thank you,
Tried to use price import with these fields:
product_override_price
product_price
virtuemart_product_id
product_tax_id
price_quantity_start
price_quantity_end
shopper_group_name

But got this message: COM_CSVI_AREA_Price Skipped 1
Any idea...

Thanks,
Pascal
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Pascal,
Can you attach the debug log and your import file? You can check How to get debug information? document to get the debug log.
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. # 7
Accepted Answer Pending Moderation
Hi Tharuna,

Been testing with product export and import with product prices, tax, currency, shopper group.
This works fine.

But I don't know what to use to export/import these settings in products 'Override' and 'Overwrite final'.
I use these:
basepricewithtax product_override_price product_price product_tax_id shopper_group_name product_currency

Attached a screen of the vm product price.

Regards,
Pascal
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello Pascal,
But I don't know what to use to export/import these settings in products 'Override' and 'Overwrite final'.

You need to use field name override in your import/export template. To set to disable status override field value should be set to 0, to set to Overwrite final, override field value should be set to 1 and to set to Overwrite price to be taxed override field value should be set to -1 in your import file. Let me know if this helps.
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. # 9
Accepted Answer Pending Moderation
Thanks Tharuna,
This works better, last question I want to set override price, I import product_override_price?
But this is still empty. Is this the wrong field or something else.

Thanks,
Pascal
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello Pascal,
This works better, last question I want to set override price, I import product_override_price?
But this is still empty. Is this the wrong field or something else.

product_override_price is correct field to set override price. Can you post your debug log to check?
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. # 11
Accepted Answer Pending Moderation
Hi Tharuna,

Works right now but it's not changing price but adds a new price?
Guess the shoppergroup is wrong, was set as 'Shopper Group Available for all'
Added new price with 'Shopper Group -default-'

Attached the log file.

Thanks in advance,
Pascal
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello Pascal,
The debug log shows that prices have been updated, there is no insert query to say that the new prices have been inserted. Did you run the import twice?

As i said when fetching a price record from database, CSVI checks for few fields and one of it is shopper group, since the value you imported is different from what is stored in database, a new price would have got created.
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. # 13
Accepted Answer Pending Moderation
Hi Tharuna,

Yes I did some tests with the import file. So it's used twice. I guess I'll check what the shopper group setting is and change my import file to this setting.
Then I can import this again to make it work.

Also in maintenance I see 'remove product prices'....is it wise to use this before import ?

Regards,
Pascal
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello Pascal,
Also in maintenance I see 'remove product prices'....is it wise to use this before import ?

Yes you can use it but remember that it will remove all prices for all products in VirtueMart.
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. # 15
  • Page :
  • 1


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