What fields are required for the Import Products spreadsheet?
Print this Article
Comment on this Article
Last Updated:
February 26, 2009 2:35 PM
Using the provided Excel spreadsheet template, you can add, modify, and delete products in your product catalog on your Quick Shopping Cart site. You cannot use another Excel spreadsheet or file format to upload products. The required fields are:
- Action
- Part Number (SKU)
- Title
- Short Description
- Long Description
- List Price
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 Catalog menu, click Import/Export Products.
- Click Download Templates, and then specify where you want to download the file.
NOTE: If you want to modify category information in Quick Shopping Cart, you should modify it after you finish importing your data.
To Edit the Excel Spreadsheet Template
- Open the Excel spreadsheet you downloaded.
- 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, and you cannot modify or delete a product that does not exist.
- Action
- Select whether you want to Add, Modify, or Delete a product.
- Part Number
- Specify the product's part number. This number must be unique from all products.
- Manufacturer Name
- Select the name of the product's manufacturer. The listed manufacturers are the ones you set up in your catalog.
- Title
- Specify the product's title.
- Short Description
- Enter a short description of the product.
- Long Description
- Enter a longer, more detailed description of the product.
- Category
- Select 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
- Enter the amount the product cost you to purchase.
- List Price
- Specify the amount you are charging for the product.
- Shipping
- Specify whether or not you charge shipping for the product.
- Weight
- Enter the product's weight.
- Length
- Enter the product's length.
- Width
- Specify the product's width.
- Height
- Specify the product's height.
- Featured
- Specify whether or not you want to feature this product on your category pages.
- Discontinued
- Specify whether or not the product has been discontinued. If you discontinue a product, it no longer displays on your storefront.
- Inventoried
- Specify whether or not you are tracking the inventory for this product.
- Allow Backorder
- Specify whether or not you allow customers to backorder this product when the inventory runs out.
- Inventory Quantity
- If you selected to track your inventory for this product, specify the current number of items you have in stock.
- Inventory Threshold
- If you selected to track your inventory for this product, specify the threshold at which you want to receive an email notification telling you the inventory is low.
- Ships In Own Package
- Specify whether or not the product ships in its own package.
- Click Save.
To Import the Excel Spreadsheet Template into Quick Shopping Cart
- 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 Catalog menu, click Import/Export Products.
- 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.