Resolved Advanced order: export only one order data record

Hello Tharuna,

thanks a lot! it works fine!

Kind regards,

Teresa

Hello Tharuna,

there is a tiny work-related issue with the override file:

Added the custom field ChampagneTax to the products with a value of 1.02 EUR. Added in all products the custom field SubSKU with values e. g. #123456
<orderline>
<Order_Id><![CDATA[20]]></Order_Id>
<Product_SKU><![CDATA[5121]]></Product_SKU>
<Product_SubSKU><![CDATA[1.02]]></Product_SubSKU> [color=#ff0000]Filled with the champagne tax instead the SubSKU[/color]
<Product_ChampagneTAX><![CDATA[1.02]]></Product_ChampagneTAX> [color=#ff0000]Looks good[/color]
etc..........
</orderline>

Thanks in advance!

Kind regards,

Teresa

Hello Teresa,

This has been fixed in the override file. The subSKU is now showing the correct value.

Hello,

still on testing and found an issue with Custom Fields. I added a new Custum Field called "Inhalt" to the product with id=1.

Triggered a new order and updated the Available Fields. Can't add these field to the Advanced Order Export like SubSKU.

Kindly request your help again.

Kind regards,

Teresa

Hello Teresa,
You need to add this custom field to available fields override.sql file. Open the file in the location /administrator/templates/isis/html/com_csvi/com_virtuemart/install/override.sql and replace the line

('ChampagneTAX', 'ChampagneTAX', 'orderadvanced', 'com_virtuemart', 'export');

to

('ChampagneTAX', 'ChampagneTAX', 'orderadvanced', 'com_virtuemart', 'export'),

('Inhalt', 'Inhalt', 'orderadvanced', 'com_virtuemart', 'export');

Note that the semi colon(; ) at the end of ChampagneTax row becomes comma(,) and so we can add one more new custom field. You need to follow this for any new custom fields added. After adding this, update your available fields and you should be seeing it in your template fields.

Hello Tharuna,

thank you very much. Stupidly I lost sight of this step when creating new fields.

Kind regards

Teresa

Hello friends,

in the meantime, we have tested the export and entered all the products. Actually, we wanted to go online today. Cautiously I have set up another subdomain beta.winzersekt.de and wanted to move the installation of CSVI with all modifications from test.winzersekt.de to this subdomain. I saved the templates before and copied all CSVI folders to beta.winzersekt.de. When trying to import the templates there was a error message - see attachment. I compared both CSVI installations (beta.winzersekt.de vs. test.winzersekt.de) to find your modified files. Copied over and it works! For the moment I can live with it.

But what about future updates? Is there a patch or will the modifications be integrated into the future updates?

On this occasion, we've discovered an error with the custom fields. In particular, it concerns the subSKU, but also other fields. As described earlier, this number is required for filling the champagne bottles. So it could be that there are several products with the same SKU, but with different subSKU's.

As an example we look at the SKU 4331. It exists 2 times, once with subSKU "test" (product_id 12) and once with subSKU "#FW4331" (product_id 34).

All custom fields are assigned to the products - with or without values. Apparently, you identify the fields using the SKU. For this reason, the incorrect subSKU is assigned with product ID 34 in purchase order 4. Should be #FW4331 instead Test from product id 12.

Would you be so kind to modify this issue. It's very important for us.

Kind regards,

Teresa

PS: The access data are still the same!

Hello Teresa,

But what about future updates? Is there a patch or will the modifications be integrated into the future updates?

Yes, all the core changes are included in our next CSVI release so future updates will not be a problem. But you need to keep track of the override file for export routine and also SQL override for custom fields.

The export templates on your test site don't export product ids 34 or 12. Can you please tell me the export template you are using and where can i test this issue? I tried using SD2000-OA OrderEXPORT 24h template on your test site you had sent me.

Hello Tharuna,

sorry, meanwhile I reset the database - so you can't find order. Made a new one with order number 6 and both products in it.

The export template is: SD2000-OA OrderEXPORT - beta.winzersekt.de

Attached log and XML with comments.

Earlier I told Roland to have fields with numbers (especially pervcentage fields) with at least 4 decimal digts. One field would be important: </Product_Discount_Percentage>

Kind regards,

Teresa
.

Hello Teresa,

Just read something I wanted to comment on.

Apparently, you identify the fields using the SKU.

That is correct, CSVI uses the SKU to identify products as this should be a unique value. An SKU should be unique enough to identify a product.

As an example we look at the SKU 4331. It exists 2 times, once with subSKU "test" (product_id 12) and once with subSKU "#FW4331" (product_id 34).

This makes me think if the subSKU and SKU should we swapped. That would only be possible if the subSKU is unique of course.

Just some thoughts I wanted to share.

Hello Teresa,

As an example we look at the SKU 4331. It exists 2 times, once with subSKU "test" (product_id 12) and once with subSKU "#FW4331" (product_id 34).

Earlier I told Roland to have fields with numbers (especially pervcentage fields) with at least 4 decimal digts. One field would be important: </Product_Discount_Percentage>

Can you check both of these issues on your beta.winzersekt.de site? I have fixed them. Please check and confirm.

Hello tharuna,

many thanks for fixing the issues. SubSKU is working fine now!

The issue with decimals works only partially. On beta.winzersekt.de I made a new order number 8 with all possible cases :woohoo:

Position ID 12 is assigned a rule with a percentage value of 15%. Output of percentage field is 15 without decimals - it's fine because 15% are 15%. For now, I don't know what happens if assigning a rule with 15.75% ?

Postion ID 13 is assigned a rule with an amount value of 1.5 EUR. Output of percentage field is 18 (%) without decimals. If you calculate correctly it is in truth 17.94xxx%.

All other positions with empty values are exported with 0.0000 - OK!

Would be great, if you can solve this, because when giving over the XLM to the ERP we need to calculate with the exact percentage value.

Please tell me which files you modified all issues, because I need to move them to the live site.

Thanks again,

Teresa

Hello Teresa,
I did some modifications to product discount percent field, can you please test it again? i made modification to order advanced export override file. You can move this file to your live server.

Hello,
in the meantime we need to modify the ChampagneTax field to Sektsteuer. On this occasion we have established that the override.sql for updating the available fields is not working.

As a workaround we copied the necessary fields to the availablefields.sql

Would you please kindly have a look on this issue?

Kind regards,

Teresa

PS: Access credentials are still valid

Hello Teresa,
Looks like you missed to move a patch file content while moving your site. I have put the code back in place and now override.sql file is working. I have moved the field Sektsteuer from availablefields.sql to override.sql. Please check and let me know. These issues should be solved once you update your CSVI to 7.0 version which is to be release anytime this week.

Hello Tharuna,

thank you very much! Meanwhile there are so many test installations, so I ask you where did you make the modifications?

Kind regards,

Teresa

Hello Teresa,
Please load the attached patch file to get the modification in all of your test sites.

patch_csvi_2016_12_21.zip