Resolved Product Options empty on Hikashop Order Export

Hello,

Could you post the debug log of your export as well? Thank you.

It says No debug log found

Hello,

See at the top of this page under "Where to get the debug information?" on how to get the log.

That's on me! Thanks for that. I feel that should be enabled by default.

See attached.

I feel that should be enabled by default.

Now you do but when you go live and the logs folder and database fills up with debug data you wish it wasn't :woohoo:

I have checked my hikashop_order_product table for the order_product_options field but this field is empty. Can you check if there is something stored in that field in your case?

That's my problem. There's nothing there in the CSV. I have product options but they aren't being exported.

That I understand it is your problem but if there is nothing in that field in the database, that is exactly what is being exported. Nothing. Hence my question to check if there is anything in that field in your database for this order. If you do not know how, please send a private message to Tharuna with Joomla and FTP access so she can check for you.

Ah the database. I thought you were talking about the CSV. I'm attaching the export of that table. Yes there is data in the field.

Yes, I see the data in the order product table and this exports OK here but only if there is a corresponding order in the order table. Could you post or send me in a private message the order table as well?

Even though it would export it will come out as

a:6:{i:0;O:8:"stdClass":11:{s:25:"variant_characteristic_id";s:1:"7";s:18:"variant_product_id";s:2:"22";s:8:"ordering";s:1:"0";s:17:"characteristic_id";s:1:"7";s:24:"characteristic_parent_id";s:1:"9";s:20:"characteristic_value";s:62:"Install IR Filter - 400-675nm response - Not removable by user";s:20:"characteristic_alias";s:0:"";s:27:"characteristic_display_type";s:0:"";s:21:"characteristic_params";s:0:"";s:23:"characteristic_ordering";s:1:"0";s:29:"characteristic_display_method";s:0:"";}i:1;O:8:"stdClass":11:{s:25:"variant_characteristic_id";s:1:"5";s:18:"variant_product_id";s:2:"22";s:8:"ordering";s:1:"0";s:17:"characteristic_id";s:1:"5";s:24:"characteristic_parent_id";s:1:"6";s:20:"characteristic_value";s:88:"16GB DDR3 - NCNR (Non-Cancellable/Non-Returnable) build option - Contact us for leadtime";s:20:"characteristic_alias";s:0:"";s:27:"characteristic_display_type";s:0:"";s:21:"characteristic_params";s:0:"";s:23:"characteristic_ordering";s:1:"0";s:29:"characteristic_display_method";s:0:"";}i:2;O:8:"stdClass":11:{s:25:"variant_characteristic_id";s:1:"1";s:18:"variant_product_id";s:2:"22";s:8:"ordering";s:1:"0";s:17:"characteristic_id";s:1:"1";s:24:"characteristic_parent_id";s:1:"3";s:20:"characteristic_value";s:5:"Color";s:20:"characteristic_alias";s:0:"";s:27:"characteristic_display_type";s:0:"";s:21:"characteristic_params";s:0:"";s:23:"characteristic_ordering";s:1:"0";s:29:"characteristic_display_method";s:0:"";}s:9:"IR Filter";s:62:"Install IR Filter - 400-675nm response - Not removable by user";s:15:"Internal Memory";s:88:"16GB DDR3 - NCNR (Non-Cancellable/Non-Returnable) build option - Contact us for leadtime";s:10:"Color/Mono";s:5:"Color";}

this doesn't look very usable or will it do for now?

I sent the pm. No this is totally unusable. How can I make an export that shows the product options/characteristics for the order? This all seems pretty useless if I can't make a report of orders that contains all the items within it. I'm getting pretty frustrated.

Hello,

How can I make an export that shows the product options/characteristics for the order?

You can't.

This all seems pretty useless if I can't make a report of orders that contains all the items within it.

Well the export exports the products that are part of the order, it doesn't do the product specific options. For those who do not use specific options the current order report is fine. In your case it is inadequate, I fully agree with that. This is also the reason I am trying to understand how you have set things up, so I can modify the order export to include the data you want exported.

I'm getting pretty frustrated.

That is understandable but I think we have been miscommunicating. As explained in the paragraph above, I have been trying to understand how things are setup in your specific case so we can modify the order export to do what you want it to do.

I am going to have a look at this and get back to you.

Hello,

Attached is a patch file that turns the order_product_options into a human readable format. You can load the patch file and run the export after that.

Let me know how it goes.

Oh I had high hopes for a minute but the export returns: No data has been found for the selections made

This is only when a product is chosen in Order Product option. When nothing is there then the options show BUT I am back to having each item be on its own line which the client can't have. I need the same results but with only the "Edgertronic Camera" in the Order Product. I'm attaching the "successful" export.

Also sorry for my grouchiness. This client is a serious pain and is preventing me from completing other projects because of this stupid report. You guys are doing a great job with support and I really appreciate the extra effort.

Hello,

No data has been found for the selections made

That is just what it says, you made a selection and nothing matches that complete selection. Without the debug information I can't tell you what you are filtering on. In your previous debug log it stated you were filtering on camera but in your order database this product is stored as camera_1_5_7.

My guess is this has something to do with the product options but it is something I will need to look into. At least the options show correctly. This I will look into as well and get back to you.

Hello,

I need the same results but with only the "Edgertronic Camera" in the Order Product. I'm attaching the "successful" export.

So, let me clear something up. Are you saying you want the multiple order products on a single line? If so, the export can't do that because it exports the data on a row by row basis, the same way it is stored. CSVI can't transpose the data.

If you just want to export the Edgertronic Camera, in the order export template you can filter the products on edge and you get 2 options, you will need to choose the option camera_1_5_7 as this contains the product options. So it is product ID 241 as shown in the screenshot.

Yeah that still didn't get the report right. I have 5 variants built to create the total options for the product such as the way camera_1_5_7 is built. See first screenshot.

I then setup five dummy orders with one of each of the configurations as the product. When I run the export, I am still getting: No data has been found for the selections made

I need a report that shows 1 order per line WITH the camera's configuration. The customer needs to have the 1 order per line so they can tally order statistics by using SUM in Excel. If each option takes up a line in the CSV then SUM will tally EACH item as its own thing in the Order Total column. Meaning if each item shows order total to be $5495 then that order will SUM to 5495 x 4 but the order total is only 5495. So I need some way to display the configuration (via options/characteristics/variants) all on one line per order.

Hello,

I need a report that shows 1 order per line WITH the camera's configuration.

As I said before, that is not possible with the export routine as it exists now. You will need a customized export routine if you want that because it means the data needs to be transposed.

The customer needs to have the 1 order per line so they can tally order statistics by using SUM in Excel.

You would need another function in Excel then to tally the totals.

So I need some way to display the configuration (via options/characteristics/variants) all on one line per order.

As I said, you can have a custom export coded, or a script that will modify the output or the Excel function needs to be improved.

Meaning if each item shows order total to be $5495 then that order will SUM to 5495 x 4 but the order total is only 5495.

You will need a modified Excel calculation then. You could add a function that extracts one total value per order. That is beyond the CSVI support.

Ok. I'm essentially giving up on this project and giving the client two options:

1. What you say above - 4 rows per order to show product options
2. 1 row that does NOT show the product options.

However, I have been able to run #2 several times but now can't after all the work we've done. How I did it before was to just set the Order Product (in template options) to JUST the main product so that it only pulls that data. However when I do that now and try to run the export I'm a getting: No data has been found for the selections made

I also see nothing about the template searching for Order Product in the logs. See attached.

Hello,

However when I do that now and try to run the export I'm a getting: No data has been found for the selections made

There is a date filter set on the order creation date perhaps that range is no longer valid. Further, the export filters on the product ID called camera. That sounds wrong to me. That should be the order product code like it was in your earlier debug logs.

I just caught that. Sorry! Thank you.