Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

order items export

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design
 
Thread Tools Search this Thread
  #1  
Old 10-30-2009, 01:39 AM
 
cycloneuk cycloneuk is offline
 

Advanced Member
  
Join Date: Apr 2008
Posts: 54
 

Arrow order items export

In the order items export i also wan't to include the customers first name and last name. Any ideas?
__________________
X-Cart Gold 4.1.12
Reply With Quote
  #2  
Old 10-30-2009, 03:37 AM
 
cycloneuk cycloneuk is offline
 

Advanced Member
  
Join Date: Apr 2008
Posts: 54
 

Default Re: order items export

This is how i have got my order_items export to display.

!ORDERID !PRODUCTCODE !B_FIRSTNAME !B_LASTNAME !EMAIL

The last 3 fields are blank because it's not pulling the data for them since they are stored in two different tables, the first 2 are stored in order_details and the last 2 are in orders.
__________________
X-Cart Gold 4.1.12
Reply With Quote
  #3  
Old 10-31-2009, 08:43 AM
 
cycloneuk cycloneuk is offline
 

Advanced Member
  
Join Date: Apr 2008
Posts: 54
 

Default Re: order items export

Anyone help with this?
__________________
X-Cart Gold 4.1.12
Reply With Quote
  #4  
Old 11-01-2009, 05:33 AM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,190
 

Default Re: order items export

Not sure how 4.1.12 is, this code is from 4.2.1
include/import_orders.php
Code:
if ($single_mode || AREA_TYPE == 'A') { $row = func_query_first("SELECT * FROM $sql_tbl[orders] WHERE orderid = '$id'"); } else { $row = func_query_first("SELECT $sql_tbl[orders].* FROM $sql_tbl[orders], $sql_tbl[order_details] WHERE $sql_tbl[orders].orderid = '$id' AND $sql_tbl[orders].orderid = $sql_tbl[order_details].orderid AND $sql_tbl[order_details].provider = '$login'"); }

you can change it like this and see if it works for you
Code:
# if ($single_mode || AREA_TYPE == 'A') { # $row = func_query_first("SELECT * FROM $sql_tbl[orders] WHERE orderid = '$id'"); # } else { $row = func_query_first("SELECT $sql_tbl[orders].* FROM $sql_tbl[orders], $sql_tbl[order_details] WHERE $sql_tbl[orders].orderid = '$id' AND $sql_tbl[orders].orderid = $sql_tbl[order_details].orderid AND $sql_tbl[order_details].provider = '$login'"); # }
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #5  
Old 11-02-2009, 01:27 PM
 
cycloneuk cycloneuk is offline
 

Advanced Member
  
Join Date: Apr 2008
Posts: 54
 

Default Re: order items export

Nope, didn't work cflsystems thanks though for trying to help. It's the order items php file that needs to be modified.
__________________
X-Cart Gold 4.1.12
Reply With Quote
  #6  
Old 07-02-2012, 06:02 AM
 
dmpinder dmpinder is offline
 

Advanced Member
  
Join Date: Jun 2009
Posts: 86
 

Default Re: order items export

Did you have any success with this?
__________________
Darren

X-Cart Gold 4.3.1
Reply With Quote
  #7  
Old 07-02-2012, 08:05 AM
 
dmpinder dmpinder is offline
 

Advanced Member
  
Join Date: Jun 2009
Posts: 86
 

Default Re: order items export

Hi cycloneuk,

I've just worked out how to include other info into this export, such as date of purchase and category of the product purchased. I'm sure you can use my instructions on here and modify the LEFT JOIN to join onto the customers table instead: http://forum.x-cart.com/showthread.php?t=64163

Let me know if you get stuck with it.
__________________
Darren

X-Cart Gold 4.3.1
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 09:05 PM.

   

 
X-Cart forums © 2001-2020