Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Need Some Custom Code Rate Topic   - - - - -

 
  • dswood
  • Member
  • Members
  • Join Date: 19-Mar 16
  • 39 posts

Posted 06 January 2018 - 01:40 PM #1

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


csc 4.3.6


 
  • poppedweb
  • Authorized Reseller
  • Members
  • Join Date: 02-Aug 16
  • 345 posts

Posted 06 January 2018 - 02:28 PM #2

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!


PoppedWeb | sales@poppedweb.com | https://poppedweb.com
TurnKey Website Design | Add-Ons | Performance Audits | Dedicated Server Management
24/7 Support | Response within an hour (during working hours).

 
  • dswood
  • Member
  • Members
  • Join Date: 19-Mar 16
  • 39 posts

Posted 06 January 2018 - 03:29 PM #3

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


csc 4.3.6


 
  • poppedweb
  • Authorized Reseller
  • Members
  • Join Date: 02-Aug 16
  • 345 posts

Posted 06 January 2018 - 03:44 PM #4

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_idproduct_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,

Yes this would be fairly easy to implement.

Best wishes,
PoppedWeb | sales@poppedweb.com | https://poppedweb.com
TurnKey Website Design | Add-Ons | Performance Audits | Dedicated Server Management
24/7 Support | Response within an hour (during working hours).

 
  • oleg.gorshkov
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 06-Dec 13
  • 2655 posts

Posted 08 January 2018 - 05:31 AM #5

 

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_idproduct_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


Simtech Development | sales@simtechdev.com | www.simtechdev.com
CERTIFIED CS-CART PARTNER | LICENSES | DEVELOPMENT | ADD-ONS | DESIGN | UPGRADE
Get more traffic with JSON-LD for SEO


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 17112 posts

Posted 09 January 2018 - 06:13 AM #6

Our team is also at your service


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.

 
  • Alt-team
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 18-Jan 11
  • 2534 posts

Posted 09 January 2018 - 09:42 AM #7

You are welcome to drop us a line too.

 

Best regards,

Alt-team.


add-ons | web development service | design | page speed increasing

Buy MULTIVENDOR - USD 1250 (14% off)   |   Buy CS-CART LICENCE - USD 345 (13% off)