There are three ways to input your price information for your products:

1. Defining the packaging and price in the Product Packaging Setup
2. Editing the product price page by page throughout the CD catalog
3. Editing and importing (Load) a .csv file (MS Excel). This option is recommended only for advance users of CD Shopping Cart.

6.1 Customizing Price Information in Product Packaging Setup

Defining your price information in the Product Packaging Setup is the simplest and fastest method if all of the products in your CD Catalog share the same packaging type and price, e.g., in a CD catalog that offers photographs of varying sizes for customers to order. By simply defining each size of photograph as one package, setting a price to it, and applying it to the entire CD catalog, you do not have to flip to every single page of your CD catalog to price each and every single photograph.

6.2 Customizing Price Information Page by Page

Alternatively, you may set your each individual product price by flipping through the CD catalog and capturing it page by page. This is recommended if you have a variety of products in your CD catalog that do not share the same packaging type or price, e.g., in a typical mail order gallery. When your customer performs an Add to Cart function on each page, only the products with prices that have been defined on that page will be presented to the customer for order.

6.3 Creating a Price Information List

For CD catalogs with a large quantity or variety of products with individual prices, you may find it easier to edit your price information on a .csv file using MS Excel. You can perform an auto-update of the price for each and every single product in your CD catalog simply by exporting the price information list to a .csv (MS Excel) file, updating the price information in it, and importing (Load) it back to CD Shopping Cart.

A sample of your price information list in MS Excel is shown in Fig 6-3-2.

Fig 6-3-1 Export Price Information

With MS Excel, open the price list (.csv) that you have just exported. You should operate on only two columns - the ID and the Price columns. Use the Page Index column to guide you on which pages you are updating and Page Name and Packaging on the range of products (if more than one) on that page. Ignore the other columns.

Once you have entered the necessary ID and Price information, your table may now look like the sample in Fig 6-3-2. Once you have updated the ID and Price columns, save your price list (.csv file). Return to CD Shopping Cart and import the list by clicking Tools on the menu bar, selecting CD Shopping Cart and clicking Import Price List.

Fig 6-3-2 Sample Price List in CSV Format