Export Shipping & Order Information

[lhungil]

I believe "Export Shipping+Order Information" will not export an order unless the order has an order_total line for ot_shipping. Make sure you are adding shipping information to the order or modify "Export Shipping+Order Information" to include orders without an order_total line for ot_shipping.

This requirement for orders has been previously mentioned in this support thread.... See #7.

[econcepts]

I believe "Export Shipping+Order Information" will not export an order unless the order has an order_total line for ot_shipping. Make sure you are adding shipping information to the order or modify "Export Shipping+Order Information" to include orders without an order_total line for ot_shipping.

This requirement for orders has been previously mentioned in this support thread.... See #7.

This is correct. When I started the module originally it was keying off of the shipping information (so if shipping information was not present the order would not show in the export.) I'm sure it can be altered to work around that if needed. I've been working on updating a number of my modules here recently but haven't looked into this one yet.

Are you entering a shipping total when editing / adding the order?

Eric

[ChiliPepperWeb]

I'm interested in adding the Product Category to the product details being exported. I've tried searching first to see if anyone else has done this already, but found nothing thus far. How much trouble would it be to do this?

[ccn1]

Hi there, brill module and well done, this is great for exporting the data.

Can I ask how and where I could change the order the CSV fields are exported ?

I have recently changed couriers and would like to streamline the upload to there site and would like to change the export of fields in order as follows;

A Address line 1 (mandatory)
B Address line 2
C Address line 3
D Address line 4
E Postcode (mandatory)
F First name
G Surname (mandatory)
H [Blank]
I [Blank]
J Phone
K Email
L Weight (in kg)
M [Blank]
N [Blank]
O Reference/Order No
P [Blank]
Q [Blank]

Thank you in advance :)

Chris

[giftmeister]

Thanks for a great mod!

I did change the admin->shipping_export.php file in 2 ways:
- deleted the lines "AND ot.class = 'ot_shipping'" so I could export all orders

I also want to export all orders and tried deleting those lines/parts above and can't get it right. How exactly should the three instances be changed?

line 102 $order_info = $order_info . "AND ot.class = 'ot_shipping'";
line 134 AND ot.class = 'ot_shipping' ";
line 162 AND ot.class = 'ot_shipping'";

And what's the simplest way to block fields from appearing in the spreadsheet, like "delivery_suburb."?

[Buffoon]

Did you manage to get this working in the end? I have just had this crop up for the first time after adding some virtual products and I can't get the report to show the orders with free shipping either. Deleting those three lines doesn't seem to help; it still works but the same orders are missing from the output.

It's a shame because the solution in post #7 sounds so perfect and this is a magnificent mod in all other respects!

[giftmeister]

Still not...and after I played around with a dozen variations to delete those lines/codes in question.

To be clear, I'm getting all order info except for the customer name and address.

[giftmeister]

Finally...

102= $order_info = $order_info . "AND ot.class = 'ot_shipping'";

change to

$order_info = $order_info;

Or block out the part after the above with //

134= delete or block, but add "; to the end of the previous line, 133. They should look like:

$order_info = $order_info . " WHERE o.orders_id = ot.orders_id ";
// AND ot.class = 'ot_shipping' ";

162= same as 134, should look like:

WHERE o.orders_id = ot.orders_id ";
// AND ot.class = 'ot_shipping'";

Then change all "delivery_" to "billing_".

[giftmeister]

What I'd like to do now is have each product attribute in its own spreadsheet column instead of all of them into one (many of my items have 2+ attributes). Is that possible?

[econcepts]

What I'd like to do now is have each product attribute in its own spreadsheet column instead of all of them into one (many of my items have 2+ attributes). Is that possible?

This is possible with the default module (no special programming updates needed.) You'll find a sample of this in action in the 'sample_exports' directory (third file in list.)

Let me know if this helps or if you need more information.