Export Shipping & Order Information

[fatfaifai]

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?

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.

[econcepts]

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?

[fatfaifai]

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.

[econcepts]

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.

[trickobrien]

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

[econcepts]

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

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

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

[trickobrien]

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

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

[econcepts]

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.

[DML73]

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?