Jump to content

sweetpatoodies

Members
  • Content count

    30
  • Joined

  • Last visited

Profile Information

  1. sweetpatoodies

    Attribute Sets Plus

    Hi Chris or anyone else who might have an answer, I've just installed the Attribute Sets Plus contribution to a client's store. First I want to say thanks for this great contribution. It's just what my client needed. Everything has gone well with the install, except one small issue.... the attributes are not sorting correctly in the product page. I've gone back and checked and I did complete Step 6 of the install which retrieves the attributes and orders them according to the required sort order. I did a copy and paste from the install instructions to my product_info.php file, so I know I didn't mistype anything, and I'm not getting any error messages. Any thoughts on what might be the problem? I do have the Attribute Option Type contribution also installed. Here's the code for Step 6 in my product_info.php file: // BOF Linkmatics attributes sets plus $products_options_query = tep_db_query(" SELECT pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix , pase.sort_order FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS . " pas2pa, " . TABLE_PRODUCTS_ATTRIBUTES_SETS . " pas, " . TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS . " pase, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov WHERE pa.products_id = '" . (int)$_GET['products_id'] . "' AND pa.options_id = '" . $products_options_name['products_options_id'] . "' AND pas2pa.products_id = pa.products_id AND pas.products_attributes_sets_id = pas2pa.products_attributes_sets_id AND pas.products_options_id = pa.options_id AND pase.products_attributes_sets_id = pas.products_attributes_sets_id AND pase.options_values_id = pa.options_values_id AND pov.products_options_values_id = pa.options_values_id AND pov.language_id = '" . $languages_id . "' ORDER BY pase.sort_order, pa.options_values_id"); // >>>>> BOF Linkmatics attributes sets plus patch v1.01 if (tep_db_num_rows($products_options_query)== 0 ) { $products_options_query = tep_db_query(" SELECT pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix , pa.options_values_id FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov WHERE pa.products_id = '" . (int)$_GET['products_id'] . "' AND pa.options_id = '" . $products_options_name['products_options_id'] . "' AND pov.products_options_values_id = pa.options_values_id AND pov.language_id = '" . $languages_id . "' ORDER BY pa.options_values_id"); } // <<<<< EOF Linkmatics attributes sets plus patch v1.01 // EOF Linkmatics attributes sets plus Thanks! Sharon sharon@artworkwebs.com
  2. sweetpatoodies

    Product Attributes - Option Type Feature v1.3

    the no typing in textbox seems to have fixed itself, after I walked away and selpt for 3-4 hours and came back. I guess the oscommerce elves were at work!
  3. sweetpatoodies

    Product Attributes - Option Type Feature v1.3

    I figured out my error messages... white space at the end of the general.php and configure.php files. But I still haven't fixed the problem of not being about to type in a text box attribute. Sharon sharon@artworkwebs.com
  4. sweetpatoodies

    Product Attributes - Option Type Feature v1.3

    I've just installed the Product Attributes-Option Type Feature contribution on a client's shopping cart and I'm getting the following error messages... This one occurs when I try to add or edit an attribute: Warning: Cannot modify header information - headers already sent by (output started at /home/robyn6/public_html/store/includes/configure.php:46) in /home/robyn6/public_html/store/admin/includes/functions/general.php on line 22 (although the new attribute or changes seem to take effect anyway) On the store home page this error has popped up: Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/robyn6/public_html/store/includes/configure.php:46) in /home/robyn6/public_html/store/includes/functions/sessions.php on line 102 The installation instructions were a bit confusing about the changes to the configure.php file. At the start it says you will modify the: /catalog/includes/configure.php But then further into the instructions it says the /catalog/includes/local/configure.php (create it if it doesn't exist). I made the modifications to the /catalog/includes/configure.php file. Also, my text box is showing up for the customer to type in special instructions, but you can't type anything in it. The site with the error is http://robynwarne.com/store/index.php Help! Sharon sharon@decorativepaintingstore.com
  5. sweetpatoodies

    Easy Populate & Products Attributes

    Any other suggestions then? Since the csv file will upload, I know my directories are right, but when the file is in the tab delimited format it won't upload. Or do I just revised my descriptions, so they don't have any commas? sharon
  6. sweetpatoodies

    Easy Populate & Products Attributes

    I've still been working to get a file to upload through Easy Populate. I'm on a Mac computer and using Excel and textEdit. Finally, I tried saving the data file as a csv (windows) file instead of a tab-delimited file, and changed the separator in the easypopulate.php file to comma "," instead of tab "/t".... and it worked this time... I actually had products added to my catalog, it just didn't work quite right. My problem now is that my product descriptions have commas in the text, so in the upload it breaks the data into a new field at each comma (including the commas in the description) throwing some of the info into the wrong fields. My question is there some character I should be placing in front of the commas that are part of the punctuation in the product description to prevent the csv file from being split at the wrong spots? I hope someone has a simple solution to this problem... sharon
  7. sweetpatoodies

    Easy Populate & Products Attributes

    ----------------------- Hi John, Under admin/tools/server, I found two references to document root and they both are: /mnt/web_d/d13/s47/b02303a4 Now when I go into my file manager under the oscommerce admin tools, it starts me out at my basic web level... before it started out at the catalog level. ----------------------- configure.php file with the db connection info "x'd out" is: <?php /* $Id: configure.php,v 1.14 2003/02/21 16:55:24 dgw_ Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License */ // define our webserver variables // FS = Filesystem (physical) // WS = Webserver (virtual) define('HTTP_SERVER', 'https://decorativepaintingstore.sslpowered.com'); // eg, http://localhost or - https://localhost define('HTTP_CATALOG_SERVER', 'http://decorativepaintingstore.netfirms.com'); define('HTTPS_CATALOG_SERVER', 'https://decorativepaintingstore.sslpowered.com'); define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where your pages are located on the server. define('DIR_WS_ADMIN', '/dpsstore/nfoscomm/catalog/admin/'); define('DIR_FS_ADMIN', $DOCUMENT_ROOT . '/www' . '/dpsstore/nfoscomm/catalog/admin/'); define('DIR_WS_CATALOG', '/dpsstore/nfoscomm/catalog/'); define('DIR_FS_CATALOG', $DOCUMENT_ROOT . '/www' . '/dpsstore/nfoscomm/catalog/'); 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/'); // define our database connection define('DB_SERVER', 'xxxxx'); define('DB_SERVER_USERNAME', 'xxxxx'); define('DB_SERVER_PASSWORD', 'xxxxx'); define('DB_DATABASE', 'xxxxx'); define('USE_PCONNECT', 'xxxxx'); define('STORE_SESSIONS', 'xxxxx'); ?> ------------------------- Sharon sharon@sweetpatoodies.com
  8. sweetpatoodies

    Easy Populate & Products Attributes

    -------------------- Hi John, Thanks for the help. It's just not working yet. I made the change to the configure.php file as follows (I included a couple of lines before and after just for reference): -------------------- define('HTTP_CATALOG_SERVER', 'http://decorativepaintingstore.netfirms.com'); define('HTTPS_CATALOG_SERVER', 'https://decorativepaintingstore.sslpowered.com'); define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where your pages are located on the server. define('DIR_WS_ADMIN', '/dpsstore/nfoscomm/catalog/admin/'); define('DIR_FS_ADMIN', $DOCUMENT_ROOT . '/www' . '/dpsstore/nfoscomm/catalog/admin/'); ---------------------- I made the change to the easypopulate.php file as follows: ---------------------- // **** Temp directory **** // if you changed your directory structure from stock and do not have /catalog/temp/, then you'll need to change this accordingly. // $tempdir = "/catalog/temp/"; $tempdir2 = "/catalog/temp/"; ---------------------- I'm still getting the double // after catalog in my file manager. When I tried to upload after making these changes, this is the error message I got: ---------------------- Warning: move_uploaded_file(/mnt/web_d/d13/s47/b02303a4/catalog/temp/DPSEPProductFile3.txt): failed to open stream: No such file or directory in /mnt/web_d/d13/s47/b02303a4/www/dpsstore/nfoscomm/catalog/admin/easypopulate_functions.php on line 32 Warning: move_uploaded_file(): Unable to move '/var/tmp/phpbAr4yC' to '/mnt/web_d/d13/s47/b02303a4/catalog/temp/DPSEPProductFile3.txt' in /mnt/web_d/d13/s47/b02303a4/www/dpsstore/nfoscomm/catalog/admin/easypopulate_functions.php on line 32 File uploaded. Termporary filename: /var/tmp/phpbAr4yC User filename: DPSEPProductFile3.txt Size: 864 Warning: file(/mnt/web_d/d13/s47/b02303a4/catalog/temp/DPSEPProductFile3.txt): failed to open stream: No such file or directory in /mnt/web_d/d13/s47/b02303a4/www/dpsstore/nfoscomm/catalog/admin/easypopulate.php on line 644 Warning: Invalid argument supplied for foreach() in /mnt/web_d/d13/s47/b02303a4/www/dpsstore/nfoscomm/catalog/admin/easypopulate.php on line 667 ---------------------- My easypopulate_functions.php file is: ---------------------- <?php function tep_get_uploaded_file($filename) { if (isset($_FILES[$filename])) { $uploaded_file = array('name' => $_FILES[$filename]['name'], 'type' => $_FILES[$filename]['type'], 'size' => $_FILES[$filename]['size'], 'tmp_name' => $_FILES[$filename]['tmp_name']); } elseif (isset($GLOBALS['HTTP_POST_FILES'][$filename])) { global $HTTP_POST_FILES; $uploaded_file = array('name' => $HTTP_POST_FILES[$filename]['name'], 'type' => $HTTP_POST_FILES[$filename]['type'], 'size' => $HTTP_POST_FILES[$filename]['size'], 'tmp_name' => $HTTP_POST_FILES[$filename]['tmp_name']); } else { $uploaded_file = array('name' => $GLOBALS[$filename . '_name'], 'type' => $GLOBALS[$filename . '_type'], 'size' => $GLOBALS[$filename . '_size'], 'tmp_name' => $GLOBALS[$filename]); } return $uploaded_file; } // the $filename parameter is an array with the following elements: // name, type, size, tmp_name function tep_copy_uploaded_file($filename, $target) { if (substr($target, -1) != '/') $target .= '/'; $target .= $filename['name']; move_uploaded_file($filename['tmp_name'], $target); } ?> ---------------------- I don't recall ever making any changes to this file. Any suggestions for next steps? Sharon sharon@sweetpatoodies.com
  9. sweetpatoodies

    Easy Populate & Products Attributes

    Ok, I'm trying to use Easy Populate and I just can't get a file upload to work. I'm on a Mac, I've downloaded a file from my store, so I have the correct headings (it's a pretty simple file), I've updated the file in Excel, saved it as a tab-delimited file, opened it in TextEdit and changed the end of lines to "Unix", and I get this type of message when I upload it: File uploaded. Termporary filename: /var/tmp/phpP1WJhY User filename: DPSEPProductFile3.txt Size: 866 The file is in my temp directory under catalog. I've tried the file with 1 product and 10 products with the same result. Here's my data file with just one product: v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_attribute_options_id_1 v_attribute_options_name_1_1 v_attribute_options_id_2 v_attribute_options_name_2_1 v_manufacturers_name v_categories_name_1 v_categories_name_2 v_categories_name_3 v_tax_class_title v_status Unix RL-SG150-0 brushes/RL-SG150.jpg Soft Grip Golden Taklon Shader #0 "Retail $2.99. These brushes have ergonically designed, thick acrylic handles and a soft, no slip, rubber grip. They are a great value for the decorative painter, since any brush in the series retails for only $2.99. The shader is a good choice for basecoating and floating techniques." 2.25 0.05 6 Royal Langnickel Brushes Royal Langnickel Soft Grip Gold Taklon $2.25 Each --none-- Active Unix I also tried uploading it through ftp and importing it from the temp directory using the Easy Populate function. Still didn't work, same message. I've checked the file where "tab" is set as the default delimiter and it looks ok to me. I actually don't know what EP is suppose to do if it uploads correctly... I just know I don't have any products added to my store. I do have the problem you mentioned above in that I have two // in front of all of my directories below the catalog level when I look at them through file manager. I'm not sure what to change. I'm running my store on netfirms.com host who has set my store directory as: http://www.decorativepaintingstore/dpsstore/nfscomm/catalog/ The line in my configure.php file for the document root is: define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT . '/www' . '/dpsstore/nfoscomm/catalog/' ); // where your pages are located on the server. I tried changing it as you suggested to someone else and I got worse errors when I tried to upload a data file because it couldn't find the temp directory at all. I'm so frustrated, I just don't know what else to try, so any suggestions would be appreciated. Sharon sharon@sweetpatoodies.com
  10. sweetpatoodies

    [Contrib] Shipping zoneworld

    John, Thanks much! I removed the zoneworld in the shipping module admin panel and then re installed it and it worked... all my zones show up with the code I added in the zoneworld.php file!!! sharon
  11. sweetpatoodies

    [Contrib] Shipping zoneworld

    First let me say, thanks so much for working on the shipping issue. I thought I was going to have to purchase another shopping cart to handle the type of shipping rates we want to do, but I think I'm just about there with your new code. I playing with the cart on my personal website before I take the plunge to move it to our large site (www.sharonandgayle.com). I downloaded the zoneworld yesterday and uploaded to my website. I need to add some more zones to the list, so I made the change to the code to show 6 zones. But when I go into my admin panel to change the country codes for each zone and add the weight/rates, only the first 3 zones show up with box titles. There are boxes for the remaining zones, but no titles, and if I input data into them they don't save. I have next to no knowledge about php, but can usually work through things if I see an example, but I can't figure out what else I need to change in the code. Here's what I'm trying to set up (these are all based on weights): Zone 1 - US Media Mail Rates Zone 2 - US Priority Mail Rates Zone 3 - Canada/Mexico (Global Priority Mail Flat Rate of $7 for approximately 2-3 lbs) Zone 4 - Selected countries in Europe, South America, & Pacific (GPM Flat Rate $9/2-3lbs.) Zone 5 - ? Countries that we ship to by air parcel post (GPM service not available through USPS) Zone (Last) - remainder of countries we don't ship to that will show as not available. To get the differentiation between US Media and US Priority (I changed the ISO3 for USA to USM and country name to United States-Media), then added a new country for USP (United States-Priority). I changed the code from ISO2 to ISO3 so it reads the 3 digit country code rather than the 2. This seems to be working, if I can just get the additional zones added for the other countries. Someone had mentioned they were having trouble figuring out how to set shipping to zero for downloaded items. I do this by making the first weight limit in the array 0:0.00, and setting the weight in my product listing to zero for items that are downloaded. If the customers orders an item with 0 weight no shipping is charged. sharon@sweetpatoodies.com www.sweetpatoodies.com
×