1. sergio0187
  2. RO CSVI
  3. Wednesday, 06 April 2022
  4.  Subscribe via email
Hi,
I have an import file with more than 300 fields.
I would like to use column headers for configuration. The original csv comes from another place and some fields I need to match with product_name and also I want to apply rules to some fields.
Is this possible while using headers for configuration?
Accepted Answer Pending Moderation
Hello,
There is no option to use column headers and rules in the current version but we have introduced a new feature Global rules in the upcoming RO CSVI version. Using this feature you can add column header name and apply the needed rule to it. We are planning to do a new release in a week or two.
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
Thank you Tharuna,

And how will mapping fields work, like if the CSV contains a field called SKU and I need it to map with the VM field product_SKU ?
Will that work too than?
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
And how will mapping fields work, like if the CSV contains a field called SKU and I need it to map with the VM field product_SKU ?
Will that work too than?

No mapping does not work with Global rules feature. You still need to map the SKU field with product_sku as RO CSVI will not know what fields you are importing. The use of global fields is that by using column headers from file users can apply the rule to it.
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
Ok and how can I map column headers with the VM fields using column headers as configuration?
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
To map the fields you can use Field mapper but you cannot use column headers as configuration. Since the column headers are different from VirtueMart fields you need to tell RO CSVI the fields you are importing. You need to add them as template fields and set use file for configuration as No for rules to run.

One way to add template fields is to use custom table import and import the available fields for a template into #__csvi_templatefields table.
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 Tharuna, that works perfect!
Is there anyway I can skip importing already imported products?
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
Is there anyway I can skip importing already imported products?

In import template settings on File tab set Overwrite existing data to No and save the template. This will skip updating of existing data in database.
Attachments (1)
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
Thanks!
If Overwrite existing data is set to no, does this means it only updates fields from a csv line which are different?
So let's say SKU is same, but product name is a bit different, price is same. Will it than only update the product name?

And I don't understand the 'Delete existing prices'
https://www.screencast.com/t/kYa9JTYxtz4
Is this needed to set to yes if I want to update the price?
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,
If Overwrite existing data is set to no, does this means it only updates fields from a csv line which are different?
So let's say SKU is same, but product name is a bit different, price is same. Will it than only update the product name?

No, with product_sku value RO CSVI checks if there is existing product row in database. With Overwrite existing data is set to no, if the product already exists then entire row is skipped and no columns are updated. If the product is a new product then it is created in database.

And I don't understand the 'Delete existing prices'
https://www.screencast.com/t/kYa9JTYxtz4
Is this needed to set to yes if I want to update the price?

Delete existing price is to remove the existing price for a product in daabase and import the new value from import file. This is used in case where you want to clean the existing multiple prices and need to keep only few. You don't need to set this to Yes for updating a price.
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
  • Page :
  • 1


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