Sql para envio pelos Correios

Para não ter que digitar todo o que foi dito no artigo anterior, basta copiar o comando Sql abaixo e executá-lo no PhpMyAdmin sobre o banco de dados de sua loja.

Ele fará todas as configurações para você, no entanto deverão ser feitos ajustes de acordo com a cidade da qual você está despachando as mercadorias.

Por exemplo, se está em Porto Alegre, deve ajustar o estado do Rio Grande do Sul – Capital para a Zona Local e Rio Grande do Sul – Interior para Divisa/estadual, conseqüentemente, o estado que estava configurado para essas zonas (Ceará) deve ser ajustado para sua zona correspondente capital/interior.

Para finalizar, é só lançar os dados das tarifas de acordo com o peso, que você ja deve ter pego nos Correios. Não esquecer, é claro, de atribuir as imagens correspondentes às transportadoas que tenha escolhido.

Não se esqueça, copie, cole e execute a consulta listada abaixo. Veja a imagem acima para vê-la colada na tela do phpmyadmin, pronta para se executada.

Consulta SQL

SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;

INSERT INTO `ps_zone` (`id_zone`, `name`, `active`, `enabled`) VALUES
(1, ‘Europe’, 1, 1),
(2, ‘US’, 1, 1),
(3, ‘Asia’, 1, 1),
(4, ‘Africa’, 1, 1),
(5, ‘Oceania’, 1, 1),
(6, ‘Local’, 1, 0),
(7, ‘Estadual/Divisa’, 1, 0),
(8, ‘MA, PB, PE, PI, RN – Capital’, 1, 0),
(9, ‘MA, PB, PE, PI, RN – Interior’, 1, 0),
(10, ‘AL, SE – Capital’, 1, 0),
(11, ‘AL, SE – Interior’, 1, 0),
(12, ‘BA, PA – Capital’, 1, 0),
(13, ‘BA, PA – Interior’, 1, 0),
(14, ‘AP – Capital’, 1, 0),
(15, ‘AP – Interior’, 1, 0),
(16, ‘DF, ES, GO, MG – Capital’, 1, 0),
(17, ‘DF, ES, GO, MG – Interior’, 1, 0),
(18, ‘MT, MS, RJ – Capital’, 1, 0),
(19, ‘MT, MS, RJ – Interior’, 1, 0),
(20, ‘AM, PR, RO, RR, SP, TO – Capital’, 1, 0),
(21, ‘AM, PR, RO, RR, SP, TO – Interior’, 1, 0),
(22, ‘SC – Capital’, 1, 0),
(23, ‘SC – Interior’, 1, 0),
(24, ‘AC, RS – Capital’, 1, 0),
(25, ‘AC, RS – Interior’, 1, 0);

INSERT INTO `ps_state` (`id_state`, `id_country`, `id_zone`, `name`, `iso_code`, `tax_behavior`, `active`) VALUES

(65, 35, 24, ‘Acre – Capital’, ‘AC’, 0, 1),
(66, 35, 25, ‘Acre – Interior’, ‘ACI’, 0, 1),
(67, 35, 10, ‘Alagoas – Capital’, ‘AL’, 0, 1),
(68, 35, 11, ‘Alagoas – Interior’, ‘ALI’, 0, 1),
(69, 35, 14, ‘Amapá- Capital’, ‘AP’, 0, 1),
(70, 35, 15, ‘Amapá – Interior’, ‘API’, 0, 1),
(71, 35, 20, ‘Amazonas – Capital’, ‘AM’, 0, 1),
(72, 35, 21, ‘Amazonas – Interior’, ‘AMI’, 0, 1),
(73, 35, 12, ‘Bahia – Capital’, ‘BA’, 0, 1),
(74, 35, 13, ‘Bahia – Interior’, ‘BAI’, 0, 1),
(75, 35, 6, ‘Ceará – Capital’, ‘CE’, 0, 1),
(76, 35, 7, ‘Ceará – Interior’, ‘CEI’, 0, 1),
(77, 35, 16, ‘Distrito Federal – Capital’, ‘DF’, 0, 1),
(78, 35, 17, ‘Distrito Federal – Interior’, ‘DFI’, 0, 1),
(79, 35, 16, ‘Espírio Santo – Capital’, ‘ES’, 0, 1),
(80, 35, 17, ‘Espírio Santo – Interior’, ‘ESI’, 0, 1),
(81, 35, 16, ‘Goiás – Capital’, ‘GO’, 0, 1),
(82, 35, 17, ‘Goiás – Interior’, ‘GOI’, 0, 1),
(83, 35, 8, ‘Maranhão – Capital’, ‘MA’, 0, 1),
(84, 35, 9, ‘Maranhão – Interior’, ‘MAI’, 0, 1),
(85, 35, 18, ‘Mato Grosso – Capital’, ‘MT’, 0, 1),
(86, 35, 19, ‘Mato Grosso – Interior’, ‘MTI’, 0, 1),
(87, 35, 19, ‘Mato Grosso do Sul – Capital’, ‘MS’, 0, 1),
(88, 35, 16, ‘Minas Gerais – Capital’, ‘MG’, 0, 1),
(89, 35, 17, ‘Minas Gerais – Interior’, ‘MGI’, 0, 1),
(90, 35, 12, ‘Pará – Capital’, ‘PA’, 0, 1),
(91, 35, 13, ‘Pará – Interior’, ‘PAI’, 0, 1),
(92, 35, 8, ‘Paraíba – Capital’, ‘PB’, 0, 1),
(93, 35, 9, ‘Paraíba – Interior’, ‘PBI’, 0, 1),
(94, 35, 20, ‘Paraná – Capital’, ‘PR’, 0, 1),
(95, 35, 21, ‘Paraná – Interior’, ‘PRI’, 0, 1),
(96, 35, 8, ‘Pernambuco – Capital’, ‘PE’, 0, 1),
(97, 35, 9, ‘Pernambuco – Interior’, ‘PEI’, 0, 1),
(98, 35, 8, ‘Piauí – Capital’, ‘PI’, 0, 1),
(99, 35, 9, ‘Piauí – Interior’, ‘PII’, 0, 1),
(100, 35, 18, ‘Rio de Janeiro – Capital’, ‘RJ’, 0, 1),
(101, 35, 19, ‘Rio de Janeiro – Interior’, ‘RJI’, 0, 1),
(102, 35, 8, ‘Rio Grande do Norte – Capital’, ‘RN’, 0, 1),
(103, 35, 9, ‘Rio Grande do Norte – Interior’, ‘RNI’, 0, 1),
(104, 35, 24, ‘Rio Grande do Sul – Capital’, ‘RS’, 0, 1),
(105, 35, 24, ‘Rio Grande do Sul – Interior’, ‘RSI’, 0, 1),
(106, 35, 20, ‘Rondônia – Capital’, ‘RO’, 0, 1),
(107, 35, 21, ‘Rondônia – Interior’, ‘ROI’, 0, 1),
(108, 35, 20, ‘Roraima – Capital’, ‘RR’, 0, 1),
(109, 35, 21, ‘Roraima – Interior’, ‘RRI’, 0, 1),
(110, 35, 22, ‘Santa Catarina – Capital’, ‘SC’, 0, 1),
(111, 35, 23, ‘Santa Catarina – Interior’, ‘SCI’, 0, 1),
(112, 35, 20, ‘São Paulo – Capital’, ‘SP’, 0, 1),
(113, 35, 21, ‘São Paulo – Interior’, ‘SPI’, 0, 1),
(114, 35, 10, ‘Sergipe – Capital’, ‘SE’, 0, 1),
(115, 35, 11, ‘Sergipe – Interior’, ‘SEI’, 0, 1),
(116, 35, 20, ‘Tocantins – Capital’, ‘TO’, 0, 1),
(117, 35, 21, ‘Tocantins – Interior’, ‘TOI’, 0, 1);

INSERT INTO `ps_range_weight` (`id_range_weight`, `id_carrier`, `delimiter1`, `delimiter2`) VALUES
(1, 2, ‘0.000000′, ‘10000.000000′),
(2, 4, ‘0.000000′, ‘0.300000′),
(3, 4, ‘0.301000′, ‘1.000000′),
(4, 4, ‘1.100000′, ‘2.000000′),
(5, 4, ‘2.100000′, ‘3.000000′),
(6, 5, ‘0.000000′, ‘0.300000′),
(7, 5, ‘0.301000′, ‘1.000000′),
(8, 5, ‘1.100000′, ‘2.000000′),
(9, 5, ‘2.100000′, ‘3.000000′),
(10, 6, ‘0.000000′, ‘0.300000′),
(11, 6, ‘0.301000′, ‘1.000000′),
(12, 6, ‘1.100000′, ‘2.000000′),
(13, 6, ‘2.100000′, ‘3.000000′),
(14, 7, ‘0.000000′, ‘0.300000′),
(15, 7, ‘0.301000′, ‘1.000000′),
(16, 7, ‘1.100000′, ‘2.000000′),
(17, 7, ‘2.100000′, ‘3.000000′),
(18, 8, ‘0.000000′, ‘10.000000′),
(19, 9, ‘0.000000′, ‘0.300000′),
(20, 9, ‘0.301000′, ‘1.000000′),
(21, 9, ‘1.100000′, ‘2.000000′),
(22, 9, ‘2.100000′, ‘3.000000′),
(23, 10, ‘0.000000′, ‘10.000000′);

INSERT INTO `ps_carrier` (`id_carrier`, `id_tax`, `name`, `url`, `active`, `deleted`, `shipping_handling`, `range_behavior`) VALUES

(3, 0, ‘PAC – Capitais’, ‘http://websro.correios.com.br/sro_bin/txect01$.QueryList?P_LINGUA=001&P_TIPO=001&P_COD_UNI=@’, 1, 1, 0, 0),
(4, 0, ‘PAC – Capitais’, ‘http://websro.correios.com.br/sro_bin/txect01$.QueryList?P_LINGUA=001&P_TIPO=001&P_COD_UNI=@’, 1, 0, 0, 0),
(5, 0, ‘PAC – Interior’, ‘http://websro.correios.com.br/sro_bin/txect01$.QueryList?P_LINGUA=001&P_TIPO=001&P_COD_UNI=@’, 1, 0, 0, 0),
(6, 0, ‘SEDEX – Capitais’, ‘http://websro.correios.com.br/sro_bin/txect01$.QueryList?P_LINGUA=001&P_TIPO=001&P_COD_UNI=@’, 1, 1, 1, 0),
(7, 0, ‘SEDEX – Interior’, ‘http://websro.correios.com.br/sro_bin/txect01$.QueryList?P_LINGUA=001&P_TIPO=001&P_COD_UNI=@’, 1, 0, 0, 0),
(8, 0, ‘Entrega Local’, ‘@’, 1, 1, 0, 0),
(9, 0, ‘SEDEX – Capitais’, ‘http://websro.correios.com.br/sro_bin/txect01$.QueryList?P_LINGUA=001&P_TIPO=001&P_COD_UNI=@’, 1, 0, 0, 0),
(10, 0, ‘Entrega Local’, ‘@’, 1, 0, 0, 0);

E isso é tudo!