Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2006
    Location
    UK
    Posts
    7
    Plugin Contributions
    0

    Default FIXED Muliple Quantities at FIXED Prices per Multiple Quantity???

    Using Zen Cart v1.3.7 full-fileset 12302006

    The problem I have is, I have to work with FIXED Muliple Quantities at FIXED Prices per Multiple Quantity from a manufacturers list.

    I've tried this in the ' Products Price Manager' page using the 'Discount Qty Applies to Mixed Attributes' section in various settings, but the end price just will not tally with the price list I have to work with, by either rounding up or down to the nearest price, but not the exact price I have to work with.

    I've tried altering all instances in the database figures for 'prices' from
    (15,4) NOT NULL default '0.0000',
    (15,9) NOT NULL default '0.000000000',
    Hoping that the increase in decimal places will correct the price, calculating the individuaul price of an item from the quantity, but it seems to make no difference

    What other areas in the database need to be reset to calculate down to more decimal places?

    Just from working with one of many price lists
    20 items = 66.45
    30 items = 76.40
    40 items = 86.35
    50 items = 96.30
    60 items = 106.25
    70 items = 116.20
    and so on

    Is there an easier or different way of doing this.

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: FIXED Muliple Quantities at FIXED Prices per Multiple Quantity???

    What settings are you using on the Discounts?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Dec 2006
    Location
    UK
    Posts
    7
    Plugin Contributions
    0

    Default Re: FIXED Muliple Quantities at FIXED Prices per Multiple Quantity???

    Hi Linda

    Working from one fixed price list to quantities and prices, as supplied to me.
    20 items = 25.50
    30 items = 33.15
    40 items = 40.80
    50 items = 48.45
    60 items = 54.40
    70 items = 60.35
    80 items = 66.30
    90 items = 72.25
    100 items = 78.20
    -----------------------------------
    Settings used (But have tried all variations) in Products Price Manager

    Tax Class --none--

    Product Price Info: 00.00

    Qty Min:20
    Qty Units:10

    Product is Free:No
    Call for Price:No
    Priced by Attributes:No (but have also tried with Yes)

    Discount Type: Actual Price
    Discount Priced from: Price

    To work out the Discount Value to use, I have to divide the quantity by the price to get a price for each individual item for each specific quantity.
    But because the database only seems to calculate to 2 decimal places, the final price to the list price is not the same end result.

    20 items = 25.60 but should be 25.50
    30 items = 33.30 but should be 33.15
    40 items = 40.80 This one Correct
    50 items = 48.50 but should be 48.45
    60 items = 54.60 but should be 54.40
    70 items = 60.20 but should be 60.35
    80 items = 66.40 but should be 66.30
    90 items = 72.00 but should be 72.25
    100 items = 78.00 but should be 78.20

    Could do with something similar to the 'Discount Qty Applies to Mixed Attributes' module but simplified so that instead of 'Minimum Qty' just 'Quantity' and instead of 'Discount Value' just 'Fixed Price' for each quantity, with the ability of adding extra fields for extra quantities.

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: FIXED Muliple Quantities at FIXED Prices per Multiple Quantity???

    Have you an URL to this Product?

    NOTE: Discount Quantity Prices is for Products with a Price ... You may need to use the Attribute Quantity Discounts if you are not using a Product Price ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5
    Join Date
    Dec 2006
    Location
    UK
    Posts
    7
    Plugin Contributions
    0

    Default Re: FIXED Muliple Quantities at FIXED Prices per Multiple Quantity???

    I don't have a URL for the specific products on my own site as yet, as I am only testing the cart to get the hang of it. The main product is for invitations, but working as an agent, I have to work with Fixed Quantities at Fixed Prices. Starting off at a minimum quantity, as in this case 20 and going up in 10's

    You mention the 'Attribute Quantity Discounts' I've been trying this and cannot get anywhere near the correct end price.

    20 items = 25.50
    30 items = 33.15
    40 items = 40.80
    50 items = 48.45
    60 items = 54.40
    70 items = 60.35
    80 items = 66.30
    90 items = 72.25
    100 items = 78.20
    and so on

    or adding the difference to the first price

    20 items = 25.50
    30 items + 7.65 = 33.15
    40 items + 15.30 = 40.80
    50 items + 22.95 = 48.45
    60 items + 28.90 = 54.40
    70 items + 34.85 = 60.35
    80 items + 40.80 = 66.30
    90 items + 46.75 = 72.25
    100 items + 52.70 = 78.20
    and so on

    So when a customer picks 60 items, the price will show and add to the cart 54.40, or if they decide to change the quantity, the correct price will show to the quantity they want.

    Surely there must be a way of doing this as the cart does just about every other function I need. Is there anyway of getting the database to recognise more than 2 decimal places as this would probably cure the problem, or is there any modification that can be made to the Quantity Price Breaks to default to fixed prices at fixed quantities.

  6. #6
    Join Date
    Aug 2004
    Location
    Fountain Hills, AZ
    Posts
    515
    Plugin Contributions
    1

    Default Re: FIXED Muliple Quantities at FIXED Prices per Multiple Quantity???

    I'm facing a similar situation with a cart that I'm building. I've noted the same issue - that due to the cart only computing with two decimals the pricing is off on certain items.

    Is there an answer to this?

 

 

Similar Threads

  1. v151 Fixed quantity price per order quantity
    By bztek in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 1
    Last Post: 7 Feb 2014, 05:30 PM
  2. v139h Multiple products with fixed quantity pricing
    By reetp in forum Setting Up Categories, Products, Attributes
    Replies: 24
    Last Post: 17 Jul 2012, 05:59 PM
  3. Fixed price for multiple zones per item
    By chelgeson in forum Built-in Shipping and Payment Modules
    Replies: 8
    Last Post: 16 May 2009, 02:56 PM
  4. Fixed Quantity Tiers With Specific Prices
    By CEP Mark in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 2 May 2009, 04:36 PM
  5. Price Breakpoints with fixed quantities
    By dickfleming in forum General Questions
    Replies: 1
    Last Post: 23 May 2006, 02:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR