Printable View
Thanks Matt for your help so far, I have managed to upload files to excel now. How can I upload a manufacturers file from excel into zencart. Do I have to create a new category name, and sub category names. and also what about product descriptions, does this have to be done manually one by one. Thanks
Once the file has been edited in excel, how do i upload it back onto zencart, i assume it doesnt simply doesnt go back to the temp file. Thanks
The layout of the spreadsheet you get from out of EP has to stay the same. All the column heading and order has to stay the same. If you get a list from your supplier in spreadsheet form, you can copy/paste the information into your EP spreadsheet.
All the information that is in your EP spreadsheet will be entered into ZC. So if you have all the manufactureres, categories, sub categories, descriptions, and so on filled out in the EP spreadsheet in the correct column, it will add it all to ZC.
I think thats what the question was?
Matt
Quote:
Originally Posted by ben harry
In your EP area under tools in your ZC admin area, you can browse for your file and insert it into the database. Make sure that the file is a .txt and not a excel file.
Thanks Hopefully I can figure this out.
good luck, I wish my EP would work.
Fingers crossed, im now uploading my first attempt at a bulk price change. Just waiting for the install to complete
The upload is complete and I got the following error messages and the prices didnt get updated, it must be something simple i didnt do. If you could help me Id be appreciative.
No model field in record. This line was not imported | | Pipercross | | | | | 0 | 0 | | 07/08/2008 | 0 | | Fast Road | Airfilter | | | | | | --none-- | 0 |
No model field in record. This line was not importedinduction | Audi 80 1. | Pipercross | | | | | 92.99 | 15 | | 07/08/2008 | 0 | | Fast Road | Induction | Audi | 80 | | | | --none-- | 1 |
No model field in record. This line was not importedinduction | Audi 80 2. | Pipercross | | | | | 92.99 | 15 | | 07/08/2008 | 0 | | Fast Road | Induction | Audi | 80 | | | | --none-- | 1 |
No model field in record. This line was not importedinduction | Audi 80 2. | Pipercross | | | | | 92.99 | 15 | | 07/08/2008 | 0 | | Fast Road | Induction | Audi | 80 | | | | --none-- | 1 |
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | |
Thanks
The problem seems to be that you didn't give those items a unique model name. EasyPopulate uses the items models as handle instead of the ID used in the rest of the store or database, so it's really needed that you give them all a unique model and none miss it. Hope that helps.
I was hoping that you werent going to say that, I kind of figured that out as I put a model number in as zero and instead of updating the products I got a new insert. Is there a way of inserting new products and deleting the old ones without a model number, or any other quick way around this problem. Thanks