/home/wwwtroti/developer/colegiosdev/core/webservices/../../files/importar/prod_2024_06_26_04_667c3fc17a672.txt
Array
(
[Codigo] => 1603610.1087
[DescricaoPT] => T-SHIRT MANGA CURTA BEBÉ
[DescricaoFR] => Array
(
)
[DescricaoEN] => SHORT SLEEVE BABY T-SHIRT
[DescricaoES] => Array
(
)
[DescricaoDE] => Array
(
)
[TextoPromociaonalPT] => T-shirt de bebé de manga curta. Rib na gola em contraste e tapa costuras no interior. Abertura c/ molas na lateral esquerda. Estampado na frente centrado.
[TextoPromociaonalFR] => Array
(
)
[TextoPromociaonalEN] => Short sleeve baby t-shirt. Rib collar in contrast and seam cover on the inside. Spring opening on the left side. Print on the front centered.
[TextoPromociaonalES] => Array
(
)
[TextoPromociaonalDE] => Array
(
)
[Menu1] => Array
(
)
[Menu2] => 16 - T-shirt
[Menu3] => Unisexo
[Clientes] => Array
(
[Cliente] => 3559
)
[Tags] => Array
(
[Tag] => Array
(
[0] => Array
(
[Nome] => Tipo3_PT_Unissexo
[Cliente] => 1087
)
[1] => Array
(
[Nome] => Tipo3_EN_Unisex
[Cliente] => 1087
)
[2] => Array
(
[Nome] => Cat33_PT_Creche
[Cliente] => 1087
)
[3] => Array
(
[Nome] => Cat33_EN_Nursery
[Cliente] => 1087
)
[4] => Array
(
[Nome] => Fam1_PT_T-shirts
[Cliente] => 1087
)
[5] => Array
(
[Nome] => Fam1_EN_T-shirts
[Cliente] => 1087
)
[6] => Array
(
[Nome] => Cor32_PT_Azul Claro
[Cliente] => 1087
)
[7] => Array
(
[Nome] => Cor32_EN_Light Blue
[Cliente] => 1087
)
[8] => Array
(
[Nome] => Mat7_PT_Jersey
[Cliente] => 1087
)
[9] => Array
(
[Nome] => Mat7_EN_Jersey
[Cliente] => 1087
)
[10] => Array
(
[Nome] => Tab9_PT_Criança
[Cliente] => 1087
)
)
)
[TiposLavagem] => Array
(
)
[Lavagens] => Array
(
)
[MPAlternativas] => Array
(
[MPAlternativa] => Array
(
[Principal] => 1
[Codigo] => Array
(
)
[Descricao] => Malha Jersey / 100% CO / 180gr
[Cores] => Array
(
)
)
)
[Combinacoes] => Array
(
[Combinacao] => Array
(
[0] => Array
(
[Cor] => AZUL CLARO;;#BDDDFD
[Tamanho] => 6M
[Preco] => 9.78
[PesoLiquido] => 0
[PVP] => 0
)
[1] => Array
(
[Cor] => AZUL CLARO;;#BDDDFD
[Tamanho] => 9M
[Preco] => 9.78
[PesoLiquido] => 0
[PVP] => 0
)
[2] => Array
(
[Cor] => AZUL CLARO;;#BDDDFD
[Tamanho] => 12M
[Preco] => 9.78
[PesoLiquido] => 0
[PVP] => 0
)
[3] => Array
(
[Cor] => AZUL CLARO;;#BDDDFD
[Tamanho] => 18M
[Preco] => 9.78
[PesoLiquido] => 0
[PVP] => 0
)
[4] => Array
(
[Cor] => AZUL CLARO;;#BDDDFD
[Tamanho] => 2A
[Preco] => 9.78
[PesoLiquido] => 0
[PVP] => 0
)
[5] => Array
(
[Cor] => AZUL CLARO;;#BDDDFD
[Tamanho] => 3A
[Preco] => 9.78
[PesoLiquido] => 0
[PVP] => 0
)
[6] => Array
(
[Cor] => AZUL CLARO;;#BDDDFD
[Tamanho] => ESP
[Preco] => 9.78
[PesoLiquido] => 0
[PVP] => 0
)
)
)
[Padroes] => Array
(
[Padrao] => Array
(
[Codigo] => AZUL CLARO
[DesCor] => Array
(
)
[Imagem] => Array
(
)
)
)
[Preco1] => 0
[Preco2] => 0
[Preco3] => 0
[Preco4] => 0
[Preco5] => 0
[Preco6] => 0
[Preco7] => 0
[Preco8] => 0
[Preco9] => 0
[Preco10] => 0
[Preco11] => 0
[Relacionados] => Array
(
)
[Promocao] => False
[Destaque] => False
[B2C] => False
[B2B] => False
[Unidade] => Un
[Situacao] => 0
[NovaCombinacao] => 0
[Gramagem] => 180
[PesoLiquidoMedio] => Array
(
)
[PesoEmbalagemMedio] => Array
(
)
[RefCli] => MOD. 101.1 COM MOLAS
[Composicao] => 100% CO
[CorPredefinida] => Array
(
)
)
UPDATE products SET Carrinho='1',ID_Marca='264' WHERE ID = '484'
codigo=1603610.1087
DescricaoPT=T-SHIRT MANGA CURTA BEBÉ
UPDATE products_lang SET Cabecalho = "T-SHIRT MANGA CURTA BEBÉ" WHERE ID_PAI = 484 AND LANG="pt"
UPDATE products_lang SET Cabecalho = "" WHERE ID_PAI = 484 AND LANG="fr"
DescricaoEN=SHORT SLEEVE BABY T-SHIRT
UPDATE products_lang SET Cabecalho = "SHORT SLEEVE BABY T-SHIRT" WHERE ID_PAI = 484 AND LANG="en"
UPDATE products_lang SET Cabecalho = "" WHERE ID_PAI = 484 AND LANG="es"
UPDATE products_lang SET Cabecalho = "" WHERE ID_PAI = 484 AND LANG="de"
TextoPromociaonalPT=T-shirt de bebé de manga curta. Rib na gola em contraste e tapa costuras no interior. Abertura c/ molas na lateral esquerda. Estampado na frente centrado.
UPDATE products_lang SET Texto1 = "T-shirt de bebé de manga curta. Rib na gola em contraste e tapa costuras no interior. Abertura c/ molas na lateral esquerda. Estampado na frente centrado.
" WHERE ID_PAI = 484 AND LANG="pt"
TextoPromociaonalFR=Array
UPDATE products_lang SET Texto1 = "" WHERE ID_PAI = 484 AND LANG="fr"
TextoPromociaonalEN=Short sleeve baby t-shirt. Rib collar in contrast and seam cover on the inside. Spring opening on the left side. Print on the front centered.
UPDATE products_lang SET Texto1 = "Short sleeve baby t-shirt. Rib collar in contrast and seam cover on the inside. Spring opening on the left side. Print on the front centered.
" WHERE ID_PAI = 484 AND LANG="en"
TextoPromociaonalES=Array
UPDATE products_lang SET Texto1 = "" WHERE ID_PAI = 484 AND LANG="es"
TextoPromociaonalDE=Array
UPDATE products_lang SET Texto1 = "" WHERE ID_PAI = 484 AND LANG="de"
Categoria1=16 - T-shirt
Categoria=Unisexo
UPDATE products SET Genero = "3" WHERE ID = 484
Cliente:3559
Tags:
| >Tipo3_PT_Unissexo
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
>Tipo3_PT_Unissexo
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
>Tipo3_EN_Unisex
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
>Tipo3_EN_Unisex
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
>Cat33_PT_Creche
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
TAG:CRECHE
pt 1 --> primeira vez |
UPDATE products set Categoria = 'CRECHE' WHERE ID = 484
UPDATE products_lang set Categoria_B = 'CRECHE' WHERE ID_PAI = 484 AND Lang='pt'
>Cat33_PT_Creche
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
TAG:CRECHE
pt 1 --> segunda vez |
SELECT * FROM products where ID=484 and Categoria like '%CRECHE%'
Ja existe
SELECT * FROM products_lang where ID_PAI=484 and Categoria_B like '%CRECHE%' AND Lang='pt'
Ja existe na tabela lang, passa para a proxima tag
>Cat33_EN_Nursery
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
TAG:NURSERY
en 1 --> primeira vez |
UPDATE products_lang set Categoria_B = 'NURSERY' WHERE ID_PAI = 484 AND Lang='en'
>Cat33_EN_Nursery
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
TAG:NURSERY
en 1 --> segunda vez |
SELECT * FROM products where ID=484 and Categoria like '%NURSERY%'
Não existe
UPDATE products_lang set Categoria_B = 'NURSERY' WHERE ID_PAI = 484 AND Lang='en'
>Fam1_PT_T-shirts
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
UPDATE products set Roupa = 'T-SHIRTS' WHERE ID = 484
UPDATE products_lang set Roupa_B = 'T-SHIRTS' WHERE ID_PAI = 484 AND Lang='pt'
>Fam1_PT_T-shirts
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
>Fam1_EN_T-shirts
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
UPDATE products_lang set Roupa_B = 'T-SHIRTS' WHERE ID_PAI = 484 AND Lang='en'
>Fam1_EN_T-shirts
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
>Cor32_PT_Azul Claro
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
********* COR
atualiza_artigo_filtro(484,5,AZUL CLARO,1,LIGHT BLUE,,32);
UPDATE filters_values_lang set value_id_import_ref = 'LIGHT BLUE' WHERE values_id='302' AND values_lang='en'
VAMOS ATUALIZAR ESTE FILTRO:
SELECT * FROM filters_products WHERE prod_id = 484 AND cat_id = '5' and valor_id='302'
JA EXISTE 37086
UPDATE filters_products set
fam_id1 = "1"
,marca_id="1"
,filtro_active="1"
,filtro_area="3"
,filtros_rel2="5_302;"
WHERE filtro_id = "37086"
UPDATE filters_products set
fam_id1 = "1"
,marca_id="1"
,filtro_active="1"
,filtro_area="3"
,filtros_rel2="5_302;"
WHERE filtro_id = "37086"
>Cor32_PT_Azul Claro
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
********* COR
atualiza_artigo_filtro(484,5,AZUL CLARO,1,LIGHT BLUE,,32);
UPDATE filters_values_lang set value_id_import_ref = 'LIGHT BLUE' WHERE values_id='302' AND values_lang='en'
VAMOS ATUALIZAR ESTE FILTRO:
SELECT * FROM filters_products WHERE prod_id = 484 AND cat_id = '5' and valor_id='302'
JA EXISTE 37086
UPDATE filters_products set
fam_id1 = "1"
,marca_id="1"
,filtro_active="1"
,filtro_area="3"
,filtros_rel2="5_302;"
WHERE filtro_id = "37086"
UPDATE filters_products set
fam_id1 = "1"
,marca_id="1"
,filtro_active="1"
,filtro_area="3"
,filtros_rel2="5_302;"
WHERE filtro_id = "37086"
>Cor32_EN_Light Blue
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
>Cor32_EN_Light Blue
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
>Mat7_PT_Jersey
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
UPDATE filters_values_lang set value_id_import_ref = 'JERSEY' WHERE values_id='238' AND values_lang='en'
UPDATE filters_products set
fam_id1 = "1"
,marca_id="1"
,filtro_active="1"
,filtro_area="3"
,filtros_rel2="4_238;"
WHERE filtro_id = "37087"
>Mat7_PT_Jersey
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
UPDATE filters_values_lang set value_id_import_ref = 'JERSEY' WHERE values_id='238' AND values_lang='en'
UPDATE filters_products set
fam_id1 = "1"
,marca_id="1"
,filtro_active="1"
,filtro_area="3"
,filtros_rel2="4_238;"
WHERE filtro_id = "37087"
>Mat7_EN_Jersey
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
>Mat7_EN_Jersey
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
>Tab9_PT_Criança
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
>Tab9_PT_Criança
[atualiza_artigo_tags]
SELECT * FROM products WHERE Ref = "1603610.1087"
TiposLavagem=Array
Lavagens:
Combinacoes:
Combinacao
0
>Cor:AZUL CLARO;;#BDDDFD
>Tamanho:6M
>Preco:9.78
>PesoLiquido:0
>PVP:0
UPDATE filters_values_lang set value_id_import_ref = '6M' WHERE values_id='296' AND values_lang='en'
UPDATE filters_values_lang set value_id_import_ref = '6M' WHERE values_id='296' AND values_lang='es'
UPDATE products set Tipo_medidas=1 WHERE ID = 484
SELECT * FROM filters_products WHERE prod_id = 484 AND cat_id = '1' and valor_id='296'
UPDATE filters_products set cat_id="1",valor_id="296",prod_id="484",fam_id1="1",marca_id="1",filtros_rel2="1_296;" WHERE filtro_id = "37088"
UPDATE filters_products set cat_id="1",valor_id="296",prod_id="484",fam_id1="1",marca_id="1",filtros_rel2="1_296;" WHERE filtro_id = "37088"
SELECT * FROM products_objs_combo WHERE obj_type_id = 484 and obj_combo2=';1-296;'
UPDATE products_objs_combo SET obj_ativo=1, obj_pvp = "9.78", obj_pvp_kit = "" WHERE obj_id = 5589
UPDATE products_objs_combo SET obj_ativo=1, obj_pvp = "9.78", obj_pvp_kit = "" WHERE obj_id = 5589
1
>Cor:AZUL CLARO;;#BDDDFD
>Tamanho:9M
>Preco:9.78
>PesoLiquido:0
>PVP:0
UPDATE filters_values_lang set value_id_import_ref = '9M' WHERE values_id='297' AND values_lang='en'
UPDATE filters_values_lang set value_id_import_ref = '9M' WHERE values_id='297' AND values_lang='es'
UPDATE products set Tipo_medidas=1 WHERE ID = 484
SELECT * FROM filters_products WHERE prod_id = 484 AND cat_id = '1' and valor_id='297'
UPDATE filters_products set cat_id="1",valor_id="297",prod_id="484",fam_id1="1",marca_id="1",filtros_rel2="1_297;" WHERE filtro_id = "37089"
UPDATE filters_products set cat_id="1",valor_id="297",prod_id="484",fam_id1="1",marca_id="1",filtros_rel2="1_297;" WHERE filtro_id = "37089"
SELECT * FROM products_objs_combo WHERE obj_type_id = 484 and obj_combo2=';1-297;'
UPDATE products_objs_combo SET obj_ativo=1, obj_pvp = "9.78", obj_pvp_kit = "" WHERE obj_id = 5590
UPDATE products_objs_combo SET obj_ativo=1, obj_pvp = "9.78", obj_pvp_kit = "" WHERE obj_id = 5590
2
>Cor:AZUL CLARO;;#BDDDFD
>Tamanho:12M
>Preco:9.78
>PesoLiquido:0
>PVP:0
UPDATE filters_values_lang set value_id_import_ref = '12M' WHERE values_id='298' AND values_lang='en'
UPDATE filters_values_lang set value_id_import_ref = '12M' WHERE values_id='298' AND values_lang='es'
UPDATE products set Tipo_medidas=1 WHERE ID = 484
SELECT * FROM filters_products WHERE prod_id = 484 AND cat_id = '1' and valor_id='298'
UPDATE filters_products set cat_id="1",valor_id="298",prod_id="484",fam_id1="1",marca_id="1",filtros_rel2="1_298;" WHERE filtro_id = "37090"
UPDATE filters_products set cat_id="1",valor_id="298",prod_id="484",fam_id1="1",marca_id="1",filtros_rel2="1_298;" WHERE filtro_id = "37090"
SELECT * FROM products_objs_combo WHERE obj_type_id = 484 and obj_combo2=';1-298;'
UPDATE products_objs_combo SET obj_ativo=1, obj_pvp = "9.78", obj_pvp_kit = "" WHERE obj_id = 5591
UPDATE products_objs_combo SET obj_ativo=1, obj_pvp = "9.78", obj_pvp_kit = "" WHERE obj_id = 5591
3
>Cor:AZUL CLARO;;#BDDDFD
>Tamanho:18M
>Preco:9.78
>PesoLiquido:0
>PVP:0
UPDATE filters_values_lang set value_id_import_ref = '18M' WHERE values_id='299' AND values_lang='en'
UPDATE filters_values_lang set value_id_import_ref = '18M' WHERE values_id='299' AND values_lang='es'
UPDATE products set Tipo_medidas=1 WHERE ID = 484
SELECT * FROM filters_products WHERE prod_id = 484 AND cat_id = '1' and valor_id='299'
UPDATE filters_products set cat_id="1",valor_id="299",prod_id="484",fam_id1="1",marca_id="1",filtros_rel2="1_299;" WHERE filtro_id = "37091"
UPDATE filters_products set cat_id="1",valor_id="299",prod_id="484",fam_id1="1",marca_id="1",filtros_rel2="1_299;" WHERE filtro_id = "37091"
SELECT * FROM products_objs_combo WHERE obj_type_id = 484 and obj_combo2=';1-299;'
UPDATE products_objs_combo SET obj_ativo=1, obj_pvp = "9.78", obj_pvp_kit = "" WHERE obj_id = 5592
UPDATE products_objs_combo SET obj_ativo=1, obj_pvp = "9.78", obj_pvp_kit = "" WHERE obj_id = 5592
4
>Cor:AZUL CLARO;;#BDDDFD
>Tamanho:2A
>Preco:9.78
>PesoLiquido:0
>PVP:0
UPDATE filters_values_lang set value_id_import_ref = '2A' WHERE values_id='167' AND values_lang='en'
UPDATE filters_values_lang set value_id_import_ref = '2A' WHERE values_id='167' AND values_lang='es'
UPDATE products set Tipo_medidas=1 WHERE ID = 484
SELECT * FROM filters_products WHERE prod_id = 484 AND cat_id = '1' and valor_id='167'
UPDATE filters_products set cat_id="1",valor_id="167",prod_id="484",fam_id1="1",marca_id="1",filtros_rel2="1_167;" WHERE filtro_id = "37092"
UPDATE filters_products set cat_id="1",valor_id="167",prod_id="484",fam_id1="1",marca_id="1",filtros_rel2="1_167;" WHERE filtro_id = "37092"
SELECT * FROM products_objs_combo WHERE obj_type_id = 484 and obj_combo2=';1-167;'
UPDATE products_objs_combo SET obj_ativo=1, obj_pvp = "9.78", obj_pvp_kit = "" WHERE obj_id = 5593
UPDATE products_objs_combo SET obj_ativo=1, obj_pvp = "9.78", obj_pvp_kit = "" WHERE obj_id = 5593
5
>Cor:AZUL CLARO;;#BDDDFD
>Tamanho:3A
>Preco:9.78
>PesoLiquido:0
>PVP:0
UPDATE filters_values_lang set value_id_import_ref = '3A' WHERE values_id='143' AND values_lang='en'
UPDATE filters_values_lang set value_id_import_ref = '3A' WHERE values_id='143' AND values_lang='es'
UPDATE products set Tipo_medidas=1 WHERE ID = 484
SELECT * FROM filters_products WHERE prod_id = 484 AND cat_id = '1' and valor_id='143'
UPDATE filters_products set cat_id="1",valor_id="143",prod_id="484",fam_id1="1",marca_id="1",filtros_rel2="1_143;" WHERE filtro_id = "37093"
UPDATE filters_products set cat_id="1",valor_id="143",prod_id="484",fam_id1="1",marca_id="1",filtros_rel2="1_143;" WHERE filtro_id = "37093"
SELECT * FROM products_objs_combo WHERE obj_type_id = 484 and obj_combo2=';1-143;'
UPDATE products_objs_combo SET obj_ativo=1, obj_pvp = "9.78", obj_pvp_kit = "" WHERE obj_id = 5594
UPDATE products_objs_combo SET obj_ativo=1, obj_pvp = "9.78", obj_pvp_kit = "" WHERE obj_id = 5594
6
>Cor:AZUL CLARO;;#BDDDFD
>Tamanho:ESP
>Preco:9.78
>PesoLiquido:0
>PVP:0
UPDATE filters_values_lang set value_id_import_ref = 'ESP' WHERE values_id='93' AND values_lang='en'
UPDATE filters_values_lang set value_id_import_ref = 'ESP' WHERE values_id='93' AND values_lang='es'
SELECT * FROM filters_products WHERE prod_id = 484 AND cat_id = '1' and valor_id='93'
UPDATE filters_products set cat_id="1",valor_id="93",prod_id="484",fam_id1="1",marca_id="1",filtros_rel2="1_93;" WHERE filtro_id = "37094"
UPDATE filters_products set cat_id="1",valor_id="93",prod_id="484",fam_id1="1",marca_id="1",filtros_rel2="1_93;" WHERE filtro_id = "37094"
SELECT * FROM products_objs_combo WHERE obj_type_id = 484 and obj_combo2=';1-93;'
UPDATE products_objs_combo SET obj_ativo=1, obj_pvp = "9.78", obj_pvp_kit = "" WHERE obj_id = 5595
UPDATE products_objs_combo SET obj_ativo=1, obj_pvp = "9.78", obj_pvp_kit = "" WHERE obj_id = 5595
Padroes:
>Padrao:Array
Gramagem=180
UPDATE filters_values_lang set value_id_import_ref = '180' WHERE values_id='122' AND values_lang='en'
UPDATE filters_values_lang set value_id_import_ref = '180' WHERE values_id='122' AND values_lang='es'
UPDATE filters_products set
fam_id1 = "1"
,marca_id="1"
,filtro_active="1"
,filtro_area="3"
,filtros_rel2="6_122;"
WHERE filtro_id = "37095"
RefCli=MOD. 101.1 COM MOLAS
UPDATE products SET Ref_secundaria = "MOD. 101.1 COM MOLAS" where ID=484
Composicao=100% CO
UPDATE filters_values_lang set value_id_import_ref = '100% CO' WHERE values_id='113' AND values_lang='en'
UPDATE filters_values_lang set value_id_import_ref = '100% CO' WHERE values_id='113' AND values_lang='es'
UPDATE filters_products set
fam_id1 = "1"
,marca_id="1"
,filtro_active="1"
,filtro_area="3"
,filtros_rel2="2_113;"
WHERE filtro_id = "37096"
UPDATE products SET Carrinho='1',ID_Marca='264' WHERE ID = '484'
484