Jump to content

antonio04

Members
  • Posts

    44
  • Joined

  • Last visited

Profile Information

  • Location
    Citta di castello
  • Activity
    User/Merchant

antonio04's Achievements

Newbie

Newbie (1/14)

2

Reputation

  1. 1.7.3 , nei prossimi giorni vorrei contattarti personalmente per un problema che devo risolvere vorrei chiederti un preventivo. Al momento ho risolto cosi , ho solo il problema che mi duplica gli articoli ma risolto tramite Excel SELECT p.reference AS 'id', l.name AS 'title', l.description AS 'description', CASE WHEN p.active = '1' THEN 'in stock' ELSE 'out of stock' END AS 'availability ', CASE WHEN p.active = '1' THEN 'new' -------------------------------> questo lo uso per crreae una colonna dove c' e' sempre il valore "new" ELSE 'new' END AS 'condition ', non ho trovato altro modo per aggiungere una colonna che nel database non c' e' FORMAT(p.price,2) AS 'price', CONCAT('https://www.fiorucciricambi.it/',cl.link_rewrite , '/',l.link_rewrite) AS 'link', concat( 'https://www.fiorucciservice.it/img/p/',mid(im.id_image,1,1),'/', if (length(im.id_image)>1,concat(mid(im.id_image,2,1),'/'),''),if (length(im.id_image)>2,concat(mid(im.id_image,3,1),'/'),''),if (length(im.id_image)>3,concat(mid(im.id_image,4,1),'/'),''),if (length(im.id_image)>4,concat(mid(im.id_image,5,1),'/'),''), im.id_image, '.jpg' ) AS 'image_link', pm.name AS 'brand' FROM ps_product AS p inner JOIN ps_product_lang AS l ON p.id_product = l.id_product LEFT JOIN ps_image im ON p.id_product = im.id_product LEFT JOIN ps_product_lang pl ON(p.id_product = pl.id_product) LEFT JOIN ps_category_product cp ON(p.id_product = cp.id_product) LEFT JOIN ps_category_lang cl ON(cp.id_category = cl.id_category) LEFT JOIN ps_manufacturer pm ON(p.id_manufacturer = pm.id_manufacturer) WHERE l.id_lang = 1 AND p.id_category_default IN (97199,64);
  2. Invece che eseguire la Query da BO, la stessa query andrebbe eseguita lanciando una pagina PHP tramite un link esempio www.fiorucciricambi.it/esporta_dati.php Sei gia stato molto gentile non voglio farti perdere troppo tempo Per ora ho ripolto quasi tutto trami query e va bene anche cosi
  3. Ok grazie, sono quasi riuscito a fare tutto Per quanto riguarda il php sarebbe la soluzione perfetta perche potrei lanciare lo script tramite cron Purtroppo non sono un programmatore e di solito risolvo con tentativi o consigli che ricevo dal forum Sai se esiste qualche esempio di script php con il quale interrogare il database di prestashop?
  4. Ok modificando la prima parte adesso ho tutto cio che mi serve Devo risolvere il problema dei prezzi che vengono esportati con molti zeri SELECT p.reference AS 'Reference #', l.name, l.description AS 'Descrizione ', p.price AS 'Prezzo', CONCAT('https://www.fiorucciricambi.it/',cl.link_rewrite , '/',l.link_rewrite), concat( 'https://www.fiorucciservice.it/img/p/',mid(im.id_image,1,1),'/', if (length(im.id_image)>1,concat(mid(im.id_image,2,1),'/'),''),if (length(im.id_image)>2,concat(mid(im.id_image,3,1),'/'),''),if (length(im.id_image)>3,concat(mid(im.id_image,4,1),'/'),''),if (length(im.id_image)>4,concat(mid(im.id_image,5,1),'/'),''), im.id_image, '.jpg' ) AS url_image, p.active AS 'Active (0/1)'
  5. Ho risolto cosi , magari a qualcuno puo essere utile In partica riesco ad avere il link rewrite al prodotto e il link rewrite alla categoria Esiste un modo da SQL di concatenare il mio indirizzo principale www.fiorucciricamabi.it/rewrite_categoria/rewrite_prodotto Altro problema mi trovo con i prezzi esportati in questo formato 15.000000 invece di 15,00 sapete se posso risolvere? Grazie SELECT p.reference AS 'Reference #', l.name, l.description AS 'Descrizione ', p.price AS 'Prezzo', concat( 'https://www.fiorucciservice.it/img/p/',mid(im.id_image,1,1),'/', if (length(im.id_image)>1,concat(mid(im.id_image,2,1),'/'),''),if (length(im.id_image)>2,concat(mid(im.id_image,3,1),'/'),''),if (length(im.id_image)>3,concat(mid(im.id_image,4,1),'/'),''),if (length(im.id_image)>4,concat(mid(im.id_image,5,1),'/'),''), im.id_image, '.jpg' ) AS url_image, cl.link_rewrite AS 'Catogorie', l.link_rewrite AS 'link', p.id_category_default AS 'Categoria', p.active AS 'Active (0/1)' FROM ps_product AS p inner JOIN ps_product_lang AS l ON p.id_product = l.id_product LEFT JOIN ps_image im ON p.id_product = im.id_product LEFT JOIN ps_product_lang pl ON(p.id_product = pl.id_product) LEFT JOIN ps_category_product cp ON(p.id_product = cp.id_product) LEFT JOIN ps_category_lang cl ON(cp.id_category = cl.id_category) WHERE p.id_category_default = 97;
  6. Ho fatto qualche prova , ma credo manchi il link rewrite alle categorie che e' quello che mi serve per ricostruire il link completo al prodotto
  7. Buongiorno , ho trovato il modo di importare gli articoli del mio sito sulla vetrina di Facebook I dati obbligatori che chiede FB sono id | title | description | availability | condition | price | link (al prodotto sul sito) | image_link | brand Riesco ad esportare tutto tranne il link al prodotto sul sito uso il codice riportato sotto per esportare una categoria Come posso aggiungere una istruzione per esportare anche il link completo al prodotto o in alternativa il link rewrite della categoria? SELECT p.reference AS 'Reference #', l.name, l.description AS 'Descrizione ', p.price AS 'Prezzo', concat( 'https://www.fiorucciservice.it/img/p/',mid(im.id_image,1,1),'/', if (length(im.id_image)>1,concat(mid(im.id_image,2,1),'/'),''),if (length(im.id_image)>2,concat(mid(im.id_image,3,1),'/'),''),if (length(im.id_image)>3,concat(mid(im.id_image,4,1),'/'),''),if (length(im.id_image)>4,concat(mid(im.id_image,5,1),'/'),''), im.id_image, '.jpg' ) AS url_image, l.link_rewrite AS 'link', p.id_category_default AS 'Categoria', p.active AS 'Active (0/1)' FROM ps_product AS p inner JOIN ps_product_lang AS l ON p.id_product = l.id_product LEFT JOIN ps_image im ON p.id_product = im.id_product WHERE p.id_category_default = 97; Faccio presente che uso questo codice per esportare le info sulle categorie( a me servirebbe solo il link rewrite) ma non so come integrare in una unica istruzione SQL SELECT a.`id_category`, `active`, `name`, `link_rewrite`, a.`id_parent`, a.`is_root_category`, `description`, `meta_title`, `meta_description`, a.`id_shop_default` FROM `ps_category` a LEFT JOIN `ps_category_lang` b ON (b.`id_category` = a.`id_category` AND b.`id_lang` = 1 AND b.`id_shop` = 1) LEFT JOIN `ps_category_shop` sa ON (a.`id_category` = sa.`id_category` AND sa.id_shop = 1) WHERE 1 ORDER BY a.`id_category` ASC Ringrazio chi potra darmi qualche info
  8. I need to export the links to my products via sql. I use this query: SELECT `name` , `link_rewrite` , `id_product` FROM `ps_product_lang` ; This only exports the rewrite link of the article. I would like to export also the rewrite of the category, can someone help me? Grazie
  9. Thanks, it works great, you're really very kind
  10. Still a help. The modification works but only on the main page. In the product page the search form is different and I do not know in the file you find.
  11. Thanks thanks thanks..... I lost a lot of time without having found a solution. Now it works, you are very kind. Now I try to modify the form also on the admin / product page With your directions maybe I can, thanks again
  12. You're very kind, I'm not an expert This is the code I would like to make the search by default in the catalog Can I get what I have to change? <ul id="header_search_options" class="dropdown-menu"> <li class="search-all search-option active"> <a href="#" data-value="0" data-placeholder="{l s='What are you looking for?' d='Admin.Navigation.Header'}" data-icon="icon-search"> <i class="icon-search"></i> {l s='Everywhere' d='Admin.Navigation.Header'}</a> </li> <li class="divider"></li> <li class="search-book search-option"> <a href="#" data-value="1" data-placeholder="{l s='Product name, SKU, reference...' d='Admin.Navigation.Header'}" data-icon="icon-book"> <i class="icon-book"></i> {l s='Catalog' d='Admin.Navigation.Menu'} </a> </li> <li class="search-customers-name search-option"> <a href="#" data-value="2" data-placeholder="{l s='Email, name...' d='Admin.Navigation.Header'}" data-icon="icon-group"> <i class="icon-group"></i> {l s='Customers by name' d='Admin.Navigation.Header'} </a> </li> <li class="search-customers-addresses search-option"> <a href="#" data-value="6" data-placeholder="{l s='123.45.67.89'}" data-icon="icon-desktop"> <i class="icon-desktop"></i> {l s='Customers by IP address' d='Admin.Navigation.Header'}</a> </li> <li class="search-orders search-option"> <a href="#" data-value="3" data-placeholder="{l s='Order ID' d='Admin.Navigation.Header'}" data-icon="icon-credit-card"> <i class="icon-credit-card"></i> {l s='Orders' d='Admin.Global'} </a> </li> <li class="search-invoices search-option"> <a href="#" data-value="4" data-placeholder="{l s='Invoice Number' d='Admin.Navigation.Header'}" data-icon="icon-book"> <i class="icon-book"></i> {l s='Invoices' d='Admin.Navigation.Menu'} </a> </li> <li class="search-carts search-option"> <a href="#" data-value="5" data-placeholder="{l s='Cart ID' d='Admin.Navigation.Header'}" data-icon="icon-shopping-cart"> <i class="icon-shopping-cart"></i> {l s='Carts' d='Admin.Global'} </a> </li> <li class="search-modules search-option"> <a href="#" data-value="7" data-placeholder="{l s='Module name' d='Admin.Navigation.Header'}" data-icon="icon-puzzle-piece"> <i class="icon-puzzle-piece"></i> {l s='Modules' d='Admin.Global'} </a> </li> </ul>
  13. Good morning, I need help with prestashop 1.7.3 I need to change the settings in the admin search box I would like to make sure that the default setting is set to catalog and not to general search Can you tell me which file I need to edit? Grazie
×
×
  • Create New...