1. sergio0187
  2. RO CSVI
  3. Tuesday, 19 October 2021
  4.  Subscribe via email
Hello,
We are currently using Ro CSVI to import products from a supplier and that works. This supplier also offers dropshipping and needs to have 2 exports from the webshop to supplier to know that stock needs to be updated at the side of supplier and to know where to send the package to.

The supplier asks for this XML format: https://webshop.europafoto.eu/page/xml-ordering

Is this possible with Ro CSVI?

Thank you in advance for looking into it, looking forward to your reply.

Kind regards
Accepted Answer Pending Moderation
Hello,
Please check Advanced order XML export document. The document explains on how to export orders, orderlines with customer address details. You need to change the node names according to your needs. Let me know if that 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. # 1
Accepted Answer Pending Moderation
Hello,

I was kindly referred to https://rolandd.com/documentation/ro-csvi/virtuemart/advanced-order-xml-export but I can't see how I can build up the XML exactly like attached screenshot. I think the requested format by the dropshipper is to specific. Do you really think it's possible?

Also see the documentation: https://webshop.europafoto.eu/page/xml-ordering

Kind regards
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

The only real issue I see is the lineNo value for an OrderLine. This is not set/used by RO CSVI at all. Looking at the XML, it is clear that not all data comes out of your webshop because it is simply not stored there, but they can be set using default values. Everything except the OrderLines are fixed values I think.

I do not know if that lineNo is optional, if yes, then you should be able to build that XML layout.

Are there any other issues you run into?
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
Accepted Answer Pending Moderation
Hi RolandD, thank you for fast response!
I just asked europafoto where this file request comes from. Unfortunately they told me the number is mandatory.
I guess I need to build our own CSV export than.
Thanks anyway. We're happy users of Ro CSVI.
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,

Actually you do not have to completely build your own CSV export. You can also add your export routine to RO CSVI as well. Have a look at the folder administrator/components/com_csvi/helper/file/export/xml. You can add your version of the orderadvanced.php file and it will show up in the list of XML websites. So you only need to make some changes to your own file and you should be good to go I think.
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. # 5
Accepted Answer Pending Moderation
Thanks!!
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hi RolandD,

Thanks again. I'm feeling stupid to ask this. I'm very comfortable for more than 10 years using RO CSVI for regular product csv imports, but XML is completely new and I really don't know where to start. I'm trying to find my way with the Titletutorial on your site, but I can't see how to modify it so it fits the desired output more. Also I found a programmer (the developer from https://virtueplanet.com/) who wants to help me create the custom XML export, but also he has no clue where to begin...Are there some hints you can give us?

Looking forward to be hearing from you again, thank you in advance.
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Sergio,

I completely agree that XMLs are a very different beast :D As to where to begin, I gave some info in my previous post. Just make a copy of the existing orderadvanced.php and modify that file. Each function in that file is part of your XML structure. Each XML file has a header, body and footer. You can see that as well when you edit the template as these are the input fields. In addition there is the order lines field, this is repeated for every order line in an order.

First copy your XML markup into the inputfields and modify it from there what you cannot make work. Important here is the element function this is what modifies each field content. So you can customize the field content as you may need it.
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. # 8
  • Page :
  • 1


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