Using Templates to Update Your Product Catalog in Quick Shopping Cart
Quick Shopping Cart® lets you use Microsoft® Excel® spreadsheet templates to add, modify, and delete products in your catalog. You must first download a template. If you already have products in your catalog, you can export your existing catalog to Excel. You cannot use another Excel spreadsheet or file format to upload products.
For updates from the Products tab, Quick Shopping Cart lets you select either Quick or Full options for downloading, importing or exporting. The Quick option produces a template that displays only the required fields to perform the update, as well as the products' categories.
If you select the Quick option, you must use that template for both the import and export. For instance, you can't export a quick template, and then import that quick template using the Full import feature.
Downloading a Template for Quick Shopping Cart
Quick Shopping Cart lets you download an Excel spreadsheet you can use to edit your product catalog.
To Download a Template for Quick Shopping Cart
- Log in to your Account Manager.
- Click Quick Shopping Cart.
- In the Quick Shopping Cart list, click Launch next to the Quick Shopping Cart account you want to modify.
- From the Manage menu, in the Catalog section, click Updates & Exports.
- From the tab associated with the part of your catalog you want to update, click Download. A window displays.
- Select whether to open or save the Excel file, and then click OK.
NOTE: If you need to make changes to categories including associating products to categories, download a template from the Category Assignments tab.
Editing a Template for Quick Shopping Cart
Edit the template spreadsheet to update your product catalog. You can also add new products or remove existing products.
NOTE: You cannot add products that already exist.
To Edit a Template for Quick Shopping Cart
- Log in to your Account Manager.
- Click Quick Shopping Cart.
- In the Quick Shopping Cart list, click Launch next to the Quick Shopping Cart account you want to modify.
- From the Manage menu, in the Catalog section, click Updates & Exports.
- From the tab associated with the part of your catalog you want to update, click Download. A window displays.
- Select whether to open or save the Excel file, and then click OK.
- Depending on the template you selected, on the Excel spreadsheet you can edit these fields:
- 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 those 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.
- Save the template.
Importing a Template for Quick Shopping Cart
After you have made edits, you need to import the spreadsheet to update your store.
To Import a Template for Quick Shopping Cart
- Log in to your Account Manager.
- Click Quick Shopping Cart.
- In the Quick Shopping Cart list, click Launch next to the Quick Shopping Cart account you want to modify.
- From the Manage menu, in the Catalog section, click Updates & Exports.
- Click Import. The Upload Products window displays.
- Click Browse to locate and open the file, and then click Upload Products.
- Publish your site for the storefront to reflect your changes.