Howdy,
Is it possible to create new inventory wizard tasks?
specifically I want the inventory wizard to toggle the "Item is available on the website" field in the options tab on the product items form.
Or can someone help me with the SQL to do this manually?
Muchas gracias,
jon
*This post is locked for comments
Hello... did you ever find an answer to this? I realize it was 6 years ago but hey, who knows.
I don't think there is any specific wizard to update "item available on website".
Be very careful when running sql statements. Always have a database backup before you run any sql. The following code will do. The first is by department, the second by category. webitem=1 is to set the item to available on website. 0 is not available.
Run the select statement first to be sure that the correct records are affected.
select itemlookupcode,description from item where departmentid = (select id from department where name = 'Dept Name')
update item set webitem=1 where departmentid = (select id from department where name = 'Dept Name')
select itemlookupcode,description from item where categoryid = (select id from category where name = 'Category Name')
update item set webitem=1 where categoryid = (select id from category where name = 'Category Name')
Thank you. TimB
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
