1. liaskas
  2. RO CSVI
  3. Monday, 19 April 2021
  4.  Subscribe via email
Hello

Browsing inside the rolandd.com but can not find a clear answer regarding the import of products in Hikashop from an XML file.

Can we import products from an XML file in hikashop using RO CSVI?

I have seen instructions for virtuemart.

Is it possible for hikashop? Do we need to install an extra plugin?

Thank you.
Accepted Answer Pending Moderation
Hello,
Can we import products from an XML file in hikashop using RO CSVI?

Yes, you can import products from XML file into HikaShop with RO CSVI. Check import XML document to get details on importing XML file.

I have seen instructions for virtuemart.

Check HikaShop Product import document for instructions for HikaShop.

Is it possible for hikashop? Do we need to install an extra plugin?

You need two packages, RO CSVI core package and RO CSVI - HikaShop addon extension installed.
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 for your reply...

You need two packages, RO CSVI core package and RO CSVI - HikaShop addon extension installed.


We have downloaded and installed from this page:

RO CSVI, RO CSVI - HikaShop and RO CSVI - HikaShop - Order Export.

With the above packages installed, we have the following:

Edit template / Details

Action: import
Component: hikashop
Operation: product

Edit template / Source
Source: Load from URL
Load from URL: The link
Test Url -> ok found the file

Edit template / File

We have these settings

Autodetect delimiters
I'm Mac
Use file for configuration
Skip first line
Skip empty custom fields
Record name

There is no "Use file extension" field there like shown here: https://rolandd.com/documentation/ro-csvi/import-xml

We are brobably not doing something right.

Please advise
Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
RO CSVI, RO CSVI - HikaShop and RO CSVI - HikaShop - Order Export.

Just so you know, RO CSVI and RO CSVI - HikaShop extensions should be good enough for HikaShop imports and exports. RO CSVI - HikaShop - Order Export is plugin for triggering an export template to export order details when a new order is created in HikaShop.

There is no "Use file extension" field there like shown here: https://rolandd.com/documentation/ro-csvi/import-xml

Click on Advanced button on top right corner to see this option.
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
Thank you for your reply.

In case of params in xml, how is the right way to handle?

For example...

In a product there are some params like the following. What do we set in the template fields / your field of "Edit template field" to get the value of <PARAM_NAME>size</PARAM_NAME> in our database corresponding field?

<PARAM>
<PARAM_NAME>size</PARAM_NAME>
<VAL>S/L</VAL>
</PARAM>
<PARAM>
<PARAM_NAME>size_system</PARAM_NAME>
<VAL>EU</VAL>
</PARAM>

Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Your field should be the path of the XML node. So to get size from PARAM_NAME node, Your field should be set to PARAM /PARAM_NAME and to get the value S/L, Your field should be set to PARAM/VAL considering these nodes are under parent node which is also set as Record name in template settings.

If you have any issues, post us the XML file so to check the path.
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 for your help. This is really the best support ever!

I have entered the xml url in the site details tab (optional info) as it is the supplier's xml and we do not want it to be visible.

The problem is that the xml has

<PARAM><PARAM_NAME>size_system</PARAM_NAME><VAL>EU</VAL></PARAM>
and
<PARAM><PARAM_NAME>colour</PARAM_NAME><VAL>ΜΑΥΡΟ</VAL></PARAM>

Our parent node which is set as Record name in template settings is SHOPITEM and everything seems to be fine in the import preview with the other fields.

Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
Yes i see there are three PARAM nodes under SHOPITEM node. Can you tell me on how you want to import PARAM field and its values? Give me an example so i can help in setting it in the way you want. Also tell me to which HikaShop fields you are mapping the PARAM field.
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
<PARAM>
<PARAM_NAME>colour</PARAM_NAME> -> is the database column product_color
<VAL>ΚΟΚΚΙΝΟ</VAL> -> is the corresponding value for the product that goes in column product_color for the particular product
</PARAM>

<PARAM>
<PARAM_NAME>size</PARAM_NAME> -> is the database column product_size
<VAL>S/L</VAL> -> is the corresponding value for the product that goes in column product_size for the particular product
</PARAM>

<PARAM>
<PARAM_NAME>size_system</PARAM_NAME> -> is the database column product_sizesystem
<VAL>EU</VAL> -> is the corresponding value for the product that goes in column product_sizesystem for the particular product
</PARAM>

etc
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,
Check the attached screenshots. You have to set Your Field field as the XML node path PARAM/VAL and that should get the values.
Attachments (2)
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
Perfect...
Everything is in order now and one last step has to be taken...

usecase example:

XML was containing 5 products 2 hours ago.

Then the supplier sold 2 of the five products and the current xml contains 3 products

Is there a way that we can change the status of the 2 products (that do not exist in the current XML) and make it unpublished? This is really critical to avoid selling products that the supplier can not provide.

Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,

The only option you have is to unpublish all products before import, this is a setting in the import template. During the import you publish the products that are in the XML file. RO CSVI cannot import what is not in the XML file as it doesn't know what is gone.

If the supplier can supply an XML with out-of-stock/discontinued products you could import that and unpublish products that way.
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. # 11
Accepted Answer Pending Moderation
Thank you for your reply... gives me hope!

Now the key question is...

Can we unpublish products that have a specific value in the database (for example... product manufacturer = 15) or we have to unpublish all the products that exist in the database?

We have more than ten suppliers. It is not possible that we unpublish the products of the all the other suppliers when importing the products of one.

Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
I have read that the unpublish is for all products on some other forum threads.

One solution would be to run an external cron script on the server to unpublish just the products of the specific supplier 10 mins before the import.

Am i correct or this might cause problems?
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello,
One solution would be to run an external cron script on the server to unpublish just the products of the specific supplier 10 mins before the import.

You don't need to run external cron script for this. We have extended Unpublish before import field to unpublish product based on selected manufacturer with attached patch file. Here is what you have to do.

1. Load the attached patch file from RO CSVI Maintenance page.
2. In your import template settings on Options tab set Unpublish before import to Yes and select manufacturers in Unpublish based on manufacturer field. You can select multiple manufacturers too. See attached screenshot.
3. Save the template.
4. Run the import and check.

Let me know on how the patch file goes.
Attachments (2)
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. # 14
Accepted Answer Pending Moderation
Probably this is not the correct patch for hikashop. When tried to load the patch it returns...

0 Incorrect Failure Cannot copy patch file from /home/ACCOUNT_NAME/public_html/tmp/com_csvi/patch/1619011344/plugins/csviaddon/virtuemart/com_virtuemart/helper/com_virtuemart.php to /home/ACCOUNT_NAME/public_html/plugins/csviaddon/virtuemart/com_virtuemart/helper/com_virtuemart.php

0 Incorrect Failure Cannot copy patch file from /home/ACCOUNT_NAME/public_html/tmp/com_csvi/patch/1619011344/plugins/csviaddon/virtuemart/com_virtuemart/language/en-GB/en-GB.com_csvi.ini to /home/ACCOUNT_NAME/public_html/plugins/csviaddon/virtuemart/com_virtuemart/language/en-GB/en-GB.com_csvi.ini

0 Incorrect Failure Cannot copy patch file from /home/ACCOUNT_NAME/public_html/tmp/com_csvi/patch/1619011344/plugins/csviaddon/virtuemart/com_virtuemart/tmpl/import/product.xml to /home/ACCOUNT_NAME/public_html/plugins/csviaddon/virtuemart/com_virtuemart/tmpl/import/product.xml

Also...
something like this can be done for product_vendor_id column that exists in hikashop #__hikashop_product?

Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello,
My bad. I misunderstood that you are using VirtueMart product import operation. Attached is the patch file for HikaShop. Please load the patch file and follow the same steps as explained in my previous reply.


Also...
something like this can be done for product_vendor_id column that exists in hikashop #__hikashop_product?

I do not see the field for product_vendor_id in HikaShop product details page though field exists in #__hikashop_product table. Can you post a screenshot on how this field is saved for a product?
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. # 16
Accepted Answer Pending Moderation
This field takes the vendor's id (number) when the site is multivendor. This does not need to list all vendors when setting up the ro csv template. Just a field to enter the vendor id.

Database screenshot...

Product_cendor_id.jpg

Thank you
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Hello,
From what i can see product_vendor_id field is used only when HikaMarket extension is used for multi vendor setup. As of now we do not support HikaMarket extension. If we get more requests in future for this field we can then consider to support this field.
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. # 18
Accepted Answer Pending Moderation
Understood and accepted.

Thank you.
  1. more than a month ago
  2. RO CSVI
  3. # 19
  • Page :
  • 1


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