New 
booksfromhome
-
Posts
30 -
Joined
-
Last visited
Posts posted by booksfromhome
-
-
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
-
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
Add More Fields
in General Add-Ons Support
Posted
just got it all to work I think
will be testing more
Thank every one for helping