Categories
View Replies (11)

Resolved Hikashop Order Export - XML Layout

  1. marko-l
    marko-l
  2. RO CSVI
  3. Thursday, 08 November 2018
  4.  Subscribe via email
Hi,

i need to have an specific XML-Layout. Like this:

Warning: Spoiler Alert! [Toggle message] 



<?xml version="1.0"?>

<Order_Data>

 <Transaction_No>100</Transaction_No>

 <Header>

  <Customer_Reference>Order 1</Customer_Reference>

  <Delivery_Date>22.06.2012</Delivery_Date>

  <Address>

   <Name1></Name1>

   <Name2></Name2>

   <Street></Street>

   <Postalcode></Postalcode>

   <City></City>

   <ISO_Country></ISO_Country>

   <Phone>1234Abc</Phone>

  </Address>

  <Positions>

   <Line>

    <Line_No>1</Line_No>

    <No>4002911121566</No>

    <Quantity>1</Quantity>

   </Line>

   <Line>

    <Line_No>2</Line_No>

    <No>4002911120491</No>

    <Quantity>5</Quantity>

   </Line>

  </Positions>

 </Header>

</Order_Data>



The problem is, that only the Lines in the Positions needs to repeat.
When i use the XML-Layout Tab in Template,only th Fields in "Body" are replaced, but not in Header.
And when i place all the fields in Body, the Adress usw. will be repetet with every product.

Actually I need an advanced export function as with virtuemart advanced export.
Is that possible?

Thank you.
0
Responses (11)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marko,
Right now there is no Advanced order export functionality in HikaShop but this feature is a good addition to CSVI HikaShop extension. We will develop this functionality and send you the patch file to test.
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
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marko,
Order advanced export functionality for HikaShop is ready and is attached in the patch file. Please follow the below instructions to test the functionality.

1. Load the attached patch file as explained in the document How to load a patch file?
2. Reset tasks and Update your available fields as explained in Missing fields in CSVI document.
3. Create HikaShop Order advanced export template. Follow Advanced Order export XML Export document to create XML layout for export. The document is explained for VirtueMart but the procedure is same for HikaShop.
4. Run the export.

Let me know how it goes.

patch_hikashop_order_advanced_2018_11_09.zip
Attachments (1)
patch_hikashop_order_advanced_2018_11_09.zip
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. # 2
marko-l
marko-l
Accepted Answer Pending Moderation
Hello

first of all thanks for the great support.

I have done point 1 and 2.
But at point 3, there is a problem.

If I want to create a new profile, there is no choice for "order advanced" under hikashop

What can I do?

Kind regards,
Marko
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marko,
Can you try doing the point 1 and 2 again and check if you can see order advanced operation for HikaShop? I tried the patch file on a fresh site in my local server and could see the option. If you still have any issues, please PM me your site administrator login details and i will take a look.
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. # 4
marko-l
marko-l
Accepted Answer Pending Moderation
Hello, you are absolutely great.

After repeating points 1 and 2 it works now.
So the export worked properly.

I have one last question.

When ordering, each product must have its own line no.
As in the example above.
That's like a posiotion on the bill.
Hikashop does not have this feature.
Is there a way to install a counter?
I have already tried with the CSVI MultiReplace Plugin , but I do not understand it correctly.

Kind regards,
Marko
  1. more than a month ago
  2. RO CSVI
  3. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marko,
Thank you so much to confirm the export is working.

When ordering, each product must have its own line no.
As in the example above.
That's like a posiotion on the bill.
Hikashop does not have this feature.
Is there a way to install a counter?
I have already tried with the CSVI MultiReplace Plugin , but I do not understand it correctly.

There is no such feature as counter in CSVI. One way to do this is to Write your own rule plugin and apply this rule on bill position 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. # 6
marko-l
marko-l
Accepted Answer Pending Moderation
Ok, but isn't it possible with the replace plugin?
There is a kind of counter in Hikashop, only this counts beyond the order.

Example:
order1:
Position1 (1)
Position2 (2)

order2:
Position1 (3)
Position2 (4)

The number in the brackets shows that the counter simply keeps counting.
Can´t I just replace them with the Replace plugin?

Kind regards,
Marko
  1. more than a month ago
  2. RO CSVI
  3. # 7
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marko,
Example:
order1:
Position1 (1)
Position2 (2)

Do you want to read the counter value or just replace them? If you need to read the counter value you can use substring functionality in Multi replace plugin and for replace use Find and Replace operation. But in your example you have text as Position1, Position2..... There is an increment with Position text itself. Is there any limit to this increment? If there is a limit then Multi replace rule can be used to replace or substring each and every Position text. Say if there is a limit till Position5 then you can create Multireplace rule for text from Position1, Position2....Position5 and so on.
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. # 8
marko-l
marko-l
Accepted Answer Pending Moderation
Hello tharuna,

Sorry for the example, it may be a bit confusing.
I just wanted to suggest that the 1st position in the second order gets the number 3, but it should start with 1 again. The Hikashop counter just keeps counting (order_product_id).

It's all about numbers, and the field is just numbers. Actually, the number should simply be replaced.
So: No matter what number is in the field, it should be replaced. With every order Starting by 1 for each product in the Order.

Kind regards,
Marko
  1. more than a month ago
  2. RO CSVI
  3. # 9
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marko,
I get your point. For each order, under every order product there should be a counter. So if a order has 3 products, the counter should start from 1 and will go till 3 and for next order this counter should be again 1. As i said earlier this is not possible unless you do some custom coding. You are trying to replace numbers but there is no consistency in the number of products an order can have. Some orders can have 4 products and some can have 2 products and so on. It is not possible to create rule for replacing these numbers.
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. # 10
marko-l
marko-l
Accepted Answer Pending Moderation
Hello Tharuna,

that's exactly how it should be.

I simply tested the export without the line-no, and there was no problem with the wholesaler, so that's probably not so important and I'll let that be for now.

Thank you for your great support.

Kind regards,
Marko
  1. more than a month ago
  2. RO CSVI
  3. # 11
  • Page :
  • 1


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