Export Shipping & Order Information

[dhcernese]

Just installed 1.2.6 it misses a whole lot. Running 1.3.8a guess ill revert to 1.2.2

I suspect that the new SQL query is overly restrictive, but I've not had any time to investigate this myself.

[econcepts]

I suspect that the new SQL query is overly restrictive, but I've not had any time to investigate this myself.

Yes, it is a result of the SQL query and the addition of a number of fields. I am working on a remedy to the issue but until then I would recommend using the previous version.

I hope to have a fix to the new version out here very soon.

[Endre]

Hi,
I need to include the gift voucher amount in the csv.
Any idea how to do this?

Cheers
Endre

[econcepts]

Hi,
I need to include the gift voucher amount in the csv.
Any idea how to do this?

Cheers
Endre

You would need to include that total from the corresponding class representation found in the "orders_total" table.

Query the proper class, pull the value.

Make sure you update the file in all needed locations and then check the results for proper inclusion of items (and that no previous items are missing in the results.)

[mcarbone]

This is a great mod! THANK YOU!

I need help separating the attributes column in different rows like 1 Product per row. The reason is that I have 5 products and the 6th product is a combination (family pack) of the first 5. To keep inventory I have attributes separate stock. We have a warehouse system that prints postage etc and it needs to have these attributes act like separate products in one order (which is what they are).

We have several hundreds of orders a day and the manual separation is overwhelming.

Thank you in advance for the help.

MC

[econcepts]

This is a great mod! THANK YOU!

I need help separating the attributes column in different rows like 1 Product per row. The reason is that I have 5 products and the 6th product is a combination (family pack) of the first 5. To keep inventory I have attributes separate stock. We have a warehouse system that prints postage etc and it needs to have these attributes act like separate products in one order (which is what they are).

We have several hundreds of orders a day and the manual separation is overwhelming.

Thank you in advance for the help.

MC

Hmm... let me take a look at this one here. I'm working on a few things with this mod in the next days anyhow and will determine what might be done to help this ...

Will post findings here.

[mcarbone]

You're amazing!

I think I have a start by narrowing down the code that can be modified in admin/shipping_export.php (around line 180)

if ($_POST['filelayout'] == 2) { // 1 PPR RADIO
$str_export = $str_export . ",\"" . $order_details->fields['products_quantity'] . "\"";
$str_export = $str_export . ",\"" . $order_details->fields['final_price'] . "\"";
$str_export = $str_export . ",\"" . $order_details->fields['products_name'] . "\"";
$str_export = $str_export . ",\"" . $order_details->fields['products_model'] . "\",";
$product_attributes_rows="SELECT Count(*) as num_rows
FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "
WHERE orders_id = " . $order_details->fields['orders_id'] . "
AND orders_products_id = " . $order_details->fields['orders_products_id'] . "";
$attributes_query_rows = $db->Execute($product_attributes_rows);
$num_rows = $attributes_query_rows->fields['num_rows'];
 If ( $num_rows > 0) {
 $product_attributes_query="SELECT *
 FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . "
 WHERE orders_id = " . $order_details->fields['orders_id'] . "
 AND orders_products_id = " . $order_details->fields['orders_products_id'] . "";
 $attributes_query_results = $db->Execute($product_attributes_query);
 $str_export = $str_export . "\"";
  for ($i = 0, $n = $num_rows; $i < $n; $i++) {
  $str_export = $str_export . $attributes_query_results->fields['products_options'] . ': ' . nl2br($attributes_query_results->fields['products_options_values']) . " | ";
  $attributes_query_results->MoveNext();
  }
 $str_export = $str_export . "\"";
}
} 

I've tried a couple things though that didn't work. I understand that most people would not want to split the attributes, so maybe there can be a check box that splits the attributes.

Thank you,

MC

[8808alpha]

Hi Guys, I am hoping that this is the thread for the "Export Shipping Information" module found here: http://www.zen-cart.com/index.php?ma...roducts_id=604

The module seems to work fine except it does not export orders from all countries. United States and Australia seem fine but countries like the UK and Finland don't show up in my export. And I have tried all the export options. Should I re-upload all the files again?

Any ideas? Thanks.

[econcepts]

Yes, this is the support thread for that.

What version are you using? It should work no matter the country etc...

I do know that version 1.2.6 has some reported issues (which I am working on as we speak) so I recommend version 1.2.5 for now.

Let me know if that version solves your problem. Again, it should work no matter the country.

[8808alpha]

Yes, this is the support thread for that.

What version are you using? It should work no matter the country etc...

I do know that version 1.2.6 has some reported issues (which I am working on as we speak) so I recommend version 1.2.5 for now.

Let me know if that version solves your problem. Again, it should work no matter the country.

I am running the latest version of Zen with with 1.2.6 Export Shipping Information. Should I downgrade to 1.2.5 and what is the best way to do that? Thanks.