Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

bowen

Pioneers
 View Profile  See their activity

  • Posts

    80

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Posts posted by bowen

    [Contribution] osc2ebay - oscommerce to ebay synchronization

    in General Add-Ons Support

    Posted

    I think there is no eBaySvc.wsdl file on your server or wrong path for it. Upload eBaySvc.wsdl as it is, do not upload it as xml.

     

    Thanks, it was a naming convention of all things!.... file should be 'eBaySvc.wsdl' i have 'ebaySvc.wsdl' who'd have thought in todays age of the internet it would be case sensitive :-s

     

    now have a new problem not it brings up something:

     

    get categories error

    get store categories error

     

    Please help.

     

    thanks

    [Contribution] osc2ebay - oscommerce to ebay synchronization

    in General Add-Ons Support

    Posted

    Hi i have been trying to get this to work and am hitting all sorts of hurdles :-s

     

    the newest one is

     

    PHP Fatal error:  SOAP-ERROR: Parsing WSDL: Couldn't load from 'eBaySvc.wsdl' : failed to load external entity "eBaySvc.wsdl", referer: http://mysite.com/admin/ebay_getcategories.php

     

    And also

     

    in /home/sites/mysite.com/public_html/ebay_common.php on line 244, referer: http://mysite.com/admin/ebay_getcategories.php

     

    Please help as i'd love to get this working.....

     

    thanks

    Oder Number Display addon wont diplay

    in General Add-Ons Support

    Posted

    Hi all,

     

    I installed the plugin http://addons.oscommerce.com/info/7761 that displays the order number in various screens. I have added this in as instructed but it wont display on any of the pages that it should

     

    The once of the the code it says to add is as follows

     

    <!--OND order number display-->
		   <tr>
		    <td class="main"><b><?php echo ORDER_NUMBER; ?></b></td>
		    <td class="main"><?php echo $order->info['order_id']; ?></td>
		  </tr>
		  <!--end OND-->

     

    But the field is blank. can anyone help?

     

    Thanks.

    SiteMonitor

    in General Add-Ons Support

    Posted

    The code is reading the configure file and not seeing the correct username so it redirects you to that page and displays that message. You have to enter the correct username if it is not already there and then click update. Clicking update is required in any case for it to work. To be sure you have the correct username, go to admin->Modules. It will be listed in the path shown on that page.

     

    Hi,

     

    I am getting the same issue when i try and goto 'site monitor> admin' i keep sseing the config page with 'Error Your username is invalid. Please change it and try again.'

     

    i have both added and removed the username from the config while and also added/removed it via the 'site monitor> configure' and clicked update but i still get the same error??

     

    please help.

    thanks

    Header Tags SEO

    in General Add-Ons Support

    Posted

    After you run fill tags, the titles and meta tags should be filled in when you view the category or product edit page in admin. If not, there is something wrong with your installation. If so, maybe you haven't enabled the category and/or product checkbox on those pages in Page Control.

     

    Hi,

     

    Thanks for the reply.

     

    Sorry, It was me :blush: ..... Once i uploaded the tags etc via EP i thought they would all appear on the pages in the right place...... i checked in the Header tags SEO> Page Control and the Default tags were all ticked and filled in, and i presumed that they would automaically fill the defaults on the pages unitl i got around to them, but they dont unless they are set to 'default' in the particaular page on the right....

     

    I did think that once they were uploaded into the DB via EP they would automatially appear, but it appears that you still have to enter something in, in order for it to fill out the rest. E.G..the product name 'BABIES 1ST CHRISTMAS BAUBLES' was uploaded via EP but did not show in on the page title. once i entered 'Posh Kitty' into the product_info page name in admin and refreshed the store it was then shown as 'new products - Posh Kitty - BABIES 1ST CHRISTMAS BAUBLES'.

     

    It was strange how before, if i updated a product in admin the page name would show up from the EP upload though but not all the products from the upload, as if it adds something SEO DB to say a tag is there, but this update is'nt forced to update via an EP upload....

     

    I'm not sure if all info means anything, but i thought it may help in future development because if it caught me out it will have no oubt caught others who may not have said anything...

     

    but as its all working now...its a fantastic app!!, it has saved me HOURS!!! of doing SEO on thousands of products :-)

     

    cheers - Mark

    Header Tags SEO

    in General Add-Ons Support

    Posted

    Hi Guys,

     

    I've just installed the header tags contrib and it is fantastic!!

     

    Just have a few little issues... when i do an update using the 'fill tags' it says it has updated but nothing shows on the site??

     

    Also i have enables the contrib in Easy populate and uploaded nearly 1.9k of products, and when i check in the catalog> categories/descriptions in admin they have all been willed in fine,

     

    but.....

     

    Nothing still shows on the page?? if i edit a product in admin, preview then update (without changing anything) the check that product on the live site the info is there??!! :(

     

    any idea what is causing this as i would presume as soon as its loaded into the database it will appear on the site

     

    any help is appreciated....

     

    thanks - Mark

    Whos Online

    in General Add-Ons Support

    Posted

    Hi All,

     

    I'm using who's online V3.5.4 and strangely its not giving the name of the page that people are on, but is showing an image name etc that's on the page 'e.g.: /images/mb_template/az_footer_mid.png'??

     

    has anyone else had this issue and how can i solve it? this only happened yesterday and i cant figure out why or how to rectify it....pease help.

     

    thanks - mark

     

     

    Hi All,

     

    I have now updated my who is to 3.6.6.2 and i still have the same issue that it shows a file/image name etc instead of the page that they are visiting....

     

    can anyone tell me why it is dong this??

     

    thanks - mark

    Whos Online

    in General Add-Ons Support

    Posted

    Hi All,

     

    I'm using who's online V3.5.4 and strangely its not giving the name of the page that people are on, but is showing an image name etc that's on the page 'e.g.: /images/mb_template/az_footer_mid.png'??

     

    has anyone else had this issue and how can i solve it? this only happened yesterday and i cant figure out why or how to rectify it....pease help.

     

    thanks - mark

    [Contribution] Option Types v2

    in General Add-Ons Support

    Posted

    hi,

     

    I have downloaded this contribution after seeing it on another site because i need for the customer to enter characters over 3 or 4 lines that can be engraved onto a product.

     

    I am lost with the install file 'option types v2 installtion instruction.txt' because there are characters in there that i have no idea what they are or are refering too...

     

    \f1\fs24 \

    \

     

    \f0\fs22 \cf2 echo \cf3 '<br><nobr><small> <i> - ' \cf0 . \cf4 $order\cf0 ->products[\cf4 $i\cf0 ][\cf3 'attributes'\cf0 ][\cf4 $j\cf0 ][\cf3 'option'\cf0 ] . \cf3 ': ' \cf0 . \cf4 $order\cf0 ->products[\cf4 $i\cf0 ][\cf3 'attributes'\cf0 ][\cf4 $j\cf0 ][\cf3 'value'\cf0 ] . \cf3 '</i></small></nobr>'\cf0 ;\

    \

     

     

     

    on the 1st part of the find this and replace with... i have no idea what all the /cf3 etc are as they are not proper php coding

     

    can anyone help or maybe could supply proper install instructions??

     

    many thanks - Mark

    [contribution] Report Missing and Unassignes Images

    in General Add-Ons Support

    Posted

    Hi All....

     

    I still need some help on the previous post about getting the right SQL query so i can display the category name....

     

    I have also tried to add alernate table colours on the page too, this is for when i launch a new site/add lots of products you can see the lines more easily.

     

    I have the alternate colours working but both rows are exactly the same and duplicate that way down the page. i'm not a php/sql coder so if anyone can point me i the right direction to finish it off is greatly appreciated...

     

    Many Thanks

     

    This is the page i have:

     

    <?
/*
 missing_pics.php,v 2.1 2006/11/20 22:05:52

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Idea by FaustinoInc.com

 Rewritten by Brian Burton (dynamoeffects)

 Released under the GNU General Public License
*/
 require('includes/application_top.php');
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <? echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<? echo CHARSET; ?>">
<title><? echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onLoad="SetFocus();">
<!-- header //-->
<? require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
   <td width="<? echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<? echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<? require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
   </table></td>
<!-- body_text //-->
   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
     <tr>
       <td class="pageHeading"><? echo HEADING_TITLE; ?></td>
     </tr>
<?
 /* ------------------------------------------------------------- */
 /* ------------------ CONFIGURABLE SETTINGS -------------------- */
 /* ------------------------------------------------------------- */

 //Change this line if you keep your images stored in a strange directory.
 //Don't touch it unless you're having problems.
 $image_directory = DIR_FS_CATALOG . DIR_WS_IMAGES;


 /*  ** Image Columns **
  *  If you have various image contributions installed and have more than one  
  *  image column in your database, add additional items to this array to include them.
  *  For example, if you have UltraPics installed, the array would look like this:
  *  $image_columns = array('products_image',
  *                         'products_image_med', 	
  *                         'products_image_lrg', 	
  *                         'products_image_sm_1', 	
  *                         'products_image_xl_1', 	
  *                         'products_image_sm_2', 	
  *                         'products_image_xl_2', 	
  *                         'products_image_sm_3', 	
  *                         'products_image_xl_3', 	
  *                         'products_image_sm_4', 	
  *                         'products_image_xl_4', 	
  *                         'products_image_sm_5', 	
  *                         'products_image_xl_5', 	
  *                         'products_image_sm_6', 	
  *                         'products_image_xl_6');
  */
 $image_columns = array('products_image');

 /* ------------------ STOP EDITING HERE -------------------- */

 $column_query_string = '';
 $image_count = 0;

 foreach ($image_columns as $column) {
   if ($column_query_string != '') $column_query_string .= ', ';
   $column_query_string .= $column;
 }

 $image_array = array();
 $images_query = tep_db_query("SELECT products_id, " . $column_query_string . " FROM " . TABLE_PRODUCTS);

 while ($row = tep_db_fetch_array($images_query)) {
   $image_array[$row['products_id']] = array();

   foreach ($image_columns as $column) {
     if ($row[$column] != '') {
       $image_array[$row['products_id']][] = array('image' => $row[$column], 'column' => $column);
       $image_count++;
     }
   }
 }

 /* Our image array is now built, start checking files. */
 $missing_images = array();

 foreach ($image_array as $id => $product) {
   foreach ($product as $image) {
     if (!is_file($image_directory . $image['image'])) {
       if (!is_array($missing_images[$id])) $missing_images[$id] = array();

       $missing_images[$id][] = $image['image'] . '  <i>(Col: ' . $image['column'] . ')</i>';
     }
   }
 }
?>
     <tr>
       <td class="main">
<?  if (count($missing_images) > 0) { ?>
         <table border="0" width="100%" cellspacing="0" cellpadding="0">
           <tr>
             <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
               <tr class="dataTableHeadingRow">
             <!--    <td class="dataTableHeadingContent" align="center" width="30"><?php echo TABLE_HEADING_PRODUCT_ID; ?></td> --> 
                 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CATEGORY; ?></td>
                 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCT_NAME; ?></td>
                 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCT_IMAGES; ?></td>
               </tr>
<?
     foreach ($missing_images as $id => $files) { 
       $product_query = tep_db_query("SELECT products_name FROM products_description WHERE products_id = '" . (int)$id . "' AND language_id = '" . ($language_id > 0 ? (int)$language_id : '1') . "'");
       $product = tep_db_fetch_array($product_query);
       $product_query2 = tep_db_query("SELECT categories_id FROM products_to_categories WHERE products_id = '" . (int)$id . "'");
       $product2 = tep_db_fetch_array($product_query2);
	$product_query3 = tep_db_query("SELECT categories_name FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id='". $product2."'");
	$cat = tep_db_fetch_array($product_query3);
?>
               <tr>
                <!-- <td class="dataTableContent" align="center" width="30"><? echo $id; ?></td> -->
                 <td class="dataTableContent" align="center"><? echo $cat; ?></td>
                 <td class="dataTableContent"><a href="<? echo tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $product2[categories_id] . '&pID=' . $id . '&action=new_product') . '">' . $product['products_name']; ?></a></td>
                 <td class="dataTableContent">

<?  //  foreach ($files as $f) { echo $f . '<br />'; } ?>
                 </td>
               </tr>
               <tr>
                 <td colspan="4" style="padding: 0px; height: 1px; font-size: 1px; background-color: #772936"></td>
               </tr>
               <? //  } ?>
               </tr>

                               <!-- test to alternate row bagrounds-->

                               <tr>
                <!-- <td class="dataTableContent1" align="center" width="30"><? echo $id; ?></td> -->
                 <td class="dataTableContent1" align="center"><? echo $cat; ?></td>
                 <td class="dataTableContent1"><a href="<? echo tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $product2[categories_id] . '&pID=' . $id . '&action=new_product') . '">' . $product['products_name']; ?></a></td>
                 <td class="dataTableContent1">

<?     
       foreach ($files as $f) {
         echo $f . '<br />';
       }
?>
                 </td>
               </tr>
               <tr>
                 <td colspan="4" style="padding: 0px; height: 1px; font-size: 1px; background-color: #772936"></td>
               </tr>
               <?
     }
?>
               </tr>

               <!-- eof test alternate background -->

             </table></td>
           </tr>
         </table>
<?
   } else { ?>
         <table border="0" width="100%" height="100">
           <tr>
             <td class="main" valign="middle" align="center"><b><h2>Congratulations!</h2><br />You have <? echo $image_count . ' product image' . ($image_count == 1 ? '' : 's'); ?> in your store and they are all accounted for!</b></td>
           </tr>
         </table>
<?  } ?>
       </td>
     </tr>
   </table></td>

<!--    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php // require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- left_navigation_eof //-->
 <!--  </table></td> -->

<!-- body_text_eof //-->
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<? require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
</body>
</html>
<? require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

    Need help with categories_name sql query

    in General Add-Ons Support

    Posted

    following is the full code for the missing_pics.php file

     

    <?
/*
 missing_pics.php,v 2.1 2006/11/20 22:05:52

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Idea by FaustinoInc.com

 Rewritten by Brian Burton (dynamoeffects)

 Released under the GNU General Public License
*/
 require('includes/application_top.php');
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <? echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<? echo CHARSET; ?>">
<title><? echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onLoad="SetFocus();">
<!-- header //-->
<? require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
   <td width="<? echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<? echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<? require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
   </table></td>
<!-- body_text //-->
   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
     <tr>
       <td class="pageHeading"><? echo HEADING_TITLE; ?></td>
     </tr>
<?
 /* ------------------------------------------------------------- */
 /* ------------------ CONFIGURABLE SETTINGS -------------------- */
 /* ------------------------------------------------------------- */

 //Change this line if you keep your images stored in a strange directory.
 //Don't touch it unless you're having problems.
 $image_directory = DIR_FS_CATALOG . DIR_WS_IMAGES;


 /*  ** Image Columns **
  *  If you have various image contributions installed and have more than one  
  *  image column in your database, add additional items to this array to include them.
  *  For example, if you have UltraPics installed, the array would look like this:
  *  $image_columns = array('products_image',
  *                         'products_image_med', 	
  *                         'products_image_lrg', 	
  *                         'products_image_sm_1', 	
  *                         'products_image_xl_1', 	
  *                         'products_image_sm_2', 	
  *                         'products_image_xl_2', 	
  *                         'products_image_sm_3', 	
  *                         'products_image_xl_3', 	
  *                         'products_image_sm_4', 	
  *                         'products_image_xl_4', 	
  *                         'products_image_sm_5', 	
  *                         'products_image_xl_5', 	
  *                         'products_image_sm_6', 	
  *                         'products_image_xl_6');
  */
 $image_columns = array('products_image');

 /* ------------------ STOP EDITING HERE -------------------- */

 $column_query_string = '';
 $image_count = 0;

 foreach ($image_columns as $column) {
   if ($column_query_string != '') $column_query_string .= ', ';
   $column_query_string .= $column;
 }

 $image_array = array();
 $images_query = tep_db_query("SELECT products_id, " . $column_query_string . " FROM " . TABLE_PRODUCTS);

 while ($row = tep_db_fetch_array($images_query)) {
   $image_array[$row['products_id']] = array();

   foreach ($image_columns as $column) {
     if ($row[$column] != '') {
       $image_array[$row['products_id']][] = array('image' => $row[$column], 'column' => $column);
       $image_count++;
     }
   }
 }

 /* Our image array is now built, start checking files. */
 $missing_images = array();

 foreach ($image_array as $id => $product) {
   foreach ($product as $image) {
     if (!is_file($image_directory . $image['image'])) {
       if (!is_array($missing_images[$id])) $missing_images[$id] = array();

       $missing_images[$id][] = $image['image'] . '  <i>(Col: ' . $image['column'] . ')</i>';
     }
   }
 }
?>
     <tr>
       <td class="main">
<?  if (count($missing_images) > 0) { ?>
         <table border="0" width="100%" cellspacing="0" cellpadding="0">
           <tr>
             <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
               <tr class="dataTableHeadingRow">
                 <td class="dataTableHeadingContent" align="center" width="30"><?php echo TABLE_HEADING_PRODUCT_ID; ?></td>
                 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CATEGORY; ?></td>
                 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCT_NAME; ?></td>
                 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCT_IMAGES; ?></td>
               </tr>
<?
     foreach ($missing_images as $id => $files) { 
       $product_query = tep_db_query("SELECT products_name FROM products_description WHERE products_id = '" . (int)$id . "' AND language_id = '" . ($language_id > 0 ? (int)$language_id : '1') . "'");
       $product = tep_db_fetch_array($product_query);
       $product_query2 = tep_db_query("SELECT categories_id FROM products_to_categories WHERE products_id = '" . (int)$id . "'");
       $product2 = tep_db_fetch_array($product_query2);
	$product_query3 = tep_db_query("SELECT categories_name FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id='". $product2."'");
	$cat = tep_db_fetch_array($product_query3);
?>
               <tr>
                 <td class="dataTableContent" align="center" width="30"><? echo $id; ?></td>
                 <td class="dataTableContent" align="center" width="30"><? echo $cat; ?></td>
                 <td class="dataTableContent"><a href="<? echo tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $product2[categories_id] . '&pID=' . $id . '&action=new_product') . '">' . $product['products_name']; ?></a></td>
                 <td class="dataTableContent">
<?     
       foreach ($files as $f) {
         echo $f . '<br />';
       }
?>
                 </td>
               </tr>
               <tr>
                 <td colspan="3" style="padding: 0px; height: 1px; font-size: 1px; background-color: #EFEFEF"></td>
               </tr>
<?
     }
?>
               </tr>
             </table></td>
           </tr>
         </table>
<?
   } else { ?>
         <table border="0" width="100%" height="100">
           <tr>
             <td class="main" valign="middle" align="center"><b><h2>Congratulations!</h2><br />You have <? echo $image_count . ' product image' . ($image_count == 1 ? '' : 's'); ?> in your store and they are all accounted for!</b></td>
           </tr>
         </table>
<?  } ?>
       </td>
     </tr>
   </table></td>

<!--    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php // require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- left_navigation_eof //-->
 <!--  </table></td> -->

<!-- body_text_eof //-->
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<? require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
</body>
</html>
<? require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

    Need help with categories_name sql query

    in General Add-Ons Support

    Posted

    Hi,

     

    I need some help if poss...

     

    Contrib missing_pics_2.1

     

    I am using a contrib to hide categories from public view as i have lots of products in there that i do not wish to show live yet, which some are also because of missing images.

     

    to make sure the products with missing images are in the right category i wanted to add a column into the missing_pics.php file, which i have done, but am having a problem with the sql query to pull the category name and place it next to the product...

     

    I have added 

    $product_query3 = tep_db_query("SELECT categories_name FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id='". $product2."'");
	$cat = tep_db_fetch_array($product_query3);

     

    after: 

    $product_query2 = tep_db_query("SELECT categories_id FROM products_to_categories WHERE products_id = '" . (int)$id . "'");
       $product2 = tep_db_fetch_array($product_query2);

     

    then added in 

    <td class="dataTableContent" align="center" width="30"><? echo $cat; ?></td>

     

    after: 

    <tr>
                 <td class="dataTableContent" align="center" width="30"><? echo $id; ?></td>

     

    But it doesnt show the category name at all... i have checked the sql query directly in phpmyadmin and it returns a result so i am pretty stumped... any help is appreaciated...

     

    thanks - mark

    [contribution] Report Missing and Unassignes Images

    in General Add-Ons Support

    Posted

    Hi,

     

    I need some help if poss...

     

    Contrib missing_pics_2.1

     

    I am using a contrib to hide categories from public view as i have lots of products in there that i do not wish to show live yet, which some are also because of missing images.

     

    to make sure the products with missing images are in the right category i wanted to add a column into the missing_pics.php file, which i have done, but am having a problem with the sql query to pull the category name and place it next to the product...

     

    I have added 

    $product_query3 = tep_db_query("SELECT categories_name FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id='". $product2."'");
	$cat = tep_db_fetch_array($product_query3);

     

    after: 

    $product_query2 = tep_db_query("SELECT categories_id FROM products_to_categories WHERE products_id = '" . (int)$id . "'");
       $product2 = tep_db_fetch_array($product_query2);

     

    then added in 

    <td class="dataTableContent" align="center" width="30"><? echo $cat; ?></td>

     

    after: 

    <tr>
                 <td class="dataTableContent" align="center" width="30"><? echo $id; ?></td>

     

    But it doesnt show the category name at all... i have checked the sql query directly in phpmyadmin and it returns a result so i am pretty stumped... any help is appreaciated...

     

    thanks - mark

    [Contribution] Option Types v2

    in General Add-Ons Support

    Posted

    hi,

     

    I have downloaded this contribution after seeing it on another site because i need for the customer to enter characters over 3 or 4 lines that can be engraved onto a product.

     

    I am lost with the install file 'option types v2 installtion instruction.txt' because there are characters in there that i have no idea what they are or are refering too...

     

    \f1\fs24 \
\

\f0\fs22         \cf2 echo \cf3 '<br><nobr><small> <i> - ' \cf0 . \cf4 $order\cf0 ->products[\cf4 $i\cf0 ][\cf3 'attributes'\cf0 ][\cf4 $j\cf0 ][\cf3 'option'\cf0 ] . \cf3 ': ' \cf0 . \cf4 $order\cf0 ->products[\cf4 $i\cf0 ][\cf3 'attributes'\cf0 ][\cf4 $j\cf0 ][\cf3 'value'\cf0 ] . \cf3 '</i></small></nobr>'\cf0 ;\
\

     

    on the 1st part of the find this and replace with... i have no idea what all the /cf3 etc are as they are not proper php coding

     

    can anyone help or maybe could supply proper install instructions??

     

    many thanks - Mark

    Google Base feeds

    in General Add-Ons Support

    Posted

    do you mean that your products are listed in google products or NOT listed - if it is not listed then why do i bother to do the addon of 'the feed machine solution v5.3'

     

    Sorry...hit the wrong key and didnt check it..trying to type too quick :huh:

     

    Should be my products are NOW listed in google products instead of not ;)

     

    sorry for the confusion.

    Google Base feeds

    in General Add-Ons Support

    Posted

    As i couldnt get this working despite my efforts i have now resorted to 'the feed machine solution v5.3'

     

    its a little more involved in setup that this single file install, but at least it works and my products are not listed in google products. you can also config for other feeds as well.

    Google Base feeds

    in General Add-Ons Support

    Posted

    Hi,

    Thanks for the contrib, but i am having a few little issues...

     

    I have installed as instructed and have added the rewrite to the htaccess file bit i get file cannot be found when i try to access it directly?

     

    this is what my error log says:

     

    petsandpals.co.uk [Tue Jul 06 14:26:13 2010] [error] [client ***.***.***.***] File does not exist: /home/sites/petsandpals.co.uk/public_html/base.txt

     

    I have this at the end of my htaccess file:

     

    #############################

    # Begin Google Base File Rewrite Code

    RewriteRule base.txt googlebase.php

    # End Google Base File Rewrite Code

    #############################

     

    and the googlebase.php is in my root directory. i have setup the googlebase feed a few days ago with google and its still says status none and last upload none??

     

    please help and so i can get my products listed.

     

    Many thanks - Mark

    [Contribution] Ship In Cart

    in General Add-Ons Support

    Posted

    my issue is the same as Marcos_kfir...

     

    Does anyone have any idea of how to work as a contribution in the pop-up product_info.php?

     

     

    my code gives error :wacko:

     

     

     

    <?php

    $cart->add_cart($product_info['products_id']); //add current to cart for estimator

     

    if (CARTSHIP_ONOFF == 'Enabled')

     

     

    {echo '<a href="java script:popupWindow(\'' . tep_href_link((DIR_WS_MODULES . 'product_shipping_estimator.php')) . '\')">' . '<img src="images/icons/shipcost.gif" border="0"> ' . TEXT_SHIPPING_COST . '</a>';}

     

    else {};

    $cart->remove($product_info['products_id']); //lets remove current product from cart

    ?>

     

     

     

    send-me this error below:

     

    Forbidden

    You don't have permission to access /loja/includes/modules/product_shipping_estimator_pop.php on this server

     

    but mine says that the file cannot be found. the format as it is is very messy and doesnt suit the page so i am trying to get it as a popup instead (similar to popup shipping estimate 1.7b). as it is tidier.

     

    any help on getting this as a popup is most appreciated.

    Estimated Shipping Costs

    in General Add-Ons Support

    Posted

    Hi,

     

    I am also using 1.7b and the box doesnt appear as an infobox and only appears on the shopping cart page as a link to the estimate.

     

    what i do want is the link on the product info page as i have added the weight of the product on there and a link to 'estimate shipping' the trouble is i now need it to estimate the shipping based on the weight on the product info page without having to add the item to th cat first as this can get long winded and tedious for the customer. (demo on www.funhousedropship.com)

     

    thanks in advance for any help.

    qtpro and easypopulate stock update

    in General Add-Ons Support

    Posted

    Hi All,

     

    i am using qtpro and have the stock set for the attributes, but i also use easy populate to add stock etc... i'm not sure if they can be combined but my problem is.....:

     

    I have a retail site with stock on there and a dropshipping site with the same stock but different prices. both sites are using qtpro so we can track the sizes etc as seperate qty's.

     

    My problem is that when things ar sold from the sites we have to change all the products manually and i am after an easy way to keep the stock the same with their prices relevant to each site. i was thinking of a download/upload to update the sql but the qtpro sql queries are far to advanced for me to figure out.

     

    any help/suggestions would be appreaciated

     

    thanks - mark

×
×
  • Create New...