Certek
Pioneers-
Posts
16 -
Joined
-
Last visited
Everything posted by Certek
-
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
-
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.
-
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
-
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
-
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
-
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
-
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)
-
Simone, Try this as it worked for me - http://www.oscommerce.com/forums/index.php?s=&...st&p=856268 Hope it works for you. Steve
-
Bruce, In my search of this problem, I have found others with the same problem. http://www.oscommerce.com/forums/index.php?s=&...st&p=820485 http://www.oscommerce.com/forums/index.php?s=&...st&p=829888 Then I found this... http://www.oscommerce.com/forums/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
-
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
-
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
-
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