Excel Import / CSV Import

24.02.2014 22:10
#1
Skrobicd
Joomshopping forum user no avatar
Name: Danny
24.02.2014
Posts: 4
Quote
Excel Import / CSV Import

Hallo,
ich möchte eine Excel Datei mit Produkten importieren. Folgende Felder sind vorhanden:
Titel, Beschreibung, Artikelnummer, Preis

TypischEcel...Zeile A1-A4 enthält die Überschriften und in den Folgezeilen stehen die Produktdaten.

Wie kann ich dasdenn nun so umbauen, dass ich es in Joomshopping importiert bekomme?


Joomla: 3.2
 
24.02.2014 22:16
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16508
Quote
Aw: Excel Import / CSV Import

Save file as csv.

addon import / export name?

 
24.02.2014 23:24
#3
Skrobicd
Joomshopping forum user no avatar
Name: Danny
24.02.2014
Posts: 4
Quote
Aw: Excel Import / CSV Import

what do you mean with addon import / export name? I don´t have any addon installed. Just Joomshopping 4.4.1. Thought I could import the products using this compnonent.

Ok, I can import Article Name (Titel), Price and description with the simple import. But I cant Import "Artkelnummer" the Article Number. This field is missing in simple Import/Export. Any ideas?


Letzte Änderung: 25.02.2014 00:15
 
25.02.2014 07:41
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16508
Quote
Aw: Excel Import / CSV Import

See
http://www.webdesigner-profi.de/joomla-webdesign/shop/import-export/universal-csv-import.html?lang=en

 
25.02.2014 19:08
#5
Skrobicd
Joomshopping forum user no avatar
Name: Danny
24.02.2014
Posts: 4
Quote
Aw: Excel Import / CSV Import

Thanks but where do I see the Article Number (Artiklenummer)? It´s not mentioned in the lsit:

Field:
id, ean, quantity, add_date, modify_date, published, tax_name, tax_value, url, old_price, purchase_price, price, currency, weight, average_rating, reviews_count, hits, unit_of_measurement_count, price_per_unit_of_measurement, label, images, videos,sale_files,demo_files,manufacturer,delivery_time, units_of_measurement, name, alias, short_description, description, meta_title, meta_description, meta_keyword, categories,product_template
related_produts,vendor,price_per_consignment,price_for_group,freeattributes,characteristics,attributes,shippings


 
25.02.2014 20:45
#6
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16508
Quote
Aw: Excel Import / CSV Import

Field ean

 
25.02.2014 21:34
#7
Skrobicd
Joomshopping forum user no avatar
Name: Danny
24.02.2014
Posts: 4
Quote
Aw: Excel Import / CSV Import

ah ok....

 
Copyrights MAXXmarketing GmbH. All Rights Reserved