Jump to content

booksfromhome

Members
  • Content count

    30
  • Joined

  • Last visited

About booksfromhome

  • Birthday 09/17/1955

Profile Information

  1. booksfromhome

    Add More Fields

    just got it all to work I think will be testing more Thank every one for helping
  2. booksfromhome

    Add More Fields

    got a little along..... I changed the drop down box to regular text and the extra field products_condition was accepted and the data was loaded into my database The extra field did not show up in my product description yet. This is what I am trying in the products discription (notworking): <b><u> Hand Made (clay OOAK) Chamilion </b></u><br><br> Hand made out of colored polymer clay, body is 6" long by 5" high<br><br> ##+PRODUCTS_CONDITION##-
  3. booksfromhome

    Add More Fields

    I got a little further along. Got code installed and add a new field. Went back to modify an existing product When I try to save the product with the new products_condition added, I get: Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /home/nzfmsfxs/public_html/store/admin/includes/functions/database.php on line 136 Warning: Cannot modify header information - headers already sent by (output started at /home/nzfmsfxs/public_html/store/admin/includes/functions/database.php:136) in /home/nzfmsfxs/public_html/store/admin/includes/functions/general.php on line 34 this is the field I added: Select A Field: products_condition Which table? Products Field Name: condition Display Name: English Type of Field: drop down Option List: new, used Field Size: Is Field Null: not null Sort Order: 0 In Easy Populate: (i do not have this installed) do I need to add a field into Which table? Products Description
  4. booksfromhome

    Add More Fields

    "You took the version he supplied" are you referring to the CATALOG folder code supplied under "Use_if_version_greaterthan_2.3" Also what do you consider "real V2.3.1" I downloaded/installed my copy thru vodahost
  5. booksfromhome

    Add More Fields

    Is in previous posts that step 7 around line 470 and around line 756 can be skipped if not found what about step 7 around line 823 and around line 925
  6. booksfromhome

    Automatically send data feed to Froogle

    This looks like it works for ($a = 0; $a < count($attributesColumns); ++$a) { if ($products_options_name->products_options_name == $attributesColumns[$a]) { if ($a == 0) $trackTabs = "\t"; /* add tab for eof if $a = 0 */ else { if (empty($trackTabs)) { $trackTabs = str_repeat("\t", $a); $trackTabs .= "\t"; } else { $trackTabs = "\t"; /* add one tab for each loop > 0 */ } }
  7. booksfromhome

    Automatically send data feed to Froogle

    I am sure excel is writing it in the wrong column I am add a link to the text file so you can look at it http://booksfromhome.net/store/feeds/your-outfile.txt
  8. booksfromhome

    Automatically send data feed to Froogle

    It looks like it only works if there is one attribute ONLY for each product
  9. booksfromhome

    Automatically send data feed to Froogle

    I am using V2.9 oscommerce 2.3 I have three attributes defined: brand, condition, isbn When I create the google feed, the condition is moved into the ISBN field if the first field is full. If the first two fields are blank, the ISBN number is correct product #1 c.brand = books, c.condition = blank, c.isbn = new product #2 c.brand = blank, c.condition = blank, c,isbn = number product #3 c.brand = books, c.condition = blank, c.isbn = blank if (OPTIONS_ENABLED_ATTRIBUTES == 1) { $products_attributes_query = mysql_query("select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='" . $row->id . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)1 . "'"); $products_attributes = mysql_fetch_object($products_attributes_query); if ($products_attributes->total > 0) { $products_options_name_query = mysql_query("select distinct popt.products_options_id, popt.products_options_name from products_options popt, products_attributes patrib where patrib.products_id='" . (int)$row->id . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)1 . "' order by popt.products_options_name") or die(mysql_error()); $trackTabs = ''; while ($products_options_name = mysql_fetch_object($products_options_name_query)) { $products_options_array = array(); $products_options_query = mysql_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from products_attributes pa, products_options_values pov where pa.products_id = '" . (int)$row->id . "' and pa.options_id = '" . $products_options_name->products_options_id . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)1 . "'"); while ($products_options = mysql_fetch_object($products_options_query)) { $products_options_array[] = array('id' => $products_options->products_options_values_id, 'text' => $products_options->products_options_values_name); } for ($a = 0; $a < count($attributesColumns); ++$a) { if ($products_options_name->products_options_name == $attributesColumns[$a]) { if ($a == 0) $trackTabs = "\t"; else { if (empty($trackTabs)) $trackTabs = str_repeat("\t", $a); $trackTabs .= "\t"; } $output .= $trackTabs; foreach ($products_options_array as $arr) $output .= $arr['text'] . ','; $output = substr($output, 0, -1); } } } } } /******************* END HANDLING THE ATTRIBUTES ********************/
  10. booksfromhome

    Add More Fields

    If I look at your "AddMoreFields_V_1.3\Use_if_version_greaterthan_2.3\catalog\admin/categories.php" there is no lines that have have"elseif (temp_not_null)" If I look at your "AddMoreFields_V_1.3\Use_if_version_lessthan_2.3\catalog\admin/categories.php" IT IS THERE do I just have the wrong instructions?
  11. booksfromhome

    Add More Fields

    I hate to keep bugging you about this but its important to me. If I search for line 470 "elseif (temp_not_null)" in your completed files (admin/categories.php) there are no lines that have have "elseif (temp_not_null)" what am I missing
  12. booksfromhome

    Add More Fields

    here we go again.. I am looking over the install of (1.3) for V2.3.1 I can not locate "around 470" "around 756" and "around 823" I have a copy of oscommerce 2.3.1 from VODAHOST and the only other add on I have googlefeed 2.9
  13. booksfromhome

    Add More Fields

    under the later than 2.3 folder is a catalog folder and a catalog_New_Files_only folder under the catalog folder is a admin folder and a product info file under the catalog_New_Files_only folder is a admin folder and a include folder
  14. booksfromhome

    Add More Fields

    I have a basic question on step #2 of the install (1.3) for V2.3 What is the catalog_new_files_only? for new install only? Also, I saw in the forum the some people questioned line 470 and 756, your comment was to skip them, that comment scares me. Should I follow all the install steps or not??
  15. booksfromhome

    Automatically send data feed to Froogle

    I added the product_condition to the database BUT I have no idea how to add it to my product input page. I may have to use your ADD MORE FIELDS . Any ideas on how to do it manually??
×