Print Page | Close Window

Make Inactive Multiple Products

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=6162
Printed Date: 24-November-2024 at 1:15pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com


Topic: Make Inactive Multiple Products
Posted By: MGatESS
Subject: Make Inactive Multiple Products
Date Posted: 14-June-2019 at 3:11pm
Have v5.2.10, running MSSQL database.

Need to bulk de-activate (make inactive) 173 products.  Tried exporting all of the products I want to update, imported it into Microsoft Excel 2007, made the changes, saved as .xls, then when importing into ProductCart, it gave an error that it was trying to import images and they exceeded the size limit of ProductCart import wizard.  I have no images I want to import, just make inactive over 100 products.

I do not do this on a regular basis, so can anyone instruct me as to how I can just change the field "Active" from "-1" (active) to "0" (inactive) on multiple products?  Can I export just key fields such as product ID, SKU and "Active" field status, then upload THAT to deactivate those specific products?  Will it mess up the database/products if I do that?

Please let me know.  Thank you.


-------------
~ Mark G.

ESS, Inc. - http://www.endoscopy.com/" rel="nofollow - www.endoscopy.com



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.04 - http://www.webwizforums.com
Copyright ©2001-2021 Web Wiz Ltd. - https://www.webwiz.net