Contributions
Category Specials
Released: 2005-11-08
Author: Ashish Kumar Singh
Compatible OSC versions: 2.2ms2
DESCRIPTION:
This will allow admin to make specials, all the products under a category. Allows to keep intact the specials product under the category from before or can be easily overridden with the new discount.
Categories can take special value as percentage(%) or flat value.
Trying to add a pre-existing category, updates the values with new value.
Thanks!
Ashish
Expand All / Collapse All
Tradução para português - BR
Deus abencoe todos.
Can anyone please help me!
When I add more than one category as special I get the following error:
" 1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
select count(*) as total from products A, products_description B , products_to_categories E left join specials C on C.products_id = A.products_id left join special_product F on A.products_id = F.product_id left join special_category D on E.categories_id = D.categ_id where E.categories_id = 44 and E.products_id = A.products_id and A.products_id = B.products_id and B.language_id = '1' "
Correction of joint statment for mysql 5.0.x compatibility.
This is the full package with french translation.
This is the full package with spanish translation.
Real great contribution!
Visitanos en los foros en español de oscommerce:
http://oscommerce.qadram.com/modules.php?name=Forums
Saludos :)
This is an addon to manage frensh translation of the Category Specials contribution (v2.0).
#English
Complete Category Specials 2.0 contribution with Polish language built-in. No additional downloads are necessary. All credits go to Ashish Kumar Singh, I only added second language and instalation instructions in Polish which can also be used in next releases too.
#Polski
Kompletna paczka kontrybucji Category Specials 2.0 z wbudowanym jezykiem polskim, nie wymagajaca sciagania oryginalnego pliku. Autorem skryptu jest Ashish Kumar Singh, ja tylko dodalem polski jezyk oraz polska instrukcje instalacji skryptu, ktore moga byc rowniez wykorzystane w nastepnych wersjach.
Piotr Krasnicki
Products under a category, can now be managed individually.
Thanks!
Ashish
Fixed a minor mistake in the install.txt
Only (install.txt).zip uploaded.
Problem: "Specials" was not visible from the admin side.
Released: 2005-11-08
Author: Ashish Kumar Singh
Compatible OSC versions: 2.2ms2
DESCRIPTION:
This will allow admin to make specials, all the products under a category. Allows to keep intact the specials product under the category from before or can be easily overridden with the new discount.
Categories can take special value as percentage(%) or flat value.
Trying to add a pre-existing category, updates the values with new value.
Thanks!
Ashish
Note: Contributions are used at own risk.