Liquid, JavaScript, Themes
Hallo Community,
wir befinden uns im Aufbau eines Onlineshops für viele verschiedene Bioprodukte, ca. 5.000 Produkte. Die einzelnen Produkte möchten wir über die App "Exelify" via Excel-Import importieren, was soweit auch funktionieren sollte. Mit dieser Methode bekommen via lediglich via "Body Html" die Produktbeschreibung hinterlegt, leider keine zusätzlichen Tabs mit Informationen wie Inhaltsstoffe oder Anwendung.
Problem:
Für jedes einzelne Produkt möchten wir diverse Angaben wie z.B Inhaltsstoffe, Anwendung etc. in einzelne Tabs hinterlegen. Wir haben viele verschiedene Apps gefunden mit denen dies grundsätzlich möglich ist. Das Problem ist, dass wir mit dieser Methode jedes Produkt händisch ändern müssten und in "Body Html" die Überschriften definieren müssten, was bei einer so großen Anzahl nicht effizient wäre.
Gibt es eine Möglichkeit (idealerweise ohne Programmieren o.Ä. bzw. mit einer App) die Tabs via Excel-Import zu füllen/ zu hinterlegen?
Alle relevanten Informationen befinden sich in einer Exelliste.
Vielen Dank im Voraus.
Beste Grüße
Alex
Gelöst! Zur Lösung
Erfolg.
Hallo Alex,
Excelify (ich hab damit noch nicht gearbeitet) kann auch Metafields schreiben. (https://excelify.io/tutorials/import-export-and-update-shopify-shop-metafields-in-bulk/)
Das würd ich mir hier zu Nutze machen und die Daten in ebensolche speichern. Die Darstellung ist dann wahrscheinlich noch ein wenig Fingerarbeit, aber keine Hexerei. Für Genauere auskunft müsste ich etwas mehr über die Gegebenheiten, insbesondere die Datenstruktur wissen.
Ich hoffe, dass das hilft,
Mario
Erfolg.
Hello @AlexBerlin
Renars here from Excelify.
Sorry about replying in English here.
With Excelify, you can import description same as you can see it in the Shopify Admin. In Admin you also have only 1 description so you can import 1 Body HMTL field with Excelify.
As @r8r mentioned, you can import Metafields with Excelify.
Metafields are custom fields in Shopify where such data is normally stored. In your case there would usually be 2 approaches:
1 - Import your own custom Metafields and develop your store's theme to display those Metafields in your store.
Here we do have a great tutorial on how to bulk manage Metafields. This tutorial will also explain how to construct Metafield columns so you can add them to your import file.
In this scenario, you would need to edit your store's Product Pages theme to display the Metafields for your Products.
Basics of displaying Metafields is also mentioned in the same tutorial, but adding tabs would be a bit more complex scenario. but still should be doable with a bit of learning about Shopify theme liquid code.
2 - You can look into using an app that does this for you. There are many apps out there that offer this functionality to add tabs to your products page.
Most of the apps would still use Metafields to store the data that is displayed, so you should still be able to import data into those Metafields and it should be displayed.
But you would need to first confirm that with the app that you are about to use.
If the app uses specific Metafields to store this data, then a great way to see what exact Metafields are used for this is to set up one product to display tabs with data as you need. Then create export with Excelify and select to export Products and Basic Columns and Metafields under Products. You can click on the "Filters" button under products to export only specific product/s.
In the exported file you can see in what Metafields this data is stored for this Product, so you can then use the same Metafileds in your import file to set it for other Products.
But with this scenario, please first find an app that you would wish to use and confirm with the app support, that data for those tabs is indeed stored in Metafields or other fields that are accessible for other apps such as Excelify.
I hope this information gives an insight into how this would usually work, if you have any more Excelify specific questions, feel free to contact us directly.
Erfolg.
Hallo Alex,
Excelify (ich hab damit noch nicht gearbeitet) kann auch Metafields schreiben. (https://excelify.io/tutorials/import-export-and-update-shopify-shop-metafields-in-bulk/)
Das würd ich mir hier zu Nutze machen und die Daten in ebensolche speichern. Die Darstellung ist dann wahrscheinlich noch ein wenig Fingerarbeit, aber keine Hexerei. Für Genauere auskunft müsste ich etwas mehr über die Gegebenheiten, insbesondere die Datenstruktur wissen.
Ich hoffe, dass das hilft,
Mario
Erfolg.
Hello @AlexBerlin
Renars here from Excelify.
Sorry about replying in English here.
With Excelify, you can import description same as you can see it in the Shopify Admin. In Admin you also have only 1 description so you can import 1 Body HMTL field with Excelify.
As @r8r mentioned, you can import Metafields with Excelify.
Metafields are custom fields in Shopify where such data is normally stored. In your case there would usually be 2 approaches:
1 - Import your own custom Metafields and develop your store's theme to display those Metafields in your store.
Here we do have a great tutorial on how to bulk manage Metafields. This tutorial will also explain how to construct Metafield columns so you can add them to your import file.
In this scenario, you would need to edit your store's Product Pages theme to display the Metafields for your Products.
Basics of displaying Metafields is also mentioned in the same tutorial, but adding tabs would be a bit more complex scenario. but still should be doable with a bit of learning about Shopify theme liquid code.
2 - You can look into using an app that does this for you. There are many apps out there that offer this functionality to add tabs to your products page.
Most of the apps would still use Metafields to store the data that is displayed, so you should still be able to import data into those Metafields and it should be displayed.
But you would need to first confirm that with the app that you are about to use.
If the app uses specific Metafields to store this data, then a great way to see what exact Metafields are used for this is to set up one product to display tabs with data as you need. Then create export with Excelify and select to export Products and Basic Columns and Metafields under Products. You can click on the "Filters" button under products to export only specific product/s.
In the exported file you can see in what Metafields this data is stored for this Product, so you can then use the same Metafileds in your import file to set it for other Products.
But with this scenario, please first find an app that you would wish to use and confirm with the app support, that data for those tabs is indeed stored in Metafields or other fields that are accessible for other apps such as Excelify.
I hope this information gives an insight into how this would usually work, if you have any more Excelify specific questions, feel free to contact us directly.
In this scenario, you would need to edit your store's Product Pages theme to display the Metafields for your Products.
Solltest Du damit Hilfe benötigen, lass es mich gerne wissen.
LG, Mario
Hi Mario@r8r and Renars @Renars,
I thank you both very much for your fast and helpful answers and your willingness to support me, I appreciate it very much!
I will try to implement your advice and hope to have success.
@r8r Mario, ich werde erstmal versuchen den Weg über eine App zu gehen. Leider verfüge ich über keinerlei Programmierkenntnisse o.Ä. und habe keine Ahnung was Metafields sind und wie diese überhaupt funktionieren. Ich werde versuchen es mir anzulesen und danach mein Bestes probieren. Kann ich dich ggf. um Unterstützung beten?
Hi @AlexBerlin
hier ist das Metafields-Konzept kurz erklärt: https://www.shopify.com/partners/blog/110057030-using-metafields-in-your-shopify-theme
Und klar - du kannst Dich melden, wenn Du Input benötigst.
Liebe Grüße und viel Erfolg!
Mario
Mit dem Lernpfad der Shopify Academy und dem Verified Skills-Badge Expanding Your Sho...
By Shopify Feb 7, 2025Den Verkauf im Großhandel steigern: In der Shopify Academy lernst du, wie das geht, zum...
By Shopify Feb 3, 2025Teil 2 - Wie die Prinzipien des UX-Designs dir dabei helfen können einen großartigen Shop ...
By Kai Sep 16, 2024