Saturday, July 23, 2011

Quickly Put A Brand Or Category On Sale In Big Commerce

With the lack of a built-in sale function in Big Commerce many new users have a difficult time putting a group of products on sale, resorting to changing prices one at a time or downloading a full Bulk Edit CSV and picking through it one by one. Here's how to get that brand or category on sale quickly:
  1. Copy the Bulk Edit export template to create a custom export template that contains only the fields you need. This would be Product Name, Category, Sale Price and any other price fields (retail, cost or selling price) that you may want to base your sale price on. You can also uncheck the "Yes, include product options in the products export" box unless you really need the options in the export - you can't put an option sku on sale, you can only change a fixed price. Note that I also include Product ID in all my custom exports even though it is technically not required unless you are changing the product name.
  2. Next go to Products > Search Products and select only the criteria you want to put on sale (Brand, Category, everything over $100, whatever).
  3. Export the search results using your custom export template.
  4. Add sale prices based on any formula or enter the price directly into the Sale Price field.
  5. Re-import the csv (check the box "Yes, I exported this file using the 'Bulk Edit' template").
There you have it, your brand, category or other product group on sale.