1. keep
  2. RO CSVI
  3. Saturday, 09 April 2016
  4.  Subscribe via email
I have a template which loads an XML file from the server which is generated by an other process before the import. The XML is processed via a hourly cron job.
I can't set fixed field list in the CSVI template because of the export process so I set "Use file for configuration" in the template settings.
Everything is fine, the process uploads/updates the products, but I have a bit problem with the multi variant fields. I set product_parent_sku which is fine but I can't assign multi variant fields.
I read the documentation and tried to implement to XML.
I have 3 types of products: parent, child and solo which hasn't any parents or children.
I have 3 XML fields: multi_variant_title, multi_variant_fields, and dummy_field.
If the product is a solo product all of these fields are empty.
If it's a parent, the fields are like this:
<dummy_field></dummy_field>
<multi_variant_title>Size</multi_variant_title>
<multi_variant_fields>dummy_field</multi_variant_fields>

If it's a child, the fields are like this:
<dummy_field>M</dummy_field>
<multi_variant_title></multi_variant_title>
<multi_variant_fields></multi_variant_fields>

The process does the import, adds the custom but it doesn't use 'custom label' ramification and the values are the product names. I need to set product sizes as variant values.
I attached the XML, the log and a screenshot from VirtueMart.

Versions:
Joomla - 3.5.1
VirtueMart - 3.0.14
CSVI Pro - 6.5.6
CSVI Pro VM addon - 6.5.6.1
PHP: 5.6.16
Accepted Answer Pending Moderation
Hello,

I can't set fixed field list in the CSVI template because of the export process so I set "Use file for configuration" in the template settings.
With an XML file you can set the fields in the template because data is retrieved based on the XML path set for each field.

I have identified the issues you have. The product_parent_sku on the parent product should be empty because it is a parent and not a child. The other problem there is with using File for configuration is that your field dummy_field is empty on the parent and as such not recognized.

So what needs to happen is that the Use file for configuration should be set to No and the fields added to the template so that empty fields are also found. For each field you set the Your field value to the same name as the field name.

Finally, the import must be run twice for the first time so that the custom fields are loaded into the system.
Kind regards,

RolandD

=========================
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 rolandd, thanks for your answer.
The problem is with the export which is an external script. There are fields which are sometime exists in the XML and sometimes aren't, so the dynamic solution would be better. I tried to fix the fields somehow.
The strange part that I used almost the same script on my other site with Joomla 3.4.8, VM 3.0.6.2 and CSVI Pro 6.5.4. I also noticed that empty fields aren't recognized so I put some placeholder into it like "X" and there wasn't any problem.
Anyway the import works, the multivariant import also works except that I got product names instead custom label.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

There are fields which are sometime exists in the XML and sometimes aren't
I don't see your problem, if you have fields that are not in the XML, they will just be skipped.

the multivariant import also works except that I got product names instead custom label.
As I said, your parent product shouldn't have a value in the product_parent_sku field. CSVI recognizes it as a child and not as a parent, so that is why the multi variant goes wrong.
Kind regards,

RolandD

=========================
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
  • Page :
  • 1


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