Importing products into Quick Shopping Cart

Posted by Tony at 12/11/2006 9:00 AM
Categories: Power Tips, Meet the Team

Hello , my name is Tony. I am a Java Developer on the Quick Shopping Cart® team. I have worked for Go Daddy® for two years as a Java Developer and have been on the Quick Shopping Cart development Team for the last 6 months. In the last 6 months I have learned much about this product and E-Commerce in general and I look forward to sharing this knowledge.

I have been a software engineer in Phoenix for the last 8 years and have coded in Java for the last 4 years. Before Java, I mainly worked in C/C++ on Unix platforms. Beside a degree in CS, I also have a degree in History from Arizona State University and at one time considered becoming a History Professor.

I look forward to hearing any and all comments sent to us as that will help us to improve this product into a best in class Shopping Cart. Please fell free to contact us via email, blog or telephone and let us know what you think of our product as well as what we can do to improve Quick Shopping Cart.

One of the requests we have received is a better explanation of how to Import Products via the Excel® Spreadsheet provided by Quick Shopping Cart. The following is an explanation of how to do this.

Importing Products into Quick Shopping Cart

Quick Shopping Cart allows you to use a Excel spreadsheet to add, modify, and delete products from your catalog. To import your product catalog, you must use the provided template. You cannot use other file formats or Excel spreadsheets to upload your products. The following is a detailed set of instructions for importing products. 

  1. Log in to Quick Shopping Cart.
  2. If you plan to add new products, use the Catalog Manager to create the categories you will be using.
  3. From the Catalog menu, click Import/Export Products.
    The Catalog Manager window displays.
  4. Click Export Products.  Open the Excel file.
  5. From the Action list, select to Add, Modify, or Delete a product.
    NOTE: You cannot add a product that already exists, and you cannot modify or delete a product that doesn't exist.
  6. In the Part Number column, specify the Part Number for the product. The Part Number must be unique, and is required.
  7. From the Manufacturer Name list, select the name of the manufacturer. Only the manufacturers you set up in your catalog are available.
  8. In the Title column, specify the product title.  The Title is required.
  9. In the Short Description column, specify a short description of the product. The Short Description is required.
  10. In the Long Description column, specify a long description of the product. The Long Description is required.
  11. From the Category list, select the category name that you want to associate the product with.  NOTE: When modifying the product, you cannot change the Category.
  12. In the Cost column, specify the product's cost.
  13. In the List Price column, specify the price you want to list the product at. The List Price is required.
  14. To indicate you do not charge shipping for the product, select No.
  15. To indicate you do charge shipping for the product, from the Shipping list, select Yes, and then complete the following:
    1. In the Weight column, specify the product's weight, if any. This must be a numeric value containing two decimal points e.g. 12 3/4 lbs converts to 12.75.
    2. In the Length column, specify the product's length, if any. This must be a numeric value containing two decimal points e.g. 1'6 3/4" converts to 18.75.
    3. In the Width column, specify the product's width, if any. This must be a numeric value containing two decimal points e.g. 1'6 3/4" converts to 18.75.
    4. In the Height column, specify the product's height, if any. This must be a numeric value containing two decimal points e.g. 1'6 3/4" converts to 18.75.
  16. From the Featured list, specify whether or not you want to feature this product on your category pages.
  17. From the Discontinued list, specify whether or not the product has been discontinued. Items that are discontinued will not display on your storefront.
  18. To indicate the product is not being tracked as inventory, from the Inventoried list, select No.
  19. To indicate the product is being tracked as inventory, from the Inventoried list, select Yes, and then do the following:
    1. From the Allow Backorder list, specify whether or not you want customers to have the ability to "back order" the product.
    2. In the Inventory Quantity column, specify the current inventory quantity.
    3. In the Inventory Threshold column, specify the threshold you want to use as a trigger for sending you an email notification about the inventory level.
  20. To indicate that the product always ships in its own package, select Yes.
  21. Save the Excel file.
  22. Return to the Quick Shopping Cart window.
  23. If necessary, return to the Catalog Manager window. Access the window from the Catalog menu by clicking Import/Export Products.
  24. In the Import File field, click the Browse button.
  25. Locate and open the Excel file, and then click Upload Products.

To update your storefront with the changes, publish your storefront.

 

What did you think of this article?




Trackbacks
Trackback specific URL for this post
  • No trackbacks exist for this post.
Comments
Display comments as (Linear | Threaded)

  • 12/12/2006 4:55 AM Pat wrote:
    I like the shopping cart programs thus far but found a major hang up in your upload process is that no pictures are uploaded with products. I just ran my database uploaded several thousand products but will have to go back and put pictures in for each one. When uploads are done pictures need to be included. Thus helping keep inventory current and the upload time to a minimum. Thank you.
    1. 12/12/2006 6:16 PM Greg wrote:
      Pat,

      Unfortunately right now there is no way to reference images with the Product Import Process.  A bulk image upload feature is on our roadmap for future development, and the Product Import  Process will be enhanced to take advantage of the new feature.

      Thanks for writing,

      Greg
  • 12/13/2006 7:08 AM Tom wrote:
    Hi you know i have about 2000 product to import. I have played with importing them a little bit. My question is does anyone provide a service to do this? It would save alot of time and grief. Tks Tom
  • 12/18/2006 3:48 PM Sandra wrote:
    A while back, I tried the import an export functionality and found that all the fields can not be imported/exported, which is extremely important.

    This article does not mention that fact, which is a glaring problem. If this is still true, then a note should be included about this and the reason why, as well as the list of fields missing.

    If it is no longer true, that should be pointed out as well.
    1. 12/22/2006 3:30 PM Tony wrote:

      Sandra,
         Thank you for taking the time to post a comment on our blog. At this time, the following fields are not available for Import/Export. They are, Product Type, Sale Prices, Addition/Deletion of categories, Images, Attributes, Options and Product Associations. At this time we do not have support, in our Import/Export process, for fields with multiple values. We have however, added this to our development roadmap and are investigating solutions to this problem.

      Thank You for you comments
      Tony Anter


  • 12/18/2006 7:49 PM Jun Cheung wrote:
    Not only the pictures upload is a major hassle when dealing with thousand of items...Also the process of modifying each item's option settings indiviually. Is there anyway to apply them in bulk? Please let me know. Thanks.
    1. 1/30/2007 4:00 PM Rob wrote:
      Hi Jun

      Sorry to say, not at this point in time.  It is something that has been brought up by other customers and we are looking at our options on the best way to accomplish this.

      Thanks for the contribution.
      - Rob
  • 12/21/2006 3:51 PM Jun Cheung wrote:
    There are too much manual processes here. The manual uploading of pictures, editing of advanced option pricing, changing of categories. Please have these automated and make them as simple as possible. It took me fews days to make these changes and I only have 157 items currently.
    1. 1/30/2007 4:04 PM Rob wrote:
      Hi Jun

      This is something that has been brought up by other customers and we are looking at our options on the best way to accomplish this.

      Thanks for the contribution.
      - Rob
  • 12/21/2006 8:55 PM Jeff Carpenter wrote:
    This service needs to have custom post-sale pages that we can edit, to provide our customers with additional information and instruction post-sale. We also need to be able to insert custom HTML code on the post-sale page so that we can insert affiliate marketing code on the post-sale page for tracking purposes.
    1. 1/30/2007 4:08 PM Rob wrote:

      Hi Jeff

      To your first comment, this is something that has been brought up by other customers and we are looking at our options on the best way to accomplish this.

      To your second comment, you can enter Google and Yahoo conversion tracking codes under the Site Promotions drop down from your Admin site.

      Thanks for the contribution.
      - Rob

       


  • 12/26/2006 11:35 PM Stephen wrote:
    I need to be able to sell to my customers in Canada and UK. Quick shopping cart only supports sales to USA address and customers. When will foreign sales be enabled?
    1. 1/30/2007 4:15 PM Rob wrote:

      Hi Stephen

      There is currently a workaround that enables you to ship to Canada if you have Custom Shipping and PayPal.  As for international, that is something that is on our roadmap and we are evaluating our options on how to best accomplish this.

      Thanks for the contribution.
      - Rob


  • 1/7/2007 11:06 PM Cindy wrote:
    Iam inquiring on how to keep track of products that come in different sizes or colors. How do we keep track of the "sizes" of the same product as we sell them.
    There is no inventory "size" option for those products that come in different sizes and we need to know this.
    Thank you
    1. 1/30/2007 4:44 PM Rob wrote:

      Hi Cindy

      Currently we do not support the tracking of inventory on options.

      Thanks for the contribution.

      - Rob


  • 1/24/2007 5:41 PM phil wrote:
    Your advice Tony is useless. Like any ebook or software publisher all my products are downloaded and you omit this feature from your discussion. Currently, any attempt to modify catalog description erases the location of the download. Does your method solve this problem?
    1. 2/2/2007 11:29 AM Tony wrote:
      Phil, thank you for your comments. You can download and modify digital products using the import process just like any other product on your site. I would be curious to know the specific steps you are using when modifying the catalog description for your product(s). I have attempted to duplicate the problem you are describing in your reply but I am unable to duplicate it when changing the description for a digital product. Both the link to the product, the product itself and the download page all remained intact after modification and publishing. Please post the specific steps you used to achieve this error so I can research this further .

      Thanks
       Tony

  • 1/25/2007 7:28 PM drew carlino wrote:
    how do i add a hyper link to my shopping cart to go back to my web sites home page ?
    1. 1/31/2007 4:13 PM Rob wrote:

      Hi Drew

      Currently there is no formal place for a link/button, but as a workaround you could add it in the html in your welcome message (you find that under Storefront | Welcome Message).

      Thanks for your contribution.
      - Rob


Leave a comment

Comments are closed.