https://netsuiteprofessionals.com logo
Join Slack
Powered by
Why not just set up the promo code to add the item...
# general
k
Why not just set up the promo code to add the item for you?
c
hey Kevin, i'm actually the same guy who just asked a question about the dual promotion on reddit that you responded to 😉. Essentially I'm trying to figure out the best way to add a fee to the cart when a customer uses a Payroll Deduction promotion code.
k
So for internal purchasers?
is it a flat fee? Percentage?
c
yeah for internal purchasers
a $20 flat fee
k
well, if they are internal, that makes it a lot easier
because then you don't have to worry about the user experience as much.
in which case - I might use a scheduled workflow to add the line
c
so I created a fee as an item that could be added to the cart but we also are trying to basically zero out the cart because it's payroll deduction so we don't want them to have pay the full amount now, just the $20 fee
oh ok, i could try that
k
I probably add some combination of fields to make this more managable and reliable
so that the fee only gets added once, etc.
granted, the issue there is that if they are pre-paying on the website, a scheduled workflow adding it later makes you switch to a more invoice oriented setup as opposed to a cash sale
so - you probably still want to script this as part of your cart process.
c
yeah because basically we just want to charge them 4% of the cart total (first payment of payroll deduction) + $20 processing fee
i tried doing the 96% off order total but it also takes 96% off of the $20 processing fee
k
can't you do an item based promotion that only looks at the item?
build a saved search that sees all the items they can purchaseexcept the processing fee
been a while since I've worked with promo codes though.
c
yeah that's what i did but when combined with another item promotion it keeps adding the two together as opposed to doing them sequentially
k
are you using the new promotions, or the old style?
c
the new promotions
k
there should be an option to not stack them
c
so the first promo code takes 8% of all tech items then the next one (the payroll one) i want to take 96% off all items in cart (except processing fee). so what happens is it takes 104% off of the tech products
k
Why not just make it so the first promo code can't be used in conjunction with the second.
c
because the first tech one is basically reducing the tech item to a sale price and then we want the 96% to be be applied to the entire order because that's the first monthly payment
so the 96% coupon we want on the adjusted (post-sale) subtotal
k
Now you've really lost me.
c
sorry, i know this is a little hard to follow
let me try again
k
So if I understand correctly - they are buying something at a discount.
Then you are trying to force them to pay the first month's payment up front
c
yes
k
and then the rest comes out of payroll later
c
yes
but the first months payment would be based on the adjusted subtotal so if they add any other promotion codes that would reduce the subtotal
k
On that note - I'm going to tap out, because that sounds like a small project to figure out.
c
haha fair enough
k
and has implications beyond just getting them to make their first payment
GL impacts, etc.
c
yeah we were planning to back out the coupon code once placed then turn it into an invoice
i can figure out the whole first monthly payment thing though by using an order based promo of 96% if i can figure out how to add a fee to the cart that wouldn't be subject to the promo
k
Seems to me like this shouldn't be an e-commerce thing unless you have hundreds of employees that will be taking this route
on a frequent basis
c
not hundreds, no
k
So how many a month? 5? 10?
Probably not that hard to just give someone a catalogue, and have a rep enter the order manually.
c
we may have about a hundred payroll deduction orders this month but probably about 4-500 per year
k
well, that's hundreds of employees haha
c
sorry, i read it as hundreds per month
k
Probably needs to be scripted in the cart process.
c
ok. good to know
k
have it add a subtotal item, discount it to 0/4% based on whatever is remaining, and then add the fee
instead of trying to force a promo code to do that
c
yeah that sounds right to me
that subtotal item couldn't be added via workflow right?
k
they can be - but I don't think you're gonna get a workflow to do that at time of checkout
at least, not on a website.
c
oh ok
k
you're welcome to try it.
but I wouldn't spend more than a couple hours once you get it working in the UI in netsuite
because I think the only way you can add lines via workflow is via server side interaction
(i.e. before record submit)
c
ah ok that makes sense
well i appreciate the time, man
you have been super helpful
really, really appreciate it!
k
Sure thing - bear in mind I'm not an ecommerce expert, so it's plausible there's another way to do it
c
ok, i'll bear that in mind
k
Jack of many trades, master of a couple. Mostly educated guesses on how NS does things and high level view of how scripts work.
c
i've only been working with it for a months so haven't really even figured out how workflows work
it being NetSuite
*few months
k
I am pretty good with workflow.
Pretty confident in my estimation on how that add lines concept works.
80/90%
NS did just trim new workflows from auto running on website/store - so make sure when you test it to enable that in workflow set up.
c
oh interesting. i'll have to look into that
2 Views
Open in Slack
PreviousNext
Powered by