Export Shipping & Order Information

Ok, for those of you who have been looking for the new release, I just uploaded it (not posted by the zen cart team yet but you can get it now from the link below if you don't want to wait.)

In this release:
**

• Bugfix:** Corrected issues with company name not exporting correctly (field was coming in blank)
  **
• Bugfix:** if a product's attributes have a newline in them, the export file also has a line break in it, making the import break. This can occur if there is a text entry field for a product attribute (such as a gift card memo, etc.). This has now been corrected.

- New Addition: Added the ability to export Manufacturers Name

The only thing that was altered was the "/admin/shipping_export.php" file so if you are running any of the versions 1.2.x plus all you need to do is upload this one file and overwrite what you already have. That's it.

If you can't wait for the free downloads area to post it get it at the link below now:

**Export Shipping and Order Information v1.2.6**

.

econcepts:

No problem. Yes, under the circumstances I listed in my response (if that is indeed the case) then it would work for months (or years) up until MySQL was altered (by possible upgrade, host changes, other means sometimes outside your control.)

Take a look at those links and let me know if they help. It seems as though the answer is in the collation of the tables.

It's all beyond my understanding. No changes have been made unless she was hacked. I am thinking we just won't be able to use this mod...

econcepts:

Ok, for those of you who have been looking for the new release, I just uploaded it (not posted by the zen cart team yet but you can get it now from the link below if you don't want to wait.)I just uploaded 1.2.6 and tested it out. It does not export any order that is missing shipping information. We get a lot of these, the prior versions exported all the other information for those order (people would put addresses in the notes or attributes), now we don't get any of them.

When I get a chance, I'll take a look at the code and see if its an easy "fix" (or add an option).

..those aren't the only orders missing. I have an order from 2-Jan (that has normal shipping information) to GB that is not included. The only oddity might be the word "it's" in the note the customer sent?

(fyi - i was last using 1.2.2, I skipped 1.2.4)
Even though the orders show up on the 'left hand side' of the export screen, they are not in the file.

1.2.2 works fine. 1.2.6 skips lots of my orders if it doesn't like something about the delivery address. anything without a delivery address doesn't get exported and orders that come in like this do not get exported (from reverting to 1.2.2):

"1480","[email protected]","chris xxx xxx xxxxxxx","","15 vieux close","otterton","Budleigh salterton"," devon","ex9 7jt","United Kingdom"

dhcernese:

1.2.2 works fine. 1.2.6 skips lots of my orders if it doesn't like something about the delivery address. anything without a delivery address doesn't get exported and orders that come in like this do not get exported (from reverting to 1.2.2):

"1480","[email protected]","chris xxx xxx xxxxxxx","","15 vieux close","otterton","Budleigh salterton"," devon","ex9 7jt","United Kingdom"

Thanks for the feedback here. I will use this to determine where the new query might be dropping any data. I had to add a bit in there to allow for the manufacturer info but other than that, nothing changed.

Until then, an easy way for you to go back is to just upload the "shipping_export.php" file from the prior verison you were using. This will work just fine since that is the only file that was altered in this latest release.

Let me know if you find anything else out on this and in the mean time, I'll look at the issue you seem to bee having with the 1.2.6 version here.

Thanks again for the feedback.

econcepts:

Thanks again for the feedback.Thanks for looking into it, ...it doesn't matter if the manufacturer is 'none', does it?

dhcernese:

Thanks for looking into it, ...it doesn't matter if the manufacturer is 'none', does it?

It shouldn't. I thought I allocated the code for that. Will check though just to make sure.

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

new2u:

Just installed 1.2.6 it misses a whole lot. Running 1.3.8a guess ill revert to 1.2.2I suspect that the new SQL query is overly restrictive, but I've not had any time to investigate this myself.

dhcernese:

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.

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

Cheers
Endre

Endre:

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.)

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. :smile:

MC

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. :smile:

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.

You're amazing!:smile:

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

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?main_page=product_contrib_info&cPath=40_41&products_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.

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.

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.

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.