jestep Posted July 11, 2010 Share Posted July 11, 2010 I still have two or three significant issues (problems) with Easy Populate after using (latest version 2.76i) for several years on 2 separate web sites. In the larger web site (AlphaNautical.com), for one distributor (as an example), I begin with a 53 KB EP file with 28,798 products in Excel 97-2003 format (Sheet 1). This file is copied and put in a new file (in Excel 97-2003 format) in order to change from a relative to an absolute format. (I use a lot of fields to the right of the EOREOR field in order to concatenate a nicer format description field.) Then all data past the EOREOR field is chopped off. Prior to making any mass load, my norm is to make several test runs with anywhere from 5 to 50 products until the newly built test products look OK. The source data in Excel 97-2003 format is converted to CSV format for input to EP. This is where the 1st problem arises. (My standard setting are: 1) Magic Quotes: Off; 2) Register Global: Off; 3) Replace Quotes: False; 4) Field separator: Comma; 5) Safe Output: True; 6) Preserve Tab/CR/If: False; 7) Enable Attributes: True & 8) SEF URLS: False. I only use one "Other Support" Option: HTC: True. Note that SPPC is False.) Every field uploads EXACTLY as loaded EXCEPT v_products_special_price. If this is a "new" record the resulting special price is blank (but should contain valid data). If this is an "update" to an existing record, then the result is a special price that was in the product before, not the new price that was uploaded. Now what is really strange is The following. I can then download these same new test records as a CSV file. Next I copy a column from the original test data (remember it did not work before) into the newly created download file and re-run it as an update. Surprise! You guessed it. The special prices work just fine, but problem 2 arises. Remember the HTC option is turned on but the three HTC fields do not get downloaded. As you can see quite easily, I have to upload the 28,000 records at about 1000 records at a time. Then I have to download the entire 28,000 records as a CSV file. Next I take the the special prices directly from the file that did not work and place the in the newly downloaded file. And finally, I upload them again but without attributes and HTC data fields. The 3rd issue/problem is caused by not having an optional switch and field to upload the "Products Short Description" field which is created in the Cieto Featured Products contribution. (I used version v2.54 MS2). (The "Pros" are that this is a very useful sales tool that randomly "features" your products. The "Cons' are that this requires extensive and careful modification to the (large) admin/catalog program.) Because it has such good sales benefits I recommend it to the careful programmer but not to newbies. After doing all the gyrations cited above, next it is necessary to go back through 28,000 records manually to fix this one field. I hope this prompts the release of a "j" version or someone spots my problem and tell me how to fix the special price upload problem. Thanks jestep Quote Joseph E. "Joe" Stephensonjestep@alphanautical.com Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.