Vendas Bellas Posted July 22, 2015 Share Posted July 22, 2015 Olá galera, existe alguma forma de saber quanto de frete teve no mês? Não a quantidade e sim o valor, para saber quanto teve de custo de frete até para saber se fecha contrato com Correios e tal. Muito Obrigado desde já. Link to comment Share on other sites More sharing options...
selectshop.at Posted July 22, 2015 Share Posted July 22, 2015 (edited) Isto é caso para um SQL query no banco de dados. Os dados vc. encontra na tabela ps_order_carrier. http://doc.prestashop.com/display/PS16/SQL+Manager Edited July 22, 2015 by selectshop.at (see edit history) Link to comment Share on other sites More sharing options...
Vendas Bellas Posted July 22, 2015 Author Share Posted July 22, 2015 Isto é caso para um SQL query no banco de dados. Os dados vc. encontra na tabela ps_order_carrier. http://doc.prestashop.com/display/PS16/SQL+Manager cOMO assim? Consegue me ensinar a fazer? Link to comment Share on other sites More sharing options...
selectshop.at Posted July 23, 2015 Share Posted July 23, 2015 (edited) Veja o tutorial que linkei. SQL query deverá ser SELECT * from ps_order_carrier - com isto vc. exporta TODOS os dados da tabela ps_order_carrier. Se quiser rafinar com os campos, entao vc. inclue com WHERE, AS e LEFT JOIN. Edited July 23, 2015 by selectshop.at (see edit history) Link to comment Share on other sites More sharing options...
Vendas Bellas Posted July 23, 2015 Author Share Posted July 23, 2015 bELEZA, VI ONTEM O LINK..TESTEI JA UNS AQUI.. MUITO OBRIGADO. Link to comment Share on other sites More sharing options...
.png.d6a00d0d660fa4302a442ac4f0e80ed3.png)
.png.022b5452a8f28f552bc9430097a16da2.png)
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