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.

Thursday, July 14, 2011

Display Single Item Price When Selling Package Quantities in Big Commerce

We've been seeing a lot of Big Commerce users wondering how to display the single unit price of a product when the product only comes in package quantities. Here's one technique to accomplish this that can also be used to add a setup or handling fee that is not included in the advertised price.
  1. Create a multiple choice Option that contains the package quantities available (or a single choice for the setup fee). Setting a default here will multiply the price automatically as soon as the product page is displayed. It's probably best to have no default so the single unit price displays until the user checks an option - shopping comparison sites may disqualify your products if they audit your site and see a different price on the page.
  2. Create an Option Set and add the Option, making it mandatory.
  3. Here you need to make a decision. We need to set up rules to change the price for each package quantity. If rules can be created in the Option Set that will apply to all products this will keep maintainance simple and is the best choice. If the package quantities cannot be based on a formula then the rules need to be created within each product.
  4. Add the Option Set to each product that is sold in package quantity only.
Here's a video to demonstrate (sorry for the crappy audio):
Unable to display content. Adobe Flash is required.