Phone Number Not Getting Fetched In Cscart_Orders Table

Multi-Vendor Questions
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.

2

[quote name='madhuri' timestamp='1425893743' post='207430']

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?

[/quote]



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.

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.

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.

5

[quote name='madhuri' timestamp='1425968137' post='207500']

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.

[/quote]



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

6

[quote name='madhuri' timestamp='1425968137' post='207500']

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.

[/quote]



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.

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?

8

[quote name='madhuri' timestamp='1425992764' post='207569']

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?

[/quote]



How many non-default Profile fields do you have?

9

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