booksfromhome

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

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##-

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

"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

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

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 */ } }

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

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

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 ********************/

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?

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

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

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

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??

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??

your are right, I was missing all the box defines, I have no idea how they disapeared

I load the new version (2.9) to my osc 2.3.1 and got a strange effect in my admin page. A lolt of the buttons are not showing up only the link text, they work but no fancy buttons BOX_HEADING_CONFIGURATION BOX_CONFIGURATION_ADMINISTRATORS BOX_CONFIGURATION_STORE_LOGO My Store Minimum Values Maximum Values Images Customer Details Shipping/Packaging Product Listing Stock Logging Cache E-Mail Options Download GZip Compression Sessions Add More Fields BOX_HEADING_CATALOG BOX_HEADING_MODULES BOX_HEADING_CUSTOMERS BOX_HEADING_LOCATION_AND_TAXES BOX_HEADING_LOCALIZATION BOX_HEADING_REPORTS BOX_HEADING_TOOLS

your right, I must have searched case senitive. This is my line 404, It does not look the same as what was expected line 404: $pInfo = new objectInfo($parameters); if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) { $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); $pInfo->objectInfo($product); $product_images_query = tep_db_query("select id, image, htmlcontent, sort_order from " . TABLE_PRODUCTS_IMAGES . " where products_id = '" . (int)$product['products_id'] . "' order by sort_order"); while ($product_images = tep_db_fetch_array($product_images_query)) { $pInfo->products_larger_images[] = array('id' => $product_images['id'], 'image' => $product_images['image'], 'htmlcontent' => $product_images['htmlcontent'], 'sort_order' => $product_images['sort_order']); }

I have not directly modified the admin/categories file. the only add on was your googlebase feed. I downloaded my version of oscommerce 2.3.1 from vodahost. I searched the entire categories file for the keyword "pinfo" and there was no match. line 470: function updateGross() { var taxRate = getTaxRate(); var grossValue = document.forms["new_product"].products_price.value; if (taxRate > 0) { grossValue = grossValue * ((taxRate / 100) + 1); } document.forms["new_product"].products_price_gross.value = doRound(grossValue, 4); }

I like a lot of others are anxious to get a copy of this code for v2.3.1 I just had to rebuild my site and loaded googlefeeder in, it works very well. I am holding off repopulating the site with my 300+ older books until I can add extra fields to the products if you can work this code into your schedule we all would appreciate it

that makes sence

Can not fint the following lines in my ADMIN/CATEGORIES.PHP FIND (around line 470): } elseif (tep_not_null($HTTP_POST_VARS)) { $pInfo->objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_url = $HTTP_POST_VARS['products_url'];

I just had to rebuild my oscom site, updated to 2.3.1 I loaded GoogleFeeder_V_2.8 EU_1_2 it is working. I still getting several errors from google that I am working on. My question is: the new google fields, brand, gtin/isbn and mpn can be turned on in googlefeeder.php but is there a contrib that add the correct names to the oscomm files to use them? Also what are the correct names of the fields to be inserted into the sql database? I know just enough php and sql to get laong

Does any know why the modules add 12oz to my 3 pound package???? The weight I entered is 3.00 pounds United States Postal Service (1 x 3.75lbs) (3lbs, 12oz) (Parcel Post): $8.62