Jump to content

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

Exporting Orders Fields Problem Rate Topic   - - - - -

 
  • anesdiaf
  • Newbie
  • Members
  • Join Date: 14-Nov 19
  • 5 posts

Posted 21 January 2020 - 02:06 PM #1

Hi,

When i export orders, the field: shipping state or billing state, can't seem to show me the state name however it shows me the state's code.

can i add more fields to the exporting fields ? and what field should i add to make the state name appear in the csv file ?

thanks.



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

Posted 22 January 2020 - 05:42 AM #2

app/schemas/exim/orders.php

 

You can extend this schema and add new export field there

 

It is required to create 2 functions to receive state name from state code and vice versa

 

Use Date field as example


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    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • anesdiaf
  • Newbie
  • Members
  • Join Date: 14-Nov 19
  • 5 posts

Posted 22 January 2020 - 07:48 AM #3

Thank you very much, but what i should convert it to.

s_state_to _? what's the db_field for s_state name please ?



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

Posted 22 January 2020 - 01:00 PM #4

Thank you very much, but what i should convert it to.

s_state_to _? what's the db_field for s_state name please ?

 

Get state_id from cscart_states by code and get description from cscart_state_descriptions table by state_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    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • anesdiaf
  • Newbie
  • Members
  • Join Date: 14-Nov 19
  • 5 posts

Posted 30 January 2020 - 08:47 AM #5

thank you very much eCom labs.