Home Guides Glossary

Using Excel to Modify Your Category Assignments

After you have created Categories in your Quick Shopping Cart®, you can use this Microsoft Excel® spreadsheet to make bulk changes and assign products to one or more category or subcategory.

Download the Excel Spreadsheet Template

  1. Log in to your GoWebsite account.
  2. Click Quick Shopping Cart.
  3. In the Quick Shopping Cart list, click Manage next to the Quick Shopping Cart account you want to modify.
  4. From the Manage menu, in the Catalog section, click Updates & Exports.
  5. Click Category Assignments.
  6. Click Export, and then specify where you want to download the file.

Editing the Excel Spreadsheet Template

You can use this spreadsheet to select and modify categories for products. Action and Category are the only fields that can be edited. To assign a product to multiple categories, simply add that product on a new line and select a different Product Category.

NOTE: To add, delete or modify products you must use the Products spreadsheet.

Action — Options are Keep, Add, or Remove.

Part Number — The product's part number. This number must be unique from all products.

Title — The product's title in the catalog. The Title cannot be updated in this spreadsheet.

Category — The Category with which the product is associated. The listed categories are the ones you set up in your catalog.

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

  1. Log in to your GoWebsite account.
  2. Click Quick Shopping Cart.
  3. In the Quick Shopping Cart list, click Manage next to the Quick Shopping Cart account you want to modify.
  4. From the Manage menu, in the Catalog section, click Updates & Exports.
  5. Click Category Assignments.
  6. Click Import and in the Upload Category Assignments window, click Browse to locate and open the file.
  7. Click Upload.

You must publish your Website for the storefront to reflect your changes.

Domain Registration

Pay less for website domain names. Register your own .com, .net or .org for as low as $10.18 per year. We have everything you need to get online with your new domain.

Website Builder

Build an amazing website in just under an hour with Website Builder. Take advantage of designs created just for your industry and then customize them to reflect your one-of-a-kind idea.

Website Security

Protect your website and keep customers safe. Your comprehensive Website Security solution. Get peace of mind by securing your websites.

cPanel Hosting

Everything needed to give your website the high-performance home it deserves.  Protect transactions and secure your customer's data with a SSL Certificate
Copyright © 2005 - 2024.  All rights reserved.  Privacy Policy