Orders Exporter Module

[juniper]

I seem to be having brain fart. I have uploaded the files to my uniquely named admin folder. I am not able to see the "Orders Export" option in my Tools dropdown. And I am out of ideas...can someone give me a hint? (P.S. I am a superuser; the only admin for this shopping cart)

[mprough]

I seem to be having brain fart. I have uploaded the files to my uniquely named admin folder. I am not able to see the "Orders Export" option in my Tools dropdown. And I am out of ideas...can someone give me a hint? (P.S. I am a superuser; the only admin for this shopping cart)

Clear your browser cache =)

[juniper]

Clear your browser cache =)

Thanks. I tried that and in several browsers. I am wondering is there anywhere in the Admin CP that I need to re-direct to my uniquely named admin folder? (It seems to know this anyway since the site is working). Perhaps tied to the webhost going down last night; will see what tomorrow brings.

[lunagraphica]

I need this same feature. Is there a way to ADD the quantity into the full report? That's a pretty important piece to be missing.

I need this as well. Without Quantity, the export file is pretty useless. Is there any way to add this?

[kharmachanic]

If you go into the ordersExport.php file in the admin directory you will see the code below
you can apparently add or delete the database fields to you want displayed in the exported files
and specify the order. You need to replicate it for each form type and you need to add the data field call to each section (line 54):


//all columns:
'v_date_purchased' => $iii++,
'v_orders_status_name' => $iii++,
'v_orders_id' => $iii++,
'v_customers_id' => $iii++,
'v_customers_name' => $iii++,
'v_customers_company' => $iii++,
'v_customers_street_address' => $iii++,
//'v_customers_suburb' => $iii++,
//'v_customers_city' => $iii++,
//'v_customers_postcode' => $iii++,
//'v_customers_state' => $iii++,
'v_customers_country' => $iii++,
'v_customers_telephone' => $iii++,
'v_customers_email_address' => $iii++,
'v_products_model' => $iii++,
'v_products_quantity' => $iii++,
'v_products_name' => $iii++,
//'v_products_options' => $iii++,
//'v_products_options_values' => $iii++,
);

$filelayout_sql = "SELECT
zo.orders_id as v_orders_id,
customers_id as v_customers_id,
customers_name as v_customers_name,
customers_company as v_customers_company,
customers_street_address as v_customers_street_address,
customers_suburb as v_customers_suburb,
customers_city as v_customers_city,
customers_postcode as v_customers_postcode,
customers_country as v_customers_country,
customers_telephone as v_customers_telephone,
customers_email_address as v_customers_email_address,
date_purchased as v_date_purchased,
orders_status_name as v_orders_status_name,
products_model as v_products_model,
products_name as v_products_name,
products_quantity as v_products_quantity,
products_options as v_products_options,
products_options_values as v_products_options_values
FROM ".TABLE_ORDERS_PRODUCTS." zop LEFT JOIN ".TABLE_ORDERS_PRODUCTS_ATTRIBUTES." opa
ON(zop.orders_products_id = opa.orders_products_id), ".TABLE_ORDERS." zo, ".TABLE_ORDERS_STATUS." zos
WHERE zo.orders_id = zop.orders_id
AND zo.orders_status = zos.orders_status_id

hope that helps..
Dont forget to backup your work

[kharmachanic]

I suspect if someone was decent at PHP coding (Which I am not) they could add a piece of code to this that would allow presorting of the data or specific data exported.
i.e all the orders on/or after a certain date.. or a certain product name..

[gjh42]

I am working on a comprehensive overhaul of this mod, including adding the ability to specify a date range (in days before present), and output all orders of a given status. I will look into the price total aspect as it has been requested repeatedly. I am only planning on supporting v1.5.x in this.

The "noAttribs" option already includes a line for order total cost, so it will probably be easy to add that to the rest of the options. Anyone who is careful and observant should be able to fix this for themselves.

[gjh42]

There are some useful code snippets in this old thread which are still relevant:
http://www.zen-cart.com/showthread.p...s-Exporter-0-1

add a piece of code to this that would allow presorting of the data or specific data exported.

I have long-range plans for a total rewrite of the mod that will allow choosing the elements to be output and their order, as well as more ways to limit output by specific criteria. For now, I will give it the date range, order status and a few more fields.

[corin]

I am having difficulty understanding the installation instructions. I am 1.3.9, so I have located the proper orders_Exporter folder to upload, but it doesn't make since to upload into my admin folder. Is that what I am supposed to do? The "orders_Exporter" folder is supposed to go exactly as is in my admin folder? Also, my admin folder was renamed years ago, so I don't understand why the instructions are asking me to rename it. Very confusing the way it is written, even a tech at bluehost could not understand the instructions. Thank you for your help.

[gjh42]

There are two levels of /orders_Export/ folders under the /orders_exporter_installation_for_zen_cart_1.3.X/ folder (I don't know why), and then the /admin/ and /oexport/ folders. Rename the mod /admin/ folder to match your renamed admin, then upload the admin and oexport folders to the root of your site.