Jump to content

Frage zum Export


Dobi78

Recommended Posts

Hallo Zusammen,

 

Ich bin auf der Suche nach einer Möglichkeit, den gesamten Katalog in (beispielsweise) CSV zu exportieren!

Es sollte alles exportiert werden: Bilder Beschreibungen etc. etc.

Den Store Manager kenne ich schon, der ist mir zu teuer für eine einmalige Nutzung. Bei den vielen Modulen, die angeboten werden, hab ich die Übersicht verloren, und möchte auch nicht das falsche erwerben....vielleicht hat ja Jemand eine Idee ;)

 

Danke

Link to comment
Share on other sites

SQL Abfrage ;)

SELECT DISTINCT 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 #',
psa.reference AS 'Reference Variant #',
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_product_attribute psa ON p.id_product = psa.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
WHERE pl.id_lang = 4

 

pl.id_lang = 4 gibt die sprache an

 

1 ist eng sowit ich es grad im kopf hab sonst mal in der ps_lang nachschauen.

 

Kannst auf deien Bedürfnisse noch anpassen

Edited by BluTiGeS (see edit history)
Link to comment
Share on other sites

  • 2 weeks later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...