Jump to content

Module to Export Orders


Burhan BVK
 Share

Recommended Posts

<p>

nformazioni sul server Versione di Prestashop: 1.4.8.2 Informazioni sul server: Linux #1 SMP Mon Jul 2 10:46:27 EDT 2012 x86_64 Versione software server: Apache/2 Versione di PHP: 5.2.17 Versione di MySQL: 5.5.14
</p>

<p> </p>

<p> </p>

<p> </p>

<div>Thanx Totti,</div>

<div>Now I know where is the cause, It's nothing fatal, <img alt="B)" class="bbc_emoticon" src="http://www.prestashop.com/forums/public/style_emoticons/default/cool.png" title="B)" /> I fix it in the next version with a filter to export data from date to date... </div>

 

  • Like 1

Share this post


Link to post
Share on other sites

nformazioni sul server

 

Versione di Prestashop: 1.4.8.2

Informazioni sul server: Linux #1 SMP Mon Jul 2 10:46:27 EDT 2012 x86_64

Versione software server: Apache/2

Versione di PHP: 5.2.17

Versione di MySQL: 5.5.14

 

 

ThanxTotti,

Now I know where is the cause, it is nothing fatal, I fix it in the next version with a filter to export data

Share this post


Link to post
Share on other sites

that's fine with the date for the tax software.

But the shipping would be a filter for e.g. ready for dispatch, favorably

 

in PrestaShop™ 1.5.0.14 but it works

////the call of the module

Warning

: Missing argument 1 for PE_ExportOrders::hookExport(), called in /is/htdocs/wp0/server/modules/pe_exportorders/pe_exportorders.php on line 310 and defined in

/is/htdocs/wp0/server/modules/pe_exportorders/pe_exportorders.php

on line

312

 

 

and

the run of the module

 

Warning

: Missing argument 1 for PE_ExportOrders::hookExport(), called in /is/htdocs/

wp0

/

server

/modules/pe_exportorders/pe_exportorders.php on line 310 and defined in

/is/htdocs/wp0/server/modules/pe_exportorders/pe_exportorders.php

on line

312

 

 

Warning

: Cannot modify header information - headers already sent by (output started at /is/htdocs/

wp0

/

server

/modules/pe_exportorders/pe_exportorders.php:312) in

/is/htdocs/wp0/server/classes/Cookie.php

on line

317

Share this post


Link to post
Share on other sites

that's fine with the date for the tax software.

But the shipping would be a filter for e.g. ready for dispatch, favorably

 

in PrestaShop™ 1.5.0.14 but it works

////the call of the module

Warning

: Missing argument 1 for PE_ExportOrders::hookExport(), called in

 

 

I decided - in the new version will be both filters - the date and order status, too.

Yes, I already know the cause of the warning, I will fix it in the new version, if you need fix this warning in last ver, edit pe_exportorders.php in row 312:

public function hookExport($params){

to this:

public function hookExport(){

However, the author of this topic whitelighter offers a pro version with filtering. I will not, I cannot copy his work. So I will decided write my version from scratch. Coming soon. :rolleyes:

Share this post


Link to post
Share on other sites

Hello,

 

The module leaves some kind of mark on the already exported orders?

My concern is that I will use the exported file to order the products to my suppliers, so I can not, by mistake, export the same order twice.....

 

Regards,

 

Steven

Share this post


Link to post
Share on other sites

Hello,

 

The module leaves some kind of mark on the already exported orders?

My concern is that I will use the exported file to order the products to my suppliers, so I can not, by mistake, export the same order twice.....

 

Regards,

 

Steven

Current module does not support this. New version will have filters (date, order status) and maybe, :D last exported orders ID number saved in module configuration.

Share this post


Link to post
Share on other sites

  • 4 weeks later...

Thanks for the module Falgener, much appricated. Don't know if I do something wrong but are the product types supported to be exported as well? Would like to use this as "picking list" for orders.

 

Thanks!

Share this post


Link to post
Share on other sites

Thanks for the module Falgener, much appricated. Don't know if I do something wrong but are the product types supported to be exported as well? Would like to use this as "picking list" for orders. Thanks!

 

If You mean "product variants" it is included in field "Product Name"

Share this post


Link to post
Share on other sites

Do you think I could try current version, and upgraded it when you have the new release? If yes, please, could you send me the last version please???

 

Thanks a lot,

 

Steven

Share this post


Link to post
Share on other sites

Hi and thanks!

 

Cant see that option tho, im using the 2.0 version? No products are exported at all actually.

 

Regards,

Oscar

 

 

Download latest version here. It is several times modified old module, i think it is continuously 2.0 version from beginning :blink: .

Latest Repaired:

Warning: Missing argument 1 for PE_ExportOrders::hookExport(), ....

But stil is there

Notice: Undefined variable: errors in D:\_test_develop\8.5\root\mymod\tools\smarty\sysplugins\smarty_internal_data.php on line 291

-- due this version is writen for Smarty 2.

 

Otherwise in exported csv, in Product Name field You can see something as this "iPod Nano - Color : Black, Disk space : 16Go" , if product have variant.

 

Do you think I could try current version, and upgraded it when you have the new release? If yes, please, could you send me the last version please???

 

Thanks a lot,

 

Steven

 

 

 

Thanks Steven, but current development version is still not for production use.

Wait please to new version, what i write from scratch, it is not hard work, if I have time :) .

pe_exportorders.zip

  • Like 2

Share this post


Link to post
Share on other sites

  • 2 weeks later...

Hi,

This module is great! Thank you for creating it.

 

I have a slight issue with the tab in BackOffice. IT has been created but it says "Orders tab file cannot be found" when I click on it.

 

Any ideas how I can fix that?

Thanks

Share this post


Link to post
Share on other sites

Hi,

Here is my new version, completely reworked from scratch.

NVN Export Orders into csv, ver 0.5.0

 

NOTE: After instalation is in Back Office>Modules>Administration. Some filters and option does not work in this version. Will be added in next version, depending on requirements. :) .

 

Tested on PS 1.4.8.3, PrestaShop™ 1.5.0.17

 

Thanks..

 

OK, 19.9. ,19 downloads, time to update - diacritic corrected in customers messages :D

OK, 24.9. +9 downloads, time to update - bug for PS 1.5 repaired :rolleyes:

OK, 11.10. +24 downloads, time to update - charset option for export added :P

post-300251-0-56574300-1347446256_thumb.jpg

Edited by Falgener (see edit history)
  • Like 2

Share this post


Link to post
Share on other sites

export_orders_nvn.zip works in 1.4.9.0!!!

 

@Falgener Module is not correctly showing special characters like č,š,ž...can you please fix it?

 

Yes, I look at it. (If you you mean Customer Message field. Other items are good, I believe.)

 

 

Its all works beautiful - how to I import this back into Presta? is there a module because under tools I only see for categories, products and so on

 

What you need to import it back? Into another e-shop? Otherwise Orders Tab in Back Office...

Share this post


Link to post
Share on other sites

Im migrating from old presta to new, i got the order info exported using your module - now how do I import it back into the other prestashop

If you migrate/update using standard prestashop update process, all orders, custommers etc. will be transfered.

But if you use csv export/import, hmm ... There is so much more, about orders etc

Share this post


Link to post
Share on other sites

well thats the point I have the csv from your export tool its useless if I can import it back into a new prestashop. There are bugs in the site/db so the upgrade is not an option. let me know what module/ tool i have to use to import the orders csv

Share this post


Link to post
Share on other sites

export_orders_nvn.zip works in 1.4.9.0!!!

 

@Falgener Module is not correctly showing special characters like č,š,ž...can you please fix it?

Update diacritic in customer messages. žluťoučký kůň pěl ďábelské ódy showing correctly. :)

Share this post


Link to post
Share on other sites

  • 2 weeks later...

So, they are constantly problems with diacritics, I added a field to select the output character set.

It is mainly because of the stupid old Excel. :wacko:

Who uses UTF8 leave the field blank. Otherwise, find your charset code on the Internet and try ..

 

Download here:

http://www.prestasho...100#entry926080

Edited by Falgener (see edit history)
  • Like 1

Share this post


Link to post
Share on other sites

So, they are constantly problems with diacritics, I added a field to select the output character set.

It is mainly because of the stupid old Excel. :wacko:

Who uses UTF8 leave the field blank. Otherwise, find your charset code on the Internet and try ..

 

Downloa here:

http://www.prestasho...100#entry926080

 

This is cool :)

I work in prestashop 1.4.3, 1.4.7 and 1.5.1 for the first test :) MS Excel has no problem :)) thx

Share this post


Link to post
Share on other sites

I've tested Falgener Export Orders module with Prestashop 1.3.7 and it works fine, great module!

 

The module export all items of orders but I would like to export only the total amount (payment) for each order, I don't need all items. Is it possible? Now it makes to many lines in export .csv (for each product).

Edited by jolvil (see edit history)

Share this post


Link to post
Share on other sites

I've tested Falgener Export Orders module with Prestashop 1.3.7 and it works fine, great module!

 

The module export all items of orders but I would like to export only the total amount (payment) for each order, I don't need all items. Is it possible? Now it makes to many lines in export .csv.

Yes, it is possible, when I have a minute, so I add it. ;)

Share this post


Link to post
Share on other sites

So, they are constantly problems with diacritics, I added a field to select the output character set.

It is mainly because of the stupid old Excel. :wacko:

Who uses UTF8 leave the field blank. Otherwise, find your charset code on the Internet and try ..

 

Download here:

http://www.prestasho...100#entry926080

 

Thanks Man!!!

Works in 1.4.9.0 !!!! Also all diacritics work in MS office with character set

Share this post


Link to post
Share on other sites

hi

is this able to export orders by manufacturer only.

 

Eg an xl sheet showing the following collums

order number Product name Manufacturer numbers ordered attribute 1 attribute 2 attribute 3 attribute 4 attribute 5 etc orders should be consecutive must be able to export orders from selected manufacturer or suppliers only (If required)

Share this post


Link to post
Share on other sites

Hi,

 

In your previous module (exportorders 2), I had add country in the csv list.

 

may be could you add country in your new module ?

 

Hi,

It will be added to the new updated version, and also the date filter

 

I have an error :

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 194 bytes) in /public_html_5_17/classes/db/DbPDO.php on line 9

 

 

From this line :

if (!$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($f)){

 

 

Db PDO.php been added since PrestaShop version 1.5

When I have time, I'll update the module. :)

Edited by Falgener (see edit history)

Share this post


Link to post
Share on other sites

it's in the SQL query

 

it's too complex with CONCAT etc...

when I uncheck all case and check one by one it works...

 

I just delete :

LEFT JOIN '._DB_PREFIX_.'message AS me ON me.id_order=od.id_order

 

to be lighter

 

CONCAT the adress is a bad idea, split it in option table to be easier : adress / telephone....

Share this post


Link to post
Share on other sites

try it

 

read licence term pls - Yes - you are allowed to make modifications for your own personal use, you may not distribute the original or the modified code without permission

why?

- now there are 2 versions to download, usually every download at the end of the thread and you're disable customer message functionality . It's not a good idea. IMHO CONCAT does not affect the complexity of the query.

- I did not signed under your version, write your own module :)

My latest version will always be here:

http://www.prestasho...100#entry926080

Edited by Falgener (see edit history)

Share this post


Link to post
Share on other sites

it's in the SQL query

 

it's too complex with CONCAT etc...

when I uncheck all case and check one by one it works...

 

I just delete :

LEFT JOIN '._DB_PREFIX_.'message AS me ON me.id_order=od.id_order

 

to be lighter

 

CONCAT the adress is a bad idea, split it in option table to be easier : adress / telephone....

 

 

So yes, the query is a little bit more complex. But it was easier for me. :)

When you have thousands of orders, it may be a problem. In next version will be a filter that limit the resulting query.

Your version without a message from a customer might work well for you. But someone just needs it there. :wacko:

Share this post


Link to post
Share on other sites

Hi Falgener, Just wondering if it is possible to use this module to export the orders with the quantity only from one manufacturer and the attribute name? I have a friend that requested this as one item he sells needs work to organize in his daily custom orders. Happy to support adding this option with some money for your time if you think it is possible? Thanks

Share this post


Link to post
Share on other sites

Hi Falgener, Just wondering if it is possible to use this module to export the orders with the quantity only from one manufacturer and the attribute name? I have a friend that requested this as one item he sells needs work to organize in his daily custom orders. Happy to support adding this option with some money for your time if you think it is possible? Thanks

 

Answer in PM

Share this post


Link to post
Share on other sites

Hello, again.

I would like to create a rapid link to your module in my admin home but this link doesn't work do you have an idea

index.php?controller=adminmodules&configure=export_orders_nvn&tab_module=administration&module_name=export_orders_nvn

 

??

Regards

Share this post


Link to post
Share on other sites

Thx a lot exactly what i need !

Work great on PS 1.5.2

 

The text "it does not work in this version" show us that the next one will be even better !

 

I follow the topic.

Regards

 

 

Děkuji mockrát ! jsem francouz ale mluvim trosku cesky ...

 

Děkuji za podporu hardiscount :)

Yes, the new version will be around next week.

 

Hello, again.

I would like to create a rapid link to your module in my admin home but this link doesn't work do you have an idea

index.php?controller=adminmodules&configure=export_orders_nvn&tab_module=administration&module_name=export_orders_nvn

 

??

Regards

 

add this to Administration>Quick Access

index.php?controller=adminmodules&configure=export_orders_nvn

 

and then you must click I understand the risks and I really want to display this page

Share this post


Link to post
Share on other sites

  • 2 weeks later...

Thanks for a great module!

 

I need to export the total number of products and total weight of each order. I've added 'od.product_weight'=>'Weight' to $fields but when I generate the CSV file, all order containing more than one order end up as several rows in the CSV file, when I need one order = one row with total number of products and total weight summarized in respective columns.

 

Is there anyone who can come up with a smart solution to this? Thanks!

Olov

Share this post


Link to post
Share on other sites

Thanks for a great module!

 

I need to export the total number of products and total weight of each order. I've added 'od.product_weight'=>'Weight' to $fields but when I generate the CSV file, all order containing more than one order end up as several rows in the CSV file, when I need one order = one row with total number of products and total weight summarized in respective columns.

 

Is there anyone who can come up with a smart solution to this? Thanks!

Olov

Hi, Answer in PM

Falgener

Share this post


Link to post
Share on other sites

  • 2 weeks later...

Hi,

Here is my new version, completely reworked from scratch.

NVN Export Orders into csv, ver 0.5.0

 

NOTE: After instalation is in Back Office>Modules>Administration. Some filters and option does not work in this version. Will be added in next version, depending on requirements. :) .

 

Tested on PS 1.4.8.3, PrestaShop™ 1.5.0.17

 

Thanks..

 

OK, 19.9. ,19 downloads, time to update - diacritic corrected in customers messages :D

OK, 24.9. +9 downloads, time to update - bug for PS 1.5 repaired :rolleyes:

OK, 11.10. +24 downloads, time to update - charset option for export added :P

Hello from Spain.

Magnifico!! operating in PS1.5.2

Could ask for aid? I also need to export the group I (id + name) to which the client belongs to see sales totals for groups. A algunamanera anyone think of it? Thank you.

Share this post


Link to post
Share on other sites

Hello from Spain. Magnifico!! operating in PS1.5.2 Could ask for aid? I also need to export the group I (id + name) to which the client belongs to see sales totals for groups. A algunamanera anyone think of it? Thank you.

 

Hi, I add it there, when I have time next week. :)

Share this post


Link to post
Share on other sites

Great Work..

 

 

one issue I noticed in the module is the address.

Country does not show up in the address field. Also it will be very helpful if we have Street Address , City, ZipCode and Country in different columns. Please let me know if it is something possible?

 

I need to export the data to another system and this will really help big time..

Share this post


Link to post
Share on other sites

Great Work.. one issue I noticed in the module is the address. Country does not show up in the address field. Also it will be very helpful if we have Street Address , City, ZipCode and Country in different columns. Please let me know if it is something possible? I need to export the data to another system and this will really help big time..

 

ok, the address will be divided into column and Country added in next version. :)

  • Like 1

Share this post


Link to post
Share on other sites

Do not know how much I appreciate your contribution.!! I am very grateful as I solve a big problem this functionality. accept a gift of appreciation? as tensile strength channel?

 

A greeting.

Share this post


Link to post
Share on other sites

Do not know how much I appreciate your contribution.!! I am very grateful as I solve a big problem this functionality. accept a gift of appreciation? as tensile strength channel?

 

A greeting.

Hi us62

Answer in PM

Falgener

thx

Share this post


Link to post
Share on other sites

  • 3 weeks later...

ok, the address will be divided into column and Country added in next version. :)

 

Falgener: great to hear it , we are trying to input it into Czech post system and with the latest version I´ve got no idea ho to solve it - divide the Street, Nr, Postcode even so the Town/City

Share this post


Link to post
Share on other sites

Falgener: great to hear it , we are trying to input it into Czech post system and with the latest version I´ve got no idea ho to solve it - divide the Street, Nr, Postcode even so the Town/City

 

Version 0.9.0(sponsor) from netvianet.com supports it today, but it will not be here sooner, if I have finished version 1.0. Sponsor version from netvianet.com will always be one step ahead. :rolleyes:

Edited by Falgener (see edit history)

Share this post


Link to post
Share on other sites

Hi Falgener,

I have an issue with the module (with both the new version and old version of the module).

 

When I press the "Export Orders" button, I get to a blank page (the BO page with only the header and no file to download).

Any idea why?

 

THanks

Share this post


Link to post
Share on other sites

Hi Falgener,

I have an issue with the module (with both the new version and old version of the module).

 

When I press the "Export Orders" button, I get to a blank page (the BO page with only the header and no file to download).

Any idea why?

 

THanks

 

Hi cyremia

- Verify that the directory export_orders_nvn/download/ is writable (file permissions)

- memory_limit ? try reduce the size of the query result (use some filter in module setting - eg increase Last Exported Order ID to last 10 orders, last ID Orders is displayed in BO Back Office > Orders )

  • Like 1

Share this post


Link to post
Share on other sites

  • 2 weeks later...

I just bought it on http://netvianet.com...rs-sponsor.html

 

Very good module !

 

Will you let the possibility to translate the text in next version ?

 

Hi Julien_Snow

Firstly, thank you for your support.

Module Translation is possible now - as with any other module.

You mean the translation "Fields for export". Yes, that's my laziness :rolleyes: , currently I collect comments for the new version.

Yes, I will add your request, as well as other :) .

Thanks.

  • Like 1

Share this post


Link to post
Share on other sites

Hi Julien_Snow

Firstly, thank you for your support.

Module Translation is possible now - as with any other module.

You mean the translation "Fields for export". Yes, that's my laziness :rolleyes: , currently I collect comments for the new version.

Yes, I will add your request, as well as other :) .

Thanks.

 

Yes it will be good !

 

If you want, I translated (what I can) it in FR (but there is some "lack" that I show with red arrow ;)

May be it can help you...

 

Fields : http://img826.imageshack.us/img826/8540/traductionbofr.jpg

 

View : http://img203.imageshack.us/img203/904/traductionbofrview.jpg

Share this post


Link to post
Share on other sites

Yes it will be good !

 

If you want, I translated (what I can) it in FR (but there is some "lack" that I show with red arrow ;)

May be it can help you...

 

Fields : http://img826.images...ductionbofr.jpg

 

View : http://img203.images...ionbofrview.jpg

Hi,

 

I have it fixed.

Send me an email as a personal message in my profile.

I will send you for testing.

When it will ok, you can then send me fr.php translation file for others. :)

thx

Share this post


Link to post
Share on other sites

  • 2 weeks later...

Nice module! One question though about the paid version on netvianet.com... Does it have the ability to export the wholesale-price?

 

It is something that is not in the free version. Even those overpriced modules on de prestashop marketplace don't seem to offer this simple option. It would be a welcome addition for bookkeeping and accounting purposes like profit calculation.

Edited by 288249ma (see edit history)

Share this post


Link to post
Share on other sites

Nice module! One question though about the paid version on netvianet.com... Does it have the ability to export the wholesale-price?

 

It is something that is not in the free version. Even those overpriced modules on de prestashop marketplace don't seem to offer this simple option. It would be a welcome addition for bookkeeping and accounting purposes like profit calculation.

 

Hi,

Field product - wholesale price is not yet implemented. So far, no one requested :rolleyes:.

But there is not a problem to add. After some time. :)

Share this post


Link to post
Share on other sites

  • 5 weeks later...

Thank you, great tool. But what if I want add all products customer bought in order? Reference number, product ID, product price..

Hi, and thanx

If I understand well. Maybe you downloaded stupid version from "la gastronome." Only one item out of order? Try this

 

http://www.prestashop.com/forums/topic/8424-module-to-export-orders/page__st__100#entry926080

  • Like 1

Share this post


Link to post
Share on other sites

Hi, and thanx

If I understand well. Maybe you downloaded stupid version from "la gastronome." Only one item out of order? Try this

 

http://www.prestasho...100#entry926080

Yes I had stupid version.. sorry. Now I have your working version, SUPER :)

 

but address - street, zip code etc. are all in one cell. Unusable.

 

EDIT: Address solved myself. Thank you.

Edited by ender666 (see edit history)

Share this post


Link to post
Share on other sites

The price you are selling is exactly what I am looking for. Modules like this should be made affordable so every one can buy them freely without much thoughts. Unlike evil dev who charge exorbitant rates and end up with no sales.

 

The separate addresses you have is good but i have to use excel CHAR(10) to induce next line. Even that, it's not smart enough to use prestashop's list of address format for individual countries.

 

I have one question before buying. When do you plan on adding a filter that merges the address1, address2, state, city, postal code, country, tel, tel mobile all in ONE cell in their respective country's format? This makes it possible to copy it to be printed as address labels which is currently what I am doing now manually.

Edited by Pressed0024 (see edit history)

Share this post


Link to post
Share on other sites

The price you are selling is exactly what I am looking for. Modules like this should be made affordable so every one can buy them freely without much thoughts. Unlike evil dev who charge exorbitant rates and end up with no sales. The separate addresses you have is good but i have to use excel CHAR(10) to induce next line. Even that, it's not smart enough to use prestashop's list of address format for individual countries. I have one question before buying. When do you plan on adding a filter that merges the address1, address2, state, city, postal code, country, tel, tel mobile all in ONE cell in their respective country's format? This makes it possible to copy it to be printed as address labels which is currently what I am doing now manually.

 

 

Hi Pressed0024

Address format is a good idea, but I'm not sure that it needs more people - it's a bit specific requirement. But - now I have tested it, and it's quite easy to solve.

So - I will add it next week :) ... in the simplest version, there is not much time :rolleyes:

Because you're the first, write me, which item has a new address fields contain - something like

 

John DOE

16, Main street

75000 Paris

France

 

Thx

Share this post


Link to post
Share on other sites

Hi Pressed0024

Address format is a good idea, but I'm not sure that it needs more people - it's a bit specific requirement. But - now I have tested it, and it's quite easy to solve.

So - I will add it next week :) ... in the simplest version, there is not much time :rolleyes:

Because you're the first, write me, which item has a new address fields contain - something like

 

John DOE

16, Main street

75000 Paris

France

 

Thx

 

This is what we need also.

 

So we can copy and paste the address easily. In one list. Cheers.

Share this post


Link to post
Share on other sites

Falgener, actually there SHOULD be many people requesting for this because if the shop ships via postal service, chances are they need it in such a format.

 

Yes, the sample address is what I am talking about. I also suggest the exported excel outputs the address based on BO > Localization > Countries > Edit. That way, it would appear exactly like how we want it to be displayed.

 

Would you be making it available in the Free version or Sponsor version? Just curious.

Share this post


Link to post
Share on other sites