Jump to content


  • Content count

  • Joined

  • Last visited

  1. jclngvl

    Automatically send data feed to Froogle

    This past week (12-March-2012) our 8,100 google base products became unavailable because the expiration date is earlier than today. For some reason the expiration date in the feed is being calculaated as 10-March-2012. I cannot find a place in the googlefeeder.php where the expiration date is calculated, but only where it's picked up from the dataset line 300: if(OPTIONS_ENABLED_EXPIRATION == 1) $output .= "\texpiration_date"; Can someone tell me what I need to configure differently in my admin panel or in the googlefeeder.php? I have looked in cpanel and don't see a field named expiration_date. Not sure if this has anything to do with daylight savings time. I updated GoogleFeeder in October 2011. File has no reference to version number, but // Last Update: 12/25/09 by Jack_mcs at oscommerce-solution.com I've had to patch this problem by running feeder but not uploading file until I edit/replace the date with a date 30 days from today. Thanks, John
  2. Web-Project suggests that I try a conditional statement that I indicated I was not able to get to work. I know we're close but still no luck. Can someone please be more specific about the syntax of how this statement will be incorporated into specials.php. I've provided the section of the code that displays the image & pricing (product price and specials price), but would appreciate it if someone could show me where the conditional statement starts and how it ends. I can re-write the echo statement to leave out the original price, but each time I have tried to put in some sort of condition, the website only returns a blank page. Thanks, John =========== lines 76 - 94 ============================== <?php $row = 0; $specials_query = tep_db_query($specials_split->sql_query); while ($specials = tep_db_fetch_array($specials_query)) { $row++; echo ' <td align="center" width="33%" class="smallText"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $specials['products_image'], $specials['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $specials['products_id']) . '">' . $specials['products_name'] . '</a><br><s>' . $currencies->display_price($specials['products_price'], tep_get_tax_rate($specials['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($specials['specials_new_products_price'], tep_get_tax_rate($specials['products_tax_class_id'])) . '</span></td>' . "\n"; if ((($row / 3) == floor($row / 3))) { ?> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <?php } } ?>
  3. The site owner likes to use specials to promote products, some of which aren't reduced in price. Can someone show me how (provide specific code changes) to change specials.php (OSC 2.3) so that the specials page does not echo the product price and the special price if they are the same. There should be an if statement added around line 77 of specials.php. e.g. something like if ($specials['specials_new_products_price'] < $products['products_price']{ then echo as currently coded OTHERWISE leave out $specials['products_price'] in the code from above. I'm not a php programmer, but can easily replace or add specific lines in the php code. I've tried a half dozen ways and apparently haven't hit the right syntax. One of you guys should be able to do this in 5 minutes Thanks, John
  4. jclngvl

    minimum amount shipping module

    You should be able to configure this feature with your Admin panel, without changing any php files. In the Admin panel, select the MODULES group and then select the ORDER TOTAL group. Under the Order Total Module, you can edit the Shipping module and you should be able to set a limit for the Free Shipping to be available.
  5. I was considering adding the coupon code feature but all I can see if problems with recent implementations. The smartass response about a crystal ball is totally useless. It takes lots more than a crystal ball for the poor dumb users to try to implement an addon like this. This feature may at one time have worked, but the most recent add-ons page [http://addons.oscommerce.com/info/4269] has an auto-installer from 30June; then a 9-July mod that references something from 21 March09 and most recently a revision to a single file that was made on 5-October. How is anyone supposed to figure what version of all this stuff is the one that might work on their shop? If kristapasnak hadn't spent 5 or 10 hours implementing this change and trying to figure out what was wrong, they wouldn't have asked for help. I'm sure it will be a long time before they ask for help again, if all they get is their chops busted for trying. If you realy want to be helpful, then fix the app and put a full package online, so that we don't need to be mindreaders to figure out which pieces to use and which to ignore. It's too late for CLEES4005 (4Nov09), who installed all this stuff and now can't even get into her admin panel. I'll wait a few months until someone clears this up before considering implementation of this feature.
  6. jclngvl

    Automatically send data feed to Froogle

    Jack, It looks like you've got a great contribution. But, I'm missing something along the lines of a few detailed instructions. I've been creating Froogle uploads weekly through MSExcel and easypopulate, but I would love to get your contribution automated on a friend's site (3,500 products that I'm helping him with for free). Using the googlebase autofeeder I was able to get a product feed uploaded but had inconsistent results and didn't pursue it. The Googlefeeder v2, Readme.html file from 2/25/2007 may no longer be necessary, but I can't find any additional usage details. I have made the simple changes to Googlefeeder.php (url, login, feed name and password) and uploaded Googlefeeder.php and Feeders.php to my admin folder. However, I'd like to be able to validate what's going to Froogle before I schedule the feed on Googlebase (so I don't wipe out or duplicate what's there). With the Googlebase autofeeder, I could browse the feed file to verify that the content would be ok (www.yourwebsite.com/catalog/googlebase.php). But, if I try to browse www.mywebsite.com/catalog/admin/googlefeeder.php I get "website cannot display the page." I guess this should be simple, but it's not obvious to me. Step-by-step, is there more than.... 1. Update Googlefeeder.php with your logins, feed name and the like ... 2. upload to www.yourwebsite.com/catalog/admin (is this correct location) 3. upload feeders.php to the admin folder Is this all? I had made some changes to .htaccess for the googlebase autofeeder. Is any of this still necessary? #Options +FollowSymLinks #RewriteEngine on #RewriteBase /catalog #RewriteRule feeds.csv googlebase.php #RewriteRule feeds2.csv googlebase.php Thanks for any suggestions that will get this going, John
  7. OK.. there are only so many permutations and I finally guessed at one that worked. For those of you who understand what you're doing, this may be obvious. For me, it's like trying to configure a windows network. Keep trying stuff until something finally works. Step 1. The .htaccess file that needs to be modified is the one that's at the highest level of your website (in httpdocs, not in your Catalog folder). But the RewriteBase statement must point to the Catalog folder, where googlebase.php is located, not httpdocs. Step 1a. Add the following statements to the .htaccess folder at the highest level of your website Options +FollowSymLinks RewriteEngine on RewriteBase /catalog RewriteRule feeds.txt googlebase.php NOTE: The difference is that I changed the "RewriteBase /" statement to "RewriteBase /catalog" Step 2. Install the googlebase.php file at the next level down (e.g. in your Catalog folder) Step 3. Browse for www.mysite.com/feeds.txt (or whatever name you gave the feed in your .htaccess file). You should receive the text which represents the data that would be received by googlebase. It looks as though the header has all of the necessary fields (including id, MPN, condition, etc). Don't try to decipher the data from the undelimited text file, but it seems to represent all of that same information and must be parsed by Googlebase some other way. In a few days (after the customers leave for the 4th of July) I'll get the nerve to try to schedule googlebase without wiping out our current feed. Thanks again for keeping me focused. John
  8. Same symptoms after the suggested updates.... www.mysite.com/catalog/googlebase.php brings back text, whereas www.mysite.com/catalog/feeds.txt does not. Here is is the content and sequence of all code that's not hashed out in the .htaccess file which is in the www.mysite.com/catalog folder. Options +FollowSymLinks RewriteEngine on RewriteBase / RewriteRule feeds.txt googlebase.php I have also changed lines 100 and 101 of googlebase.php to read.... $catalogURL = HTTP_SERVER . DIR_WS_HTTP_CATALOG; $imageURL = HTTP_SERVER . DIR_WS_HTTP_CATALOG . DIR_WS_IMAGES; I will appreciate any further suggestions? www.carolinaboatoutfitters.com/catalog/googlebase.php works fine www.carolinaboatoutfitters.com/catalog/feeds.txt does not bring anything back. --------------But, while I'm at it---------------- When I use easypopulate to create the froogle file, I have to open the downloaded csv file in MS Excel and add a column for the model_number, which is simply a copy/paste of the product ID. I also have to do a lookup to create a column for the brand, so that these both of these values are available to Froogle. Would it be practical to change easypopulate.php to include these two columns (and the proper field heading) in the froogle file? I've looked in the easypopulate.php and it's not apparent how to get these two columns included in the output file. I don't know what's involved, but I'd need some pretty specific instructions if I'm going to make this change to easypopulate.php, which is ~3200 lines of code (e.g. I can't just be told something like "add the fields to the printoutput statement". Otherwise, we're probably as well off just manually downloading the csv file, adding columns and manually uploading to googlebase. My problem is that the store owner can't handle this type of procedure, so if I could make it turnkee for him, then he wouldn't need to involve me and we could automate the feed to run each week. Thanks again... I'm amazed at the time that you guys put into just supporting OSC, while we're out here trying to get our stores working. John
  9. Jim... DDame and I both seem to be able to see product information if we browse www.mysite.com/catalog/googlebase.php. So it looks like we've got that file in the proper location. Does this mean that the problem is with the changes to .htaccess (either in the root or in the catalog folder). I followed your suggestion @ 11:14 today to add to .htaccess : Options +FollowSymLinks RewriteEngine on Now I get a "done" from Firefox (rather than a file not found error), but IE "cannot display page". If I hash out the two lines in .htaccess then the error in Firefox is file not found and IE is still 'cannot display page' You indicated that if the store is in a subdirectory, we need to change googlebase.php, but there doesn't seem to be reference to a change provided in this thread. The suggested changes to googlebase.php relate to configuration of what goes into the product upload file for google. It's not clear what would be changed to output to the proper text file. Can you be more specific about the date/location of the thread &/or what code in googlebase.php needs to be changed for those of us who have our store (and googlebase.php) in a subdirectory (e.g. mysite.com/catalog/googlebase.php? Once this is corrected, then DDame and I should both be able to see our data if we browse www.mysite.com/catalog/feeds.txt (or whatever name we gave it in the .htaccess RewriteRule statement) Are our stores really in a "subdirectory", or is the standard configuration that Catalog in in the root and has folders for Admin, Includes, images, etc. ==================================================================== DDame: There's an excellent discussion of the layout of OSC and how to find files at http://forums.oscommerce.com/index.php?showtopic=307356 The first couple of times I read it I was lost, but some time it will make sense to you. I think that the quick answer to your question is that your store is in a folder called Catalog that's in your Httpdocs folder. If you're using an FTP client to access files on the site you should see Catalog in the root and Catalog/Admin (which is where your OSC administrative files are located). The Googlebase.php file that needs updating should be put into the folder named www.mysite.com/catalog/ which it seems was done from your post on Jun 17. I don't think that there's anything wrong with our Googlebase.php files. I think that the problem is with the .htaccess.
  10. We have got to be close and several of us seem to have same problem (described in threads since 16Jun09), which is probably related to having our catalog in a subdirectory of the root. Thanks again to all of you for getting us this close. We're all going to thump our heads when we see how simple this was, but right now it's just getting past us. My store is is found at www.mysite.com/catalog/index.php, but there's a statement in .htaccess in the root directory to: Redirect /index.html http://www.mystore.com/catalog/index.php I've added googlebase.php to the folder at www.mystore.com/catalog/ and can see thousands of lines of text if I browse www.mystore.com/catalog/googlebase.php. We have 3,200 products on the site. I've added the following statements to .htaccess in www. mystore.com/catalog/.htaccess RewriteBase / RewriteRule feeds.txt googlebase.php BUT, when I try to access www.mystore.com/catalog/feeds.txt I get the following error: The requested URL /catalog/feeds.txt was not found on this server. Ditto if I try for www.mystore.com/feeds.txt with the error: The requested URL /feeds.txt was not found on this server. Thanks again, John