Mass Update to make items available on website

Is there a way to do a mass update to change item properties to enable the "item is available on website" box? I'd rather not go through 1000+ items manually to do this. I am using RMS and Nitrosell.

Thanks!

Reply to
Julie
Loading thread data ...

Hi Julie - you could run an update query using SO administrator. I am not familar with the Nitrosell application, you may want to consult with the company that sold you this solution. Usually not all your inventory items will be available for sale on your web site, but I'm not sure how Nitrosell interacts with the web item flag...

Anyway if your partner approves using a sql query, BACKUP YOUR DATABASE FIRST, then you can run

update item set webitem = 1

I would recommend us> Is there a way to do a mass update to change item properties to enable the

Reply to
convoluted

My day job is a database marketer, so I'm very familiar with SQL. (My retail store is what I do the rest of the time.) Thanks for the prompt response, and I'll give it a whirl!

Reply to
Julie

NitroSell has a tool called the Product Attribute Manager (PAM) that helps with this also. The query of course is fine, but the PAM allows you to use filters to parse down the inventory so you can make speciufic sub-sets available online. It of course is useful for other edits as well. Give us a call or submit an entry on our website if you would like to hear / see more.

Regards, Todd

formatting link

Reply to
Todd

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.