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,
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. # 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,
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. # 3
  • Page :
  • 1


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