Вопрос по YML Export

17.05.2013 22:21
#1
price-tema
Joomshopping forum user no avatar
Name: Zgerskiy
31.05.2011
Posts: 64
Quote
Вопрос по YML Export

Возможно ли сделать так, чтобы не выгружались нулевые остатки и нулевые цены?

 
18.05.2013 14:01
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 19066
Quote
Aw: Вопрос по YML Export

Yes.
Change file
administrator\components\com_jshopping\importexport\ymlexport\ymlexport.php

Bofore
$query = "SELECT ".$adv_sel." prod.product_id, prod.product_ean, prod.product_quantity, prod.product_date_added, prod.product_price, tax.tax_value as tax, prod.`".$lang->get('name')."` as name, prod.`".$lang->get('short_description')."` as short_description, prod.`".$lang->get('description')."` as description, cat.`".$lang->get('name')."` as cat_name, categ.category_id, man.`".$lang->get('name')."` as man_name, prod.currency_id
FROM `#__jshopping_products` AS prod...........................

add code

$adquery.= " and prod.product_quantity>0 and prod.product_price>0";

 
19.05.2013 22:39
#3
price-tema
Joomshopping forum user no avatar
Name: Zgerskiy
31.05.2011
Posts: 64
Quote
Aw: Вопрос по YML Export

thank you

 


Copyrights MAXXmarketing GmbH. All Rights Reserved
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.