+ Reply to Thread
Results 1 to 6 of 6

Discount not showing right when 2 or more of the same items..

  1. 05-19-2025, 05:40 PM #1
    Nielinki
    Nielinki is offline
    Registered User
    Join Date
    03-03-2025
    Location
    Wilmington, NC
    MS-Off Ver
    365
    Posts
    63

    Discount not showing right when 2 or more of the same items..

    Hi there..

    Just ran into this error this past weekend with the items that are discounted. If the item has a bigger discount than $1 and more than 1 is added to the cart, it discounts the first of the items the right amount and all the rest only as another $1.. So like the soda refill discount is $2 for employee but if you add a 2nd refill it only discounts it as $3, a 3rd refill it only discounts it as $4.. It is gonna happen in the MERCH part as well, because most of those items are $5 discounts.. It is ok if it is different items, just when the quantity is 2 or more of the same item..

    Can someone help me on this one please?

    Screenshot 2025-05-19 172910.png
    Screenshot 2025-05-19 172929.png
    Screenshot 2025-05-19 172949.png
    Screenshot 2025-05-19 173508.png
    BAR POS OG.xlsm
    Reply With QuoteRegister To Reply
  2. 05-20-2025, 02:45 AM #2
    MikeVol
    MikeVol is offline
    Valued Forum Contributor MikeVol's Avatar
    Join Date
    12-30-2020
    Location
    Odessa / Ukraine
    MS-Off Ver
    MSO Prof Plus 2021 x64 (En)
    Posts
    568

    Re: Discount not showing right when 2 or more of the same items..

    Hi @Nielinki . How can the program understand (take) what discounts you have for what products? It was necessary to take this into account somehow, create a list of discounts, what product has what discount. Then the program would recognize what you want from it. That's the whole answer to you.

    P.S.And you are not so generous (people help you), read my signature.
    NOTE: As the original poster/owner, only you can mark your thread as SOLVED (Thread Tools above Post #1).
    You can say "Thanks" in your thread to everyone who offered to help you.
    You can also reward them by clicking * "Add Reputation" under their username on the left.
    With Regards, MikeVol.
    Reply With QuoteRegister To Reply
  3. 05-20-2025, 03:51 PM #3
    MSDols
    MSDols is offline
    Forum Contributor
    Join Date
    01-25-2025
    Location
    Presov, Slovakia
    MS-Off Ver
    2021
    Posts
    287

    Re: Discount not showing right when 2 or more of the same items..

    Hi Nielinki ,
    you are adding "1" or "value", but you are not taking into account the number of pieces in each item.
    The unit discount should be multiplied by the number of pieces of the given item:
    Please Login or Register  to view this content.
    m.s.
    Last edited by MSDols; 05-20-2025 at 03:53 PM. Reason: text correction
    Reply With QuoteRegister To Reply
  4. 05-20-2025, 04:51 PM #4
    MikeVol
    MikeVol is offline
    Valued Forum Contributor MikeVol's Avatar
    Join Date
    12-30-2020
    Location
    Odessa / Ukraine
    MS-Off Ver
    MSO Prof Plus 2021 x64 (En)
    Posts
    568

    Re: Discount not showing right when 2 or more of the same items.. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 06-01-2025, 10:47 AM #5
    Nielinki
    Nielinki is offline
    Registered User
    Join Date
    03-03-2025
    Location
    Wilmington, NC
    MS-Off Ver
    365
    Posts
    63

    Re: Discount not showing right when 2 or more of the same items..

    Thank you so much for the help!!

    I was finally able to get to this problem and it worked awesome!!
    Reply With QuoteRegister To Reply
  6. 06-01-2025, 11:04 AM #6
    MikeVol
    MikeVol is offline
    Valued Forum Contributor MikeVol's Avatar
    Join Date
    12-30-2020
    Location
    Odessa / Ukraine
    MS-Off Ver
    MSO Prof Plus 2021 x64 (En)
    Posts
    568

    Re: Discount not showing right when 2 or more of the same items..

    Thx for the Rep+
    With Regards, MikeVol.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Distribute the discount i got on the products to get product price after discount
    By HiS2oKa in forum Excel General
    Replies: 3
    Last Post: 10-18-2022, 04:28 AM
  2. calculate a discount based on the amount of items in stock, using a table array
    By JNisch in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2019, 03:16 AM
  3. How to find appropriate prices for Items including discount price.
    By T.I. in forum Excel General
    Replies: 16
    Last Post: 07-24-2018, 03:19 PM
  4. array within an array to discount selected items from formula
    By Hub101 in forum Excel General
    Replies: 4
    Last Post: 05-26-2016, 09:30 AM
  5. giving a discount based on if a customer bought two items and his name came up twice
    By Luvly in forum Excel General
    Replies: 4
    Last Post: 09-13-2014, 02:02 AM
  6. giving discount based on if you buy two items and your name came up twice
    By Luvly in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-11-2014, 02:46 PM
  7. Percentage discount formula for a grid of figures and a different discount figure
    By SkydiveAnnie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-31-2013, 11:09 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1