Post by thop » Sat Oct 08, 2016 5:22 am

Here is my scenario

Got 1 customer group called "default"

Added 5000 products and added 5000 special prices assigned to "default"

Then added 25 customer groups :)

Need an extension or a way to add Product Specials to all Customer Groups

How you guys seen any solution like this ?

Thansk in advance for your recommendations!!

Newbie

Posts

Joined
Sat Oct 08, 2016 5:06 am

Post by florinsith » Sat Oct 08, 2016 4:19 pm

If you are looking to just copy the same specials then just run the following query for each customer group you have:

Code: Select all

INSERT INTO `oc_product_special`(`product_id`, `customer_group_id`, `priority`, `price`, `date_start`, `date_end`) SELECT product_id, CGID, priority, price, date_start, date_end from oc_product_special
where CGID would be replaced by the id of the customer group to which you copy the specials (its a number)

If you want to add other specials by percentage or something, there are extensions for this.

Image
My Extensions - SuperTheme - Opencart templates - Opencart modules


User avatar
Expert Member

Posts

Joined
Fri May 14, 2010 2:36 am


Post by Johnathan » Sat Oct 08, 2016 10:50 pm

Bulk Product Editing Pro can do this, although you still need to add a price for each customer group. But you could edit multiple products at the same time, and can add specials by flat value (e.g. 95.00) or by percentage (e.g. 90%, which would be 10% off). Feel free to take a look at the screenshots and demo site, and if you're interested let me know at www.getclearthinking.com/contact if you have any further questions.

Image
Image Image Image Image


User avatar
Global Moderator

Posts

Joined
Fri Dec 18, 2009 3:08 am


Post by MariOiraM » Fri Oct 21, 2016 12:48 am

@thop , how did you solve this?
I have the same issue.

Unior orodje | Makita orodje| Dewalt orodje


New member

Posts

Joined
Sun Apr 19, 2015 12:40 am


New member

Posts

Joined
Sat Oct 18, 2014 6:45 pm

Who is online

Users browsing this forum: No registered users and 12 guests