Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by choosealogin

  1. choosealogin

    Do I smell or something??

    You found the right table. Those 4 fields need to be added the easypopulate.php file. Simply adding them to the header row in excel won't do it, as I think you already found out. Since those are in a table that's not even looked at in EP as it stands, I don't have a quick fix. I could play with that but it will take a little time.
  2. choosealogin

    Do I smell or something??

    I'm far from an expert on this download stuff, but this is what I would look at next: Just a couple of things... Around line 97 of easypopulate.php, // VJ product attributes begin // **** Product Attributes **** // change this to false, if do not want to download product attributes global $products_with_attributes; $products_with_attributes = true; Do you have that set to 'true'? That's good. Do you have dowloads enabled already? That's important...or the filename attributes won't show up for you, to my knowledge. If so, go put in one test product, the old fashioned way (in osC admin). Then go to admin>>catalog>>products_attributes and add the necessary attribute (filename) for that test product. If you still have the demo products, you can look at the attribute for Unreal Tournaments as an example. Then download a complete EP file. Your test product should show it's attribute in that file. You should be able to follow the example you'll have in your EP file to go on from there, adding filenames (as attributes) for your other products.
  3. choosealogin


    You'll have to modify the mopics code in product_info.php Post your product_info.php file and I'll see if I can help.
  4. choosealogin


    if you're pasting that directly into your description, you need to reference the images folder 'images/p5.jpg'
  5. choosealogin

    Help please!!!! Error Message

    Kgt pointed to pretty much the only reason for your error. One single (invisible) space will cause that. Put your mouse at the end of the file and drag it to the ?> at the end...and delete the space. also, just in case - editing in cPanel will add an empty line at the end. So if you're using that, use something else to edit w/.
  6. choosealogin

    Do I smell or something??

    Sure, it makes perfect sense. What version of EP are you using? Do you have it (EP) running ok already? In other words, have you tried any test runs?
  7. You'll have to first set up your database and code to do that (make model year), and then customize Easy Populate to fill in the fields. So the part about EP is really the easiest part, and it's the last part. I put something together for "year", but as I'm only dealing with one make and 3 models, it was fairly easy :P It's a pretty dry subject around here :huh: You could look at 'product extra fields' (in the contributions), but while the theory is good, I'm not sure how to use it for that purpose.
  8. choosealogin

    Do I smell or something??

    To my knowledge, download filenames are stored as a product attribute, which easy populate alreay has the ability to handle. The table orders_products_download stores info related to ordered products, as a record of downloadable goods orders. Maybe I misunderstood what you're wanting to do.
  9. choosealogin


    They use a JS function called 'doPic'. Googling for 'dopic', I found this http://javascript.internet.com/miscellaneo...ery-viewer.html You would need to tweak something like mopics and this 'dopic' into your code, and you're good to go. Sorry, I didn't explain very well. Mopics is a multiple image contribution. It's here http://www.oscommerce.com/community/contri...l/search,mopics It would take some customizing, but I don't think it would be too difficult.
  10. choosealogin

    new install but no payment mods HELP!!!!

    In that case some of your other paths aren't right, in that same file (admin/includes/configure.php) check this one define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); using $DOCUMENT_ROOT should work....see if yours looks like that or not. You'll see in that file that a lot of the other paths reference DIR_FS_DOCUMENT_ROOT in their paths, like define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG); so if it can't find your DIR_FS_DOCUMENT_ROOT, then the other paths won't work either. if it's already defined as $DOCUMENT_ROOT and that's not working, try using absolute paths, instead of the $DOCUMENT_ROOT variable. To find that path, go to your osC admin panel >>tools >> server info and scroll down to where you see "document root"....use the full path you see there for this line define('DIR_FS_DOCUMENT_ROOT', /the/path/you/found/in/admin/tools/serverinfo/);
  11. choosealogin

    new install but no payment mods HELP!!!!

    DIR_FS_CATALOG_MODULES is not defined. It needs to be. That is in catalog/admin/includes/configure.php That line normally looks like this define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
  12. choosealogin

    Shipping categories and combinations?

    You might look at this... http://www.oscommerce.com/community/contri...ping+categories I haven't used it but it might help you. Be careful, as it's one of those contributions where nearly everyone has made some sort of "helpful" push in one direction or another...it looks like the second entry by thunderace might be a good one.
  13. I'm not sure, but I think this is the problem get rid of one ?> (the ?> that is before the if (isset($HTTP ...) so your "whole code" will be case 'PRODUCT_LIST_IMAGE': $listing_sql .= "pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } if (isset($HTTP_GET_VARS['manufacturers_id'])) $db_query = tep_db_query("select manufacturers_htc_title_tag as htc_title, manufacturers_htc_description as htc_description from " . TABLE_MANUFACTURERS_INFO . " where languages_id = '" . (int)$languages_id . "' and manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"); else $db_query = tep_db_query("select categories_htc_title_tag as htc_title, categories_htc_description as htc_description from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$current_category_id . "' and language_id = '" . (int)$languages_id . "'"); $htc = tep_db_fetch_array($db_query); ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><h1><?php echo $htc['htc_title']; ?></h1></td> <?php // optional Product List Filter if (PRODUCT_LIST_FILTER > 0) { if (isset($HTTP_GET_VARS['manufacturers_id'])) { $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name"; } else {[quote]
  14. choosealogin

    easy populate without globals?

    The fix is in the first post, here http://forums.oscommerce.com/index.php?s=&...st&p=432915 read item number 2
  15. choosealogin

    Paypal screen says $0.00

    Great, glad it worked. Thanks for coming back w/ the news.
  16. choosealogin

    Easy Populate updates times

    You'll need to make sure that v_date_added is also in your file, when downloaded it will have the original date added. At that point, make sure your column is formatted as YYYY-MM-DD and it will carry the correct original date with it on upload. PS, if it's not already including that column ...it's a change that needs to be made in the easypopulate.php file, i.e. you can't just add the column in excel and expect it to work. I realized I made it sound like that would be so easy, sorry. If you're not sure how to fix that, let me know.
  17. choosealogin

    Paypal screen says $0.00

    Paypal showing zero is usually caused by a conflict between your Paypal account currency, your osC Paypal module default currency setting, and your osC shop's default currency. Make sure all 3 of them are the same, all using the (same) correct abbreviation recognized by Paypal (USD, AUD, CAD, GBP, etc ...).
  18. choosealogin

    Easypopulate load assistance

    When you see words that are all capital in the error, it usually means a path of some sort is undefined. In your case it's the EP_TEMP_DIR Now, there are 3 problems ...I can tell from that error that you are using a version of EP that included an .sql file in the contribution package. That .sql file needs to be loaded into your database. But, before you do that please go back and make sure you really want to use that version. Many of the most recent versions (that one in particular) have some things hard-coded into them to accomodate certain other contributions, that you may or may not be using. Simple, basic EP is the one near the top that says "easy populate is easy, just start here first". You can get that here http://www.oscommerce.com/community/contri...h,easy+populate Then, finally you will want to use txt (tab delimited) when saving the file in excel.
  19. excellent news :) Thanks for following up.
  20. Ok, I changed just one line. I think maybe the directions confused you...easy to do as EP has been rewritten in so many diff. ways, that the directions are somewhat irrelavant at this point. I removed the $ sign from DIR_FS_DOCUMENT_ROOT. Let's try it again now. This time, also fix the easypopulate.php file, with the temp dir declaration like this...if you haven't already. $tempdir = "/temp/"; $tempdir2 = "/temp/"; Also, once you have that finished. Then "Download Complete tab-delimited .txt file to edit" Then, if it's full of products, remove them. Just leave the header row that has the column names in it. Then fill in just 2 or 3 products. Don't try to do the whole huge upload until that works w/no errors. Let me know how that goes. <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright ? 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://knifesupercenter.com'); // eg, http://localhost - should not be empty for productive servers define('HTTP_CATALOG_SERVER', 'http://knifesupercenter.com'); define('HTTPS_CATALOG_SERVER', 'https://knifesupercenter.com'); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', '/home/knifesup/public_html/'); // where the pages are located on the server define('DIR_WS_ADMIN', '/admin/'); // absolute path required define('DIR_FS_ADMIN', '/home/knifesup/public_html/admin/'); // absolute pate required define('DIR_WS_CATALOG', '/'); // absolute path required define('DIR_FS_CATALOG', '/home/knifesup/public_html/'); // absolute path required define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
  21. Hello, EP cannot find the file or your temp directory...that's why it shows up in all CAPS in your error DIR_FS_DOCUMENT_ROOT it needs to be able to find that. Could you post your admin/includes/configure.php, without the database entries that are at the bottom. PS, this is secondary, as the doc root setting needs to be correct first....but, if you created /temp/ directly in /public_html/ then the correct setting in the easypopulate.php file is: $tempdir = "/temp/"; $tempdir2 = "/temp/";
  22. Is your last column populated with EOREOR ? And do all of your products have a model number assigned?
  23. choosealogin

    DHtml Menu/Cookies/Ultimate SEO Problem

    Cool, I'm glad it worked. If you want to be able to turn it back on later, you can just exclude the category box from caching by editing the includes/column_left.php if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_categories_box(); } else { include(DIR_WS_BOXES . 'categories.php'); } just change all of that to just simply.... include(DIR_WS_BOXES . 'categories.php'); :)
  24. choosealogin

    DHtml Menu/Cookies/Ultimate SEO Problem

    See if you have caching turned ON. Your admin panel >> configuration >>cache The stock osC caching only works when there's no session id present. On the first page view, there is one...and on subsequent ones there is not (that's normal) ...so that might explain why the stock menu reappears on the second click.
  25. choosealogin

    Froogle/Google Base, Yahoo, and Bizrate Feeds

    This should help http://forums.oscommerce.com/index.php?showtopic=207004