copy quantity discounts

[VGlide]

Gosh, I haven't thought about this for a while.

( Things to keep in mind. It was written for a specific install on 1.3.8a originally. It should work on any version of zen. But the reason that it is not an official module is that I have never got round to making it one. )

The install is very simple and does not effect anything else. No edits or database alterations. Just upload the files.

But the module is making major changes to some of the tables in the database when it copies the discounts so it is most definitely worth backing up the database before doing it. That can be done from phpMyAdmin or there is a mod called something like BackupMysql which I believe Dr Byte wrote.

This mod doesn't actually add any discount handling to Zen Cart. It uses the existing quantity discount system to set the discounts. What it allows you to do is set the discounts for one product and then copy the discounts to other products. Or to whole categories. This just makes adding discounts to your catalog much easier.

There should be no problem with using it in conjunction with SWGuys module. I have a client who does that quite successfully. The two modules add their discounts in different places as the order total is being calculated so can work together. Although you could get some weird effects if the discounts overlap and you get two discounts being applied. This isn't really to do with this module because, as I say, it just used the existing zen cart quantity discount system.

I think that is it. Thanks everyone.

It's a great mod!

[stevefriedman71]

Doesn't seem to work in 1.5.0.

[niccol]

Well, I would guess that it would work but the way the admin menus is handled in 1.5 has been changed so it would need to be updated so that the correct item actually appeared in the menu so that you could actually use it. It will go on the list of things to do in the new year but if someone else wants to adapt it for 1.5 that would be great.

[niccol]

Version 1.5.0

Install as before and then run the following sql statement ( if your store uses database prefixes then you may need to add those to the sql statement) :

SELECT (@sort_order:=MAX(sort_order)+1) FROM admin_pages WHERE menu_key='catalog';
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('discountCopier', 'BOX_CATALOG_DISCOUNT_COPIER', 'FILENAME_DISCOUNT_COPIER', '', 'catalog', 'Y', @sort_order);

I wrote this add on a while ago and it is probably due an update in the near future.

[minskin]

I came across this thread after hours of trying other much more complicated methods. The copier is great and has saved me hours of work. Thanks Niccol.

[swguy]

@niccol, when you have a minute, please submit this to the Free Software Add Ons. Thanks!