Categories
View Replies (8)

Resolved Specific export of order product

  1. jarlu
    jarlu
  2. RO CSVI
  3. Thursday, 11 October 2018
  4.  Subscribe via email
Hello, I need export my orders from Virtuemart eshop to my shop system, but this system has specific requirements. This source is model of xml structure .
<?xml version="1.0" encoding="Windows-1250"?>

<VFPDataSet>

	<objednavka id_obj="12345" cislo="1107PO121211" varsymbol="20180101" emailfaktura="meno@server.com" datum="1.7.2011" suma_bDPH="106.25" suma_sDPH="127.50">

		<zakaznik>

			<id_zak>12345</id_zak>

			<login>AAA</login>

			<tel>0903 123 123</tel>

			<kontaktna_osoba>Jozef Novak</kontaktna_osoba>

			<fakturacna_adresa>

				<titul>Ing.</titul>

				<meno>Jozef</meno>

				<priezvisko>Novák</priezvisko>

				<ulica>A. Hlinku</ulica>

				<cislo_domu>2214</cislo_domu>

				<mesto>Žilina</mesto>

				<psc>01010</psc>

				<stat>Slovensko</stat>

				<ico>1234567890</ico>

				<dic>1234567890</dic>

				<icdph>SK1234567890</icdph>

			</fakturacna_adresa>

			<dodacia_adresa>

				<titul>Ing.</titul>

				<meno>Jozef</meno>

				<priezvisko>Novák</priezvisko>

				<ulica>A. Hlinku</ulica>

				<cislo_domu>2214</cislo_domu>

				<mesto>Žilina</mesto>

				<psc>01010</psc>

				<stat>Slovensko</stat>

			</dodacia_adresa>

		</zakaznik> /*this structuje is OK*/

		<poznamka>Poslať len ak bude objednávka kompletná</poznamka>

		<polozky pocet="2" kontrolny_sucet="13.0123">

			<polozka id_kart="2440" id_sklad="63242" pocet="1" poznamka="Ak nebude takéto balenie, tak väčšie" predaj_sdph="1.56" predaj_bdph="1.42" />

			<polozka id_kart="3735" id_sklad="62240" pocet="12.0123" poznamka="" />

		</polozky>

	</objednavka>

</VFPDataSet>


<polozka> is tag of ordered item
"pocet" in tag <polozky> => quantity of tag <polozka> (when customer ordered two kind of product this tag has value 2. When customer ordered two kind of product when first product in two quantity, this tag is stil 2)
"predaj_sdph" => price with VAT minus the price without VAT
"kontrolny_sucet" => total quantity of ordered products (when customer ordered two kind of product this tag has value 2. When customer ordered two kind of product when first product in two quantity, this tag is 3)

I have problem with tag <polozky>. I need the checksum of the items that will be in this tag. And I also need to quantify the sum of VAT. Is it possible to create this type of xml?
0
Responses (8)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Jarlu,

To start, you are going to need to use the VirtueMart Advanced Order Export and the Advanced Order XML export document explains on how to set this up. That will allow you to create this structure.

The issue of pocet is something that CSV Improved cannot export as we do not keep track on the number of items exported. You will need to create an override of the export routine and add these values yourself. That is the only way I can see this work.

And I also need to quantify the sum of VAT
The total amount of VAT I believe is the order_tax field.
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. # 1
jarlu
jarlu
Accepted Answer Pending Moderation
Hello! Thank you for your answer. Now, I have problem with kontrolny_sucet. kontrolny_sucet is sum of total pieces of order product. do you have any idea how I can change template for this speciffic value?
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

There is no field available that has the total amount of products in it. There is only the product_quantity field which holds the quantity per product. So you would need to add those up for the complete order to get the total amount of products. This is also custom coding you would need to add to your override.
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
jarlu
jarlu
Accepted Answer Pending Moderation
Hello, I created specific folder for my own template, but in file i can't find specific source for product_quantity (administrator/templates/isis/html/com_csvi/com_virtuemart/model/export/orderadvancedcustom.php). Please where I can find source for this value?
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

There are 2 ways to go about this, the first is to add product_quantity to your list of fields to export, the second is to add the field in the code to the $userfields array before this line 
$userfields = array_unique($userfields);
.

You should probably make your own query to calculate the total products for a given order or you can sum up the total of every product_quantity field for every record.
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
jarlu
jarlu
Accepted Answer Pending Moderation
Is it possible, that you write for my this php code? what would be the price?
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I am sorry, but I have no time for custom jobs.
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. # 7
easysoftware
easysoftware
Accepted Answer Pending Moderation
Ahoj Jarlu,

export objednávek z VM realizujeme například pro Helios velice rychle:

http://bookmall.easysoftware.cz/index.php?option=com_easyfeeder&view=server&id=13&format=xml

Takto vyhovuje?

Rudolf
  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!