Using Excel to Update Your Quick Shopping Cart Product Catalog
Using the provided Microsoft Excel® spreadsheet template, you can add, modify, and delete products in your Quick Shopping Cart® site. To get started, you must first download the template. If you already have products in your catalog, you can Export to download your existing catalog. You cannot use another Excel spreadsheet or file format to upload products.
To Download the Excel Spreadsheet Template
- Log in to your Account Manager.
- In the My Products section, click Quick Shopping Cart.
- In the Quick Shopping Cart list, click Open next to the Quick Shopping Cart account you want to modify.
- From the Manage menu, in the Catalog section, click Update.
- Click Download, and then specify where you want to download the file.
NOTE: If you need to make changes to categories including associating products to categories, use the Category Assignments tab.
Editing the Excel Spreadsheet Template
Use this spreadsheet to modify any details of the products you would like to update. You can also add new products or remove existing products.
NOTE: You cannot add products that already exist.
Action — Options are Add, Modify, or Delete.
Part Number — The product's part number. This number must be unique from all products.
Manufacturer Name — The name of the product's manufacturer. The listed manufacturers are the ones you set up in your catalog.
Title — The title of the product as it appears in your catalog.
Short Description — A brief description of the product for the product preview.
Long Description — A detailed description of the product for the product details page.
Category — The category with which you want to associate the product. The listed categories are the ones you set up in your catalog.
NOTE: When modifying a product, you cannot change the Category associated with it.
Cost — The amount the product cost you to purchase.
List Price — The amount you are charging for the product.
Shipping — Shipping for the product.
Weight — The product's weight.
Length — The product's length.
Width — The product's width.
Height — The product's height.
Featured — Featured products appear on the main category page.
Discontinued — Discontinued products no longer display on the storefront.
Inventoried — Inventoried products are in stock and will ship immediately.
Allow Backorder — Users can backorder product when the inventory runs out.
Inventory Quantity — The number of products you have to sell.
Inventory Threshold — The number of products remaining at which you want to be notified of quantity remaining.
Ships In Own Package — The product ships in its own package.
Importing the Excel Spreadsheet Template into Quick Shopping Cart
After you have made edits, you need to import the spreadsheet to update your store.
To import the Excel Spreadsheet
- Log in to your Account Manager.
- In the My Products section, click Quick Shopping Cart.
- In the Quick Shopping Cart list, click Open next to the Quick Shopping Cart account you want to modify.
- From the Manage menu, in the Catalog section, click Update.
- Click Import and in the Upload Products window, click Browse to locate and open the file.
- Click Upload Products.
You must publish your site for the storefront to reflect your changes.