Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

choosealogin

Pioneers
  • Posts

    1,104
  • Joined

  • Last visited

Profile Information

  • Real Name
    Mark
  • Gender
    Male

choosealogin's Achievements

  1. 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. 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. 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. if you're pasting that directly into your description, you need to reference the images folder 'images/p5.jpg'
  5. 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. 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. 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. 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. 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. 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. 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. The fix is in the first post, here http://www.oscommerce.com/forums/index.php?s=&...st&p=432915 read item number 2
  15. Great, glad it worked. Thanks for coming back w/ the news.
×
×
  • Create New...