Page 1 of 2

[vQmod][Commercial] Special Manager

Posted: Fri Mar 25, 2011 8:41 am
by d7a7z7e7d
This extension will make your specials much easier to manage by allowing you to manage specials directly on a new specials list page. You can easily create specials for one or more categories, an entire store or a selection of products. You have full control over how the discount is applied and can choose to discount by percentage, fixed amount or just set the special price directly to a fixed number. In addition, you can edit specials directly on the specials list page! Just click on a field and it will become editable. Clicking out of the field immediately saves it to the database. With this powerful extension, your new special list page almost becomes a spreadsheet!

Special Manager Extension

A demo is available at ... al_manager
Username: demo
Password: demo

Make any changes you wish to test the extension. The demo store will be reset every 2 hours.

  • Comes with vQmod file for plug and play installation!
  • Edit specials directly on the special list page. Update discount, discount type, start and end dates and more.
  • Apply specials to entire categories with ease. Or, select all categories and apply a store-wide discount!
  • Discount by percentage, fixed amount or just set it to a fixed number!
  • Easily show and/or hide columns from the list.
  • Search box automatically filters categories and products as you type.
  • Copy, CSV and Print buttons allow you to copy the rows to your clipboard, export them to a CSV file or print them with the click of a button!
  • Preloads data so you can switch pages even faster.
  • Sort any field by clicking on the column header.
  • Automatically remembers your column, sorting and other preferences.
  • Allows you to easily change the number of results per page.
  • Validates fields appropriately. Prices should be numbers afterall.
Make managing your specials easier today! Download Extension

Manage All Specials - screenshot_1.png (45.85 KiB) Viewed 8735 times


Add Category Specials - screenshot_2.png (13.23 KiB) Viewed 8735 times


Add Product Specials - screenshot_3.png (11.49 KiB) Viewed 8735 times

Re: [vQmod][Commercial] Special Manager

Posted: Thu Nov 17, 2011 2:19 pm
by d7a7z7e7d
Now updated to work with OpenCart v1.5.x!

Re: [vQmod][Commercial] Special Manager

Posted: Sun Nov 27, 2011 1:28 am
by marvmen21
Nice Work, though this post shouldn't be here. Any mod please move it to the commercial section.

Re: [vQmod][Commercial] Special Manager

Posted: Tue Nov 29, 2011 1:12 pm
by d7a7z7e7d
Version 1.2 has just been released which now allows you to create manufacturer-wide specials with ease!

View Special Manager Extension

Re: [vQmod][Commercial] Special Manager

Posted: Fri Dec 30, 2011 4:45 am
by srunyon1
Im getting errors when ever I try and delete a special.

Code: Select all

Notice: Error: Table 'zigzterc_mkshop.category_special_to_product_special' doesn't exist
Error No: 1146
DELETE FROM category_special_to_product_special WHERE product_special_id = '897' in /home4/zigzterc/public_html/shop/system/database/mysql.php on line 49
it seems to delete one at a time even with the error but it will not delete multiples at all..
any help?

Re: [vQmod][Commercial] Special Manager

Posted: Fri Dec 30, 2011 4:54 am
by d7a7z7e7d
It looks like the SQL tables didn't get created. Did you execute the code in "special_manager.sql"? You can usually do this through the cPanel that your hosting provider provides. Just login and look for "phpMyAdmin" then select your database, select the SQL tab, paste in the code in "special_manager.sql" and hit "Go".

Re: [vQmod][Commercial] Special Manager

Posted: Fri Dec 30, 2011 5:00 am
by srunyon1
ahh i did not see that in the instructions.. I'll try it..

Re: [vQmod][Commercial] Special Manager

Posted: Sat Dec 31, 2011 2:41 am
by srunyon1
thanks that worked..helps when you read the instructions.. :)
one strange thing I have seen is adjusting prices in the Edit section sometime defaults to zero or even just a strange number. I have also seen this happen in the main window. it just doesn't seem to update right.
What would really make this and your product Manager perfect would be to ad a column with the special price right next to the product price with the option to change either.. thanks for all your work on this very helpful extension!!

im using your version 1.2 on 1.5.3

Re: [vQmod][Commercial] Special Manager

Posted: Sat Dec 31, 2011 3:05 am
by d7a7z7e7d
Hmm, that's strange. Can you show me a screenshot of the "strange number"?

The problem with trying to integrate this directly into Product Manager is that a product can have more than one special, on more than one date, applied to different customer groups, etc. It isn't just a one-to-one relationship so it just isn't really feasible to try and integrate the two.

Re: [vQmod][Commercial] Special Manager

Posted: Sat Dec 31, 2011 9:09 am
by srunyon1
I think I figured it out, I was having a confusion over fixed price and fixed discount..
I got works great!!

Re: [vQmod][Commercial] Special Manager

Posted: Sat Dec 31, 2011 9:11 am
by srunyon1
Also couldn't you add a column in the special manager to show regular price?

Re: [vQmod][Commercial] Special Manager

Posted: Sat Dec 31, 2011 9:54 am
by d7a7z7e7d
Glad you got it working! Yeah, I think showing the regular price is a great idea! I'll see if I can get this added to the next release. Thanks!

Re: [vQmod][Commercial] Special Manager

Posted: Tue Jan 31, 2012 8:01 am
by psicoz

I bought your extension days ago. It's working perfect, but could you please tell me how to order the special products ?

I added 'order' in product_special table and change this in catalog/controler/module/special.php

$data = array(
'sort' => 'ps.order',
'order' => 'ASC',
'start' => 0,
'limit' => $setting['limit']

then I changed in function getProductSpecials (catalog/model/catalog/product.php)

$sort_data = array(

but still not working... any idea ?

thank you !

Re: [vQmod][Commercial] Special Manager

Posted: Fri Feb 03, 2012 1:42 am
by d7a7z7e7d
What is it that you want them ordered by?

Re: [vQmod][Commercial] Special Manager

Posted: Thu Apr 05, 2012 10:04 pm
by tophat

Looks good and useful, however.... does this take a percentage off for the special price with options included or just the base price.

All my products come in different sizes and uses options to change the price accordingly. However, I'm struggling to find a solution that reduces the figure as a total with options for the special. As a £10 saving off our small items will not mean a lot off our much larger items, therefore needs to be relative.

Thanks for any help and input..!

Re: [vQmod][Commercial] Special Manager

Posted: Fri Apr 06, 2012 10:13 am
by d7a7z7e7d
Hi tophat,

It only takes the percentage off the base price. It would be a major undertaking to implement something like you describe.


Re: [vQmod][Commercial] Special Manager

Posted: Fri Apr 06, 2012 1:42 pm
by d7a7z7e7d
Version 1.2.1 has just been released which officially adds support for OpenCart v1.5.2.x!

Re: [vQmod][Commercial] Special Manager

Posted: Thu Apr 12, 2012 7:19 am
by tophat
d7a7z7e7d wrote:Hi tophat,

It only takes the percentage off the base price. It would be a major undertaking to implement something like you describe.

I understand and from what I've read elsewhere, it doesn't appear easy to implement.

Would be incredible if someone like yourself could come up with a solution as I'm sure I'm not the only one who has products priced through options in the manner I do. Makes having a sale very difficult.

Re: [vQmod][Commercial] Special Manager

Posted: Tue Jun 26, 2012 10:55 am
by markdyer
Hi, I seem to be unable to untoggle the columns. If I have them turned off in the config, I can turn on in the web browser but not turn back off in the web browser.. Is this a known problem? Thank you.

If it possible to remove the toggle option from showing alltogeather?


Re: [vQmod][Commercial] Special Manager

Posted: Fri Jul 13, 2012 7:22 pm
by ty-uc
This seems like the best option out there for applying a site wide % based sale but I have one question...

It seems to overwrite all current special prices, lets say I have some items that are reduced by 23% because I'm pricematching another shop then we want to apply a 20% sale to everything on the site the current specials will be lost. How would I avoid that? Export our entire shop before the sale then import it again after the sale ends? Or would there be a better way of doing it?