save order to txt file index;;quantity

[c64girl]

Looking for module that will allow save order to txt by pressing button in back office orders list.

Nothing special needed only SKU/index with no - and quantity.

The file with order would look like this

AD0360000002007268;;3
VE0770000003009020;;1
OD036000004007154;;2
GE0770000004007154;;2
S062415220016708;;3
TS0262517040016708;;3
ZE0770000003006425;;1

I am low in php and average in MySQL can someone help creating a module?

[ps8modules.com]

Hi.

I'd be happy to help, but I'm missing more information. Prestashop version (full, only 1.7 is not enough), if any module already edits the order list, if TXT or CSV should be generated (excel may not be able to process TXT), if SKU or product or attribute reference code is needed, what is an empty field between SKU and by quantity, the location of the export button in the list of orders.

[c64girl]

4 hours ago, ps8moduly.cz said:

Hi.

I'd be happy to help, but I'm missing more information. Prestashop version (full, only 1.7 is not enough), if any module already edits the order list, if TXT or CSV should be generated (excel may not be able to process TXT), if SKU or product or attribute reference code is needed, what is an empty field between SKU and by quantity, the location of the export button in the list of orders.

PS. 1.7.8.9 will be updated in future. No module edits the order list in the back office. It is to generate a simple txt will be uploaded to an external program that takes products off stock using sku and status. In our store there are no combinations and attributes. There are products themselves one product means combinations / attribute. Sku at my store has hyphens between several digits when exporting it would be nice if there were none.

 

Maybe module will add a button like this in list orders:

And a button inside order:

 

Edited October 23, 2023 by c64girl (see edit history)

[c64girl]

I came up with something like this but dont know how to implement it

 

SELECT concat(replace(product_reference,'-',''),';;',product_quantity) FROM `ps_order_detail` where id_order = 7300

 

[ps8modules.com]

Hi.

Thanks for the additional answer.
Everything is now perfectly clear.
It is nothing complicated and the work estimate is a maximum of one hour.
It is also possible to use JavaScript and it will not be necessary to modify the module at all for higher versions of Prestashop.

[c64girl]

10 minutes ago, ps8moduly.cz said:

Hi.

Thanks for the additional answer.
Everything is now perfectly clear.
It is nothing complicated and the work estimate is a maximum of one hour.
It is also possible to use JavaScript and it will not be necessary to modify the module at all for higher versions of Prestashop.

Superb, so can You help me with it?

[ps8modules.com]

I certainly can. Let's go to a private message.

[c64girl]

Just now, ps8moduly.cz said:

I certainly can. Let's go to a private message.

Ok.

[ps8modules.com]

You know I'll solve everything quickly 😉

 

[c64girl]

Just now, ps8moduly.cz said:

You know I'll solve everything quickly 😉

 

Yes i do