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.
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.
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?
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