I have an online store with a hosting provider and it works exactly like we are describing. I can set up a csv file for all the new items I need to import and it does it seamlessly. I hope this will some day have that functionality.

Scott, don't want to beat this one to death (well, maybe I do ).

I have a "shop" where I manage product information. It's just a SCC pro file that contains all my product information. I changed a price on one of the products and then exported the entire product set as an .CSV file. Let's call it "MasterFile.CSV"

I have another shop that's a real online shop. We'll call the store "OnlineStuff". It contains all the products that are in the "MasterFile".

I opened "OnlineStuff" in SCC Pro. Keep in mind it's an existing store. I then imported "MasterFile.CSV". All the products imported perfectly and I could see the one product where I had changed the price in the "MasterFile". The price changed as a result of the importing of the .CSV file. I then published "OnlineStuff" to the web it everything uploaded perfectly.

So what am I missing? I've been using the import/export facility just as I've described for several weeks but you're telling it can't be done.

I guess I stand corrected. It appears that enhancement was already in place.

Scott ... thanks. I thought I was really missing something.

I am having difficulty with the EXACT format this CSV file needs to be. I have an excel spreadsheet with very particular columns and titles. Has anyone got an easy way to configure a current excel database into the format SCCP requires for import.
Am I correct in thinking each field of a spreadsheet is separated by a "C" when saved into a csv? Or do I have to reconfigure the spreadsheet into a txt file and create each line of product information to exactly be in the order in which SCCP needs to import the operation. I would be curious to see someone's actual working file which they have imported into the Cart.

Ed ... the way I learned the correct format was to put products into SCCP Pro manually. Put in 10 or so products in various categories with various fields filled out. Then do an export to .CSV. The output file will give you insight into what the CSV needs to look like.

Hope this helps.

Jerry or anyone else.....

I'm not getting the hang of this at all. I have a CSV file which has all the data in individual cells. With the exact headers Coffee Cup expects of the data to have. If I export a Test file to see what is exported and in theory what the program wants imported, then I see a file that has all the columns condensed into one cell and each item separated by a ;.
If this is to work, then I assume all my columns need to be condensed into one cell and each field be separated by a ;. (Which is silly in my opinion, seeing that spreadsheets don't work this way. I am confused as to why the software is so particular about this import and export setup)
Is there a way to take all of my existing spreadsheet information and condense it into one cell separated by ; as the software insists to work.

I am attaching my examples.....
Test_Shop is what Coffee Cup seems to want (and is how it exports the data)
Test_Tessiers is what I have to work with and will have other data to work with which I would like to import in.

I was under the impression that when one saves an excel into csv it takes each cell and automatically separates fields by the , thus doing what one would expect we want to achieve.

Ed,

I understand your point. When I created my .CSV file I did it via a PHP program rather than from a spreadsheet. Even then it took some trial and error before I worked out some of the finer details.

First of all, don't confuse the content of the CSV file with the way Excel displays it.

Let me make a suggestion. If you save your file in Excel as a .CSV and then open it using Notepad you should see that the fields are separated by commas (I think that's the Comma Separated in .CSV). Notepad usually gives me a more accurate view of how the data is stored in a CSV than the spreadsheet. The spreadsheet tries to intelligently format the data and you get some goofy looking things. Try different things like putting commas or ";" in your data and you'll be able to see via Notepad what the CSV really looks like.

Hope this investigative technique helps.

This stuff does work. It took me a while to figure it out but I use constantly now without any problems.

Good luck.

Ed, The easiest thing to do is to setup your shop with one category then 1 sub category and then 1 product. Now fill out the info about the product that would be in your shop. Now export to CSV to a folder on your pc. Now goto that location and open that file with Excel. Excel will show the data in seperate columns making it easy to alter. When you get all your data entered make sure to save it and that it "saves as" a CSV(Comma delimited). Now you should be able to import the CSV back into you shop with all the new data.