Latest News: (loading..)

Certek

Members
  • Content count

    16
  • Joined

  • Last visited

About Certek

Profile Information

  • Real Name
    Steve
  1. Thanks Don for your reply. I will do the install and see how it turns out. Hope it will not be too bad. I have a pretty modified store so there is always some type of issue that comes into play. Thanks again. Steve
  2. DK, I want to thank you for your posts regarding installing the Virtual Merchant contribution. I also am currently running with ViaKlix and got the same change notice. I have a question regarding your install. Did you uninstall the ViaKlix contribution prior to installing the VM? You also mention adding the "Order ID" field when making this install. I know enough to be dangerous and it would go a long way if you could show me the code that did this. Thanks in advance for your reply.
  3. Thanks Glen and I was able to figure that out the hard way. Nonetheless, I learned more about SQL in my efforts so not all is lost. The module is up and running fine on my sight. Thanks again. Steve
  4. Glen, Thanks for the reply. I have a lot of packages that will be affected by this change so I am scrambling to make the correct changes. I have my files updated but have yet to run the SQL updates. I am a little confused on the SQL. I know I run them in myPHP but have a question. The instruction state the following... Execute this SQL update: ALTER TABLE `configuration` CHANGE `set_function` `set_function` VARCHAR( 555 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL; Execute this SQL update if you already have the module installed and are updating: UPDATE `configuration` SET `set_function` = 'tep_cfg_select_multioption(array(''Global Express'', ''Global Express Non-Doc Rect'', ''Global Express Non-Doc Non-Rect'', ''Express Mail Int'', ''Express Mail Int Flat Rate Env'', ''Priority Mail Int'', ''Priority Mail Int Flat Rate Env'', ''Priority Mail Int Flat Rate Box'', ''First-Class Mail Int''),' WHERE `configuration_key` ='MODULE_SHIPPING_USPS_TYPES_INTL' LIMIT 1 ; ==================== My question is what exactly do I input for this change? Is this two separate commands? I already have this module installed so do I just run the second one listed? Sorry if this is a stupid question. Just not too up on this stuff. Steve
  5. Glen, This will not be an easy task as the new rates are not only weight based but vary based on the size of the package. Any priority package over 1 foot cube is going to have a size surcharge. There will have to be an oversize entry for this contribution that takes package size into account. I really think it will be a disaster to deal with and I am thinking of just not using USPS. Steve
  6. I just installed the 1.7a version. I have been looking for this type of contribution for some time. While the UPS and USPS shipping estimates seem to be working fine, I can't get the table rates to work. I did a quick search and I think this may be a problem that has yet to be resolved. Has anybody been able to use this contribution with table rates? I have a table rate for U.S. customers. If their order is below $199 then shipping is $7.97. Over $199 and it is free. Thanks in advance for your insight on this. Steve
  7. I think the link is not working - here is what I changed. MySQL 5 Fix The current version of the Froogle Feeder errors when using MySQL 5. This can be resolved by making the following change: (Just add the parenthesis and see what happens) Around line 89: FROM categories, categories_description, products, products_description, products_to_categories Change to: FROM (categories, categories_description, products, products_description, products_to_categories)
  8. Simone, Try this as it worked for me - http://forums.oscommerce.com/index.php?s=&...st&p=856268 Hope it works for you. Steve
  9. Bruce, In my search of this problem, I have found others with the same problem. http://forums.oscommerce.com/index.php?s=&...st&p=820485 http://forums.oscommerce.com/index.php?s=&...st&p=829888 Then I found this... http://forums.oscommerce.com/index.php?s=&...st&p=856268 I tried it an no more error after I ran it. I got the following... File completed: frooglefile.txt Connected to uploads.google.com, for user realdealtools Uploaded D:/Home/...I removed the tree data on purpose... /feeds/frooglefile.txt to uploads.google.com as frooglefile.txt Script timer: 26.373841 seconds. I think this worked but don't know for a fact. Will have to check out the details on Google Base. I don't know if I have to first define the file name to Google before they receive it. Hope this helps you out on your next build. I will let you know if I run into any additional problems. Steve
  10. Bruce, Thanks for getting back to me so quickly. I checked on the product table and I do in fact have the manufactures_id in place. Here are the total headings for the products table. products_id products_quantity products_model products_image products_price products_date_added products_last_modified products_date_available products_weight products_status products_tax_class_id manufacturers_id products_ordered As you may know I am a newbie with all of this stuff. At the same time I have learned a ton these past few months as I got my store up and running. I have checked around the help section and just can't get my hands on a solution for this problem. Thanks again for your time and effort. Steve
  11. Bruce, Thanks for the opportunity to report errors and your hard work with this contribution. I have tried to no avail to install it. And I really can find any information in the forums to resolve it. If you can shed some light on the problem I would be extremely grateful. After I run the Froogle Feed (actually any feed yahoo, froogle, or bizrate results in the same error) I get the below listed error. I have yet to try it with bidhopper. If it helps my provider is running PHP Version 4.4.3-dev. Also, I am running on a Windows Server. Start Error SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://www.realdealtools.com/oscommerce/catalog//product_info.php?products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.realdealtools.com/oscommerce/catalog/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM categories, categories_description, products, products_description, products_to_categories left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id AND products.products_status != 0 AND products.products_price != 0 AND products.products_price != '' ORDER BY products.products_id ASC End Error Thanks for you time and effort. Steve
  12. Just installed the latest version of Froogle/Google Base, Yahoo, and Bizrate Feeds contribution and get the following error. I have checked the support threads and can't find reference to it. Anybody know what it means? Your time and effort is appreciated. Error... : SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://www.realdealtools.com/product_info.php?products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.realdealtools.com/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM categories, categories_description, products, products_description, products_to_categories left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id ORDER BY products.products_id ASC