c64girl Posted October 21, 2023 Share Posted October 21, 2023 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? Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 23, 2023 Share Posted October 23, 2023 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. Link to comment Share on other sites More sharing options...
c64girl Posted October 23, 2023 Author Share Posted October 23, 2023 (edited) 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) Link to comment Share on other sites More sharing options...
c64girl Posted October 23, 2023 Author Share Posted October 23, 2023 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 Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 23, 2023 Share Posted October 23, 2023 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. Link to comment Share on other sites More sharing options...
c64girl Posted October 23, 2023 Author Share Posted October 23, 2023 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? Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 23, 2023 Share Posted October 23, 2023 I certainly can. Let's go to a private message. Link to comment Share on other sites More sharing options...
c64girl Posted October 23, 2023 Author Share Posted October 23, 2023 Just now, ps8moduly.cz said: I certainly can. Let's go to a private message. Ok. Link to comment Share on other sites More sharing options...
ps8modules.com Posted October 23, 2023 Share Posted October 23, 2023 You know I'll solve everything quickly 😉 Link to comment Share on other sites More sharing options...
c64girl Posted October 23, 2023 Author Share Posted October 23, 2023 Just now, ps8moduly.cz said: You know I'll solve everything quickly 😉 Yes i do Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now