ProductCart Shopping Cart Software Forums : Mapping data fields from excel https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 04:26:10 +0000 Mon, 12 Jul 2010 09:05:28 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=3844 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Mapping data fields from excel : I have not given up ship yet,...]]> https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14923.html#14923 Author: postcarddepot
Subject: 3844
Posted: 12-July-2010 at 9:05am

I have not given up ship yet, but rather trying to manipulate our database and forms to make it work. With hundreds of thousands of inventory items (close to a million sitting here in my office!) the database was custom designed to make the data entry as fast/easy as possible.
 
As of now I am down to 9 absolute fields that I need to carry over from the database.
 
There is a slight possibility that i have some friends who *could* possibly tweak the code for me if necessary, but I am trying to see  if it can be done without tweaking. I'm quite honestly tired of having to depend on others. That was why I was looking for an out of the box product for me.
 
I'm back to playing with the sample website after a good night's sleep and a new perspective on things. Thanks again for the help!
 
Stacey
]]> Mon, 12 Jul 2010 09:05:28 +0000 https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14923.html#14923 <![CDATA[Mapping data fields from excel : Got it. Yes, importing 30 Custom...]]> https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14921.html#14921 Author: ProductCart
Subject: 3844
Posted: 11-July-2010 at 9:15pm

Got it. Yes, importing 30 Custom Search Fields would be time consuming with the way the Product Import Wizard is structured at the moment, and a modification to that feature would probably be necessary to avoid performing the import task multiple times (it would have to be performed 10 times to import or update 30 Custom Search Fields).

We'll look at a way to make this dynamic in a future release.

Thanks for your feedback.
]]> Sun, 11 Jul 2010 21:15:34 +0000 https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14921.html#14921 <![CDATA[Mapping data fields from excel : FYI, in a PM she asked for 20-30...]]> https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14919.html#14919 Author: Greg Dinger
Subject: 3844
Posted: 11-July-2010 at 9:07pm

FYI, in a PM she asked for 20-30 custom fields.]]> Sun, 11 Jul 2010 21:07:38 +0000 https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14919.html#14919 <![CDATA[Mapping data fields from excel : Stacey,Greg is very experienced...]]> https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14917.html#14917 Author: ProductCart
Subject: 3844
Posted: 11-July-2010 at 9:00pm

Stacey,

Greg is very experienced with ProductCart, but we're afraid some of the information provided above might be misleading (or we misunderstood it).

You can certainly import custom fields. They simply need to be setup as "Custom Search Fields". The column name in your spreadsheet must match the name of the field in the ProductCart database. The Import Wizard will take care of the rest.

For more information about importing Custom Search Fields, please see:
http://wiki.earlyimpact.com/productcart/products_import#importing_custom_search_fields

The only limitation is that you can only import 3 custom search fields at a time. The workaround is to import products, then update them with a second import, and that can be done rather quickly.

Taking the example above, the first import will include any product information you wish to import, and the following 3 columns:

Publisher
Distributor
PM_Type

... which will match 3 Custom Search Fields in the ProductCart database.

The second import simply needs to contain the Product SKU (part number) to match the data that already exists in the database, and the following 3 columns:

Card_Type
Card_Country
Card_State

ProductCart will update the existing products (matching each product via the SKU) and will add those additional Custom Search Fields.

Just make sure that the column names match the names of the field. So, for example, if you create a Custom Search Field called "Type of Card", then the column name in your spreadsheet will be "Type of Card" and not "Card_Type".

We hope this helps!
]]> Sun, 11 Jul 2010 21:00:59 +0000 https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14917.html#14917 <![CDATA[Mapping data fields from excel : That&#039;s unfortunate. PC is...]]> https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14916.html#14916 Author: Greg Dinger
Subject: 3844
Posted: 11-July-2010 at 8:52pm

That's unfortunate.  PC is excellent stuff.  Making a decision around choosing to abandon the cart because it does not accomodate industry-specific data is probably going to lead you to few choices.  Hope you change your mind.]]> Sun, 11 Jul 2010 20:52:35 +0000 https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14916.html#14916 <![CDATA[Mapping data fields from excel : Thanks for the assistance, but...]]> https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14915.html#14915 Author: postcarddepot
Subject: 3844
Posted: 11-July-2010 at 8:42pm

Thanks for the assistance, but that makes this software too costly for me, to have to pay for something in addition to what comes out of the box.  Back to my google searches for another software. Thanks, this software looks great just won't work for my needs
 
Stacey
]]> Sun, 11 Jul 2010 20:42:42 +0000 https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14915.html#14915 <![CDATA[Mapping data fields from excel : Regarding your question, yes,...]]> https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14914.html#14914 Author: Greg Dinger
Subject: 3844
Posted: 11-July-2010 at 8:21pm

Regarding your question, yes, the only way to add new fields to the import/export tools is to dig into the code.  And the code is far from simple. 

Here is an example.  At the URL below, we have introduced a field that represents a number of "stock staus" settings.  We altered the import tool to accomodate that new field.  When the client receives a "current inventory" listing from his vendor, he updates a bunch of products in an XLS file, and performs a bulk update using the import tool.
http://www.sierratoysoldier.com/ourstore/pc/viewPrd.asp?idproduct=8482
]]> Sun, 11 Jul 2010 20:21:51 +0000 https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14914.html#14914 <![CDATA[Mapping data fields from excel : Well since I flooded the category...]]> https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14913.html#14913 Author: postcarddepot
Subject: 3844
Posted: 11-July-2010 at 7:44pm

Well since I flooded the category list with over a couple thousand categories, it might be a good time for the database to be refreshed.

 
So am I correct in understanding that there is no way (without going into the code) to create these fields myself? The import tool works fine for me, I just need more fields in that drop down list.
 
Thanks for the help!
 
Stacey
]]> Sun, 11 Jul 2010 19:44:22 +0000 https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14913.html#14913 <![CDATA[Mapping data fields from excel : The product import tool is rigid,...]]> https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14912.html#14912 Author: Greg Dinger
Subject: 3844
Posted: 11-July-2010 at 7:06pm

The product import tool is rigid, and provides no functionality for introducing custom fields other than rolling up your sleeves and digging into the code. If that is out of your skills, and provided that this is not a show stopper for you, my team has experience altering that import tool and we would be happy to assist you with the alterations. 
 
As for the work you are performing against the test store, those changes are public.  However, EI does occasionally refresh the database so it's not going to be there forever.
]]> Sun, 11 Jul 2010 19:06:25 +0000 https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14912.html#14912 <![CDATA[Mapping data fields from excel : Hi folks! I&#039;m a newbie here,...]]> https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14911.html#14911 Author: postcarddepot
Subject: 3844
Posted: 11-July-2010 at 6:51pm

Hi folks! I'm a newbie here, and debating purchase of this software. Been playing with the demo site all afternoon.
 
I have an access database which I am exporting to excel to upload to this software. I have fields that I need to custom map, but i am not sure where exactly to go to add them properly to the "ProductCart database fields"
 
For example, I want to create "ProductCart Database Fields" for the following fields that I have in my excel file, so that they will match up:
 
Publisher
Distributor
PM_Type
Card_Type
Card_Country
Card_State
 
 
((basically how do I create more options to show up under the "to" drop down on this pafge of the sample site https://www.earlyimpact.com/demos/standard/pcadmin/step2.asp))
 
 
Right now, I imported a product list, and have these items showing in the left column as "From" but nothing to map them to on the right column.
 
Also, this is a silly question I know, but are all of the "things" I have done to the sample cart visible only to me to or everyone? I stupidly uploaded a rather large category list, do I need to delete them all or are they viewable only on my end?
 
Thanks for the help
]]> Sun, 11 Jul 2010 18:51:52 +0000 https://forum.productcart.com/mapping-data-fields-from-excel_topic3844_post14911.html#14911