1. Anonymous User
  2. RO CSVI
  3. Sunday, 18 April 2021
  4.  Subscribe via email
Greetings.

I am trying to get a custom xml export of my products, I have setup the export file to xml and added the fields I want.

On the xml layout i added the following

Header
<?xml version="1.0" encoding="UTF-8"?>
<channel>


Body
<product>
<id>[product_sku]</id>
<sku>[product_sku]</sku>
<product-id>[product_sku]</product-id>
<product-id-type>SHOP_SKU</product-id-type>
<description>[product_s_desc]</description>
<internal-description>[product_s_desc]</internal-description>
<price>[product_price]</price>
<price-additional-info>Τιμή Συμπεριλαμβανομένων των Φόρων</price-additional-info>
<quantity>[product_in_stock]</quantity>
<min-quantity-alert>1</min-quantity-alert>
<state>11</state>
<available-start-date></available-start-date>
<available-end-date></available-end-date>
<logistic-class></logistic-class>
<discount-price></discount-price>
<discount-start-date></discount-start-date>
<discount-end-date></discount-end-date>
<leadtime-to-ship>3</leadtime-to-ship>
<update-delete>Update</update-delete>
<offer-additional-fields>
<offer-additional-field>
<code>offervat</code>
<value>24</value>
</offer-additional-field>
<offer-additional-field>
<code>shippingvat</code>
<value>24</value>
</offer-additional-field>
</offer-additional-fields>
</product>

Footer
</channel>

On the export file i wanted to get the product sku, the product description etc of my products, but instead I get the text printed 6011 times.

You can see the result here: https://www.e-connect.gr/public-xml/public-custom.xml

Can you please suggest what am I doing wrong?

Thank you in advanced!!
Accepted Answer Pending Moderation
Hello,
Do you have template fields added to your export template? Can you share a screenshot of the added export template fields? Also, post your export debug log to check. To get the debug log check How to collect debug information? document.
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 and thank you for your quick responce!

I have added the template fields as you can see on the printscreen.

I also exported the log for you..

Thank you in advance!
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Thank you for the screen shot and the debug log. In your template fields page you have column headers added for the fields, for product_sku you have column header set as sku so in the XML layout you need to use the column header as replace text instead of field name. For product_sku the XML layout would be <id>[sku]</id> instead of <id>[product_sku]</id>. You need to change field names to column header name for other fields too.
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
  • Page :
  • 1


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