Rosaspina Posted March 6, 2013 Share Posted March 6, 2013 Ciao a tutti, qualcuno sa dirmi come faccio ad esportare le schede prodotto, in un unico file ex-cell ? Grazie Link to comment Share on other sites More sharing options...
eddiehunter Posted March 27, 2013 Share Posted March 27, 2013 1.Effettua l'accesso in phpmyadmin e seleziona (qualora avessi piu' database) quello relativo al negozio. 2.Esegui questa query cliccando su sql: SELECT p.id_product AS 'ID', p.active AS 'Active (0/1)', pl.name AS 'Name', p.id_category_default AS 'Default Category', p.price AS 'Price tax excl.', p.id_tax_rules_group AS 'Tax rules ID', p.wholesale_price AS 'Wholesale price', p.on_sale AS 'On sale (0/1)', p.reference AS 'Reference #', p.supplier_reference AS 'Supplier reference #', sl.description AS 'Supplier', ml.description AS 'Manufacturer', p.ean13 AS 'EAN13', p.upc AS 'UPC', p.ecotax AS 'Ecotax', p.weight AS 'Weight', p.quantity AS 'Quantity', pl.description_short AS 'Short description', pl.description AS 'Description', pl.meta_title AS 'Meta-title', pl.meta_keywords AS 'Meta-keywords', pl.meta_description AS 'Meta-description', pl.link_rewrite AS 'URL rewritten', pl.available_now AS 'Text when in stock', pl.available_later AS 'Text when backorder allowed', p.available_for_order AS 'Available for order', p.date_add AS 'Product creation date', p.show_price AS 'Show price', p.online_only AS 'Available online only', p.condition AS 'Condition' FROM ps_product p INNER JOIN ps_product_lang pl ON p.id_product = pl.id_product LEFT JOIN ps_supplier_lang sl ON p.id_supplier = sl.id_supplier LEFT JOIN ps_manufacturer_lang ml ON p.id_manufacturer = ml.id_manufacturer A me ha funzionato. NB.: Se hai un server o servizio di hosting con timeout basso suddividi in varie tranche l'esportazione. Ti ricordo che devi esportare il file utilizzando l'opzione "Personalizzato" e output "File" MS Excel Spero di essermi spiegato Link to comment Share on other sites More sharing options...
DeCBiT Posted March 27, 2013 Share Posted March 27, 2013 Oppure si fa il download di "PrestaShop Store Export" http://www.presta-shop-modules.com/prestashop-14-modules/25-prestashop-store-shop-export.html si esportano i prodotti in CSV e poi si caricano e si manipolano in excel. ----------------- Se ti è servita la risposta clicca su "Like This" DeCBiT http://www.decbit.it - hosting performante, veloce ed affidabile per Prestashop Link to comment Share on other sites More sharing options...
danigy Posted February 7, 2015 Share Posted February 7, 2015 E se nelle schede prodotto ci sono anche le foto? Link to comment Share on other sites More sharing options...
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