Export Shipping & Order Information

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

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


.

[Doodlebuckets]

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

[dhcernese]

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

[dhcernese]

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

[dhcernese]

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

[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"

[econcepts]

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.

[dhcernese]

Thanks again for the feedback.

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

[econcepts]

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.

[new2u]

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