Export Shipping & Order Information

I saw it on some printed stickers, that was with my modified version. Then I tried with the original version, and the same thing happened to me.

Just with default settings. By the way, you could easily see my changes if you load the original file and the adjusted file into winmerge. I think that it would clarify some things.

Maybe I will try again later tonight, but I think it's just some forgotten code. (At the places where I added the extra code were the other things, such as delivery street, there but not company.)

Briann:

I saw it on some printed stickers, that was with my modified version. Then I tried with the original version, and the same thing happened to me.

Just with default settings. By the way, you could easily see my changes if you load the original file and the adjusted file into winmerge. I think that it would clarify some things.

Maybe I will try again later tonight, but I think it's just some forgotten code. (At the places where I added the extra code were the other things, such as delivery street, there but not company.)

Thanks for the clarification. Will definitely look at this here and report back.

I have been using this model but have needed to make some changes to suit my shop.
The first was so I could download the orders with attributes and totals. I got it to work.
However I have two problems

1. Every order is duplicated.
2. I need to also download other information from the orders table for example delivery address and notes for the order. I followed the same method as already used however now when I download I don't get any information. Any help would be appreciated. (Please note this is the first time I have attempted to make changes to PHP.)
   Thank you in Advance
   Stephen

This is what I changed it to.
case 'onlyAttribs':
$iii = 0;
$filelayout = array(
//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_state' => $iii++,
'v_customers_postcode' => $iii++,
'v_customers_country' => $iii++,
'v_customers_telephone' => $iii++,
'v_customers_email_address' => $iii++,
'v_delivery_name' => $iii++,
'v_delivery_company' => $iii++,
'v_delivery_street_address' => $iii++,
'v_delivery_suburb' => $iii++,
'v_delivery_city' => $iii++,
'v_delivery_state' => $iii++,
'v_delivery_postcode' => $iii++,
'v_delivery_country' => $iii++,
'v_products_model' => $iii++,
'v_products_name' => $iii++,
'v_products_options' => $iii++,
'v_products_options_values' => $iii++,
'V_products_options_price' => $iii++,
'v_total_cost' => $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_state as v_customers_state
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,
delivery_name as v_delivery_name,
delivery_company as v_delivery_company,
delivery_street_adress as v_delivery_street_address,
delivery_suburb as v_delivery_suburb,
delivery_city as v_delivery_city,
delivery_state as v_delivery_state,
delivery_postcode as v_delivery_postcode,
delivery_country as v_delivery_country,
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_options as v_products_options,
products_options_values as v_products_options_values,
options_values_price as V_products_options_price,
order_total as v_total_cost
FROM ".TABLE_ORDERS." zo JOIN ".TABLE_ORDERS_PRODUCTS." zop JOIN ".TABLE_ORDERS_PRODUCTS_ATTRIBUTES." opa
ON(zo.orders_id = zop.orders_id), ".TABLE_ORDERS_STATUS." zos
WHERE zop.orders_products_id = opa.orders_products_id
AND zos.orders_status_id != '3'
AND zo.orders_status = zos.orders_status_id
";
break;
} //eof switch
$filelayout_count = count($filelayout);

Doh problem two was fixed, it was a simple spelling error. Opps
I still have the problem where each order line is duplicated.
Also I need to have on the download the shipping cost for each order.
I am downloading this file for a piece of software to produce a Sage invoice for me.

stecrox:

Doh problem two was fixed, it was a simple spelling error. Opps
I still have the problem where each order line is duplicated.
Also I need to have on the download the shipping cost for each order.
I am downloading this file for a piece of software to produce a Sage invoice for me.

If orders are being duplicated and you made changes to the file it sounds like you did something incorrectly in the "loop" that either pulls the data from the database or the one that writes to the file.

Check your SQL query and make sure you are only pulling a single record per row (if that is what you want.) It may be that you added a new statement to the SQL query that duplicates the records being pulled (before ever being written to the file.)

Briann:

Solved it by some searching on google. It seems to be a common problem with IE and an SSL connection. (tried FF at home, and it's fine)

See over here: http://support.microsoft.com/kb/316431

Can you explain how you solved this problem? Where did you change the Header Cache-control settings?

Thanks
ArtisticD

I would like to strip the quotemarks from the export so the file just exports the data and doesn't add the "" .

any help would be appriciated.

Regards,

This module is totally wonderful and has allowed me to create a "combined packing list" so that I can more easily fill orders.

It would be absolutely perfect if we also had the ability to download the Manufacturer ID (or better yet, Manufacturer Name). Would this be difficult to add in a future release?

Thanks again.

karimm:

I would like to strip the quotemarks from the export so the file just exports the data and doesn't add the "" .

any help would be appriciated.

Regards,

Be careful if you strip out the quotes. You can do it but it would require altering the code in the file (make a backup first).

Removing the quotes incorrectly could cause the data exported to be spread across multiple columns and out of sync with the headers so again, be careful. The "quotes" are to indicate text fields etc...

Another method might be to open the file in a program like Excel and then re-save as csv and make sure you don't "quote characters" when saving (from excel).

Let me know if that works.

GardenGal:

This module is totally wonderful and has allowed me to create a "combined packing list" so that I can more easily fill orders.

It would be absolutely perfect if we also had the ability to download the Manufacturer ID (or better yet, Manufacturer Name). Would this be difficult to add in a future release?

Thanks again.

Glad you like it! I certainly could look at adding Manufacturers ID in future release.

PM me your email and I'll make sure you get a notification when it is up and ready.

Thanks!

Where can I find this mod?

Thanks,

Eric

I'm having a problem with this add-on. The orders show up on my screen but when I export, I only get the column headers. All the other lines are blank. I tried installing again but still nothing. Any suggestions?

sgt_slaughter:

Where can I find this mod?

Thanks,

Eric

You can get it from the downloads section here:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=604

nazy:

I'm having a problem with this add-on. The orders show up on my screen but when I export, I only get the column headers. All the other lines are blank. I tried installing again but still nothing. Any suggestions?

I've heard of others having this problem in the past.

1. Try selecting "export orders already exported" and see if that works.

Let me know what happens. I might need to take a look at it for you.

econcepts:

I've heard of others having this problem in the past.

1. Try selecting "export orders already exported" and see if that works.

Let me know what happens. I might need to take a look at it for you.

I tried that already but got the same result.

nazy:

I tried that already but got the same result.

Do all of your product orders have a "shipping address" (delivery)?

It might sound strange, but the system bases its info off of the shipping address and in a few cases I've seen users get nothing exported if there is no shipping (delivery) address present?

Let me know that answer.

Thanks!

econcepts:

Do all of your product orders have a "shipping address" (delivery)?

It might sound strange, but the system bases its info off of the shipping address and in a few cases I've seen users get nothing exported if there is no shipping (delivery) address present?

Let me know that answer.

Thanks!

Everything looks fine. Could the problem be caused by other add-ons I have installed?

nazy:

Everything looks fine. Could the problem be caused by other add-ons I have installed?

No other add in should affect it to my knowledge.

PM me the link to your site and the admin section (if you want) and I'll take a look for you.

Ok, got your PM and am looking into this (in your admin now).

From initial glance, it looks like order #245 could be the culprit as it is missing all the shipping information.

I will run a few more tests here and report back.

Hang in there!

It also looks like you are missing an updated language file or something because there is a portion near the bottom of the right side (just above the export button) that lists the CONSTANT names and not the actual language.