Hello,
I think your component could really help me with the following task, but need confirmation...
I use Hikashop, for each order a csv file is generated.
This csv file must be transmitted to a delivery service which also provides a csv file. The problem is that the column headers do not match the Hikashop column headers.
Can RO CSVI change the header names so that the service file can accept data from Hikashop?
I'm attaching both files, as it stands I don't know which headers need to be replaced, it's just to give you an example of the two files to be matched.
Many thanks,
Lorenzo
- Home »
- Support »
- Pre-sale questions »
- Change column headers
- iorbita
- Pre-sale questions
- Thursday, 16 May 2024
- Subscribe via email
Accepted Answer
Pending Moderation
Hello Lorenzo,
With RO CSVI you can give your column headers any name you like. However, I am more worried about the data in your files. First thing I notice is the sequence number, this does not strike me as a field from HikaShop but rather a custom field. Is that correct? RO CSVI does not have such a field.
Could you share how the export is build now? Is it another extension where you can just pick the fields or is it an SQL query?
We would need to see if you can get the same data out of your HikaShop as now.
Let me know and we can check further.
With RO CSVI you can give your column headers any name you like. However, I am more worried about the data in your files. First thing I notice is the sequence number, this does not strike me as a field from HikaShop but rather a custom field. Is that correct? RO CSVI does not have such a field.
Could you share how the export is build now? Is it another extension where you can just pick the fields or is it an SQL query?
We would need to see if you can get the same data out of your HikaShop as now.
Let me know and we can check further.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- more than a month ago
- Pre-sale questions
- # 1
Accepted Answer
Pending Moderation
Hi Roland,
thanks again for your prompt reply. I apologize for the confusion in my previous message; I mistakenly attached only the delivery service's csv files and forgot to attach Hikashop csv file.
The files I've attached are only those that the delivery service makes available and which must be filled in before being loaded onto their delivery platform.
To recap, I'm hoping to use RO CSVI to achieve the following:
- Create custom fields in Hikashop (if necessary) to capture the data required by the delivery service.
- Modify the Hikashop CSV file to match the header structure of the delivery service's csv file.
The "sequence number" is a field in the delivery service's csv file, not in Hikashop.
Here's an overview of the column headers in the delivery service's csv file (sorry, it's in Italian, but I think it's not so difficult to translate just to understand the meaning of the header).
Are you referring to the Hikashop export? In the meantime, here's an export of a simple Hikashop order + a simple csv file to fill in from the delivery service (it's the same as one of those I sent you in my first message).
Thanks again,
Lorenzo
thanks again for your prompt reply. I apologize for the confusion in my previous message; I mistakenly attached only the delivery service's csv files and forgot to attach Hikashop csv file.
The files I've attached are only those that the delivery service makes available and which must be filled in before being loaded onto their delivery platform.
To recap, I'm hoping to use RO CSVI to achieve the following:
- Create custom fields in Hikashop (if necessary) to capture the data required by the delivery service.
- Modify the Hikashop CSV file to match the header structure of the delivery service's csv file.
First thing I notice is the sequence number, this does not strike me as a field from HikaShop but rather a custom field. Is that correct?
The "sequence number" is a field in the delivery service's csv file, not in Hikashop.
Here's an overview of the column headers in the delivery service's csv file (sorry, it's in Italian, but I think it's not so difficult to translate just to understand the meaning of the header).
Could you share how the export is build now?
Are you referring to the Hikashop export? In the meantime, here's an export of a simple Hikashop order + a simple csv file to fill in from the delivery service (it's the same as one of those I sent you in my first message).
Thanks again,
Lorenzo
Attachments (1)
- more than a month ago
- Pre-sale questions
- # 2
Accepted Answer
Pending Moderation
Hello Lorenzo,
Yes, you can create custom fields in HikaShop and run the update of available fields in RO CSVI. You will be able to add these custom fields to export template after that.
In template fields page when you add a new export field you can set Your field to the header you need. You can also run a sample export on our demo site and check for column headers.
- Create custom fields in Hikashop (if necessary) to capture the data required by the delivery service.
Yes, you can create custom fields in HikaShop and run the update of available fields in RO CSVI. You will be able to add these custom fields to export template after that.
- Modify the Hikashop CSV file to match the header structure of the delivery service's csv file.
In template fields page when you add a new export field you can set Your field to the header you need. You can also run a sample export on our demo site and check for column headers.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- more than a month ago
- Pre-sale questions
- # 3
Accepted Answer
Pending Moderation
Hi and thanks for your reply Tharuna, so I guess Roland's doubts about my example have been clarified.
It's clear that RO CSVI is a fairly complex component, but I think it's the only extension that can help me to load orders from Hikashop to the delivery service.
One question about automation. I believe it's possible to automate this task? To clarify, instead of importing the csv file from Hikashop into RO CSVI for subsequent export, RO CSVI would directly handle the export upon order submission.
But perhaps I should take a closer look at how your component works...
In any case, I'm meeting with the delivery service team on Monday to discuss their csv file requirements in more detail. This will help me better understand how to make the two components work together.
Thanks again,
Lorenzo
It's clear that RO CSVI is a fairly complex component, but I think it's the only extension that can help me to load orders from Hikashop to the delivery service.
One question about automation. I believe it's possible to automate this task? To clarify, instead of importing the csv file from Hikashop into RO CSVI for subsequent export, RO CSVI would directly handle the export upon order submission.
But perhaps I should take a closer look at how your component works...
In any case, I'm meeting with the delivery service team on Monday to discuss their csv file requirements in more detail. This will help me better understand how to make the two components work together.
Thanks again,
Lorenzo
- more than a month ago
- Pre-sale questions
- # 4
Accepted Answer
Pending Moderation
Hello Lorenzo,
However we do supply example templates that can serve as a starting point.
Let us know if you have any further questions.
It's clear that RO CSVI is a fairly complex componentCorrect, RO CSVI has somewhat of a learning curve but that comes with the territory
![:D](/media/com_easydiscuss/images/markitup/emoticon-happy.png)
One question about automation. I believe it's possible to automate this task?Yes, RO CSVI can be run as a cronjob provided you have enabled cron in the template. For Joomla 4/5 we include a task to run it through the Joomla CLI.
RO CSVI would directly handle the export upon order submission.That is possible as well. Have a look at the Export HikaShop order after an order is created document. That may be something you are after.
Let us know if you have any further questions.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- more than a month ago
- Pre-sale questions
- # 5
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!