Jump to content
xt:Commerce Community Forum
Sign in to follow this  
andy5476

Eingabe Sonderangebote

Recommended Posts

Hallo,

wir haben sehr viele Artikel in unserem Shop die sich in der Artikelbezeichnung kaum oder garnicht unterscheiden. Bei der Dropdown-Auswahl des Artikels bei neuerstellen eines Sonderangebots bekomme ich nur Die Artikelbezeichnung und Preis angezeigt.

Weiss jemand was ich im Code ?ndern muss, dass ich anstatt der Artikelbezeichnung die Artikelnummer im Dropdownmen? zur Auswahl habe?!?

Danke

Andy

Share this post


Link to post
Share on other sites

Und wie siehts mit Lösungen aus??

Wäre eine feine Sache, wenn wenigstens einer eine Ausage treffen könnte ob das gelöst werden kann.

Gruß

Share this post


Link to post
Share on other sites

Hier eine Lösung (3.0.4. Sp.2.1):

admin/specials.php

==================


ca. Zeile 139 folgendes suchen:


 $product_query = xtc_db_query("select p.products_tax_class_id,

                                            p.products_id,

                                            pd.products_name,

                                            p.products_price,

                                            s.specials_quantity,

                                            s.specials_new_products_price,

                                            s.expires_date from

                                            " . TABLE_PRODUCTS . " p,

                                            " . TABLE_PRODUCTS_DESCRIPTION . " pd,

                                            " . TABLE_SPECIALS . "

                                            s where p.products_id = pd.products_id

                                            and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'

                                            and p.products_id = s.products_id

                                            and s.specials_id = '" . (int)$_GET['sID'] . "'");

und hiermit ersetzen:


 $product_query = xtc_db_query("select p.products_tax_class_id,

                                            p.products_id,

                                            p.products_model,

                                            pd.products_name,

                                            p.products_price,

                                            s.specials_quantity,

                                            s.specials_new_products_price,

                                            s.expires_date from

                                            " . TABLE_PRODUCTS . " p,

                                            " . TABLE_PRODUCTS_DESCRIPTION . " pd,

                                            " . TABLE_SPECIALS . "

                                            s where p.products_id = pd.products_id

                                            and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'

                                            and p.products_id = s.products_id

                                            and s.specials_id = '" . (int)$_GET['sID'] . "'");


-------------------------------------------------------------

ca. Zeile 192 folgendes suchen:


<td class="main"><?php echo ($sInfo->products_name) ? $sInfo->products_name . ' <small>(' . 


$xtPrice->xtcFormat($price,true). ')</small>' : xtc_draw_products_pull_down('products_id', 


'style="font-size:10px"', $specials_array); echo xtc_draw_hidden_field('products_price', $sInfo->products_price); 


?></td>


und hiermit ersetzen:


<td class="main"><?php echo ($sInfo->products_name) ? $sInfo->products_name . ' ('. $sInfo->products_model .')  


<small>(' . $xtPrice->xtcFormat($price,true). ')</small>' : xtc_draw_products_pull_down('products_id', 


'style="font-size:10px"', $specials_array); echo xtc_draw_hidden_field('products_price', $sInfo->products_price); 


?></td>


-------------------------------------------------------------

ca. Zeile 230 folgendes suchen:


$specials_query_raw = "select p.products_id, pd.products_name,p.products_tax_class_id, p.products_price, 


s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, 


s.date_status_change, s.status from " . TABLE_PRODUCTS . " p, " . TABLE_SPECIALS . " s, " . 


TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . 


$_SESSION['languages_id'] . "' and p.products_id = s.products_id order by pd.products_name";


und hiermit ersetzen:


$specials_query_raw = "select p.products_id, p.products_model, pd.products_name,p.products_tax_class_id, 


p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, 


s.expires_date, s.date_status_change, s.status from " . TABLE_PRODUCTS . " p, " . TABLE_SPECIALS . " s, " . 


TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . 


$_SESSION['languages_id'] . "' and p.products_id = s.products_id order by pd.products_name";


-------------------------------------------------------------

ca. Zeile 261 folgendes suchen:


<td  class="dataTableContent"><?php echo $specials['products_name']; ?></td>


und hiermit ersetzen:


<td  class="dataTableContent"><?php echo $specials['products_model']. ' ('. $specials['products_name']. ')'; 


?></td>



-------------------------------------------------------------

-------------------------------------------------------------

admin/includes/functions/general.php


ca. Zeile 316 folgendes suchen:


$products_query = xtc_db_query("select p.products_id, pd.products_name,p.products_tax_class_id, p.products_price 


from ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd where p.products_id = pd.products_id and 


pd.language_id = '".$_SESSION['languages_id']."' order by products_name");


und hiermit ersetzen:


$products_query = xtc_db_query("select p.products_id, p.products_model, pd.products_name,p.products_tax_class_id, 


p.products_price from ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd where p.products_id = pd.products_id 


and pd.language_id = '".$_SESSION['languages_id']."' order by products_name");


-------------------------------------------------------------

ca. Zeile 323 folgendes suchen:


$select_string .= '<option value="'.$products['products_id'].'">'.$products['products_name'].' 


('.xtc_round($products['products_price'], PRICE_PRECISION).')</option>';


und hiermit ersetzen:


$select_string .= '<option value="'.$products['products_id'].'">'.$products['products_name'].' 


('.$products['products_model'].') ('.xtc_round($products['products_price'], PRICE_PRECISION).') </option>';



-------------------------------------------------------------

-------------------------------------------------------------

das war es.




Edited by riese

Share this post


Link to post
Share on other sites
Sign in to follow this  

×
×
  • Create New...