Export Shipping & Order Information

Danielle:

Oh...darn it lol, mine is quite heavily modified to include extra fields and remove other unnecessary fields. Can I just grab the header section from the 1.3.2 file and put it in my file, or are there other changes that would need to be made for that to work?

It depends on what previous version you were running. Copying headers under any case will not work.

If yours is modified to that extent it probably would not be a good idea to upgrade.

It would also be difficult to determine where the issue might be as it could be related to some of the modifications that were made on your end.

Give me a list here of the exact issues and I will see if I can provide you with the sections of code (from the original code that is) where you might want to look to correct them.

Also give me the version of the program you were using that you modified so I know what code you started with.

Thanks!

OK, thanks! It is version 1.3.1. I don't think any of the changes I made would have removed the header information. The modifications I made were mostly to row names and I also added some more fields and moved some around. We are using it to export orders to the shipping warehouse so it had to follow their required format. I also set up a php script to automatically FTP the file from the server to the warehouse when the store owner clicks the Export button. The headers work fine if I download the file, but they just don't show up if I save it to the server.

The only issue is the header row, I just want it to show up in the file when it is saved on the server. Right now it only shows up if I download the file. Everything else works great :D

Danielle:

OK, thanks! It is version 1.3.1. I don't think any of the changes I made would have removed the header information. The modifications I made were mostly to row names and I also added some more fields and moved some around. We are using it to export orders to the shipping warehouse so it had to follow their required format. I also set up a php script to automatically FTP the file from the server to the warehouse when the store owner clicks the Export button. The headers work fine if I download the file, but they just don't show up if I save it to the server.

The only issue is the header row, I just want it to show up in the file when it is saved on the server. Right now it only shows up if I download the file. Everything else works great :D

Do this. Send that file over to me (just the one found here /admin/shipping_export.php) and I'll take a look. I can correct the header info only and then send it back for you. Sound good?

That way you don't lose any current custom functionality but still get it working to your liking.

You'll need to zip the file up and send it. If you can attach it to a Private Message then do that. Otherwise, contact me via a private message and I'll give you an email to send it to.

Thanks!

econcepts:

Do this. Send that file over to me (just the one found here /admin/shipping_export.php) and I'll take a look. I can correct the header info only and then send it back for you. Sound good?

That way you don't lose any current custom functionality but still get it working to your liking.

You'll need to zip the file up and send it. If you can attach it to a Private Message then do that. Otherwise, contact me via a private message and I'll give you an email to send it to.

Thanks!

Wow thank you, I really appreciate this! I will send you a PM right now :)

Fixed and sent back (check your PM).

Let me know if it works.

Worked perfectly, thanks so much!

Great! Glad to hear it worked for you.

econcepts:

If you want to send me a private message with your email I can email a copy of that to you (with the changes you need to the ship dest type field).

Hi,

Thanks, Eric. That's ok; I'll just wait for the normal release. I got around the problem by editing the exported file, moving those columns around, and deleting the extra field. Then it imported fine.

Weird about the records not showing up, though. In the past whenever I went in with PHPAdmin and changed that flag, it would then show up to be exported again. But now it doesn't. I refreshed the page and then tried logging out and back in. Nothing.

--Susie

Hi there I have a fresh Zen Cart 1.39f install and I am trying to use it to process 5K race registrations.

In order for my store to be useful I need to be able to download the entries in a bulk manner and import them into my timing system, hence my discovery of your great module.

However I have hit a snag. My entries have additional attributes like Gender, date of birth, t-shirt size etc...

In order to get imported correctly I need those fields to each have their own column. Instead the extra attributes get exported all in one column with a | between them.

Is there any way to change this behavior? If you would like to see my "store" it is at https://gcrunner.c10.ixwebhosting.com/zencart

You can see the various options that I need to include.

Thanks for any ideas you may have.

@sduffy,

There is no way in the current module to alter that from within the interface. However, if you want me to customize a version just for your needs (I've done this for a few others with specific requirements) send me a private message and we can talk about it.

Thanks!

econcepts:

What version of the module are you using?

I'll have to look and see if anything else changed that would have added or dropped something when the ISO codes are used. Anyone else notice this problem on their system?

magnusrf:

I had ISO Country Code checked, when I went back and unchecked it , it worked.

Same here.

version 1.3.2, when click product per row, with ISO Country Code selected will have error, bug at admin/shipping_export.php line 91 and 92, interchange this two line will work.

fatfaifai:

Same here.

version 1.3.2, when click product per row, with ISO Country Code selected will have error, bug at admin/shipping_export.php line 91 and 92, interchange this two line will work.

What was the exact error code you received?

econcepts:

What was the exact error code you received?

excalty same as magnusrf

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND cc.countries_name = o.delivery_country WHERE o.orders_id = ot.orders_id AND' at line 1
in:[...] If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

It appeared that the 'AND cc.countries_name = o.delivery_country' append before the WHERE clause in line 91-92, when iso country 2 or 3 selected.

fatfaifai:

excalty same as magnusrf

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND cc.countries_name = o.delivery_country WHERE o.orders_id = ot.orders_id AND' at line 1
in:[...] If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

It appeared that the 'AND cc.countries_name = o.delivery_country' append before the WHERE clause in line 91-92, when iso country 2 or 3 selected.

Ok, super. Thanks for listing that. I'll look at it here and alter for the next release. I have a new one coming out soon so that will be addressed.

Hi
just a couple of quick questions regarding the exported CSV file with customers orders-
1.There seems to be a zero or letter o in some header row titles-such as,Product 0 Price,Product 0 Name etc,any idea how to remove this?
2.How can I remove certain header row items such as Customer email, Country and Postcode?
3.Have noticed some exported orders are being exported twice in the same export-in test mode without including previously exorted orders

Thanks in advance for any help

trickobrien:

1.There seems to be a zero or letter o in some header row titles-such as,Product 0 Price,Product 0 Name etc,any idea how to remove this?

This is automatically added only when you are trying to export one order per row (it is not present in one product per row) and it should not be removed or it will render the rest of the export un-usable. If you have more than one product per order that is when it increments up Product 2, etc...

trickobrien:

2.How can I remove certain header row items such as Customer email, Country and Postcode?

These are part of the default export. You can remove them but you'll need to remove them in several locations. First staring with the header row (in the php file) and then you will need to find each instance of where the data would be exported (the actual data row) and remove those as well. If you don't remove them correctly, you will throw your entire export file off (items will be exported in the incorrect locations most likely.)

trickobrien:

3.Have noticed some exported orders are being exported twice in the same export-in test mode without including previously exorted orders

What version of the mod are you using? If you are exporting one ORDER per row then you should see (if all is working ok) only one order per line.

If however you are exporting one PRODUCT per row then you will see one product per line. So if an order has multiple products, you will get that order info multiple times (because each product exports on a separate line.)

Thanks for taking the time to clear that up for me,now I understand

I would like to remove the 'Product Price' and 'Product Attributes' fields from the csv file (when 'Full Product Details' is checked), could you possible let me know exactly how I could do that?

DML73:

I would like to remove the 'Product Price' and 'Product Attributes' fields from the csv file (when 'Full Product Details' is checked), could you possible let me know exactly how I could do that?

These are referenced in a few areas with in the file (header, one product per row, one order per row) sections.

The best thing to do is to search on 'price' and 'attributes' and then just comment out all of those areas where they appear.

You might need to remove some code from an SQL query or so as well.

If I check the checkbox "Save file to server and automatically email to supplier", where is the file saved on my server?? in what folder? :blink: