Jump to content



Member Since 09 Aug 2013
Offline Last Active Jul 05 2015 06:43 AM

Topics I've Started

"in Stock" / "out Of Stock" And "available Since"

20 May 2014 - 09:14 AM

I have searched and tried a lot of combinaison, but can't find how to make it work as I want... Maybe somebody can help me ?

What I would like :
-> "In stock" if product qty > 0 (and "Add to cart" displayed)
-> "Out of stock" if qty =< 0 (and "Add to cart" displayed)
-> "Out of stock" and "Available since xx/xx/xxx" if date that date exists (and "Add to cart" displayed)

Actual general setup :
Enable inventory tracking = yes
Allow negative amount in inventory = yes
Low stock notification threshold = 0
Show out of stock products = yes

Actual product setup :
In stock = 0
Inventory = Track without options
Avail since = 31/05/2014
Out of stock actions = buy in advance

Actual result :
Product is "In stock" + "Available since 21/05/214" + "Add to cart" displayed

Result expected :
Product is "Out of stock" + "Available since 21/05/214" + "Add to cart" displayed

Thanks !

Sql Optimisation

18 April 2014 - 07:14 AM

My provider told me that some SQL queries where too long/slow and are consuming too much ressources on the MySQL server.

I found the queries in the logs. here is one line but the logs contains hundreds of similar lines...

Can somebody tell me where they are coming from and what I could do ?

# Query_time: 12  Lock_time: 0  Rows_sent: 3  Rows_examined: 1999152
SELECT SQL_CALC_FOUND_ROWS products.*, descr1.product as product, MIN(IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100)) as price, descr1.short_description, IF(descr1.short_description = '', descr1.full_description, '') as full_description, GROUP_CONCAT(IF(products_categories.link_type = 'M', CONCAT(products_categories.category_id, 'M'), products_categories.category_id)) as category_ids, products_categories.position, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, IF(shared_descr.product_id IS NOT NULL, shared_descr.short_description, descr1.short_description) as short_description, IF(shared_descr.product_id IS NOT NULL, IF(shared_descr.short_description = '', shared_descr.full_description, ''), IF(descr1.short_description = '', descr1.full_description, '')) as full_description, IF(shared_descr.product_id IS NOT NULL, shared_descr.meta_keywords, descr1.meta_keywords) as meta_keywords, IF(shared_descr.product_id IS NOT NULL, shared_descr.meta_description, descr1.meta_description) as meta_description, IF(shared_descr.product_id IS NOT NULL, shared_descr.search_words, descr1.search_words) as search_words, IF(shared_descr.product_id IS NOT NULL, shared_descr.promo_text, descr1.promo_text) as promo_text, IF(shared_prices.product_id IS NOT NULL,MIN(IF(shared_prices.percentage_discount = 0, shared_prices.price, shared_prices.price - (shared_prices.price * shared_prices.percentage_discount)/100)),MIN(IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100))) as price, cscart_seo_names.name as seo_name FROM cscart_products as products  LEFT JOIN cscart_product_features_values ON cscart_product_features_values.product_id = products.product_id AND cscart_product_features_values.lang_code = 'fr' LEFT JOIN (SELECT product_id, GROUP_CONCAT(cscart_product_features_values.variant_id) AS advanced_variants FROM cscart_product_features_values WHERE lang_code = 'fr' GROUP BY product_id) AS pfv_advanced ON pfv_advanced.product_id = products.product_id LEFT JOIN cscart_product_features_values as var_val_11_9 ON var_val_11_9.product_id = products.product_id AND var_val_11_9.lang_code = 'fr' LEFT JOIN cscart_product_features_values as var_val_11_10 ON var_val_11_10.product_id = products.product_id AND var_val_11_10.lang_code = 'fr' LEFT JOIN cscart_product_features_values as var_val_9_7 ON var_val_9_7.product_id = products.product_id AND var_val_9_7.lang_code = 'fr' LEFT JOIN cscart_product_features_values as var_val_9_8 ON var_val_9_8.product_id = products.product_id AND var_val_9_8.lang_code = 'fr' LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'fr'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H')   LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'fr' LEFT JOIN cscart_ult_product_prices as shared_prices ON shared_prices.product_id = products.product_id AND shared_prices.lower_limit = 1  AND shared_prices.usergroup_id IN (0, 0, 1) AND shared_prices.company_id = 1 LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = products.product_id AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = ''  AND cscart_seo_names.lang_code = 'fr' AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0) WHERE 1  AND ( FIND_IN_SET('8', advanced_variants)) AND ( FIND_IN_SET('35', advanced_variants)) AND ((var_val_11_9.value_int >= 1 AND var_val_11_9.value_int <= 1 AND var_val_11_9.value = '' AND var_val_11_9.feature_id = 35) OR (var_val_11_10.value_int >= 2 AND var_val_11_10.value_int <= 2 AND var_val_11_10.value = '' AND var_val_11_10.feature_id = 35)) AND ((var_val_9_7.value_int >= 6 AND var_val_9_7.value_int <= 10 AND var_val_9_7.value = '' AND var_val_9_7.feature_id = 36) OR (var_val_9_8.value_int >= 10 AND var_val_9_8.value_int <= 999 AND var_val_9_8.value = '' AND var_val_9_8.feature_id = 36)) AND cscart_categories.category_id IN (1) AND cscart_categories.company_id = 1 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id   ORDER BY price desc  LIMIT 0, 12;

Shipment notification html

04 December 2013 - 01:09 PM

I would like to keep the format in the comments which are sent to the customers when sending shipment notification. Html tags I tryed to add in {$shipment.comments} are filtered and not displayed.

I'm trying without success to find out how to modifiy {$shipment.comments} in shipment_products.tpl to keep formating of the text (line feed, paragraph).

Hidden languages

02 October 2013 - 07:24 AM

Hello. I assumed that hidden languages were only visible in Admin, not in storefront.

But if I make any of my installed languages hidden, it is no longer visible in storefront, but also for the administrator : the language is no longer available in top right corner dropdown list to change the admin language and no longer visible in the dropdown list in administration/languages for translations.

Consequently, hidden and disabled have the same effect...

Is it a problem with my installation or understanding the feature ?

No shipment notification sent

01 October 2013 - 10:02 AM


No notification mail is sent after creating a new shipment (of course, checkbox "Send shipment notification to customer" is checked).

Mails are sent via SMTP Server and other emails are sent (new orders, status changes).
If I change the "Order status" in the "New shipment options", the mail for that status change is sent, but not for shipment.

Can't find out why no notification is sent for the shipment. Any option I've missed ?

Using Ultimate 4.0.1