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.
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 Manage next to the Quick Shopping Cart account you want to modify.
- From the Manage menu, in the Catalog section, click Updates & Exports.
- From the Products tab, click Download, and then select one of the following:
- Full — Displays all product information that you can update.
- Quick — Displays only the required fields to perform an update, as well as the products' categories.
NOTE: If you select the Quick option, you must use that template for both the import and export. For example, you cannot export a quick template, and then import that quick template using the Full import feature.
- Select whether to open or save the Excel file, and then click OK.
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 Manage next to the Quick Shopping Cart account you want to modify.
- From the Manage menu, in the Catalog section, click Updates & Exports.
- From the Products tab, click Export, and then select one of the following:
- Full — Displays all product information that you can update.
- Quick — Displays only the required fields to perform an update, as well as the products' categories.
- Select whether to open or save the Excel file, and then click OK.
- Depending on whether you selected Full or Quick, 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. If you need to make changes to categories including associating products, Export a template from the Category Assignments tab.
- 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.
- Hide — Hidden 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 Manage next to the Quick Shopping Cart account you want to modify.
- From the Manage menu, in the Catalog section, click Updates & Exports.
- Click Import, and then select either Full or Quick.
- Click Browse to locate and open the file, and then click Import.
- Publish your site for the storefront to reflect your changes.