Printable View
Quote:
Originally Posted by econcepts
Same here.Quote:
Originally Posted by magnusrf
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?Quote:
Originally Posted by fatfaifai
excalty same as magnusrfQuote:
Originally Posted by econcepts
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.Quote:
Originally Posted by fatfaifai
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
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...Quote:
Originally Posted by trickobrien
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.)Quote:
Originally Posted by trickobrien
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.Quote:
Originally Posted by trickobrien
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?
These are referenced in a few areas with in the file (header, one product per row, one order per row) sections.Quote:
Originally Posted by DML73
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: