Need Some Custom Code

Hi,

I'm a former Oracle, Delphi, and C# developer and am not proficient at php. I'm now semi retired and a woodworker. Some of my products have options and I want a report that shows what options have sold.

So, technically, what I want is a php page that, when called, will insert into a new mysql table:

order_id, product_id, and the "Options: .." string as seen on packing slips.

Then I can write a query to join the new table with existing order/product tables to create my report.

The Options string is what I'm having trouble with because it apparently comes from php serialized data. It would take me a very long time to figure out how to do it and I thought it would be a breeze for those of you who do this all the time.

Please PM me with a price to do it. Or, if there already exists an add-on that accomplishes this, please let me know.

Thanks,

Don

Hi,

I'm a former Oracle, Delphi, and C# developer and am not proficient at php. I'm now semi retired and a woodworker. Some of my products have options and I want a report that shows what options have sold.

So, technically, what I want is a php page that, when called, will insert into a new mysql table:

order_id, product_id, and the "Options: .." string as seen on packing slips.

Then I can write a query to join the new table with existing order/product tables to create my report.

The Options string is what I'm having trouble with because it apparently comes from php serialized data. It would take me a very long time to figure out how to do it and I thought it would be a breeze for those of you who do this all the time.

Please PM me with a price to do it. Or, if there already exists an add-on that accomplishes this, please let me know.

Thanks,

Don

Hello,

You can use the php 'unserialize' function. Take a look:

$data = unserialize($database_query_result);

After this you can approach any data as follows:

$data['array_key']

If you havent been able to with this knowledge please contact us via e-mail (sales@poppedweb.com) or a PM.

Cheers!

Thank you, but that solution requires that I spend hours learning about php and the framework used by CS-Cart. That's a huge amount of time to invest when my only goal is to find which options were selected for each order so I can estimate what to make/buy next year.

Again, I want is a php page that, when called, will insert into a new mysql table:

order_id, product_id, and the "Options: .." string as seen on packing slips.

I imagine this would be fairly easy code to write for someone who is familiar with php and the cs-cart framework?

Thank you, but that solution requires that I spend hours learning about php and the framework used by CS-Cart. That's a huge amount of time to invest when my only goal is to find which options were selected for each order so I can estimate what to make/buy next year.

Again, I want is a php page that, when called, will insert into a new mysql table:
[b]order_id[/b], [b]product_id[/b], and the "Options: .." string as seen on packing slips.

I imagine this would be fairly easy code to write for someone who is familiar with php and the cs-cart framework?


Hello,

Yes this would be fairly easy to implement.

Best wishes,

Thank you, but that solution requires that I spend hours learning about php and the framework used by CS-Cart. That's a huge amount of time to invest when my only goal is to find which options were selected for each order so I can estimate what to make/buy next year.

Again, I want is a php page that, when called, will insert into a new mysql table:

order_id, product_id, and the "Options: .." string as seen on packing slips.

I imagine this would be fairly easy code to write for someone who is familiar with php and the cs-cart framework?

Hello!

We would be glad to make such modification for you. Please contact us

Our team is also at your service

You are welcome to drop us a line too.

Best regards,

Alt-team.