REALLY Having Trouble Understanding / Implementing Quantity Price Break Module!

[Guest]

Hello. I've pretty much Gotten my cart set up with the basics, but I'm trying to understand and install the QPBPP contrib with much confusion. I realize there are read me files and instructions but I'm not sure if I'm suposed to download an old version of the contrib 1st, then edit THAT with a new updated one?

 

When I go straight to the newwest version it tells me to make edits....half of which are required / the other half already seem to be changed in the files I'm supposed to be updating.

 

i'm WAY confused on where each individual file is supposed to be uploaded to.

 

I really need this contrib to work for my site as I reallly only offer 4 items. Mens and womens distressed denim....either supplied by us, or customer supplied. Basically, it's $69.99 for the first pair and $49.99 for each pair after that. So I really dont have anything too complicated.

 

My background is I'm a photoshop master, pretty good with HTML, and I honestly have NEVER delved into PHP or database code until this cart so I am LLLLOOOSSSTTTT! :P

 

Please anyone who can maybe take some time and give me something a little more guided then the 4 text files that come in the contrib. I'm basically supposed to have this site launched by beginning of the business day tomorrow. Hopefully everyone's not tailgating or watching the superbowl today. B)

 

Thanks - Jay

 

http://rockstardenimworks.com

Edited February 4, 2007 by RockstarDenimWorks

[Jan Zonjee]

I'm trying to understand and install the QPBPP contrib with much confusion.

If you mean this Quantity Price Break Per Product contribution, just follow the install.html and upload PriceFormatter.php and PriceFormatterStore.php to the correct directory (/includes/classes).

[Guest]

If you mean this Quantity Price Break Per Product contribution, just follow the install.html and upload PriceFormatter.php and PriceFormatterStore.php to the correct directory (/includes/classes).

 

So accoring to install.html...

 

I need to do the following,

 

alter, and upload the 15 files listed..

 

Files:

catalog/includes/application_top.php

catalog/advanced_search_result.php

catalog/index.php

catalog/product_info.php

catalog/includes/classes/shopping_cart.php

catalog/includes/languages/english/product_info.php

catalog/includes/modules/product_listing.php

catalog/includes/functions/general.php

admin/categories.php

admin/includes/languages/english/categories.php

catalog/stylesheet.css

admin/includes/stylesheet.css

 

New files (upload to your server in the indicated directory):

catalog/includes/classes/PriceFormatter.php

catalog/includes/classes/PriceFormatterStore.php

admin/includes/classes/PriceFormatter.php (different from the catalog version!)

 

and then i'm done?

[Jan Zonjee]

So accoring to install.html...

 

I need to do the following,

 

alter, and upload the 15 files listed..

 

Files:

catalog/includes/application_top.php

catalog/advanced_search_result.php

catalog/index.php

catalog/product_info.php

catalog/includes/classes/shopping_cart.php

catalog/includes/languages/english/product_info.php

catalog/includes/modules/product_listing.php

catalog/includes/functions/general.php

admin/categories.php

admin/includes/languages/english/categories.php

catalog/stylesheet.css

admin/includes/stylesheet.css

 

New files (upload to your server in the indicated directory):

catalog/includes/classes/PriceFormatter.php

catalog/includes/classes/PriceFormatterStore.php

admin/includes/classes/PriceFormatter.php (different from the catalog version!)

 

and then i'm done?

No, you also (and first) need to run the sql script price_break_v1_2_0.sql that is in the package. You do that in phpMyAdmin (which is the usual program that the hosting providers install to give you direct access to the database).

The bright side is that in the folder catalog will be the changed files. So if you are certain (you should have kept a list of that really) you have not added a contribution to a particular file (say admin/categories.php) you can upload the file from the package.

 

If you already changed a page, you have to do the manual install on that particular page (stylesheet.css for example is changed for sure).

 

Perhaps you also want to change product_info.php because the standard table that shows the price breaks is butt ugly.

[Guest]

so in reality..... once i run the sql script thru phpMyadmin, i upload all the files as is???? because i'm going thru the changes that the installer file is telling me to make and so far it appears the files are all correct. everything it's telling me to replace or insert after.... is already done.

 

that's one big thing that was confusing me!

[Guest]

so in reality..... once i run the sql script thru phpMyadmin, i upload all the files as is???? because i'm going thru the changes that the installer file is telling me to make and so far it appears the files are all correct. everything it's telling me to replace or insert after.... is already done.

 

that's one big thing that was confusing me!

 

 

Sorry, but now I get THIS message when i try to run the sql script in phpMyadmin..

 

SQL query:

 

ALTER TABLE products ADD COLUMN products_price1 decimal( 15, 4 ) NOT NULL default 0.0,

ADD COLUMN products_price2 decimal( 15, 4 ) NOT NULL default 0.0,

ADD COLUMN products_price3 decimal( 15, 4 ) NOT NULL default 0.0,

ADD COLUMN products_price4 decimal( 15, 4 ) NOT NULL default 0.0,

ADD COLUMN products_price5 decimal( 15, 4 ) NOT NULL default 0.0,

ADD COLUMN products_price6 decimal( 15, 4 ) NOT NULL default 0.0,

ADD COLUMN products_price7 decimal( 15, 4 ) NOT NULL default 0.0,

ADD COLUMN products_price8 decimal( 15, 4 ) NOT NULL default 0.0,

ADD COLUMN products_price1_qty int NOT NULL default 0,

ADD COLUMN products_price2_qty int NOT NULL default 0,

ADD COLUMN products_price3_qty int NOT NULL default 0,

ADD COLUMN products_price4_qty int NOT NULL default 0,

ADD COLUMN products_price5_qty int NOT NULL default 0,

ADD COLUMN products_price6_qty int NOT NULL default 0,

ADD COLUMN products_price7_qty int NOT NULL default 0,

ADD COLUMN products_price8_qty int NOT NULL default 0,

ADD COLUMN products_qty_blocks int NOT NULL default 1;

 

MySQL said: Documentation

#1060 - Duplicate column name 'products_price1'

 

:blush:

[Jan Zonjee]

Sorry, but now I get THIS message when i try to run the sql script in phpMyadmin..

 

MySQL said: Documentation

#1060 - Duplicate column name 'products_price1'

OK, so you already run the sql commands that were in the install.html. The sql file is just another method to do the same thing. No problem.

[Guest]

It appears I have everything in fine operating order now.

 

Thanks a bunch!

 

http://rockstardenimworks.com