Printable View
Hi there,
I am having real problem with installation.
I have followed all instructions and when i open my admin and click on export shipping/order information i get internal server error:
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Any ideas what's wrong with it?
I am using Zen Cart 1.3.8a
Thanks
That is a good question. I have no specific answer for you but we can certainly try to get to the bottom of why it is happening.Quote:
Originally Posted by dpalmer4217
If it works in test mode it should work in live mode. The queries are the same in both. The only difference is one single element is left out of the test and that is the update query to set each order to 'downloaded'. Other than that, everything else is identical.
Is everything you are selecting (from test to live) exactly the same (no changes at all)?
There is no way to do this from the admin. It would require custom programming (not sure how much as I haven't looking into it.) You would likely need to alter a number of SQL queries to include the information desired to segment by group pricing.Quote:
Originally Posted by solidrock
Quote:
Originally Posted by vita
An internal server error means you did something wrong somewhere on install (obviously) or that your server has issues handling the requests needed to run the program (very unlikely as this should run on any reliable server.)
The 404 error document has nothing to do with the install as such. If you are getting that, it means you are missing file(s) that are required to run the program.
Make sure you go back and ensure ALL files are uploaded and in the proper location.
Hi, Thank you for this Mod, I hope to have it working soon.
I just installed the version 1.3.2 on my ZC 1.3.9h.
My issue is that in the menu bar under tools there is not
Tools > Export Shipping/Order Information
I uploaded the complete admin folder (and verified that the files are there on the remote server) but I may have misunderstood the directions on line #2
2)Login Admin > Tools > Install SQL Patches and run the query (copy and paste into the admin to run) found in the "INSTALL.sql" file provided with the download.
I opened the INSTALL.sql, copied the contents and pasted it in the first text box "Enter the query
to be executed:"
I clicked "Send" and did not get an error, I assume everything worked fine. I tried logging out and back in but there is still not an "Export Shipping/Order Information" under Tools (or anywhere else on the menu).
Your help would be greatly appreciated.
Thank you,
Brian
A quick update to my post above. I just looked at the mysql files and I believe there should be one called "downloaded_ship" Is this correct? I do not have this added to the mysql.
I'm guessing that I'm misunderstanding #2 in the directions.
Any help is greatly appreciated.
Thank you,
Brian
Sorry, I do not see a link to edit my post so I am replying to it.
More info. I just checked all the php files in the admin folder that I uploaded and they are 644. Should they be something different?
So I tried to copy the contents of the INSTALL.sql into the Install SQL Patches page again and received
" Failed: 1
ERROR: Cannot ADD column downloaded_ship because it already exists.
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
So apparently downloaded_ship is there.
Still can not find "Export Shipping/Order Information" in the Tools menu. Pulling hair out.
I saw this line too
>NOTE: If there are no orders found to export, then the "Export" button will not show.
I was doing test purchases under a current account so I made a purchase with a new account and it still does not show the "Export Shipping/Order Information" under Tools.
I'm hoping someone can assist me.
Thank you,
Brian
I have one other mod, Fast and Easy Checkout. Would this cause any problems?
No, it won't cause any problems.Quote:
Originally Posted by brihan
If you don't see the drop down (it doesn't matter if there are orders in your db or not ... you still should see the add on link under "Tools".)Quote:
Originally Posted by brihan
1) Check to see if you have something like "Admin Profiles" installed. If so, make sure the sure you are logged in under has permission to view the new add-on.
2) If the above does not work then check to make sure you have uploaded all files to the correct locations. The SQL patch has nothing to do with installing the drop down link (that is strictly file related.)
3) You can ignore the error message about the download_ship field already being in place. It means you already installed the SQL patch and it worked.
Let me know if that helps.
Thank you econcepts.
As I was going through your reply I realized that I had made a bone head mistake. In my local directory there was admin and then another renamed admin folder. I read the directions and was warned about this but was fooled by the admin file that was in my system.
I uploaded to the proper folder and now have the link.
So I have advanced and now have the link and can get into the program however I am not getting all the information for each account (see the gif below).
When I export the CSV it includes information in:
*Order ID
*Customer email
*Ship Dest Type
*Customers Telephone
*Order Total Order notes (Credit card AUTH info, not the comments from the customer)
The headers are there for all fields but no info other than the fields I listed above.
http://inspectionconference.com/export.gif
Once again any help would be greatly appreciated.
Thank you for your time.
Brian
What happens if you export it and select "include previously downloaded orders" (one of the options)?Quote:
Originally Posted by brihan
Hi Econcepts,
Thank you for the reply.
I have tried many combinations of options (and use "Include orders already downloaded in export") and the results are always the same. I never receive data for
First Name
Last Name
Company
Delivery Street
Delivery Suburb
Delivery City
Delivery State
Delivery Post Code
Delivery Country
Now that has me thinking. My cart is used as a registration for an event so there is no shipping. Would that make a difference?
I was thinking that it was going to give me the information for the customer account but now that I think about it I bet you are getting the information from the shipping. That makes sense.
I think I just answered my own question.
http://inspectionconference.com/zenorder.gif
http://inspectionconference.com/zenorder2.gif
OK, let me go change one of my registration to require shipping and see what happens.
I thank you for your help and hope I have not wasted to much of your time.
Yes, without the shipping it could pose problems as the system is built to pull based on shipping information.Quote:
Originally Posted by brihan
Let me know what happens when you change it.
That solved the problem.
In my product listing I changed it to "No, Shipping Address Required" and "Yes, Always Free Shipping"
It adds the free shipping field on the checkout which I did not want but I will work through that so I can capture the information for export.
One other question that I think I saw somewhere else but can't remember where.
Is there a way to export the customer comments that are entered on the checkout page? Right now the comment field that is exported is the credit card info.
Thank you again for your help.
Brian
Just downloaded and installed - no problems.
Reading through this thread I have seen references to 'test mode' and 'product per row' and 'order per row'
where and how are these configured?
AM I being thick - I havent spotted any configuration liks.:unsure:
These are found in the same area as the rest of the configuration options for the module (and where you actually perform the export).Quote:
Originally Posted by tsrplatelayer
Tools > Export Shipping and Order Info
:blush:I dont have Tools > Export Shipping and Order Info
I have Tools > Orders Export - click this and I go to Mat's Orders Exporter page. (which does export order details)
When I installed I renamed the 'Admin' install folder to match my the name of my admin folder.
Ah - ha - there are 2 different add ons for exporting orders
Orders Exporter 1.0 and Export Shipping Information 1.3.2
I'lll try installing the 'other' one -:oops:
Yes, this is the support forum for the "Export Shipping Information" module.Quote:
Originally Posted by tsrplatelayer
hello, i need to export the orders of several order status,
what do i change <?php echo zen_draw_pull_down_menu('order_status', $status_array, $_POST['order_status'], 'id="order_status"'); ?> to checkbox?
can i export the file with format type SQL?
with this mod, i can export the delivery country iso code correctly, what do i export both delivery country iso code and billing country iso code?
What version are you running? Older versions had a bug when those options were selected together. I believe this was corrected in the most recent version.Quote:
Originally Posted by quick1
No. The options available at this time are CSV and TXT. It's mainly meant for order / shipping fulfillment and not database building etc... If you want to get data out in SQL format you could setup a query that runs directly through something like PHPMyAdmin etc... (or cron) that would enable you to export what you need in SQL format. There are also come backup programs available in the zen cart downloads section which could help with this regard.Quote:
Originally Posted by quick1
You would need to alter a number of sections of code to do this (just making that box a checkbox won't work.)Quote:
Originally Posted by quick1
That is the box you need to alter, but you'll also need to change the SQL statement to accommodate multiple options in that field (likely from an array or something.)
It would then need to be tested to see if it works.
To get around this you could run multiple exports.
The first for one order status, the second for the second order status, third for the third order status, etc...
Or you could export all order statuses then open your file in a program like Excel and edit it there (removing the orders statuses you do not need.)
hello, i send you a message, please check, thanks
I'm just testing the export function with five orders on the test cart.
Two orders have customer comments (from me :smile: ) attached and those are the ones not being exported into the CSV.
Is this a known problem or have I missed something?
I've searched the thread and there's nothing I can find about this.
Hi,
Is it possible to automatically export new orders every few hours?
Yes. You would have to setup a new script that is similar to the current, take into account the sessions etc... and then setup a CRON job to run it. I've helped a few others do this as custom jobs but none used the standard conventions (all had custom fields etc...) so there is no version outside of those, but it does work quite well.Quote:
Originally Posted by waterbender
Send me a PM if you need assistance on this.
They should still export, but let me know this (just out of curiosity sake). Do any of those orders which don't export have apostrophes, commas, etc... in them (in the comments section)? I thought I had a syntax cleaner built in for that but wanted to find out.Quote:
Originally Posted by worldmaker
Can we also import shipping addresses for the system with this one? If not, any idea how to import in bulk many shipping addresses that are same among the customers? (There is a customer, a big company, who wants the different order makers at their company to have their own accounts for the shop but all of them need the same additional shipping addresses to be available)
Would it be relatively easy directly via db sql?
This module is only for exporting information from the cart. If you want to import information you could use phpMyAdmin (which might be best in your case) or use a tool like EZPopulate (which might be overkill for what you need.)
Hey! This looks like a great addon! I see in the file admin\shipping_export.php that you have the following text:
//$available_export_formats[3]=array('id' => '3', 'text' => 'XML');
Does this mean that you will make an option to export to XML? This is exactly what i'm looking for! :)
In the future, I did account for the ability to add XML exports as an option. Just haven't added it to this point as there are numerous ways to build an XML file and with the little demand never got to it.Quote:
Originally Posted by panservolvo
Yes, though, the opportunity is there for me to add it if needed.
Does this contribution work with 1.5.0 RC1?
It should work with that as well.
Let me know if you have any issues however and I can look into them.
Anybody know how to add the products weight field to the export???Quote:
Originally Posted by econcepts
very good addon. 2 questions:
1. how i can add "Shipped" into drop down menu that has Pending, Processing, Delivered.
2. When i try to use "Delivered", file comes empty, even i have lots of delivered orders in database. How to fix this? thanks.
A big thank you for this contribution by the way.
I have a customer who isnt comfortable working in his Zen Cart admin,this contribution allows him to login,export and log out in under a minute.Couldnt be easier :)
This should be added automatically as long as you have the 'shipped' option added in your actual zen cart status section (in the admin.) This module just pulls that data and populates the drop down with it. So if it is missing in your status section of the cart, it won't show here either.Quote:
Originally Posted by simpledomaining
If you already ran an export then you'll need to select more options in addition to the "delivered" option. Specifically you'll need to select "include orders already exported" as well. This will enable the module to pull orders that have already been exported at a previous date (and thus marked in the database as to the fact.)Quote:
Originally Posted by simpledomaining
Excellent. Glad you like it and thanks for the kind feedback!Quote:
Originally Posted by trickobrien
Hi,
That's a really really good plugin, thanks a lot for sharing...
Is there any way I can export with ';' instead of ',' ? Without breaking the layout ? as i changed the line $FIELDSEPARATOR = ','; to $FIELDSEPARATOR = ';'; and it didn't really work...
Thanks for your help.
Cheers,
meth0d
You are correct in making the change in the location you indicated. Using a semicolon however might interfere with the coding. What happens when you enter the semicolon? What type of error / problem arises?Quote:
Originally Posted by meth0d
Is there a way a to get State names as 2 letters and not the full name?
Hi Eric,
I seem to be having the same problem I had last year. The export worked great all year. But as soon as year end hit and the orders spanned the end of the year, the export gives me an empty file.
I've been using exactly the same settings as always because I have them hard-coded.
The first time I tried it, I did not put a date range. It showed me about 20 orders on the screen, but the file was empty.
Then I put in a date range which should have covered those same 20 records. Again I got a blank file.
I'm using version 1.3.2.
Thanks, Susie
Hi, has anyone installed this with v1.5? I have done but cannot get the page to show. ie from within admin, go to Tools> Export Shipping/Order Information. this does not exist after installing it. I can however get to the page by changing the web browser url to ....../adminxxxx/shipping_export.php
I would like to be able to get to it via the tools tab if this is possible. I assume the page just needs registering through admin page eegistration but have little idea of what info is required in the boxes
Any help will be much appreciated.
Thanks
This was in one of the versions but it ended up throwing off the entire file for some reason. I took it out and thought about adding it at a later date.Quote:
Originally Posted by webstar59
A few questions for you:Quote:
Originally Posted by susb8383
1) What did we determine was the issue and what corrected it for you last time?
2) About how many records do you think it is trying to export? Could your server be timing out due to the php time (processing setting) for scripts? If you you'll want to increase the memory limit in your php setting.
3) Does it work with shorter date ranges? If so, it might have something to do with #2 above.
4) Is there an order in there (from earlier in the year when it may have been a problem originally) that could be causing the entire file to end up blank?
Let me know some of this info and we'll see what we can come up with to correct it.
Well, the mysterious problem has mysteriously vanished. I set download_ship to no and tried again. Worked fine. Weird.
The last time you had me download a more recent version.
So...who knows? In answer to your question, there were only about 50 records, so I don't think it was a timing out issue.
I know this is a really old post, but was a resolution for this ever found? I am having the same issue. When using the quantity discounts module, the figures are incorrect.Quote:
Originally Posted by quick1
Also, a request.. When you don't select a payment method in the dropdown, would it be possible to display the payment method on the report? My client needs to be able to sort by the payment method and it would be great not having to export each payment method group separately to know which is which.
The first issue has not been resolved yet. I would have to look at the ability to display the payment method when none is selected.Quote:
Originally Posted by abcisme
You just saved me some aggravation trying to work out the Syntax of checkboxes - but via a working example - so thanks Marc! :clap:Quote:
Originally Posted by tat2nu
Hi -
Great add-in and worked well for a while, but then suddenly stopped working. We have ZC 1.3.9f.
I applied a fix Eric posted earlier in this thread to change a few lines of code around line 95 of shipping_export.php and that fixed one error, but now I've got a new one. (Post 286 - http://www.zen-cart.com/showthread.p...rmation/page29)
It only happens when the option "1 Product per Row" is selected. Unfortunately this is the one we need for our fulfillment partners to process.
Here is the error:
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 '' at line 4
in:
[SELECT Count(*) as num_rows FROM orders_products_attributes WHERE orders_id = 12050622 AND orders_products_id = ]
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.
Can anyone help?
I'm having the same problem. Great module but could just do with a fix to make it easier to get to!Quote:
Originally Posted by dkwwkd
We're having the same problem. Is there a fix for this?
We have version 1.3.2 with ZC 1.3.9h
This works fine, EXCEPT when we try to export 1 product per row. Then we get an SQL error:
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 '' at line 4 in:
[SELECT Count(*) as num_rows FROM orders_products_attributes WHERE orders_id = 19012 AND orders_products_id = ]
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.
Is there a fix for this?
Hi All,Quote:
Originally Posted by dkwwkd
I was able to get the menu item to show by following the advice on this forum post Addons / modules not visable in admin
To do so create a php file under <YOUR_ADMIN>/includes/functions/extra_functions/init_shipping_export.php and include the following code:
I had to clean out some initial attempts from my admin_pages database table, and then voila! it worked!Code:<?php
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');
}
if (function_exists('zen_register_admin_page')) {
if (!zen_page_key_exists('shipping_export')) {
zen_register_admin_page('shipping_export', 'BOX_TOOLS_SHIPPING_EXPORT',
'FILENAME_SHIPPING_EXPORT','' , 'tools', 'Y', 20);
}
}
?>
Hope this proves helpful to others!
Regards,
Jason
:cool:
Hi,
Thanks for this great mod! We are looking for a way to include the customer's Billing Address information in the export file. Could you point us to information on how to do this, or ?
thanks!
It looks like the "Orders Products ID" is blank in this case (meaning there is something missing in the db relating to the order.)
Find out what that might be be looking at this order compared to another (at the database level might be easiest) and then report back here so I can help you get around it.
You would need to open up the "shipping_export.php" file (in the admin directory) and then my recommendation would be to copy the lines for the "shipping information" and alter to include the billing info for the customer. You will need to alter this in multiple areas of the script and may also need to alter some SQL queries for it to work.
If you need help adding this let me know (just send me a private message). I've customized this for many others.
Hi,
Please see private message.
thanks!
Anybody knows how to add the Currency of all order placed. I read through the whole thread and found no one ever mentioned it. Is it not important enough if you run a store with muti-currencies? This is the only thing lacked for import to our ERP system. Anybody can do help would be much appreciated!
When I install this plugin (v1.3.2.1) on Zen Cart v1.5.1 (using the for_v1.5.0 directory's files from the plugin) and the currently signed-in admin is not a superuser (but has been given authority to use this tool), they are receiving the message "Sorry, your security clearance does not allow you to access..". To correct this problem, you'll need to edit the file /admin/includes/extra_datafiles/shipping_export.php as described below to remove the .php from the filename definition:
If you've installed the plugin on v1.5.0 or v1.5.1, you'll need to edit the file /YOUR_ADMIN/includes/extra_datafiles/shipping_export.phpCode:<?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce |
// +----------------------------------------------------------------------+
// | Copyright (c) 2003 The zen-cart developers |
// | |
// | http://www.zen-cart.com/index.php |
// | |
// | Portions Copyright (c) 2003 osCommerce |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license, |
// | that is bundled with this package in the file LICENSE, and is |
// | available through the world-wide-web at the following url: |
// | http://www.zen-cart.com/license/2_0.txt. |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to |
// | [email protected] so we can mail you a copy immediately. |
// +----------------------------------------------------------------------+
// $Id: shipping_export.php 2007-06-01 econcepts $
//
//define('FILENAME_SHIPPING_EXPORT', 'shipping_export.php');
define('FILENAME_SHIPPING_EXPORT', 'shipping_export');
define('BOX_TOOLS_SHIPPING_EXPORT', 'Export Shipping/Order Information');
?>
We are in need of the customer's billing address in export as well, could you help please? Did send a private message but never heard back from you.Quote:
Originally Posted by econcepts
I've have tried to install this module, all files are installed, ren sql. it tells me 1 item processed,however cant find the export under tools. what im doing wrong?
See post#363.Quote:
Originally Posted by yoyospike
i have edited the file below and still no option under tools. using v1.51. any advise?
<?php
//
// +----------------------------------------------------------------------+
// |zen-cart Open Source E-commerce |
// +----------------------------------------------------------------------+
// | Copyright (c) 2003 The zen-cart developers |
// | |
// | http://www.zen-cart.com/index.php |
// | |
// | Portions Copyright (c) 2003 osCommerce |
// +----------------------------------------------------------------------+
// | This source file is subject to version 2.0 of the GPL license, |
// | that is bundled with this package in the file LICENSE, and is |
// | available through the world-wide-web at the following url: |
// | http://www.zen-cart.com/license/2_0.txt. |
// | If you did not receive a copy of the zen-cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to |
// | [email protected] so we can mail you a copy immediately. |
// +----------------------------------------------------------------------+
// $Id: shipping_export.php 2007-06-01 econcepts $
define('FILENAME_SHIPPING_EXPORT', 'shipping_export.php');
define('BOX_TOOLS_SHIPPING_EXPORT', 'Export Shipping/Order Information');
?>
Hi, great mod!
I am in the process of customizing so that default values are selected. However, my php ability is exceeded when it comes to the drop down tables for ORDER STATUS.
Can anyone help me modify the code below so that I can define which order status to use as default rather than the drop down menu.
Thanks in advance
<hr />
<table border="0" cellspacing="0" cellpadding="2">
<tr>
<td><strong>Update Order Status on Export</strong><br/>(If this is set then the order status will update to what you select here after a successful export.)</td>
</tr>
<tr>
<td>
<?php echo zen_draw_checkbox_field('status_setting', '1', order_status_setting_checked);?>Set Order Status After Export to
<!--</td>
</tr>
<tr>
<td>--><?php echo zen_draw_pull_down_menu('order_status_setting', $status_array, $_POST['order_status_setting'], 'id="order_status_setting"'); ?></td>
</tr>
</table>
<hr />
<table border="0" cellspacing="0" cellpadding="2">
<tr>
<td><strong>Order Status Export Options</strong></td>
</tr>
<tr>
<td>
<input type="radio" name="status_target" value="2" checked="yes">Assigned Order Status (select below)
</td>
</tr>
<tr>
<td><?php echo zen_draw_pull_down_menu('order_status', $status_array, $_POST['order_status'], 'id="order_status"'); ?></td>
</tr>
</table>
I have tried to look and see if this issue has already been addressed but have not seen it so I will post a question. I have installed this and it has been working fine. But now I have 100 orders and when I run my report, and include all orders even if they have already been downloaded, it only shows 98 orders. Do you know why it would not include my two latest orders in the report? I need help ASAP.
elsiesfinds.com
I am running Zen 1.5.1 with the Edit Orders and Add Orders plugin so I can add wholesale orders as they come in. Orders are successfully being added from the Admin UI.
I am also running the "Export Shipping+Order Information" plugin to use for sending shipping files to a fulfillment warehouse. When I go into this tool I can see all of the orders I have added from the Admin and that have been added from the customer side.
When I try and export the orders to a CSV I am not getting the orders that I manually added from the Admin. I do get the customer side orders though.
Any thoughts?
I believe "Export Shipping+Order Information" will not export an order unless the order has an order_total line for ot_shipping. Make sure you are adding shipping information to the order or modify "Export Shipping+Order Information" to include orders without an order_total line for ot_shipping.
This requirement for orders has been previously mentioned in this support thread.... See #7.
This is correct. When I started the module originally it was keying off of the shipping information (so if shipping information was not present the order would not show in the export.) I'm sure it can be altered to work around that if needed. I've been working on updating a number of my modules here recently but haven't looked into this one yet.Quote:
Originally Posted by lhungil
Are you entering a shipping total when editing / adding the order?
Eric
I'm interested in adding the Product Category to the product details being exported. I've tried searching first to see if anyone else has done this already, but found nothing thus far. How much trouble would it be to do this?
Hi there, brill module and well done, this is great for exporting the data.
Can I ask how and where I could change the order the CSV fields are exported ?
I have recently changed couriers and would like to streamline the upload to there site and would like to change the export of fields in order as follows;
A Address line 1 (mandatory)
B Address line 2
C Address line 3
D Address line 4
E Postcode (mandatory)
F First name
G Surname (mandatory)
H [Blank]
I [Blank]
J Phone
K Email
L Weight (in kg)
M [Blank]
N [Blank]
O Reference/Order No
P [Blank]
Q [Blank]
Thank you in advance :)
Chris
Thanks for a great mod!
I also want to export all orders and tried deleting those lines/parts above and can't get it right. How exactly should the three instances be changed?Quote:
I did change the admin->shipping_export.php file in 2 ways:
- deleted the lines "AND ot.class = 'ot_shipping'" so I could export all orders
line 102 $order_info = $order_info . "AND ot.class = 'ot_shipping'";
line 134 AND ot.class = 'ot_shipping' ";
line 162 AND ot.class = 'ot_shipping'";
And what's the simplest way to block fields from appearing in the spreadsheet, like "delivery_suburb."?
Did you manage to get this working in the end? I have just had this crop up for the first time after adding some virtual products and I can't get the report to show the orders with free shipping either. Deleting those three lines doesn't seem to help; it still works but the same orders are missing from the output.
It's a shame because the solution in post #7 sounds so perfect and this is a magnificent mod in all other respects!
Still not...and after I played around with a dozen variations to delete those lines/codes in question.
To be clear, I'm getting all order info except for the customer name and address.
Finally...
102= $order_info = $order_info . "AND ot.class = 'ot_shipping'";
change to
$order_info = $order_info;
Or block out the part after the above with //
134= delete or block, but add "; to the end of the previous line, 133. They should look like:
$order_info = $order_info . " WHERE o.orders_id = ot.orders_id ";
// AND ot.class = 'ot_shipping' ";
162= same as 134, should look like:
WHERE o.orders_id = ot.orders_id ";
// AND ot.class = 'ot_shipping'";
Then change all "delivery_" to "billing_".
What I'd like to do now is have each product attribute in its own spreadsheet column instead of all of them into one (many of my items have 2+ attributes). Is that possible?
This is possible with the default module (no special programming updates needed.) You'll find a sample of this in action in the 'sample_exports' directory (third file in list.)Quote:
Originally Posted by giftmeister
Let me know if this helps or if you need more information.
The samples, like what my files show, is one cell with all the attributes:
Color: Black | Memory: 16 mb |
Did I miss something?
I use attributes for the registration of students under 18 (account creation/payment is for the parents) so would like to separate the attributes of Student First Name, Student Last Name, Age, etc. I played around with separators other than | and tried to open the file with different spreadsheet selections other than Comma, but to no avail.
While you're here...
2) To change the order of columns (ID, Name, etc.), is it enough to play with your file or is the mod connected to a core file? I tried moving around just two as a test and didn't even get that working...average/poor php skills here.
3) Is there a way to export just a certain product category? That would be amazing for the company I do this for, there are only a handful of categories, and we'd donate a few bucks for it.
I am currently using Orders Exporter but need the date range feature of this module.
BUT I only want to export these 4 columns of data in my csv file.
Deliver TO Company - Order ID - Product Name - Product Quantity
1:
Can I modify the code to do this?
2:
Would you point me to where in the code I do this?
AND I want to eliminate the RSS stuff.
1:
I'm thinking I just don't upload hose files?
Thanks,
By default, the module will export the shipping information as well (address etc...). The only way to remove that is to go into the code and comment out all of those sections (there will be a few based on the ability to export two ways (1. one order per row, and 2. one product per row.)
You would also need to remove the part of the header (column headings) that would print for those as well.
All other columns are controlled by check marking items in the admin of the module.
For the RSS Stuff you would need to remove those files and (1. remove the section of code that includes those in the admin panel .... 2. alter the panel template if desired to remove that now blank section.)
Let me know if that helps.
Thanks, Sounds like I'm on the right path.
excellent module - thank you
however we have spotted a weird thing and not sure how to come around it
when we do an export we only want to export orders that are "completed" - that works on the CSV however the non-completed orders are getting updated as "exported" in the database and therefore not appearing again?
Does that follow?
Using 1.3.9h
Everything else works as expected it just seems to toggle the database to "export" everything and ignoring the "completed" part for the "Order Status Export Options"
we select - Assigned Order Status (select below) and completed from drop down
I sit possible that it only updates the database with items that match the CSV file ?
Thank you
Sarah
The reason this is, is because the module looks for any order that has not been SHIPPED yet (all new orders) and exports those. Is one of your "order statuses" (in the admin) "completed"? If you want to only export orders that are "completed" (order status) then you would need to customize the current module to look for order status 'completed' (the id of what that is in your db).
Hi EricQuote:
Originally Posted by econcepts
I am somewhat confused by your reply
Am I not right in that the CSV file download does NOT equal whats updated in the database table?
As the CSV correctly uses this setting in your module "Order Status Export Options" and yes one of our statuses is "Completed" - so it downloads the "completed" and "unshipped" orders
However regardless of us using this option or not the "non-completed" and "unshipped" statuses are still marked as "exported" - when actually the ones that are not "completed" should be carried over to the next time its run?
As I don't understand why the SQL isn't matching the options for the CSV download....
Or is that not what this module does and everytime its run marks anything not exported as exported regardless of any options selected?
Thanks
Sarah
Sarah,
What version of the module are you using? It is possible that there is a bug in it preventing that from working correctly. Let me know and I'll have a look at it.
Eric
version 1.3.2
as using 139h on ZC too
and yes agree its odd too:)
thanks
Sarah
Sarah,
I took a look at that version and it appears that the update function only accounts for date range when selected and / or all or nothing (meaning update of all orders.)
If you send me the file that you are using (I sent you a PM for where to send it) then I'll make the update to it and send it back to you.
Thanks!
ZC 1.5.1. The easy stuff first:
What code in export_shipping_information_V1.3.2.1/"shipping_export.php" do I change to set the below as defaults?
(Obviously not the 10 things I tried :yuck:
1:
Product per row.
(Currently set to Order per row)
2:
Include Header Row In Export.
(Currently you have a check box)
3:
Full Product Details
(Currently you have a check box)
And the issue................
ZC 1.5.1 with plugins: When installed in the order listed below everyone plays nice. Note the order listed and that EP4 & ESI must be installed before FEC.
EasyPopulate-4.0-master [mc12345678 strain], export_shipping_information_V1.3.2.1, FEC, column_layout_grid_2_3_1, extra_field_on_customer_sign_up_2-0, Minimum Order, AND Mods to the layout template.
I installed ESI on my production build which already had the other mods installed and ESI exports the headers but NO product data and does NOT throw any errors.
I know this isn't much to go on but maybe some of you who are smarter that me (or at least know how ESI works) could tell me how this is possible.
Seems to me this is some sort of database ordering issue. I have compared the databases of the working vrs. non-working install and the only differences I could see was the order the plugins were install in.
NOTE:
A similar condition exists with EasyPopulate-4.0-master in that it has to be installed before FEC. Because I already have it installed on my production build it's not a problem for me in the short term but may be a problem later on.
Thanks,
It technically shouldn't matter what order any of those are installed in UNLESS, one of them has a "delete" type of command that in unknowingly removes some database field(s) from other modules (I've seen this before with a number of mods.)
To set defaults on the selection items you need to add another portion to the function for drawing either the radio fields, checkboxes etc...
Specifically you would need to add something that follows this pattern "$variablenamehere=true"
An example of how you would select by default the type of file layout would be
ORIGINAL LINE OF CODE:
CHANGE TO:Code:<?php echo zen_draw_radio_field('filelayout', '2' );?> <?php echo TEXT_FILE_LAYOUT_PPR_FIELD; ?><br />
Notice the addition of the ", $filelayout=true" portion of code.Code:<?php echo zen_draw_radio_field('filelayout', '2' , $filelayout=true);?> <?php echo TEXT_FILE_LAYOUT_PPR_FIELD; ?><br />
You would do the same for the checkboxes (adding the appropriate variable = to true for each that you wish to pre-select.
Example for checkbox would be:
ORIGINAL LINE:
CHANGE TO:Code:<?php echo zen_draw_checkbox_field('product_details', '1');?> <?php echo TEXT_PRODUCT_DETAILS_FIELD; ?> <span style="color: #ff0000"><strong>*</strong></span><br />
Notice addition of the ", $prod_details_checked=true" portion.Code:<?php echo zen_draw_checkbox_field('product_details', '1', $prod_details_checked=true);?> <?php echo TEXT_PRODUCT_DETAILS_FIELD; ?> <span style="color: #ff0000"><strong>*</strong></span><br />
Let me know if that helps.
Thanks for the default code. Nothing like what I was trying. :blush: I'll try yours later today.
The SOI Issue:
My Orders tables look identical as far as the same numbers of columns/fields except the order of them.
Obviously if you add OSI first it's extra column/field is before the columns/fields FEC adds and the opposite if you add FEC first.
Is it a different table causing the problem?
I reviewed the code in shipping_export.php but couldn't see where SOI pulls data from any other sql tables. Of course I'm not that good at PHP so I may have missed something.
The only other table I see affected is the "admin_pages but the same applies there, only the order is different.
Here's the two "orders" Tables
i.e.. See red stuff
FEC First
-- Table structure for table `orders`
--
CREATE TABLE IF NOT EXISTS `orders` (
`orders_id` int(11) NOT NULL AUTO_INCREMENT,
`customers_id` int(11) NOT NULL DEFAULT '0',
`customers_name` varchar(64) NOT NULL DEFAULT '',
`customers_company` varchar(64) DEFAULT NULL,
`customers_street_address` varchar(64) NOT NULL DEFAULT '',
`customers_suburb` varchar(32) DEFAULT NULL,
`customers_city` varchar(32) NOT NULL DEFAULT '',
`customers_postcode` varchar(10) NOT NULL DEFAULT '',
`customers_state` varchar(32) DEFAULT NULL,
`customers_country` varchar(32) NOT NULL DEFAULT '',
`customers_telephone` varchar(32) NOT NULL DEFAULT '',
`customers_email_address` varchar(96) NOT NULL DEFAULT '',
`customers_address_format_id` int(5) NOT NULL DEFAULT '0',
`delivery_name` varchar(64) NOT NULL DEFAULT '',
`delivery_company` varchar(64) DEFAULT NULL,
`delivery_street_address` varchar(64) NOT NULL DEFAULT '',
`delivery_suburb` varchar(32) DEFAULT NULL,
`delivery_city` varchar(32) NOT NULL DEFAULT '',
`delivery_postcode` varchar(10) NOT NULL DEFAULT '',
`delivery_state` varchar(32) DEFAULT NULL,
`delivery_country` varchar(32) NOT NULL DEFAULT '',
`delivery_address_format_id` int(5) NOT NULL DEFAULT '0',
`billing_name` varchar(64) NOT NULL DEFAULT '',
`billing_company` varchar(64) DEFAULT NULL,
`billing_street_address` varchar(64) NOT NULL DEFAULT '',
`billing_suburb` varchar(32) DEFAULT NULL,
`billing_city` varchar(32) NOT NULL DEFAULT '',
`billing_postcode` varchar(10) NOT NULL DEFAULT '',
`billing_state` varchar(32) DEFAULT NULL,
`billing_country` varchar(32) NOT NULL DEFAULT '',
`billing_address_format_id` int(5) NOT NULL DEFAULT '0',
`payment_method` varchar(128) NOT NULL DEFAULT '',
`payment_module_code` varchar(32) NOT NULL DEFAULT '',
`shipping_method` varchar(128) NOT NULL DEFAULT '',
`shipping_module_code` varchar(32) NOT NULL DEFAULT '',
`coupon_code` varchar(32) NOT NULL DEFAULT '',
`cc_type` varchar(20) DEFAULT NULL,
`cc_owner` varchar(64) DEFAULT NULL,
`cc_number` varchar(32) DEFAULT NULL,
`cc_expires` varchar(4) DEFAULT NULL,
`cc_cvv` blob,
`last_modified` datetime DEFAULT NULL,
`date_purchased` datetime DEFAULT NULL,
`orders_status` int(5) NOT NULL DEFAULT '0',
`orders_date_finished` datetime DEFAULT NULL,
`currency` char(3) DEFAULT NULL,
`currency_value` decimal(14,6) DEFAULT NULL,
`order_total` decimal(14,2) DEFAULT NULL,
`order_tax` decimal(14,2) DEFAULT NULL,
`paypal_ipn_id` int(11) NOT NULL DEFAULT '0',
`ip_address` varchar(96) NOT NULL DEFAULT '',
`COWOA_order` tinyint(1) NOT NULL DEFAULT '0',
`downloaded_ship` enum('yes','no') NOT NULL DEFAULT 'no',
PRIMARY KEY (`orders_id`),
KEY `idx_status_orders_cust_zen` (`orders_status`,`orders_id`,`customers_id`),
KEY `idx_date_purchased_zen` (`date_purchased`),
KEY `idx_cust_id_orders_id_zen` (`customers_id`,`orders_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=145 ;
--
-- Dumping data for table `orders`
--
INSERT INTO `orders` (`orders_id`, `customers_id`, `customers_name`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `billing_name`, `billing_company`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `payment_method`, `payment_module_code`, `shipping_method`, `shipping_module_code`, `coupon_code`, `cc_type`, `cc_owner`, `cc_number`, `cc_expires`, `cc_cvv`, `last_modified`, `date_purchased`, `orders_status`, `orders_date_finished`, `currency`, `currency_value`, `order_total`, `order_tax`, `paypal_ipn_id`, `ip_address`, `COWOA_order`, `downloaded_ship`) VALUES
(142, 62, 'rrrrrrrrrrrr rrrrrrrrrr', 'rrrrrrrrrr', 'rrrrrr', 'rrrrrrrrrrr', 'rrrrrrrrrr', 'rrrrrrrrrr', 'Rhode Island', 'United States', 'rrrrrrrrrrrr', '[email protected]', 2, 'rrrrrrrrrrrr rrrrrrrrrr', 'rrrrrrrrrr', 'rrrrrr', 'rrrrrrrrrrr', 'rrrrrrrrrr', 'rrrrrrrrrr', 'Rhode Island', 'United States', 2, 'rrrrrrrrrrrr rrrrrrrrrr', 'rrrrrrrrrr', 'rrrrrr', 'rrrrrrrrrrr', 'rrrrrrrrrr', 'rrrrrrrrrr', 'Rhode Island', 'United States', 2, '', 'moneyorder', 'Flat Rate (Best Way)', 'flat', '', '', '', '', '', NULL, NULL, '2014-02-17 12:44:14', 1, NULL, 'USD', '1.000000', '1282.05', '0.00', 0, '70.123.98.89 - 70.123.98.89', 0, 'no'),
SOI First
Table structure for table `orders`
--
CREATE TABLE IF NOT EXISTS `orders` (
`orders_id` int(11) NOT NULL AUTO_INCREMENT,
`customers_id` int(11) NOT NULL DEFAULT '0',
`customers_name` varchar(64) NOT NULL DEFAULT '',
`customers_company` varchar(64) DEFAULT NULL,
`customers_street_address` varchar(64) NOT NULL DEFAULT '',
`customers_suburb` varchar(32) DEFAULT NULL,
`customers_city` varchar(32) NOT NULL DEFAULT '',
`customers_postcode` varchar(10) NOT NULL DEFAULT '',
`customers_state` varchar(32) DEFAULT NULL,
`customers_country` varchar(32) NOT NULL DEFAULT '',
`customers_telephone` varchar(32) NOT NULL DEFAULT '',
`customers_email_address` varchar(96) NOT NULL DEFAULT '',
`customers_address_format_id` int(5) NOT NULL DEFAULT '0',
`delivery_name` varchar(64) NOT NULL DEFAULT '',
`delivery_company` varchar(64) DEFAULT NULL,
`delivery_street_address` varchar(64) NOT NULL DEFAULT '',
`delivery_suburb` varchar(32) DEFAULT NULL,
`delivery_city` varchar(32) NOT NULL DEFAULT '',
`delivery_postcode` varchar(10) NOT NULL DEFAULT '',
`delivery_state` varchar(32) DEFAULT NULL,
`delivery_country` varchar(32) NOT NULL DEFAULT '',
`delivery_address_format_id` int(5) NOT NULL DEFAULT '0',
`billing_name` varchar(64) NOT NULL DEFAULT '',
`billing_company` varchar(64) DEFAULT NULL,
`billing_street_address` varchar(64) NOT NULL DEFAULT '',
`billing_suburb` varchar(32) DEFAULT NULL,
`billing_city` varchar(32) NOT NULL DEFAULT '',
`billing_postcode` varchar(10) NOT NULL DEFAULT '',
`billing_state` varchar(32) DEFAULT NULL,
`billing_country` varchar(32) NOT NULL DEFAULT '',
`billing_address_format_id` int(5) NOT NULL DEFAULT '0',
`payment_method` varchar(128) NOT NULL DEFAULT '',
`payment_module_code` varchar(32) NOT NULL DEFAULT '',
`shipping_method` varchar(128) NOT NULL DEFAULT '',
`shipping_module_code` varchar(32) NOT NULL DEFAULT '',
`coupon_code` varchar(32) NOT NULL DEFAULT '',
`cc_type` varchar(20) DEFAULT NULL,
`cc_owner` varchar(64) DEFAULT NULL,
`cc_number` varchar(32) DEFAULT NULL,
`cc_expires` varchar(4) DEFAULT NULL,
`cc_cvv` blob,
`last_modified` datetime DEFAULT NULL,
`date_purchased` datetime DEFAULT NULL,
`orders_status` int(5) NOT NULL DEFAULT '0',
`orders_date_finished` datetime DEFAULT NULL,
`currency` char(3) DEFAULT NULL,
`currency_value` decimal(14,6) DEFAULT NULL,
`order_total` decimal(14,2) DEFAULT NULL,
`order_tax` decimal(14,2) DEFAULT NULL,
`paypal_ipn_id` int(11) NOT NULL DEFAULT '0',
`ip_address` varchar(96) NOT NULL DEFAULT '',
`downloaded_ship` enum('yes','no') NOT NULL DEFAULT 'no',
`COWOA_order` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`orders_id`),
KEY `idx_status_orders_cust_zen` (`orders_status`,`orders_id`,`customers_id`),
KEY `idx_date_purchased_zen` (`date_purchased`),
KEY `idx_cust_id_orders_id_zen` (`customers_id`,`orders_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `orders`
--
INSERT INTO `orders` (`orders_id`, `customers_id`, `customers_name`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `billing_name`, `billing_company`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `payment_method`, `payment_module_code`, `shipping_method`, `shipping_module_code`, `coupon_code`, `cc_type`, `cc_owner`, `cc_number`, `cc_expires`, `cc_cvv`, `last_modified`, `date_purchased`, `orders_status`, `orders_date_finished`, `currency`, `currency_value`, `order_total`, `order_tax`, `paypal_ipn_id`, `ip_address`, `downloaded_ship`, `COWOA_order`) VALUES
(3, 1, 'FFFFFFF LLLLLLLL', 'FEC Co', '9876Huiuy', '', 'Jkkkk', '90909', 'Florida', 'United States', '9876545432', '[email protected]', 2, 'FFFFFFF LLLLLLLL', 'FEC Co', '9876Huiuy', '', 'Jkkkk', '90909', 'Florida', 'United States', 2, 'FFFFFFF LLLLLLLL', 'FEC Co', '9876Huiuy', '', 'Jkkkk', '90909', 'Florida', 'United States', 2, 'Check/Money Order', 'moneyorder', 'Flat Rate (Best Way)', 'flat', '', '', '', '', '', NULL, NULL, '2014-02-17 14:01:51', 1, NULL, 'USD', '1.000000', '47.00', '0.00', 0, '70.123.98.89 - 70.123.98.89', 'no', 0);
-- --------------------------------------------------------
econcepts , That is purrrfect! THANKS!
You have just taught this man how to fish (for the little ones) :cool:
=================
I've been reviewing the code & database regarding the below issue but no joy... I'm sure the problem is staring me in the face but I can't see it.
And the issue................
ZC 1.5.1 with plugins: When installed in the order listed below everyone plays nice. Note the order listed and that EP4 & ESI must be installed before FEC.
EasyPopulate-4.0-master [mc12345678 strain], export_shipping_information_V1.3.2.1, FEC, column_layout_grid_2_3_1, extra_field_on_customer_sign_up_2-0, Minimum Order, AND Mods to the layout template.
I installed ESI on my production build which already had the other mods installed and ESI exports the headers but NO product data and does NOT throw any errors.
I know this isn't much to go on but maybe some of you who are smarter that me (or at least know how ESI works) could tell me how this is possible.
Seems to me this is some sort of database ordering issue. I have compared the databases of the working vrs. non-working install and the only differences I could see was the order the plugins were install in. Can't determine where the DB Query is going off the rails.
After a couple of 4:00 AM sessions I found the smoking gun and a workaround for the issue I posted on Feb. 22, 2014 :clap:If I reset the "starting order" number via the admin panel before importing new product with EP4, ES+OI then correctly exports ALL information. Obviously it has to be reset to a number above the highest existing order number.Quote:
ES+OI exports the headers but NO product data and does NOT throw any errors
You still have to adhere to the plugin installation order listed in my Feb. 22 post.
Is this an EP4 or an ES+OI problem?
I would sure like to know how/why this happens and IMHO an elegant fix is in order.
Found another nit. Leading zeros are stripped from (in my case product numbers) when data is exported as a CSV file.
This does not happen when exporting to a CSV file in EP4 so can that same code be applied to this plugin?
Other than those two issues I Love this Plugin.
This bit of information may save someone a LOT of time & hair pulling.
I found the rest of the smoking gun which was the real problem I had where just the header information would download.
IMHO I think this is a bug and should be fixed for those who do not want to/need to display certain shipping information.
If you do NOT have ot_shipping selected in the "Admin Panel > Modules > Shipping > ot_shipping" ES+OI will NOT download the order information.
My work around/solution was to comment out the code for "ot_shipping" in ADMIN > shipping_export.php
Around line 104:
$order_info = $order_info; // . "AND ot.class = 'ot_shipping'";
Around line 135:
$order_info = $order_info . " WHERE o.orders_id = ot.orders_id";
// AND ot.class = 'ot_shipping' ";
Around line 165:
WHERE o.orders_id = ot.orders_id";
//AND ot.class = 'ot_shipping'";
Thanks,
ZC Version 1.5.1
Hi,
I am using the Keep Alive Timer Pluggin. When exporting to csv or text I get the following code showing before the order info:
<!-- BOF: Keepalive for Session -->
<!-- timeout warning alert -->
<div id="keepalivetimer" title="Your session is about to expire!" style="display: none">
<p class="ui-state-error-text">
<span class="ui-icon ui-icon-alert" style="float:left; margin:0 7px 50px 0;"></span>
You will be logged off in <span id="keepalivetimer-countdown" style="font-weight:bold"></span> minutes.
</p>
<p>Do you want to continue your session?</p>
</div>
<link href="//ajax.googleapis.com/ajax/libs/jqueryui/1.10.1/themes/base/jquery-ui.css" type="text/css" rel="stylesheet" />
<script type="text/javascript">
if (typeof jQuery == "undefined") {//no jquery yet
document.write('<scr'+'ipt type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js">');
document.write('</scr' + 'ipt>');
}
</script>
<script type="text/javascript">
if (!jQuery.ui) {
document.write('<scr'+'ipt type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jqueryui/1/jquery-ui.min.js">');
document.write('</scr' + 'ipt>');
}
</script>
<script src="includes/javascript/jquery.idletimer.js?t=1393853933" type="text/javascript"></script>
<script src="includes/javascript/jquery.idletimeout.js?t=1393853933" type="text/javascript"></script>
<style type="text/css">
a.ui-dialog-titlebar-close {display:none;}
.ui-widget-overlay { background: green; opacity: .40;filter:Alpha(Opacity=40); }
</style>
<script type="text/javascript">
//setup the dialog
$("#keepalivetimer").dialog({
autoOpen: false
modal: true
width: 430
height: 250
closeOnEscape: false
draggable: false
resizable: false
position: "top"
buttons: {
'Yes Keep Working': function(){
$(this).dialog('close');
}
'No Logoff': function(){
$.idleTimeout.options.onLogoffClick.call(this);
}
}
});
// start the idle timer monitor
var $countdown = $("#keepalivetimer-countdown");
$.idleTimeout('#keepalivetimer' 'div.ui-dialog-buttonpane button:first' {
idleAfter: 600 // 600 user is considered idle after 10 minutes of no movement in this browser window/tab
warningLength: 250 // 250 countdown timer starts at this many seconds (250sec=4:50min)
pollingInterval: 60 //60 check for server connection every minute; if it fails or user is logged out keepalive scripts will abort
keepAliveURL: 'keepalive.php' serverResponseEquals: 'OK'
titleMessage: 'Warning: %s seconds until log out | '
onTimeout: function(){
document.title = '!!Expired Session';
$(this).html('<p class="ui-state-error-text"><span class="ui-icon ui-icon-alert" style="float:left; margin:0 7px 50px 0;"></span>Sorry you have been logged out due to inactivity.</p><p>Any unsaved work was lost. If you were composing content which you wish to save click Close and copy that content to your clipboard. Then refresh the page to login again.</p><p>To continue please login again.</p>');
$(this).dialog("option" "title" 'Your session has expired');
$(this).dialog("option" "minWidth" "450");
$(this).dialog("option" "buttons" {'Close': function(){$(this).dialog('close');} 'Login': function(){window.location.reload();}});
//$(this).dialog("option" "buttons" {'Login': function(){window.location.reload();} });
}
onAbort: function(){
// TODO: another modal dialog would be more friendly
alert('We are unable to connect to the server. Your work may be lost. Please review your work and perhaps copy information to your clipboard if you had any work in progress which you do not wish to lose.');
}
onIdle: function(){
$(this).dialog("open");
}
onLogoffClick: function(){
window.location = "logoff.php";
}
onCountdown: function(counter){
var sec = counter % 60;
var min = Math.floor(counter/60);
if (sec < 0) {
sec = 59;
min = min - 1;
}
if (sec<=9) { sec = "0" + sec; }
var time = (min<=9 ? "0" + min : min) + ":" + sec;
$countdown.html(time);
}
});
</script>
<!-- EOF: Keepalive for Session -->
I have included a snapshot of the settings.
Attachment 13850
Is there something that I can do to stop this from showing?
I would also like to alter the fields that are shown when I download the info. My suppliers dropship many items for me and do not need all of the info that is supplied by this pluggin. They have requested that I do not send all of the info that the Excel file contains. This means I have to manually alter the info that is shown and delete fields that are not required. How can I alter what is downloaded so that only the fields needed are shown in the CSV file?
I would need the following:
Order ID
Delivery Name
Company
Delivery Street
Delivery Suburb
Delivery City
Delivery State
Delivery Post Code
Delivery Country
Product Qty
Product Name
Product Model
Delivery Comments (This is a field that I am going to add to the checkout procedure as a one line separate field in the near future and will allow me to separate order comments from delivery comments).
Also, I would like to include a Suppliers field that I have placed in the product info page on the admin side. I would like to include this as a field so that I can separate orders for different suppliers. This I would probably have to do manually but it would help a lot and save a lot of time going through all of the orders and determining which order is for which supplier. If I can see which supplier is providing each product it would be a cut and paste into another Excel document.
I think that I have provided all of the info but if more is needed please ask and I will make sure that I make things a little clearer.
Thanks in advance for any help.
I modified in my code to achieve the results pictured. My MODIFIED shipping_export.php.zip is attached.
Attachment 13851
Sorry but I did not comment my changes. You'll have to compare this to the original shipping_export.php.
Attachment 13852Attachment 13853
I would like to export my orders sorted by Order/product Name. Instead they are exported by Order/order entered in cart.
Any suggestions/code on how to do this?
Thanks,
Responding to one of your older posts. Glad you found it all and got it working. I have been in the process of updating all of my plugins as part of a suite of tools so at some point a new version here of this will be ready to go with some added features hopefully.