| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | Mark Forums Read | User manuals | Login |
order items export | |||
|
|
Thread Tools | Search this Thread |
#1
|
|||||||
|
|||||||
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 |
|||||||
#2
|
|||||||
|
|||||||
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 |
|||||||
#3
|
|||||||
|
|||||||
Re: order items export
Anyone help with this?
__________________
X-Cart Gold 4.1.12 |
|||||||
#4
|
|||||||||
|
|||||||||
Re: order items export
Not sure how 4.1.12 is, this code is from 4.2.1
include/import_orders.php Code:
you can change it like this and see if it works for you Code:
__________________
Steve Stoyanov CFLSystems.com Web Development |
|||||||||
#5
|
|||||||
|
|||||||
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 |
|||||||
#6
|
|||||||
|
|||||||
Re: order items export
Did you have any success with this?
__________________
Darren X-Cart Gold 4.3.1 |
|||||||
#7
|
|||||||
|
|||||||
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 |
|||||||
|
Thread Tools | Search this Thread |
|
|
|
|||
X-Cart forums © 2001-2020
|