How can we help?

You can get to this part of the system by going to Inventory > Products.

 

Editing Products in Bulk

You can quickly and easily apply changes to your selected products with this tool. For example, here is how you can set a Sale Price for a large selection of items: 

 

Please note: For this particular action the Scheduled Sale tool under the Marketing menu will be much more efficient, as it will remove the sale prices once the event is over. But this serves as an excellent example of what you can do with our Bulk Edit tool.

 

1. First, you could use a Filter search for the category you want (or department, or you can search by keyword), which will load all of those products into the Products window.

2. Click the Select All button (the topmost check-box on the left, above your product list), and that would ready all of those items for the bulk change you want.

3. Click the Bulk Actions button.

4. Click the drop-list for the attribute you want (Sale Price is in the lower section) and click on it. See the image below this section for Bulk Edit Product Options for the full list.

5. Click the small drop-list next to Sale Price and set your preference on what type of Sale Price will be applied.

   

6. Set either the Percentage (pictured above) or the Dollar Amount you are setting for the Sale Price adjustment.

7. Set what the Sale Price will be Calculated From. You can choose whether it will be based on the Default Cost of the item (if you do this, it's wise to make sure you have Default Cost values saved in the products you're editing or no changes will be made to the Sale Price, note that this is different from the standard Cost values for your products). You can base it on the regular selling Price, or on an existing Sale Price. Again, if there is no Sale Price in place, no changes will be entered for the product.

   

8. Set how Rounding will be handled in the change to your Sale Prices. You can set to have No Rounding, you can Round Up, Round Down, or Round Nearest. In the latter three cases, you can specify if you're rounding in any of those ways to a certain amount of cents. There's an example you can see in the images here of how it can apply, but basically, let's say that your Sale Price edit on an item would have made a resulting Sale Price of $4.77. If you have that set to Round Up and set the amount to $0.05 (5 cents), it would result in a Sale Price of $4.80. If you have it Round Down and set $0.05 (5 cents), it would be $4.75. Or if you want everything to be set to sell for '$x.99', Round Nearest is what you would use with the amount of $0.99 (99 cents), and the Sale Price, in this case, would round to $4.99. It's a good idea to play with this with a few differently priced products to see how the pricing goes in with these different options, just until you get used to how it works.

   

9. Once you have your settings in place, click the Save button.

   

10. You can, if you like, click another product attribute in the drop-list if you want to adjust something else for all of the products selected. A common one in this case would be to add them all to the Sale Price category. In the line item for each of the Pending Changes, on the right there is a small options button (the stack-of-three-dots button, below) that will allow you to either Edit or Delete the change. If no further changes are needed, click the green Update Products button to put your edits in place for all the products. When making edits to large numbers of products, a progress indicator will pop up for you.

    

Changes cannot be undone, so if you select all items in an entire Department and set them all to have their Availability be for Both website and point of sale, then later realize you need some of them to be POS Only, you would have to find all of those products and change them to that status.

It's a good idea when trying new Bulk Edit changes to try it out first with a single product to make sure it does what you think. Once you're sure of how it will work, applying the same edit to large numbers of products will be safe.

For a full list of detailed changes you can make in this area, please click here: Bulk Product Actions: Barcode Labels, Bulk Product Editing, and Bulk Product Export / Import.

Here is a list of the different attributes you can adjust: