Export Shipping & Order Information

[giftmeister]

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.

[linuxguy2]

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,

[econcepts]

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.

[linuxguy2]

Thanks, Sounds like I'm on the right path.

[SarahL]

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

[econcepts]

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

[SarahL]

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 Eric

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

[econcepts]

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

[SarahL]

version 1.3.2
as using 139h on ZC too

and yes agree its odd too:)

thanks
Sarah

[econcepts]

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!