Post by wladevlad » Sat Sep 19, 2015 11:05 pm

Salut. Am achizitionat de curand modulul Total Import Pro, cred ca este o alegere buna la cei 100 de dolari insa intampin o problema: Nu reusesc sa import un titlu de produs complet, adica Producator+Model+Cateva Atribute.
Inteleg ca probabil modulul nu face asa ceva insa puteti sa-mi recomandati inca un modul care m-ar ajuta la generarea automata a titlurilor pe baza de atribute si producator/model produs?

Apreciez un raspuns prompt. multumesc.

Newbie

Posts

Joined
Thu Dec 23, 2010 5:04 am

Post by opencartromania » Sat Sep 19, 2015 11:15 pm

Salutare!

De ce nu discutati cu cei care v-au dezvoltat modulul? ptr. ceva banuti in plus cred ca va pot face acest lucru.

Sunt multe module de import, majoritatea sunt proaste sau nu fac treaba complet.

Sau achizitionati modul separat de generare seo ptr. ce doriti dvs.

Succes!

User avatar
Active Member

Posts

Joined
Wed Sep 25, 2013 9:26 pm


Post by florinsith » Tue Sep 22, 2015 1:50 am

Pentru concatenare producator + model

Code: Select all

Update oc_product_description pd LEFT JOIN oc_product p on (p.product_id = pd.product_id) LEFT JOIN oc_manufacturer m on (m.manufacturer_id = p.manufacturer_id) set pd.name = CONCAT(m.name, " - ", p.model) WHERE p.model is not null and m.name is not null
Si pentru a mai adauga 3 atribute in nume

Code: Select all

Update oc_product_description as pd LEFT JOIN ( Select product_id, substring_index(GROUP_CONCAT(text SEPARATOR ' - '), ' - ', 3) as atribute FROM oc_product_attribute GROUP BY product_id ) as pa on (pd.product_id = pa.product_id) set pd.name = CONCAT(pd.name, " - ", pa.atribute) WHERE pa.atribute is not null
Deja Testat, atat ce nu-i multi-language, dar se poate adapta usor daca e cazul

Image
My Extensions - SuperTheme - Opencart templates - Opencart modules


User avatar
Expert Member

Posts

Joined
Fri May 14, 2010 2:36 am

Who is online

Users browsing this forum: No registered users and 3 guests