Hi!
Sorry, dass ich mich jetzt erst melde - hab wohl vergessen die Mailbenachrichtigung zu aktivieren
Hier mal ein Beispielartikel zum Vergleich. Den Artikel heißt SED220, es gibt ihn in 4 Farben (BR, BW, WBP und WR) sowie in Größe 5 - 14. Den Lagerbestand gibt es in drei Varianten "yes", "low", "no". Die UPC-Nummer verwende ich nicht.
So sieht der Artikel in der Lagerbestand.csv aus:
"Artikelnummer","Grösse","Lagerbestand","UPC-Nummer"
"SED220/BR ","5 ","YES ","885487233499 "
"SED220/BR ","6 ","YES ","885487233505 "
"SED220/BR ","7 ","YES ","885487233512 "
"SED220/BR ","8 ","LOW ","885487233529 "
"SED220/BR ","9 ","YES ","885487233536 "
"SED220/BR ","10 ","YES ","885487233543 "
"SED220/BR ","11 ","YES ","885487233550 "
"SED220/BR ","12 ","LOW ","885487233567 "
"SED220/BR ","13 ","LOW ","885487233574 "
"SED220/BR ","14 ","NO ","885487233581 "
"SED220/BW ","5 ","NO ","885487233598 "
"SED220/BW ","6 ","YES ","885487233604 "
"SED220/BW ","7 ","YES ","885487233611 "
"SED220/BW ","8 ","YES ","885487233628 "
"SED220/BW ","9 ","YES ","885487233635 "
"SED220/BW ","10 ","LOW ","885487233642 "
"SED220/BW ","11 ","LOW ","885487233659 "
"SED220/BW ","12 ","LOW ","885487233666 "
"SED220/BW ","13 ","LOW ","885487233673 "
"SED220/BW ","14 ","LOW ","885487233680 "
"SED220/WBP ","5 ","YES "," "
"SED220/WBP ","6 ","YES "," "
"SED220/WBP ","7 ","YES "," "
"SED220/WBP ","8 ","YES "," "
"SED220/WBP ","9 ","YES "," "
"SED220/WBP ","10 ","YES "," "
"SED220/WBP ","11 ","YES "," "
"SED220/WBP ","12 ","LOW "," "
"SED220/WBP ","13 ","NO "," "
"SED220/WBP ","14 ","NO "," "
"SED220/WR ","5 ","NO ","885487233697 "
"SED220/WR ","6 ","YES ","885487233703 "
"SED220/WR ","7 ","YES ","885487233710 "
"SED220/WR ","8 ","LOW ","885487233727 "
"SED220/WR ","9 ","YES ","885487233734 "
"SED220/WR ","10 ","YES ","885487233741 "
"SED220/WR ","11 ","YES ","885487233758 "
"SED220/WR ","12 ","YES ","885487233765 "
"SED220/WR ","13 ","LOW ","885487233772 "
"SED220/WR ","14 ","NO ","885487233789 "
Und so gibt XTC die Artikel aus:
XTSOL" p_model p_stock p_sorting p_shipping p_tpl p_manufacturer p_fsk18 p_priceNoTax p_priceNoTax.1 p_priceNoTax.2 p_priceNoTax.3 p_tax p_status p_weight p_ean p_disc p_opttpl p_vpe p_vpe_status p_vpe_value p_image.1 p_image.2 p_image.3 p_image.4 p_image.5 p_image.6 p_image.7 p_image.8 p_image p_name.en p_desc.en p_shortdesc.en p_meta_title.en p_meta_desc.en p_meta_key.en p_keywords.en p_url.en p_name.de p_desc.de p_shortdesc.de p_meta_title.de p_meta_desc.de p_meta_key.de p_keywords.de p_url.de p_cat.0 p_cat.1 p_cat.2 p_cat.3 p_cat.4 p_cat.5
"XTSOL" "PL-SEDUCE-220" "-1" "0" "3" "product_info_v1.html" "Pleaser" "0" "32.7731" "1:32.7731" "1:32.7731" "1:30.0000::12:27.0000" "1" "1" "0.00" "" "0.00" "product_options_dropdown.html" "0" "0" "0.0000" "212_1.jpg" "" "" "" "" "" "" "" "212_0.jpg" "Seduce-220 Patent two-tone pumps laces Size 35-46 black/white" "Seduce-220 Patent peep toe pump with instep cutout at inner side, eyelet and lce detail on captoe and heel, from Pleaser. 5 inch heel (approx. 12 cm). Available in sizes US 5 - 14 (35 - 46). Colour: black/white." "" "" "" "" "" "" "Seduce-220 zweifarbige Pumps Schnürung Gr. 35-46 schwarz/weis" "Seduce 220 Peep-Toe Pumps mit kontrastierender Schnür-Optik von Pleaser. Absatzhöhe 5 inch (entspricht ca. 12 cm). Erhältlich in den Größen US 5 - 14 (entspricht 35 - 46). Farbe: schwarz/weiss." "" "" "" "" "" "" "" "" "" "" "" "" ""
"XTSOL" "PL-SEDUCE-220" "0" "0" "3" "product_info_v1.html" "Pleaser" "0" "32.7731" "1:32.7731" "1:32.7731" "1:30.0000::12:27.0000" "1" "1" "0.00" "" "0.00" "product_options_dropdown.html" "0" "0" "0.0000" "213_1.jpg" "" "" "" "" "" "" "" "213_0.jpg" "Seduce-220 Patent two-tone pumps laces Size 35-46 white/babypink" "Seduce-220 Patent peep toe pump with instep cutout at inner side, eyelet and lce detail on captoe and heel, from Pleaser. 5 inch heel (approx. 12 cm). Available in sizes US 5 - 14 (35 - 46). Colour: white/babypink." "" "" "" "" "" "" "Seduce-220 zweifarbige Pumps Schnürung Gr. 35-46 weiss/rosa" "Seduce 220 Peep-Toe Pumps mit kontrastierender Schnür-Optik von Pleaser. Absatzhöhe 5 inch (entspricht ca. 12 cm). Erhältlich in den Größen US 5 - 14 (entspricht 35 - 46). Farbe: weiss/rosa." "" "" "" "" "" "" "" "" "" "" "" "" ""
"XTSOL" "PL-SEDUCE-220" "-1" "0" "3" "product_info_v1.html" "Pleaser" "0" "32.7731" "1:32.7731" "1:32.7731" "1:30.0000::12:27.0000" "1" "1" "0.00" "" "0.00" "product_options_dropdown.html" "0" "0" "0.0000" "214_1.jpg" "" "" "" "" "" "" "" "214_0.jpg" "Seduce-220 Patent two-tone pumps laces Size 35-46 black/red" "Seduce-220 Patent peep toe pump with instep cutout at inner side, eyelet and lce detail on captoe and heel, from Pleaser. 5 inch heel (approx. 12 cm). Available in sizes US 5 - 14 (35 - 46). Colour: black/red." "" "" "" "" "" "" "Seduce-220 zweifarbige Pumps Schnürung Gr. 35-46 schwarz/rot" "Seduce 220 Peep-Toe Pumps mit kontrastierender Schnür-Optik von Pleaser. Absatzhöhe 5 inch (entspricht ca. 12 cm). Erhältlich in den Größen US 5 - 14 (entspricht 35 - 46). Farbe: schwarz/rot." "" "" "" "" "" "" "" "" "" "" "" "" ""
"XTSOL" "PL-SEDUCE-220" "0" "0" "3" "product_info_v1.html" "Pleaser" "0" "32.7731" "1:32.7731" "1:32.7731" "1:30.0000::12:27.0000" "1" "1" "0.00" "" "0.00" "product_options_dropdown.html" "0" "0" "0.0000" "215_1.jpg" "" "" "" "" "" "" "" "215_0.jpg" "Seduce-220 Patent two-tone pumps laces Size 35-46 white/red" "Seduce-220 Patent peep toe pump with instep cutout at inner side, eyelet and lce detail on captoe and heel, from Pleaser. 5 inch heel (approx. 12 cm). Available in sizes US 5 - 14 (35 - 46). Colour: white/red." "" "" "" "" "" "" "Seduce-220 zweifarbige Pumps Schnürung Gr. 35-46 weiss/rot" "Seduce 220 Peep-Toe Pumps mit kontrastierender Schnür-Optik von Pleaser. Absatzhöhe 5 inch (entspricht ca. 12 cm). Erhältlich in den Größen US 5 - 14 (entspricht 35 - 46). Farbe: weiss/rot."
Ich habe leider keinen Plan von Programmierung, deshalb weiß ich nicht, worauf ich da achten muss. Also ich habe für jede Farbe desselben Schuhmodells einen eigenen Artikel angelegt, wobei die Artikelnummer unabhängig von der Farbe dieselbe ist (das müsst ich dann wohl manuell noch ändern).
Im Moment heißt der Artikel in der Lagerbestands.csv also "SED220/WBP" (wobei WBP ein Farbcode ist) und bei mir "PL-SEDUCE-220" ohne Farbcode. Es sind zwar über 4000 Artikel, das liese sich aber durchaus mit Farbcode etc. noch genau auf die Bezeichung in der Lagerbestands.csv abstimmen (also daran solls nicht scheitern, sofern es sonst machbar wäre).
Ich würde gerne eine Tabelle einblenden in der alle Größen gelistet sind und daneben ein Farbsymbol für den Lagerbestand. Eine Verknüpfung der in der Lagerbestands.csv angegebenen Größen mit den bei mir als Attribute hinterlegten Größen ist nicht nötig, da auch bei Lagerbestand "NO" der Artikel bestellbar bleiben soll (will heißen ich brauch den Lagerbestand nur als Info für die Kunden und nicht um daran irgendwelche Funktionen zu knüpfen).
Wär das so machbar?
Viele Grüße,
Katja