Inventory - Taking trade in on sale

mtc1234mtc1234 Member Posts: 1
edited August 2021 in Feedback
We are a bike shop that occasionally takes in a bike as trade for partial payment towards a new bike. Was curious if anyone else does this and how do they manage it. We pay some of our sales people commission off of total amount of sales and others off of profit gained.

Where it really makes it difficult is when the trade is enough money that it makes the profit of the sale a negative amount..

Mainly though is anyone taking in trades and how do you enter it into the system??? 
Post edited by VD_LS on


  • JasonSrJasonSr Member Posts: 1

    we have a store trade payment option set up as a payment option. So instead of taking a return on an item during the sale, we accept a store credit as payment and then the balance on whatever tender they use. We then add the traded equipment into inventory.

  • MillRiverMusicMillRiverMusic Member Posts: 2

    Jason, the trouble with that method for us is that a trade in should be a pre tax calculation. I wish that we could do it as a store payment method that would do a tax reduction. Right now we have a product called "Trade In" for any trade in items that we take in that are not already a sku in our system and we write a negative dollar amount. The problem with this is that we have to add the Trade IN deductions back into our totals to get a full report for our sales totals. Lightspeed really needs to make a proper trade in function with proper accounting.

  • RideABikeNCRideABikeNC Member Posts: 1

    Each used bike we either take in on trade or buy has it's own SKU prefaced with a sequential number (IE, 762 - Raleigh Talus 1 [I like the sequential numbering because at a glance I know it's a used bike and I know roughly how long we've had it]). Here's how we do it:

    1. Create SKU for used item and categorize it as "Bicycles - Used"
    2. Put purchase price as sale and cost.
    3. Open a new sale, attach customer, and then REFUND that new SKU. Be sure to uncheck tax.
    4. Apply the refunded money to the current sale OR the customer's store account. You could also refund the store account money as check, cash, etc as needed for your situation. We do store credit or check only.

    The SKU for the used bike you just purchased now shows 1 in stock, the customer has their money, and we have good records of what we bought.

    When you have the used bike ready to sell, change the SKU's price to your new retail price and you're done.

    If the bike needs any kind of work, we create a workorder under the owner's name. We put all parts and labor on the WO just as if they were going to keep the bike. We pay for the repairs out of what we refunded to the customer's account above and they get the remainder. If the repairs exceed the wholesale value of the bike we either don't buy or buy as a parts bike.

    I still have to pay my people to fix the used bikes so we do charge normal labor on used bikes. If they kept the bike it would need that work and (usually) they were the ones that rode the bike into that condition.

  • abacusabacus Member Posts: 4

    I'm about 90% done building an app that handles trade ins with Lightspeed. I've built it for my buy/sell/trade used instrument company Evolution Music. We've been successfully using it for almost 2 years but I'm almost done making it a fully fledged SaaS.

    The app handles pre tax calculation for trade in value, treats any remainder similarly to @RideABikeNC issuing a refund to be paid in whatever tender you prefer (we always do Check, Store credit or Gift Card). It also lets you simply buy inventory in from a customer whether or not it is a trade.

    It also automatically creates listings on our Shopify driven website and (basically Ebay for music gear) and syncs inventory levels every minute.

    The only drawback is that reporting becomes skewed because buy-ins and trades register as "refunds" as @MillRiverMusic mentioned.

    I built this to scratch my own itch but if you guys are interested let me know. I've become very fluent with the Lightspeed API and could create custom solutions for you as well.

  • sam123456sam123456 Member Posts: 54

    @abacus I tried to PM you a while ago. Can you share any progress on your app? Has anyone else found a better solution than the return for store credit one?

  • daprice89daprice89 Member Posts: 1

    can i also get an update on this trade in app?

  • sam123456sam123456 Member Posts: 54

    @daprice89 I never heard back from that person. I'm assuming it was abandoned.

  • ToshiToshi Member Posts: 1 have option for trade in.

  • pmjpmj Member Posts: 12

    Be careful with excepting trade ins and applying the values pretax. Some tax rules have a time limit which apply for refunding taxes paid on goods or what is considered a return in which taxes can be refunded. You find yourself being assessed the unpaid tax. I would only apply a trade in for a payment type, to reduce the after tax payment.

  • danmccloskey1danmccloskey1 Member Posts: 9

    Here is what I have come up with. I created a Discount called Trade-In, and assess a value to it according to the item being traded. Then when I create a sale, add a customer, and apply the discount it deducts the trade value and does not tax the discount amount, it only the taxes the difference.

    When I do the next trade it all I have to do is adjust the value of the discount.

  • VD_LSVD_LS Administrator, Moderator, Lightspeed Staff Posts: 796 moderator

    I've moved this thread to our feedback forum so it can be considered as an enhancement request.


    If you have any further questions Please do not hesitate to contact LightSpeed support or check out our Support Page.

    All the best!


    Lightspeed Retail Support

    866-932-1801 ext. 2 (Toll-Free)

    514-907-1801 ext. 2 (Montreal)

Sign In or Register to comment.