Jump to content

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

Phone Number Not Getting Fetched In Cscart_Orders Table. Rate Topic   - - - - -

 
  • madhuri
  • Advanced Member
  • Members
  • Join Date: 27-Aug 14
  • 110 posts

Posted 09 March 2015 - 09:35 AM #1

When the order is generated for particular customer one row in cscart_orders table get created with order information along with customer details.In table cscart_orders all the other customer details are fetched rather than customer mobile number.Could anybody help me this?Does anybody know when the row is added when order is generated and which function is used for the insert query so icould debug it further?



Thank You.

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

Posted 09 March 2015 - 10:58 AM #2

When the order is generated for particular customer one row in cscart_orders table get created with order information along with customer details.In table cscart_orders all the other customer details are fetched rather than customer mobile number.Could anybody help me this?Does anybody know when the row is added when order is generated and which function is used for the insert query so icould debug it further?


If you use custom profile field for the phone number, the entered value is stored in the cscart_profile_fields_data table where the object_type is O and object_id is order ID.

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 руб.


 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11429 posts

Posted 09 March 2015 - 09:19 PM #3

And it is stored as an regular array, not a relational array. So you will have to loop through all the custom profile fields and then select it by name rather than referencing it by index.

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • madhuri
  • Advanced Member
  • Members
  • Join Date: 27-Aug 14
  • 110 posts

Posted 10 March 2015 - 06:15 AM #4

Could you please tell me where is the insert query i.e in which function where the row gets inserted in cscart_profile_fields_data when we place a order or a user is registered.It would be of great help.

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

Posted 10 March 2015 - 09:27 AM #5

Could you please tell me where is the insert query i.e in which function where the row gets inserted in cscart_profile_fields_data when we place a order or a user is registered.It would be of great help.


Please check the fn_store_profile_fields function in the app/functions/fn.users.php file

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 руб.


 
  • CS-Market
  • Senior Member
  • Authorized Reseller
  • Join Date: 06-Mar 13
  • 676 posts

Posted 10 March 2015 - 09:39 AM #6

Could you please tell me where is the insert query i.e in which function where the row gets inserted in cscart_profile_fields_data when we place a order or a user is registered.It would be of great help.


The following line replaces the data into this table (approximately 621 string of app/functions/fn.users.php file):
db_query("REPLACE INTO ?:profile_fields_data ?e", $_data);

To find out, which data will place in this table, please use the following code before the function above:
fn_print_r($_data);

Hope it will help you.

GET A FREE QUOTE  │  CS-Cart add-ons   │   CS-Cart custom development   │  CS-Cart design integration  │  CS-Cart license

Сертифицированный разработчик на CS-Cart Русская Версия. More than 5 years experience in CS-Cart development.


 
  • madhuri
  • Advanced Member
  • Members
  • Join Date: 27-Aug 14
  • 110 posts

Posted 10 March 2015 - 01:06 PM #7

What do you mean by field type column in cscart_profile_fields_data ?It stores two values 36 and 40?And during each order two rows are created ..please could you explain me this?

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

Posted 10 March 2015 - 04:10 PM #8

What do you mean by field type column in cscart_profile_fields_data ?It stores two values 36 and 40?And during each order two rows are created ..please could you explain me this?


How many non-default Profile fields do you have?

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 руб.


 
  • madhuri
  • Advanced Member
  • Members
  • Join Date: 27-Aug 14
  • 110 posts

Posted 12 March 2015 - 06:48 AM #9

I have solved that problem.Thanks a lot for your help..