Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


Forgot your Password?
 All Forums
 VPCart Forum
 VP-Cart 8.00 Issues
 [Solved] Quantity discount ''sticking''		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

[email protected]
VP-CART New User

149 Posts
Posted - June 28 2016 :  12:47:06  Show Profile  Reply with Quote
Is the quantity discount storing information somewhere else (like in a cache)?

We changed a quantity discount entry and there is only that one entry in the mysql table but the page still shows the old quantity discount values.

I''m wondering where I can go to fix this.
Edited by - [email protected] on June 28 2016 15:19:26

[email protected]
VP-CART New User

149 Posts
Posted - June 28 2016 :  14:43:02  Show Profile  Reply with Quote
If it helps,
I''ve literally deleted everything in the quantitydiscounts table and added it back in but it''s still showing the old value and there is nowhere that I can spot where it can get this information from
Go to Top of Page

[email protected]
VP-CART New User

149 Posts
Posted - June 28 2016 :  15:24:02  Show Profile  Reply with Quote
ok, so...short answer is: I''m an idiot.

Longer answer: We created a special page so people can see every product that we have a bulk deal on. We arranged this page by category. We did this by getting the categoryid for each product...finding out what the top-level category for that item was and grouping them together by their toplevel category.
To make things easier, we put the id for the top level category into the categoryid field in the quantitydiscounts table.

As it turns out, there is a snippet of code that looks for discounts by categoryid (which suggests to me that VPASP might be capable of setting an entire category on a quantity discounted price) and that one of the entries for that category was being used as the discount for all of the products in that particular category.
As soon as I set all the categoryid''s back to 0 in the quantitydiscounts table, the individual products got their proper discounts back. So. This error was self-inflicted and I am an idiot.
Go to Top of Page

support
Administrator

4679 Posts
Posted - June 30 2016 :  02:14:57  Show Profile  Visit support's Homepage  Reply with Quote
LOL. I cannot tell you how many times I have said those exact same words about myself when working on a site.

Great to hear all resolved!

Cam Flanigan
VPCart Customer Care
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty