140
Store finally got approval to accept EBT. They have a 2 yr old database. Is there anyway to update the items have the foodstamp option checked for a department or category.
*This post is locked for comments
Jerry,
He found the solution in the KB.
The next post he made he posted the entire KB here and that's not allowed. KB articles are only to be used/seen in CustomerSource and are not to be posted publicly
Excuse me, Mauirox, but are you asking just how to make the items foodstampable by department?
If so, you need to get the department id numbers of the ones you want to change, then apply the bulk changes to the item table.
You can do this in the SO admin by running the following queries:
"SELECT * FROM [Department];"
Then youcan pick out your department id numbers, then...
substitute the id number for x in the query below:
"UPDATE [Item] SET Foodstampable='True' WHERE DepartmentID=X;"
Am I on the right track here?
-Jerry
jerry@jrdata.us
As Jeff said we are unable to post the contents of a customer source knowledge base article, but if you need assistance with locating it, this is the hyperlink to access it.
mbs2.microsoft.com/.../kbdisplay.aspx
This link will walk you through setting up EBT as a payment method and setting up the items to be EBT acceptable.
Thanks,
Nicole
Well said Jeff.
Craig
You should refrain from posting KB articles here.
A. Its copyrighted material.
B. Your agreement with CustomerSource says you won't do this.
C. CustomerSource and all its articles are paid by you with your BREP/BRAP/BRAP+ maintenance plan. Why give it away free to someone else?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (